Bank Reconciliation Generator

What is a bank reconciliation and why does it matter?

A bank reconciliation is the process of comparing your business's internal accounting records (the "book balance") against the closing balance on your bank statement for the same date, and explaining every difference. When both sides agree after accounting for timing items, your accounts are reconciled. When they don't, there is an error — or potentially a fraud — to investigate. Bank reconciliation is one of the most fundamental internal controls in any business, regardless of size.

For Australian businesses, the bank reconciliation also supports BAS accuracy. GST-registered businesses on an accruals basis account for GST when invoices are raised or received — but the bank statement captures the cash reality. Regular reconciliation ensures that all cash movements are captured in the correct BAS period and that no transactions are omitted or duplicated. The ATO requires business financial records — including bank statements and reconciliation workpapers — to be retained for at least five years under section 262A of the Income Tax Assessment Act 1936.

A common mistake is performing the bank reconciliation infrequently — monthly at best, quarterly or annually at worst. The longer the gap between reconciliations, the harder it becomes to trace individual discrepancies, and errors can compound across periods. For high-volume businesses, weekly bank reconciliation is the standard. For smaller businesses, completing it within five business days of each month-end is a reasonable target.

How to use this generator

1. Enter your company name, bank account name, and the reconciliation date (typically the last day of the month).
2. Enter the closing balance from your bank statement and your book balance from your accounting software as at the same date.
3. List reconciling items: deposits in transit (add to bank balance), outstanding payments (deduct from bank balance), bank fees and charges not yet in books (deduct from book balance), and interest or direct credits not yet recorded (add to book balance).
4. The tool calculates adjusted balances — both sides should agree. Download as PDF and file alongside the corresponding bank statement.

What are the most common reconciling items?

The most frequent timing differences in Australian bank reconciliations are: deposits in transit (receipts recorded in the books that haven't yet cleared the bank — common for end-of-month receipts banked on the last business day), unpresented payments (EFT payments or cheques recorded in the books that haven't yet been presented to the bank), bank fees and account-keeping charges deducted by the bank but not yet recorded in the books, interest earned credited by the bank but not yet journalised, and ATO-initiated direct debits (PAYG instalments, BAS payment arrangements) that may not have been recorded in Xero or MYOB before the bank statement was downloaded.

What if my bank reconciliation doesn't balance?

If the adjusted book balance and adjusted bank balance don't agree, start by checking whether the opening balance from the prior month's reconciliation is correct — a prior-period error carries forward. Then check for transposition errors (numbers entered in reverse, e.g. $1,980 instead of $1,890), duplicated entries, omitted transactions, or transactions posted to the wrong period. If the unreconciled difference is exactly divisible by 9, a transposition error is very likely. If it matches a single transaction amount, search for that amount in both the bank statement and the general ledger to identify which side is missing it.

How does bank reconciliation relate to accounts payable?

Supplier payments are one of the largest outflow categories on any business's bank statement. Unpresented payments to suppliers — cheques issued or EFT transfers initiated but not yet cleared — are a standard reconciling item. If your AP process is manual and payment runs are not recorded promptly in your accounting software, the book balance will overstate available cash, and the reconciliation will show unexplained differences. Automating AP through a platform that posts payment records at the point of payment initiation eliminates this source of reconciling items and reduces month-end close time significantly.