Multicurrency Reporting

The system provides numerous report selections so you can create custom reports that satisfy the reporting needs in your organization. This reporting gives you the flexibility you need, from specifying which columns appear, to sorting and totaling the information presented. You control the output so you get just the reports you want.

Below is a list all the reports available in the Multicurrency module:

Report Menu Selections

Reports

Reports>

Exchange Rates List

  • If the Multicurrency module has been installed and added to an organization, most reports function differently than they do without this module. Some differences are noted below:
  • A total for each currency type set up by the Administrator in the system (Organization>Currency Setup) is printed at the bottom of each report, even if the currency is not being used in that report.
  • "Source" and "Invoice" columns are added for some reports.
  • The Source Currency column tells you what currency the transactions were recorded in.
  • The Source Debit and Source Credit columns represent the amounts that were entered on the transaction entry forms.
  • The Debit and Credit columns represent the functional amounts. Therefore, for functional currency, it is the debit or credit amount entered during transaction entry. For non-functional currency, it is the Source Debit times the Exchange Rate.
  • The Invoice Debit and Invoice Credit columns only display data for Accounts Payable and Accounts Receivable accounts to accommodate second and third currency payout scenarios.
  • Revaluation entries are generated when transactions are revalued (Activities>Revalue Multicurrency). Gain and loss lines are also generated when an invoice is settled and there is an exchange rate difference. There are no gains or losses associated with "source" amounts. Gains and losses can only be recorded in functional amounts.