Appendix 5B Section 4.5: The FX Line That Breaks Reconciliation for ASX Junior Explorers

Section 4 of the Appendix 5B reconciles the quarter. It takes the three section totals, net cash from operating activities (4.2), investing activities (4.3) and financing activities (4.4), adds the effect of exchange rate movements on cash held (4.5), and arrives at the closing cash balance (4.6). Four of those five lines come straight from adding up Sections 1, 2 and 3. Item 4.5 does not. It is the one number on the form that has to be calculated separately, and it is the line most likely to be left blank, guessed, or quietly forced to make the reconciliation work.

This matters more than its size on the page suggests. If 4.5 is wrong, item 4.6 is wrong, and Section 5 (the reconciliation to actual bank and call deposit balances) will not tie out. For a solo CFO working through the form under deadline pressure, an FX mismatch found at Section 5 usually means retracing the whole quarter to find where it went missing.

Why the line exists

Most ASX and NSX junior explorers hold cash in Australian dollars only. But a meaningful number, particularly explorers with tenements or farm-in agreements in Africa, Papua New Guinea or the Americas, hold at least one foreign-currency bank account: US dollars for a joint venture partner, local currency for a field office, or a USD-denominated cash reserve from a capital raise. Whenever cash is held in a currency other than AUD, its Australian-dollar value moves every time the exchange rate moves, even if not a single dollar was spent or received. Sections 1, 2 and 3 only capture cash that actually moved. Item 4.5 is where the accounting standards require the entity to capture cash that did not move but changed value anyway.

This is a translation concept from AASB 121, The Effects of Changes in Foreign Exchange Rates: foreign-currency monetary balances, cash included, are restated at the closing rate at each reporting date, and the movement is recognised as an FX gain or loss. Section 4.5 is that FX movement, isolated to cash and cash equivalents specifically, for the quarter just ended.

Where the number actually comes from in Xero

Xero handles multi-currency automatically if the entity is on a plan with multi-currency enabled and the foreign bank account is set up as a foreign-currency account rather than translated at the transaction date only. Two things then happen inside Xero every period:

• Realised FX gain/loss posts when a foreign-currency transaction is paid or received at a different rate than it was raised at. This belongs in the ordinary operating, investing or financing section the underlying transaction sits in, not in 4.5.
• Unrealised FX gain/loss is generated when Xero revalues the closing balance of a foreign-currency bank account to the period-end rate, through the Foreign Currency Gain/Loss report. This unrealised revaluation on cash balances specifically is the number that maps to Section 4.5.

The most common Section 4.5 error is not a wrong number. It is no number, because the unrealised revaluation was never run for the quarter end date, or it was run but posted to a general FX account that also catches revaluation on foreign-currency trade debtors, creditors, or loans, none of which belong in 4.5. Item 4.5 is cash and cash equivalents only. If the FX account in the chart of accounts blends cash revaluation with debtor and creditor revaluation, the number pulled for 4.5 will be wrong even when the FX report was run correctly.

The fix: split the FX account before it becomes a quarterly problem

The practical solution is a chart of accounts change, not a process change. Give foreign-currency cash its own unrealised FX gain/loss account, separate from the general FX account that catches everything else. Once that split exists:

1. Run the Xero Foreign Currency Gain/Loss revaluation as at the last day of the quarter, before pulling any 5B figures.
2. Confirm the revaluation posted to the dedicated cash-only FX account, not the general one.
3. That account's movement for the quarter is item 4.5, no further calculation required.
4. Cross-check: opening cash (from last quarter's 4.6) plus 4.2, 4.3, 4.4 and 4.5 should equal this quarter's 4.6 exactly, before moving to the Section 5 bank reconciliation.

Done this way, item 4.5 stops being a plug that gets adjusted until Section 5 balances, and becomes a number with a source: one Xero report, one dedicated account, one figure that a reviewer can trace back to a specific revaluation entry.

What this has nothing to do with

It is worth being precise about what does not belong in 4.5, because the confusion runs both ways. Realised gains or losses on paying a foreign-currency supplier invoice sit in Section 1 or 2 with the underlying payment. Revaluation of a foreign-currency loan sits with Section 3 financing, not 4.5. Revaluation of foreign-currency trade debtors or creditors does not appear on the 5B cash flow statement at all, since neither is cash. Section 4.5 is narrower than "all our FX movements this quarter." It is the revaluation of cash and cash equivalents specifically, and nothing else.

Where to start

If your explorer holds any foreign-currency cash and Section 5 has been a fight in past quarters, three checks resolve most of it:

1. Confirm Xero multi-currency is enabled and the foreign bank account is genuinely set up as a foreign-currency account, not just labelled in AUD.
2. Split the unrealised FX gain/loss account so cash revaluation is separated from debtor and creditor revaluation.
3. Run the currency revaluation as at quarter end, before touching any other 5B section, so 4.5 is available before you need it, not derived under pressure at the end.

Once that setup is in place, item 4.5 stops being the line that breaks reconciliation and becomes the line that proves it, because Section 4 and Section 5 tie out for a reason a reviewer can see, not because the number was nudged until they did.

Syed Samir Ahmad
Founder, Genius Accounting Solutions
CA ANZ | MBA | Salesforce Certified (4x) | Xero Partner