Multi-currency ERP reporting for export plants: base currency, rates and auditor checks

Why export plants need multi-currency ERP reporting

An export plant sells in dollars, pays suppliers in euros and reports statutory accounts in local currency. Every invoice, payment and cost must be recorded in its original currency, yet the trial balance, profit & loss and balance sheet must reconcile to a single base currency. Without multi-currency ERP reporting, finance teams spend days each month manually converting and reconciling transactions, introducing errors and delaying month-end close.

Facteno posts every transaction in its original currency and converts it to base currency at the exchange rate locked at the moment of posting. This ensures that the double-entry accounting always ties, and that auditors can trace any entry back to its source document without leaving the system.

Choosing the base currency

The base currency is the currency in which the plant prepares its statutory accounts. It is usually the local currency of the country where the plant is registered. Once chosen, the base currency should not be changed without consulting auditors and tax authorities, as it affects the entire accounting period and comparative figures.

In Facteno, the base currency is set during implementation and is enforced across all modules. Every foreign-currency transaction is converted to base currency at the rate specified at the time of posting, and the original amount and rate are stored alongside the converted amount. This means that the finance reports always show both the original and converted amounts, allowing auditors to verify the conversion without leaving the system.

Transaction exchange rates: when and how to lock them

Exchange rates must be locked at the moment the transaction is posted, not at month-end or when the bank statement arrives. This ensures that the financial records reflect the economic reality of the transaction and prevents retrospective adjustments that auditors will question.

Facteno allows plants to set exchange rates in three ways:

• The system can fetch daily rates from a central bank or commercial provider and apply them automatically to transactions posted on that day.
• Users can enter a manual rate at the time of posting, which is then locked and cannot be altered without leaving an audit trail.
• For contracts with fixed exchange rates, the rate can be set at the time the order is confirmed and applied to all subsequent invoices and payments.

Once locked, the rate is used to convert the transaction to base currency and is stored with the transaction record. This ensures that the audit trail is complete and that auditors can verify the conversion without relying on external spreadsheets.

What auditors expect to see in multi-currency records

Auditors will check three things in multi-currency records: consistency, traceability and completeness. They will expect to see:

• Every foreign-currency transaction recorded in both its original currency and the base currency, with the exchange rate used clearly shown.
• A clear audit trail from the source document (invoice, payment voucher, bank statement) to the ledger entry, with no gaps or manual adjustments.
• Exchange gains or losses calculated and posted to the correct nominal account, with supporting documentation for any large or unusual items.
• Bank reconciliations that tie the foreign-currency bank balance to the base-currency ledger, with any timing differences clearly explained.

Facteno meets these requirements by posting every transaction in its original currency and converting it to base currency at the locked rate. The system maintains a complete audit trail, including who posted the transaction, when, and from which screen. This means that auditors can trace any entry back to its source without leaving the system, reducing the time and cost of the audit.

Illustration: a dollar sale converted to local currency

On 15 March, a plant invoices a US customer for $10,000. The exchange rate on that day is 1 USD = 85.50 local currency units (LCU). The plant receives payment on 30 March, when the exchange rate is 1 USD = 86.00 LCU. Here is how the transactions are recorded:

The invoice is converted to LCU at the rate on 15 March, and the payment is converted at the rate on 30 March. The difference of 5,000 LCU is posted to the exchange gains account, where it will appear in the profit & loss statement for the period.

Exchange gains and losses: where they come from and how to report them

Exchange gains or losses arise when the exchange rate changes between the date a transaction is posted and the date it is settled. They are a normal part of multi-currency trading and must be reported in the profit & loss statement, not hidden in the balance sheet.

In Facteno, exchange gains or losses are calculated automatically when a foreign-currency transaction is settled. The system posts the gain or loss to the correct nominal account, ensuring that the profit & loss statement reflects the economic reality of the transaction. The system also provides a report showing all exchange gains and losses for the period, broken down by currency and nominal account, which auditors can use to verify the figures.

When exchange gains or losses are material

If exchange gains or losses are material (typically more than 5% of profit before tax), auditors will expect to see them disclosed in the notes to the accounts. The disclosure should include:

• The amount of exchange gains or losses recognised in the profit & loss statement for the period.
• The amount of exchange gains or losses deferred in the balance sheet at the period end.
• The accounting policy for exchange gains or losses, including how they are calculated and where they are reported.

Facteno provides all the information needed for this disclosure in its finance reports, including a breakdown of exchange gains and losses by currency and nominal account.

What to do next week

If your plant trades in multiple currencies, take these steps in the next week:

• Review your current process for recording foreign-currency transactions and identify any manual steps or spreadsheets that could introduce errors.
• Check that exchange rates are locked at the moment of posting and not altered retrospectively.
• Run a report showing all foreign-currency transactions for the last month, with the original amount, exchange rate and converted amount.
• Verify that exchange gains or losses are being calculated and posted to the correct nominal account.
• If you are using spreadsheets to reconcile foreign-currency transactions, consider whether an ERP system would reduce errors and save time.

These steps will help you identify any gaps in your multi-currency reporting and prepare for your next audit.