Bank Reconciliation: How to Match Invoices and Payments

Quick answer: Bank reconciliation means comparing your recorded cash balance with your bank statement for the same date and explaining every difference. You match each invoice payment and expense to a bank line, adjust your books for fees or missing entries, list timing items such as deposits in transit, and confirm both balances agree.

Sending invoices is only half of getting paid. The other half is knowing, with certainty, which invoices have actually turned into cash in your bank account. Bank reconciliation is the monthly habit that gives you that certainty. It catches customer payments that went unnoticed, bank fees nobody recorded, duplicate supplier payments and the occasional fraudulent debit. This guide walks through the process step by step, shows a worked example with real arithmetic, and ends with a checklist you can reuse every month.

What is bank reconciliation?

A bank reconciliation is a short report, usually one page, that starts with the closing balance on your bank statement, adjusts it for items the bank has not processed yet, and arrives at the same figure as the cash account in your books. If the two figures match after adjustments, the account is reconciled. If they do not, there is an error or an unrecorded transaction somewhere, and the reconciliation tells you roughly where to look.

For a business that invoices customers, most of the work is on the money-in side: matching deposits to the invoices they pay. That matching step is called cash application in accounts receivable, and it feeds the reconciliation. If your receipts are applied correctly, the bank reconciliation is mostly a matter of ticking off lines.

Why bank reconciliation matters for invoicing

• Accurate receivables. An invoice marked unpaid when the money has arrived leads to embarrassing reminders. An invoice marked paid when the money never arrived means lost revenue.
• Reliable cash figures. Your cash forecast is only as good as the opening balance it starts from.
• Error and fraud detection. Unfamiliar debits, altered payee details and duplicate payments surface quickly when someone looks at every line each month.
• Clean tax records. Tax authorities expect your books to be supported by source documents. The IRS guidance on business recordkeeping lists bank statements and deposit records among the documents that support gross receipts.
• A faster month-end close. Reconciled cash is usually the first item on any month-end close checklist, because many other balances depend on it.

What you need before you start

Gather these items for the period you are reconciling:

• The bank statement (or a transaction export) covering the full month, plus the closing balance on the last day.
• Your cash account ledger for the same dates, from accounting software or your cash book spreadsheet.
• A list of invoices issued and their status, ideally your accounts receivable aging report as of the month-end date.
• Remittance advices and payment confirmations received from customers.
• Last month's reconciliation, so you can check that its outstanding items have now cleared.

How to do a bank reconciliation, step by step

1. Pick the date and lock both balances. Note the bank statement closing balance and the book cash balance at the same date. Do not mix a statement dated the 30th with a ledger run on the 3rd of the next month.
2. Clear last month's open items. Each deposit in transit and outstanding check from last month should appear on this month's statement. Tick them off. Anything still open after several weeks needs follow-up.
3. Match deposits to recorded receipts. Go down the bank statement and match each incoming payment to a receipt in your books. Use the payment reference, the customer name and the amount. A remittance advice from the customer tells you which invoices a lump-sum payment covers.
4. Match withdrawals to recorded payments. Do the same for checks, transfers, card payments and direct debits going out.
5. List bank items missing from your books. Typical examples are monthly account fees, wire charges, card processing fees, interest earned and returned payments. Record each one in your books with the bank statement as support.
6. List book items missing from the bank. These are usually timing differences: deposits made on the last day of the month and checks not yet presented. They stay on the reconciliation until they clear.
7. Investigate everything else. Amounts that differ by a few dollars, items recorded twice, payments posted to the wrong invoice or customer, and transactions you do not recognize.
8. Prepare the reconciliation statement and sign it off. Show the adjusted bank balance and the adjusted book balance side by side. They must be equal. Date the report and keep it with the month's records.

Common reconciling items and how to treat them

Item	Where it appears	Typical cause	What to do
Deposit in transit	Books only	Payment received late on the last day, credited by the bank the next business day	Add to the bank balance on the reconciliation; confirm it clears next month
Outstanding check	Books only	Supplier has not cashed the check yet	Subtract from the bank balance; chase or void if very old
Bank fee or wire charge	Bank only	Monthly fees, incoming wire fees, foreign exchange charges	Record as a bank charges expense
Interest earned	Bank only	Interest on the account balance	Record as interest income
Short customer payment	Both, different amounts	Customer or intermediary bank deducted a fee, or the customer took a deduction	Apply the receipt, then resolve the remaining balance on the invoice
Returned or bounced payment	Bank only	Insufficient funds, closed account, reversed direct debit	Reverse the receipt so the invoice shows as unpaid again
Duplicate entry	Books only	Same receipt or bill recorded twice	Delete or reverse the duplicate

