Bank Reconciliation: How to Match Payments to Invoices (Australian Guide)

Bank reconciliation is checking that every deposit and withdrawal on your bank statement matches a record in your books, and that the two balances agree at a set date. For a business that invoices, the core of it is matching each payment to the invoice it pays, recording card processing fees separately from the sale, and following up anything left unmatched. Do it at least monthly and always before you lodge a BAS, because an unmatched payment usually means either an invoice is still unpaid or your GST figures are wrong.

What is bank reconciliation?

Bank reconciliation compares your bank statement with your accounting records for the same period and explains every difference. When it is done, the balance in your books equals the balance at the bank, after allowing for items still in transit. Three related terms describe slices of the same job.

For most sole traders and small businesses, all three happen in one sitting: you go down the bank statement line by line and match, record or query each item.

Why does bank reconciliation matter for an Australian business?

Reconciling catches unpaid invoices, duplicate payments, missed expenses and fraud while they are recent enough to fix. It also keeps your BAS accurate, because the GST you report depends on income and expenses that only reconciled books get right.

• Unpaid invoices surface early. If an invoice was due on the 14th and nothing matching it has arrived, you can chase on the 15th instead of finding out at the end of the quarter.
• GST credits on fees get claimed. Card processing fees are a business expense with GST in them. If you only record the net payout, you understate both income and expenses.
• Payment-redirection scams show up. A client who says they paid but whose money is not in your account may have been sent fake bank details. Reconciling quickly gives the client's bank the best chance of recovering the money.
• Records hold up. The ATO requires most business records to be kept for five years. A monthly reconciliation file with notes on how each odd item was resolved is the evidence you want if anything is questioned. See the ATO's record-keeping rules.

How to reconcile payments to invoices: step by step

Work through the bank statement in date order, match each deposit to an invoice or other income, record anything not yet in your books, and finish by checking that the adjusted balances agree. Seven steps cover it.

1. Pick the period and gather the documents. Bank statement (or a CSV export), your list of invoices with their status, and payout reports from Stripe, Square or PayPal for the same dates.
2. Start from a reconciled opening balance. Your book balance at the start of the period should equal last period's reconciled closing balance. If it does not, fix last month first.
3. Match deposits with a clear reference. Any deposit whose description contains an invoice number and the right amount gets marked as paid against that invoice.
4. Break down processor payouts. Use the provider's payout report to split each payout into the individual sales it contains, minus fees and refunds. Match each sale to its invoice.
5. Investigate the rest. Match by payer name and amount, look for part-payments and combined payments, and put genuinely unidentified money in a holding account.
6. Record outgoings. Check each withdrawal against a supplier bill or expense record, and enter bank fees, merchant fees and direct debits you have not recorded yet.
7. Agree the balances. Bank closing balance, plus deposits you have recorded that have not cleared yet, minus payments you have recorded that have not cleared yet, should equal your book balance. Any remaining difference is an error to find, not a figure to plug.

How do you match payments when the reference is missing?

Match on the strongest evidence available: invoice number first, then exact amount plus payer name, then amount and date against open invoices for that client. If two open invoices could fit, do not guess. Ask the client which one they paid.

Reference quality depends partly on how the client pays. When both banks support Osko, the payment description can be up to 280 characters, so an invoice number and business name fit easily. Older-style BSB transfers often carry a much shorter reference, and some banks cut it off. That is why a short, consistent format such as INV-1042 works better than a long description. Our guide to numbering invoices covers formats that survive truncation.

Common patterns and what to do with them:

• Payer name only: match by amount against that client's open invoices, then confirm by email.
• One payment for several invoices: split it across the invoices it covers, oldest first unless the client says otherwise.
• Part-payment: apply it to the invoice and leave the balance open. Send a statement of account showing what remains.
• Short by exactly the GST: the client paid the subtotal and missed the 10% GST line. Ask for the difference; do not reissue the invoice.
• Duplicate or overpayment: refund it or issue a credit note against a future invoice, and record what you did.

How do you reconcile Stripe and Square payouts (gross vs net)?

Card processors pay you the net amount: the sale minus their fee, often with several sales bundled into one payout. Record each invoice as paid at the full gross amount, record the fee as a separate expense, and the payout then matches what landed in your bank. Never record the net payout as the sale.

Example: invoice INV-1042 is for $1,100 including $100 GST, and the client pays by card through Stripe. As at October 2026, Stripe's published rate for domestic cards in Australia is 1.65% + 30c, and Stripe says its fees include GST (check the current figure on Stripe's Australian pricing page).

In your books: INV-1042 is paid in full at $1,100, your sales include $100 of GST payable, merchant fees go up by $16.77, and you have a $1.68 GST credit if you are registered and hold the provider's tax invoice or fee statement. Square, for example, provides a monthly tax invoice for its fees in the Square Dashboard. Payouts that bundle several sales work the same way: list each sale, subtract the total fees and any refunds, and check that the result equals the deposit.

Payouts also lag the sale. A card payment taken on Friday 31 October may not reach your account until the following week, so it sits as "money in transit" at month end. That is normal; note it and it will clear next period.

A worked bank reconciliation example

Here is a month of incoming payments for a marketing consultant with seven deposits and seven open invoices at the start of October 2026. Five deposits matched an invoice, one was a duplicate and one could not be identified.

Two invoices that had no deposit at all, INV-1039 ($880) and INV-1043 ($1,540), stay open on the receivables list. The follow-up list for the month is: chase $820 on INV-1036, ask for the missing $100 GST on INV-1041, identify the $3,300, refund or credit the duplicate $2,200, and remind the clients on INV-1039 and INV-1043. An aged receivables report keeps that list in order of urgency.

To finish, agree the balances. Say the bank statement shows $18,430.55 at 31 October. A $640 Square payout recorded in the books is still in transit, and a $1,200 supplier payment scheduled on the 31st has not cleared. $18,430.55 + $640.00 − $1,200.00 = $17,870.55, which should match the cash balance in your books. If it does not, the difference is usually a missed bank fee, a typo or a transaction entered twice.

What do you do with unmatched payments?

Put unmatched money in a holding (suspense) account, never against a random invoice. Then work outwards: check the amount against every open invoice, check the payer name against your client list, and look at the date against recent quotes or deposits you requested.

If you still cannot identify it after a few days, contact the most likely client and ask, or ask your bank for any further detail on the payer. Do not spend it. Money paid to you by mistake may have to be returned, and an unexplained deposit sitting in your income can also distort your BAS. Once you know what it is, move it out of suspense and note how you resolved it.

The reverse problem, where a client insists they paid and nothing has arrived, deserves a fast response. Check the account details they used against your invoice. If they do not match, the client may have received a fake invoice or a spoofed email, and they should contact their bank immediately.

How to do a bank reconciliation in Excel

Excel or Google Sheets works well for up to a few dozen payments a month. Use one sheet for bank transactions and one for invoices, pull the invoice number out of each bank description, and let formulas match and total the payments.

• Bank sheet columns: A Date, B Description, C Amount, D Invoice no. In D2, extract a reference such as INV-1042: =IFERROR(MID(B2,SEARCH("INV-",B2),8),"")
• Check it exists: in E2, =IF(D2="","No ref",XLOOKUP(D2,Invoices!A:A,Invoices!B:B,"Not found")) returns the client name or flags the line.
• Invoices sheet columns: A Invoice no, B Client, C Total incl. GST, D Paid, E Balance, F Status. In D2, =SUMIFS(Bank!C:C,Bank!D:D,A2). In E2, =C2-D2.
• Status: in F2, =IF(E2=0,"Paid",IF(E2<0,"Overpaid",IF(D2>0,"Part paid","Unpaid")))

For Stripe or Square, enter the gross sale against the invoice and add the fee as a separate negative line on the bank sheet so the bank sheet total still equals the deposit. Sort by status at month end and you have your follow-up list.

How often should you reconcile, and how does it tie to your BAS?

Reconcile at least monthly, and always before lodging a BAS. Quarterly BAS lodgers have deadlines of 28 October, 28 February, 28 April and 28 July (see the ATO's BAS due dates), so three monthly reconciliations mean the quarter is already clean when the BAS is due.

Before lodging, check three things: total sales (G1) agree with your reconciled invoices for the period, GST on sales is one-eleventh of GST-inclusive taxable sales, and GST credits include the GST on merchant and bank fees you have tax invoices for. If you report GST on a cash basis, only invoices actually paid in the quarter count, which makes the reconciliation itself the source of your sales figure.

If keeping track of who has paid is the part that keeps slipping, InvoiceSonic sends automatic payment reminders at 7, 14 and 30 days after the due date, so an unpaid invoice gets followed up without waiting for your month-end reconciliation.

This article is general information, not tax, accounting or financial advice. Fees and examples are illustrative and were checked as at October 2026. For guidance specific to your situation, see the ATO and business.gov.au, or speak to a registered tax or BAS agent.

Frequently asked questions