Bank Statement Reconciliation: Balances and Gaps

What Reconciliation Proves in a Legal Matter

Reconciliation establishes the completeness and arithmetic of the supplied statement sequence for the period you are analysing. Each calculation used in a schedule must trace to the statements and agree with their totals. Cross-account matching then separates internal movements from money entering or leaving the group of accounts.

Bookkeeping reconciliation has a different starting point. It matches bank transactions to records in an accounting ledger, such as invoices and payments. In a dispute, you can have years of PDFs without a reliable ledger to compare against.

The legal review therefore starts with the source records themselves. Establish which accounts and periods the bundle covers before drawing conclusions about income or expenditure. A balanced sequence for one account cannot establish that every account has been disclosed.

Before starting, define the review period and the people or entities whose accounts are relevant. Keep the original PDFs and identify each account by bank, account number and currency. Record the statement’s printed coverage period and page count, including pages with no transactions.

Balance Continuity Checks

Check each statement’s arithmetic, then match its closing balance to the next statement’s opening balance for that account. For a deposit account, the calculation is opening balance plus credits minus debits equals closing balance. Include interest and fees among the posted transactions.

Use the balance convention printed on the statement. For a credit card showing a positive amount owed, purchases and fees increase that amount while repayments reduce it. Do not apply the deposit-account formula to a debt balance without adjusting the signs.

Follow these checks in order.

1. Add the credits and debits on every page of the statement. Compare those sums with any printed transaction totals.
2. Calculate the closing balance from the opening balance and those totals. Record the difference between your result and the printed closing balance. The expected difference is zero.
3. Put the statements in coverage order within each account. Compare each closing balance with the opening balance of the next consecutive period. Those balances must agree.
4. Investigate each difference against the original pages. Look for a missing page, a duplicated transaction or a debit read as a credit. Recalculate after correcting the identified cause.

Consider this hypothetical deposit account. Each supplied statement covers one month.

Period	Opening balance	Credits	Debits	Closing balance	Continuity result
Month 1	AUD $10,000	AUD $6,000	AUD $4,000	AUD $12,000	Arithmetic agrees
Month 2	AUD $12,000	AUD $3,000	AUD $5,000	AUD $10,000	Opening matches Month 1 closing
Month 3	Missing	Unknown	Unknown	Unknown	One month absent
Month 4	AUD $7,000	AUD $5,000	AUD $2,000	AUD $10,000	Opening is AUD $3,000 below Month 2 closing

Month 4 passes its own arithmetic test: AUD $7,000 plus AUD $5,000 minus AUD $2,000 equals AUD $10,000. The sequence still has a gap. The missing month must explain how the balance moved from AUD $10,000 to AUD $7,000.

Do not enter the AUD $3,000 difference as a transaction. It is a net movement over an undocumented period, which could contain many receipts and payments. Request the missing statement before using that period in a cash-flow calculation.

A failed calculation can also prompt a closer examination of the document. The guide to checking a potentially fake bank statement explains how arithmetic discrepancies fit into that wider assessment.

Finding Missing Statements and Periods

Build a timeline for every account using the coverage periods printed on its statements. This exposes missing months and accounts mentioned in transfers whose own statements have not arrived. Statement counts alone cannot show whether a period is complete.

Use one row per statement, with the account identifier and covered start and end dates. Add opening and closing balances alongside the source filename. Record overlapping coverage separately so the same transactions are not imported twice.

Read the period label before deciding that a statement is missing. Everyday-account statements can cover several months, while credit card statements usually follow a monthly cycle. A term deposit can have a longer reporting interval and separate maturity documents.

The Banking Code of Practice requires subscribing banks to issue deposit-account statements at least every six months, except for passbook accounts. Customers can request more frequent statements. Westpac’s personal deposit terms also allow an inactive statement cycle to be deferred, with a statement still issued at least every six months.

NAB’s credit card terms describe a statement period as usually 30 days. Its term deposit terms specify six-monthly statements for terms longer than six months, or more often on request. The deposit term and the statement period are separate measures.

A six-month statement can cover all six months in one document. A monthly account with statements for Month 2 and Month 4 has a missing Month 3 even if both supplied documents balance. Check coverage at the start and end of the requested review period too.

Make the follow-up request specific to the account and uncovered period. For the hypothetical example, a suitable request is below.

Please provide the complete statement for Month 3 for the account ending 4821, including all transaction pages. The supplied Month 2 statement closes at AUD $10,000, while Month 4 opens at AUD $7,000. Please also provide the statement immediately before Month 1 if it is needed to establish the review’s opening balance.

In the actual request, replace the relative period labels with the exact dates printed on the surrounding statements. Identify any transfer destination for which you also require account details and records. The guide to obtaining old bank statements covers retrieving those missing documents.

Reconciling Across Related Accounts

Match each transfer out with the corresponding deposit into the related account, while retaining both statement entries. Transaction reconciliation prevents an internal transfer from inflating the reconstructed income and expenditure totals.

Start with the account details and transaction reference. Compare amounts and posting dates, allowing for a processing delay between the debit and credit. Matching only on amount is unsafe when several accounts have repeated payments of the same size.

In a hypothetical example, AUD $8,000 leaves an everyday account and reaches a savings account owned by the same person. The two rows document one internal movement. Adding the savings deposit to external income would count the same funds again.

Mark the rows with a shared transfer identifier. Exclude both sides from external cash-in and cash-out totals for the combined accounts, while retaining them in each account’s own balance reconciliation. A transfer to an account outside the review remains an outflow from the accounts you are analysing.

