Sections 1 and 2 of the Appendix 5B are meant to be a complete account of every dollar that moved through your bank accounts during the quarter, split between operating activities (Section 1) and investing activities (Section 2). In theory, the two sections together should reconcile exactly to the movement on your Xero bank statement for the period. In practice, most FCs building a 5B by hand find a gap on the first attempt, and spend an afternoon tracing it back through the ledger.
With the June quarter due 31 July, the reconciliation is worth running properly rather than forcing a number to fit. Here is the process.
What the reconciliation actually checks
The tie-out is simple in principle: net cash from operating activities (item 1.9) plus net cash from investing activities (item 2.6) plus net cash from financing activities (item 3.10) should equal the net movement in cash and cash equivalents for the quarter, which in turn should equal the difference between your opening and closing bank balances at items 4.1 and 4.6.
| Xero source | 5B mapping | What to check |
|---|---|---|
| Bank transaction export, quarter date range | Sections 1 & 2 line items | Every transaction is coded to an account that maps to a specific 5B line, not left in a suspense or uncoded bucket |
| Account codes tagged as capitalised E&E | Item 2.1(d) | Coded consistently with the entity's AASB 6 policy, not judgement-call by whoever entered the bill |
| Inter-account transfers (e.g. term deposit to operating account) | Excluded from Sections 1 & 2 | Internal transfers between the entity's own bank accounts are not operating or investing cashflow and must be stripped out before totalling |
| GST component of each transaction | Excluded from 5B (GST-exclusive reporting) | Xero reports include GST by default; the 5B figures do not |
| Opening and closing bank balances | Items 4.1 and 4.6 | Matches the actual Xero bank account balance at the first and last day of the quarter, not a rounded estimate |
The four errors that break the tie-out
GST-inclusive coding. The single most common gap. If even a handful of transactions are pulled through at their GST-inclusive value instead of the net amount, Sections 1 and 2 will not reconcile to the bank movement, and the gap is rarely obvious from the total alone, since it is usually a mix of overstated and understated lines that partially offset.
Capitalised E&E miscoded to operating. Exploration and evaluation spend that should sit at item 2.1(d) under the entity's AASB 6 policy is frequently coded to a general operating expense account in Xero, especially when the same cost centre also carries genuine administrative overhead. This inflates Section 1 outflows and understates Section 2, while the total may still net out, which is exactly why it survives unnoticed until an auditor or an ASX query asks for the split. See our companion article on the AASB 6 capitalisation boundary for the classification rules themselves.
Related-party payments left in the general ledger accounts. Director fees and related-party payments need to be separately identified for Section 6 as well as correctly classified within Section 1. If they are coded to a generic consulting or administration account with no tracking flag, they are invisible at reconciliation time and only surface when someone manually reviews the Section 6 disclosure.
Internal transfers counted as cashflow. Moving cash from an operating account to a term deposit, or drawing down a facility into the operating account, is not operating, investing, or financing activity in the 5B sense. It is cash moving between the entity's own accounts. Left uncoded correctly, these transfers inflate both inflows and outflows and can make Section 8's runway calculation look better or worse than it actually is.
Reconciliation check that catches all four: total Section 1 net cash flow plus Section 2 net cash flow plus Section 3 net cash flow should equal (closing bank balance) minus (opening bank balance) for the quarter, adjusted for any unpresented items. If it does not tie within a few dollars, one of the four errors above is present somewhere in the quarter's coding.
Why this is a coding problem, not a 5B problem
Every one of the four errors above originates in how a transaction was coded in Xero during the quarter, not in how the 5B template adds things up. That is why the fix is upstream: a Xero chart of accounts and tracking category structure that separates capitalised E&E, related-party payments, and internal transfers from ordinary operating spend, applied consistently at the point of data entry, is what our companion piece on tracking category setup for Appendix 5B walks through. Reconciliation at quarter end confirms the setup worked; it should never be the first time the coding gets checked.
This is exactly what our ASX 5B Automation checks automatically. It reads every bank transaction and bill payment for the quarter directly from Xero, applies the entity's AASB 6 capitalisation policy to classify each line into its correct 5B section, and produces a full audit trail so every figure traces back to source. Items requiring CFO judgement, including anything that would affect the reconciliation, are surfaced with a review flag before anything reaches the template, rather than a total that quietly doesn't add up.
Does your June quarter 5B tie out to the bank?
We can run the reconciliation against your live Xero data and show you exactly where, if anywhere, Sections 1 and 2 diverge from the bank movement, before you lodge on 31 July.
Get in touch →
Syed Samir Ahmad
Founder, Genius Accounting Solutions
CA ANZ | MBA | Salesforce Certified (4x) | Xero Partner