FX Tutorial: Foreign Currency Reporting

Trial Balance and Exchange Variation Reports

All report layouts will report foreign currency figures by default.

You can import Aged Trial Balance Reports and Exchange Variation Reports that are customised for Foreign Sales and Purchases and are grouped by Customer / Creditor Group.

The Exchange Variation Reports for AR and AP show all Invoices, Credits and Journals entered in the period selected where a variation has occurred. Variations can be Unrealised or Realised. Unrealised Variations are from Revaluations, Realised Variations are from Allocations.

1. Go to Navigator > Setup > Company > Reporting > Report Layouts.
2. Click Import Layout (Ctrl+I).
3. Open the Foreign Currency Folder. Click one on of the Reports, then press Ctrl+A to select all the report. Then click Open. The Reports will be added to your list of Report Layouts.

You can customise base currency figures into your reports where relevant. You may want to edit the display labels for base currency values to use your Base currency code (such as NZD or AUD) rather than the "Bs" abbreviation.

Reports that include more than one Currency will need to be customised to group by Currency Code or by Customer / Creditor Group. If you see "FX Mixed" on a report, this means there are values for more than one currency in the column. Accredo recognises that it cannot add different currencies together. If you group by Currency, you will get a sub-total per currency. You can also select the Bs (base) fields and total these. They will show the base equivalent of the foreign amounts, and these can be totalled.

Other Reports

Some AR, AP and CB FX Reports you may wish to add are:

Exchange Variation Sequence Report

Go to Navigator > Reports > Accounts Receivable / Accounts Payable / Cash Book > Transaction Reports > Add Layout > Exchange Variation Sequence. This report lists the exchange variations in the period order they were generated in, so will include Transactions from prior periods that were Revalued or allocated in the selected period.

Revaluation Rates Report

Go to Navigator > Reports > Accounts Receivable / Accounts Payable / Cash Book > Transaction Reports > Add Layout > Revaluation Rates. This report list the rates used to Revalue Foreign Balances for the period.

Exchange Variation Report

Go to Navigator > Reports > Cash Book > Account Reports > Add Layout > Exchange Variation. This report shows Variations for the month as a result of Revaluing the Bank Account Balance and from the movement of funds.