Bank reconciliation worked example

Here is an illustrative month for a small design studio. The figures are made up to show the arithmetic.

On September 30, the bank statement shows a closing balance of $18,420. The cash account in the studio's books shows $17,905. That is a difference of $515, which needs to be explained.

Working through the statement, the bookkeeper finds:

• A customer check for $1,200 (paying invoice INV-0418) was deposited on September 30 but credited by the bank on October 1. That is a deposit in transit.
• Two supplier checks, for $850 and $640, have not yet been cashed. Those are outstanding checks.
• The bank charged a $25 monthly account fee that was not recorded in the books.
• A customer paid invoice INV-0409 for $2,400 by wire, but $2,385 arrived because an intermediary bank deducted $15. The books recorded the full $2,400, so the receipt must be corrected to $2,385, leaving $15 to resolve on the invoice.
• Interest of $5 was credited and not recorded.

Adjusted bank balance: $18,420 + $1,200 deposit in transit − $850 − $640 outstanding checks = $18,130.

Adjusted book balance: $17,905 − $25 monthly fee + $5 interest = $17,885. That still leaves a $245 gap against $18,130, so the bookkeeper keeps looking. She finds a $260 card refund from a supplier credited to the bank and never recorded, and remembers the $15 wire deduction on INV-0409: the books show $2,400 received, but only $2,385 hit the bank. Recalculating: $17,885 + $260 − $15 = $18,130.

Both adjusted balances equal $18,130, so the account is reconciled. Notice that the wire deduction is recorded only once, as a correction to the receipt. Booking it again as a separate bank charge is a common way to create a difference that does not exist. The $15 left on INV-0409 is now a receivables question, covered in our guide to handling short payments and deductions.

Matching invoices to payments faster

Most of the time spent on reconciliation goes into answering one question: which invoice is this deposit for? You can make that question easier before the money ever arrives.

Put a clear reference on every invoice

Ask customers to quote the invoice number as the payment reference. Our guide to the invoice reference number explains why a short, unique number works better than a long description, and the invoice number generator helps you keep a consistent sequence.

Show payment details that leave no room for error

Print the account name, account number or IBAN, and the reference to use on the invoice itself. Our article on putting bank details on an invoice covers the fields customers need for domestic and international transfers.

Record partial payments properly

When a customer pays in installments, each receipt should reduce the balance of a specific invoice. The free invoice generator lets you enter an amount paid so the PDF shows the remaining balance due, which makes the next payment easy to identify. See our guide to the partial payment invoice for wording.

Common bank reconciliation mistakes

• Using mismatched dates. A statement and a ledger run on different days will never agree.
• Forcing the balance. Posting an unexplained "reconciliation difference" entry hides the problem and usually makes next month harder.
• Ignoring old outstanding items. A deposit in transit that never clears may be a payment that was never banked or was banked to the wrong account.
• Recording fees twice. As in the example above, a fee deducted from a customer payment is not also a separate charge.
• Marking invoices paid from emails. A "we've paid you" message is not cash. Mark an invoice paid only once the money appears in the bank.
• Missing duplicate payments. If a customer pays the same invoice twice, record the overpayment and refund or credit it.
• Reconciling only once a year. By then, customers have forgotten details and banks may charge for old statement copies.

Monthly bank reconciliation checklist

• Bank statement and book balance taken at the same date.
• Last month's deposits in transit and outstanding checks have cleared or been investigated.
• Every incoming payment is matched to a recorded receipt and to specific invoices.
• Every outgoing payment is matched to a recorded bill, payroll item or transfer.
• Bank fees, interest and returned payments are recorded in the books.
• Short payments are identified and the remaining invoice balances are flagged for follow-up.
• Adjusted bank balance equals adjusted book balance.
• Reconciliation report is dated, signed off and filed with supporting statements.
• Any unexplained difference is documented and escalated, not plugged.

Bank reconciliation under cash and accrual accounting

The mechanics are the same whichever method you use, but the effect on your reports differs. Under cash accounting, income is recorded when the deposit arrives, so a missed deposit understates revenue. Under accrual accounting, revenue is recorded when you invoice, and the deposit only moves the amount from receivables to cash, so a missed deposit overstates receivables instead. Our comparison of cash vs accrual accounting explains which method suits which business.

Next step

Pick last month's statement and reconcile it this week, even if your books are messy. Start with the closing balances, tick off what you can and list what you cannot. Then fix the cause of the biggest problem: usually missing payment references. Issue your next invoice from one of our free invoice templates with a clear invoice number and payment instructions. Then put the same checklist on your calendar for the first week of every month.