Language:


The Currency A/C Rate Change Report

This page describes the Currency A/C Rate Change report in the Nominal Ledger.

---

The Currency A/C Rate Change report in the Nominal Ledger lists the balances of Asset, Liability and Equity in which a Currency has been specified. Three versions of each balance will be shown: in the original Currency; in either Base Currency using the Exchange Rate at the time of each posting; and in the Base Currency using the current Exchange Rate (or the Exchange Rate for a specified date). The report will also show the difference between the two Base Currency figures. This difference is the balance adjustment that will be made when you next run the 'Rate Gain/Loss' Maintenance function. The report will therefore show the losses or gains that will result from applying current Exchange Rates to old Transactions.

Date
Paste Special    Choose date
The report will use the date that you specify here for the following purposes:

  1. The first two columns in the report will display the balance of each Account on this date in two Currencies: the Currency of the Account and Base Currency 1 (your home Currency).

  2. The third column in the report will display the Currency balance of each Account converted to Base Currency 1 using the Exchange Rate applying on this date.

If you do not enter a date, the current date will be used.

Accounts
Paste Special    Account register, Nominal Ledger/System module
If you need to produce a report for a particular Account, specify that Account here. For an Account to be included in the report, it must have an entry in its Currency field, that Currency must not be Base Currency 1 or 2 and it must be an Asset, Liability or Equity Account. Income and Expense Accounts will not be included.

To report on several Accounts at once, enter them all to this field, separated by commas.

List Rates
Select this option if you want the Exchange Rates for all Currencies that are current on the date specified above to be printed in a separate list at the top of the report.

Only changes above limit
Select this option if you only want the report to suggest that a balance adjustment should be made when that adjustment is greater than the Limit specified in the Rate Gain/Loss setting.

Values in
If you are using the Dual-Base system, values in this report can be shown in either Base Currency. Use these options to choose which Currency is to be used on this occasion.

If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.

---

Exchange Rate Gains and Losses:

Go back to: