Currency A/C Rate Change
This report in the Nominal Ledger shows balances for all Accounts of a certain nature (those with a Currency specified and of Type Asset, Liability or Equity). These balances are shown in Currency, in either Base Currency using the Exchange Rate at the time of the Transactions (or, if appropriate, at the time the
'Rate Gain/Loss' function was last run) and in the Base Currency using the current Exchange Rate. The report can thus be used to analyse any losses or gains that could be achieved by applying current Exchange Rates to old Transactions and should therefore be produced prior to running the
'Rate Gain/Loss' function.
- Date
- Paste Special
Current Date
- Enter the date of the report. The latest Exchange Rates at that date will be taken to be the current Exchange Rates for the purposes of the report. Note that this date is exclusive: Transactions on the date specified or later will not be included in the report. If no date is entered, the current date will be used.
- Accounts
- Paste Special
Account register, Nominal Ledger/System module
- If you wish to limit the report to a particular Account specify that here. Note that for an Account to be included in the report, two criteria must be met: the Account must have an entry in its Currency field 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
- Use this option if you want the latest Exchange Rates for all Currencies (i.e. those current at the report date) to be included in a separate list at the top of the report.
- Only changes above limit
- Use this option if you only want to include in the report Transactions where carrying out a Currency conversion at the current Exchange Rate would produce a gain or loss that is greater than a certain amount (defined 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 a transitional user of this system, this complies with the EMU requirement that you should be able to produce Nominal Ledger reports in either your home Currency or the Euro.
- If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.
