Multiple currencies in an EDF worksheet: avoid misleading totals

Keep USD, EUR, INR and other currency amounts readable without adding unlike values together.

A total is meaningful only when its unit is clear. Adding USD 500 and EUR 500 produces a count of numbers, not a reliable currency amount. Keep original currencies visible throughout your working schedule, especially when one payout provider converts several invoices into a single local credit.

Preserve original amounts and conversion evidence

Record the invoice currency on every row. Keep the original gross value even if your accounting system also displays a home-currency equivalent. Where a provider converts money, retain the settlement amount, rate information available from the provider and resulting credit. Label an accounting conversion separately from the actual settlement conversion so readers do not confuse the two.

Review totals by currency and purpose

Create a subtotal for each currency and check counts beside them. If your bank requires a converted presentation, ask which method and supporting evidence it accepts. Keep that presentation alongside the originals. Do not choose an exchange rate from a search snippet simply to make the bank credit match an expected value; differences need a traceable explanation.

Use explicit units in every view

Currency should travel with the number wherever it appears: input sheet, summary, PDF and enquiry. A column heading saying amount is insufficient if rows can contain different currencies. Do not allow an empty currency to default silently to the previous row. Check imported data for symbols that could be ambiguous, such as a dollar sign without a currency code.

Keep totals by currency and show counts beside them. A consolidated management view may use converted figures, but label its conversion basis and keep it separate from the original export values. A reviewer should never need to infer whether a number is USD, EUR or INR from the customer’s country or the account receiving the final credit.

Trace conversion in stages rather than forcing one rate

A provider may convert an invoice currency into a payout currency and a bank may apply another conversion or charge. Preserve each documented stage. The invoice-to-provider reconciliation and provider-to-bank reconciliation may use different evidence and different dates. Treat them as linked bridges instead of trying to force the whole route into one unexplained exchange rate.

Where the evidence does not show a rate, ask the responsible provider for the relevant statement or explanation. Do not insert a public market rate and call it the actual transaction rate. A public reference may serve a separate accounting purpose, but it should be labelled accordingly. The accepted regulatory presentation or conversion method must be confirmed with the relevant institution.

Handle rounding and negative entries visibly

Small rounding differences can occur in reports, but do not automatically dismiss every small difference as rounding. Compare the precision and units used by each source. Record a supported rounding adjustment separately, with an explanation of how it arose. Keep refunds or reversals as negative events linked to the original transaction rather than removing them to improve the subtotal.

Before sharing a schedule, inspect number formatting. Thousands separators and decimal conventions differ across systems and can change the apparent amount. Review a sample of large values and fractional amounts after import or export. The final reader should see a consistent presentation while the original document remains available to verify the precise value.

A fictional example

Two invoices are USD 900 and EUR 600. The monthly worksheet shows two subtotals. A later INR payout is connected through provider statements rather than entered as a third new export invoice.

Preparation checklist

Require a currency on each amount.
Separate original and converted figures.
Keep the provider’s rate and fee evidence where available.

Can the Braininnx organiser total mixed currencies?

It keeps currency totals separate. Any regulatory conversion method should be confirmed with the receiving authority.

FICTIONAL WALKTHROUGH

EUR invoices settled through a USD payout

A fictional business raises EUR 700 and EUR 300 invoices. Its provider statement converts the combined settlement to USD and identifies charges separately. The working invoice table keeps EUR 1,000 as its original-currency subtotal and records the provider conversion evidence as a linked stage.
The USD payout then leads to an INR bank credit. A second reconciliation links the USD transfer to the INR statement. The preparer does not add EUR, USD and INR together or treat each stage as a new sale. Each amount retains its own currency label.
The bank is asked how it wants the final schedule represented. The business retains both original invoices and both settlement stages, allowing a reviewer to reproduce the route without assuming a single rate from an internet calculator.

Your next step

Open the invoice organiser

Sources and scope

Sources reviewed 9 October 2026. The routines and fictional examples are editorial preparation suggestions. They do not confirm your bank’s acceptance, classification or transaction status.