Getting started

Check That Your Accounts Add Up: Reconciling Cards and Banks in One View (Australia)

Combine statements, then check each account's opening balance plus inflows minus outflows equals the closing balance. A worked A$ example with formulas.

Editorial illustration for Check That Your Accounts Add Up: Reconciling Cards and Banks in One View (Australia)

Once you have merged several accounts into one list, check it. For each account, opening balance plus money in minus money out should equal the closing balance printed on the statement. If it does, nothing is missing. If it does not, you have found a gap before it distorts your totals.

What is the reconciliation formula?

Closing balance = opening balance + money in - money out. Do it per account, not for the combined list, so a gap can be traced to one place.

A worked example with two accounts

ItemEveryday accountCredit card
Opening balanceA$2,400.00A$0.00
Money inA$3,800.00A$900.00
Money outA$3,950.50A$1,140.20
Calculated closingA$2,249.50negative A$240.20
Statement closingA$2,249.50negative A$240.20

The everyday account: 2,400 plus 3,800 minus 3,950.50 is 2,249.50. The card: starting at zero, money in of 900 (a repayment), money out of 1,140.20 (purchases) leaves minus 240.20, meaning you owe that. Both match, so nothing is missing.

How do I get these numbers from a sheet?

  • Money in for one account: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Everyday", $F$2:$F$500, "In")
  • Money out for the same account: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Everyday", $F$2:$F$500, "Out")
  • Calculated closing: the opening balance plus the first cell minus the second.

Here Amount is in column C, Account in D and a Direction column F holds In or Out. These work in Excel and Google Sheets as written.

What if the numbers do not match?

  1. Check the date range: did you include the first and last day?
  2. Look for a line pasted twice, which is common when statements overlap.
  3. Look for a missing page or a skipped row.
  4. Compare the difference with the amount of single lines; if the gap is A$45.00, hunt for a A$45.00 line.

Where does an app help?

SpendixAI asks you to pick the account before importing, keeps each transaction with its account, flags possible duplicate imports and lists possible duplicate charges, which saves the hunt for repeated lines. It is built around India and INR, so it is not offered here as a promise for Australian users. Look for duplicate checks in any tool.

What should I do with the gap if we cannot find it?

Sometimes a small gap stays unexplained. Record it as an adjustment line with a clear note, such as "unreconciled difference, A$3.20", so your totals match the statement and the gap is visible rather than hidden. Review it next month; often a delayed transaction explains it.

Do not let a tiny gap stop you using the combined view. Perfection is not the aim. A figure that is right to within a few dollars, with a note about the difference, is far more useful than no view at all.

How do I use the check after the first month?

Once an account reconciles, the closing balance becomes next month's opening balance. Copy it forward, and the next check starts with a trusted figure. Over a few months you will build a short history of balances for each account, which also shows whether money is growing or shrinking overall.

The routine is small: opening balance, money in, money out, closing balance. Four numbers per account, once a month.

If you keep a spreadsheet, add a small check row under each account: opening, in, out, calculated closing, statement closing, and a difference cell that should read zero. A glance at a column of zeros tells you the month is clean.

Make it a habit

  • Reconcile each account at month end.
  • Note the opening and closing balances in the sheet.
  • Investigate any gap the same day.

This article is about records. Charges and rules differ between institutions; read your own statements and terms.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports