Make sure the two balances use the same currency
Identify the bank account's currency and the currency shown in the accounting report. A euro statement cannot be compared directly with a dollar balance-sheet value. Record both labels, the reporting date and the account identifier before investigating a difference that may simply reflect two different measures.
Xero distinguishes a foreign bank account's own-currency balance from its revalued base-currency balance. Other systems use their own report names, so locate the equivalent native-currency view in your software. Confirm the account was configured in the correct currency before changing transactions or exchange rates.
References: Xero: Foreign-currency bank balances and revaluation; Xero: Foreign Currency Gains and Losses report
Reconcile the actual money movement first
Match the statement opening balance, receipts, payments and closing balance in the currency the bank holds. Investigate missing transactions, duplicate imports, fees and transfers using their original amounts. A native-currency shortage should not be sent to an exchange-difference account merely because the account is foreign.
For a transfer between differently denominated accounts, preserve the amount leaving one account and the amount reaching the other, plus the bank's conversion and fee evidence. Each account needs its own reconciliation. The transfer relationship should explain why the two numeric amounts differ without requiring them to be identical.
Keep cutoff differences identifiable. A payment instructed near month-end may post in another period, and reports can use different dates. Confirm the statement period and accounting cutoff with the accountant before adjusting dates simply to make the balances agree. Retain the original payment date and bank posting date in the exception record so later reviewers can follow that judgment.
Review the reporting-currency value as a separate calculation
Once the native balance is supported, obtain the revaluation report and the applicable exchange-rate evidence. Ask the accountant to confirm the reporting policy, date and rate source. Distinguish transaction-level conversion from the period-end translation of the remaining balance.
Xero's foreign-currency report provides both account-currency and base-currency balances and identifies the rates used in its footnotes. Inspect equivalent details in the actual report rather than relying on a dashboard rounded to whole units. A manual rate or different report date can explain a translation difference without any missing bank transaction.
For a hypothetical account holding EUR 12,000, an illustrative reporting rate of USD 1.10 per euro produces a USD 13,200 translated amount before other accounting considerations. That calculation does not imply that the bank holds USD 13,200 or that converting the euros would yield that exact cash amount after provider terms and fees.
References: Xero: Foreign Currency Gains and Losses report
Preserve both conclusions in the close pack
Keep the native-currency reconciliation and the reviewed reporting-currency calculation together, with a clear link between them. The reviewer should see that the bank balance was supported before evaluating the translation. Record any adjustment in the appropriate layer under the accountant's direction.
If the system automatically generates currency movements, inspect its supported correction process before adding manual journals. An extra journal can duplicate an adjustment already included in a report. Retain the software report and the explanation for any manual entry so the next period's movement remains understandable.
Carry forward the verified foreign balance, unresolved bank items and approved valuation policy. When management requests a consolidated cash total, show the conversion basis and any limits on using the funds. The translated amount is a reporting measure; payment planning still needs the actual currencies, account locations and settlement requirements.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.