For cross-currency transfers, retain the original currency and amount on each side. Use the transfer confirmation’s exchange rate and any fee to explain the receiving amount. A current exchange rate does not establish what the historic payment delivered.

For example, assume a confirmation records USD $2,000 sent, a USD $10 fee deducted and an exchange rate of AUD $1.50 per USD $1. The receiving amount is AUD $2,985: USD $1,990 multiplied by 1.50. Match that amount to the receiving statement and keep the fee separate from the internal transfer.

Keep an unmatched transfer on an exceptions list with its source and the missing evidence. A description naming another account can point to records still required. A payment reference alone cannot establish who owns the destination account.

For years of disorganised statements from several banks, reconcile each account first, then consolidate the transactions into one ledger. Preserve account and currency fields, source filenames and page references. Mark duplicates and transfer pairs before calculating external cash flow across the whole period.

FinTrace saves forensic accountants hours of sorting and statement review by bringing large PDF bundles into one searchable ledger and a readable findings report. The service follows transfers across related accounts and matches movements across currencies. Every finding cites its source PDF filename and page, putting the supporting evidence beside the analysis.

Once transfers and exceptions are recorded, flow-of-funds analysis can show how the money moves through the reconciled accounts.

Bank Statement Reconciliation Software vs Forensic Review

Accounting bank reconciliation software matches the bank’s transactions to the organisation’s accounting records. A forensic review tests the supplied statement set and reconstructs movements relevant to the dispute.

Xero’s reconciliation guidance describes matching a bank statement line to an existing transaction or creating a transaction during reconciliation. MYOB’s guidance compares the account records with the bank statement balance and requires reconciliation even when bank feeds are used. Those workflows support maintaining business books.

Review question	Accounting reconciliation	Forensic statement reconciliation
What is compared?	Bank transactions against accounting records	Source statements within and across accounts
What explains a difference?	Unrecorded entries or timing differences in the books	Missing periods, extraction errors or unmatched movements
What must support the result?	The matched accounting transaction and bank entry	The original statement filename and page for the figure or finding
How are scans handled?	Bank feeds and imported transaction data support reconciliation	Read the scanned pages, preserve their source references and check extracted amounts against balances

A bank statement reconciliation tool can help calculate differences, but the review still needs a coverage timeline and evidence for transfer matches. A reconciled accounting balance does not by itself answer whether a scanned disclosure bundle contains every statement period.

FinTrace handles thousands of PDFs through staged extraction, source-grounding checks and independent reviews. Its report identifies gaps in the supplied statements and clearly flags suspicious transactions. Forensic accountants can spend more time interpreting the findings, with the consolidated ledger available for their own analysis.

The service performs this statement-analysis work at a fraction of the cost of manual review or engaging a forensic accountant for the same task. Firms engage FinTrace per matter, with a fixed base fee plus a per-page quote based on scope.

Allocate Payments to the Disputed Balance

Match each cleared payment to the claimed debt and the payer’s directions before reducing the disputed balance. A bank entry establishes a movement of money. The contract and applicable law determine which liability that movement discharges.

Keep the cash evidence and the proposed allocation in separate columns. Record the debit date and cleared-credit date, amount, payer and recipient, with the source filename and page. Beside them, identify the invoice or loan account and the remittance instruction. Show the proposed amounts applied to principal, interest and fees individually.

Where the parties disagree, retain both allocations with their supporting documents. For example, a payer’s instruction may nominate one invoice while the creditor’s ledger applies the receipt to another balance. Give the legal team the instruction, contract clause and competing calculations. A matching bank credit alone cannot decide that disagreement.

A payment attempt also needs its later entries checked. NAB’s Cash Manager terms explain that a deposit made available before clearance can subsequently fail and be debited back. Its direct-debit terms also allow dishonour where cleared funds are insufficient. Trace the outcome through the records before treating an attempted payment as received.

A Dishonoured Payment and Its Replacement

Consider this hypothetical debt with AUD $9,000 principal, AUD $800 interest and AUD $200 fees. Assume those amounts are agreed for the example and no further charges accrue during the sequence. The total claimed balance is AUD $10,000.

Event	Payer’s statement	Recipient’s evidence	Effective payment against debt
Attempted debit	AUD $2,000 debit appears	Credit is provisional	AUD $0 pending clearance
Dishonour two days later	AUD $2,000 returned	Provisional credit reverses	AUD $0
Replacement transfer the next day	New AUD $2,000 debit	Receipt awaits confirmation	AUD $0 pending receipt
Replacement clears the following day	Debit remains	AUD $2,000 cleared credit matches the reference	AUD $2,000

The failed attempt and replacement produce one effective AUD $2,000 payment. Counting both debits would overstate payment by AUD $2,000. Link the dishonour to the original attempt, then link the replacement debit to the cleared credit.

Assume the parties agree that the replacement pays AUD $200 fees, AUD $800 interest and AUD $1,000 principal. Record that allocation explicitly. The remaining principal is AUD $8,000, and the example’s interest and fee balances are zero. If allocation remains disputed, show the alternative balances without presenting either as agreed.

Record every actual transaction date in the working schedule, including dishonour and clearance. Keep any bank dishonour fee separate from the creditor’s claimed charges. A fee charged by the payer’s bank does not itself show that the creditor received money.

Finish the reconciliation with a record of the results. Each supplied statement must have an explained arithmetic result, each required period must be covered or listed as missing, and each claimed internal transfer must have matching evidence. Each debt reduction must match an effective payment and an explained allocation. Keep unresolved differences outside confirmed cash-flow totals and attach the exact records needed to resolve them.