AugTool Documentation

Net Settlements with Foreign Currencies

Foreign Currency:

Augtool allows you to net settle Foreign Currency Purchase Invoices, Sales Invoices and Journals. These may be the same Foreign Currency eg Dollar to Dollar transactions or different Foreign Currency transactions eg Dollar and Euro. 

The Net Settlement View displays the net settlements in Base Currency. However it has a currency selector which allows you to view the net settlements associated with a specific currency.

Should there be any variances in the rates of the invoices or Foreign Exchange amounts, Augtool will write this off to the Forex Variance Account. Therefor the Forex Varinace Account needs to be setup in Defaults in Business Units.

net-settlements-with-foreign-currencies/b4d0acbe49fbdd947f04a628ea8f3352.jpg

Base Currency

Augtool allows you to net settle foreign currencies but displays the debit and credit totals in Base currency. The GL for the Variance account will also be in the Base currency.

a) Net Settlement with the Same Foreign Currency:

Once you select 2 invoices to offset against each other, Augtool will display the available balances on those invoices. You will then be able to put in the Foreign currency amounts and Augtool will calculate the base currency equivalents based on the exchange rate that was done in the invoices. 

net-settlements-with-foreign-currencies/391e1b869d96c036c03b67b7b04a4aa9.jpg
net-settlements-with-foreign-currencies/a750114ae8274d29075a93f41af4549e.jpg

b) Net Settlement with different Foreign Currencies

Augtool allows you to net settle invoices that have different currencies. Any difference in the invoice rates or Foreign exchange amounts will be accounted for in the Forex Variance Account.

net-settlements-with-foreign-currencies/f6aadff4ed1941c0c51ee1b3371e833d.jpg

c) Net Settlement with Journal Entries with Foreign Currencies

Augtool allows you to net settle journal entries against invoices. If you do a journal entry to a customer account, that entry appears as unallocated in the customer account. In Augtool you can 'allocate' the journal to the invoice by net settlement. 

Augtool allows you to net settle for foreign currencies that are the same as well as 2 different foreign currencies. Any differences in rates or foreign currency amounts will be accounted for in the Forex Variance account.


net-settlements-with-foreign-currencies/92294c1461c37228fea63adfcbe2c1f7.jpg
net-settlements-with-foreign-currencies/21b0549633dc83e46d7f726769f8cb5a.jpg