Reconcile invoice payments with your bank: 4 checks

Key takeaways

Gather invoices, payment records, the bank statement, and full cash-account records.
Track uncleared payments separately and investigate aging items.
Document combined payments, installments, and fees when matching deposits.
Explain differences before closing the period.

When the answer is yes, confirm the matches and document them. When it is no, the gap can hide a missed deposit, a payment entered twice, a bounced check, or an invoice that was never paid. The longer a difference sits unexplained, the harder it becomes to trace, because the paper trail goes cold and the people involved forget what happened.

This post walks through four checks you can run to match invoice payments to your bank statement. Each check narrows the problem for the next one, so work through them in order. None requires special software, though a good tool can make the steps faster. Whether you are a bookkeeper handling several clients or an owner checking the books yourself, the goal is the same: trace invoice payments to deposits, document timing differences and fees, and distinguish other bank activity from customer payments.

Before you start: gather the four records

Reconciliation works best when four sets of records sit side by side: your invoices, your payment log, the bank statement, and your full cash-account records. Comparing invoices against payments checks your billing. Comparing payments against the bank checks your cash. This article compares invoices, payments, and bank deposits. MyCase describes consistent 3-way trust reconciliations, from invoice to bank statement, as a way to help confirm compliance with state bar requirements. You do not need to be a law firm to see the value. The habit of tracing each dollar from invoice to deposit applies to any business that collects payment on invoices.

Before you open the statement, collect four things:

The invoice list. Every invoice issued or paid during the period, with its amount, date, and customer.
The payment log. Every payment received, with its method, the date it was recorded, and the matching invoice numbers.
The bank statement. The full statement for the exact period, including its start date, end date, and ending balance.
The cash-account records. Opening balances, all incoming and outgoing payments, and adjustments needed to calculate the adjusted book balance.

Write the statement's dates and ending balance on your worksheet before you compare anything. You will refer to them throughout, and they keep you from drifting into transactions from another period. Also create a separate list for open items, meaning the things you cannot explain yet. Keeping that list apart from your worksheet stops unresolved problems from getting buried in the working columns.

Check 1: confirm the timing of every deposit and payment

Your books and your bank often disagree about dates, and most of the time that disagreement is harmless. A customer may mail a check on the last business day of the month. You record it when it arrives. The bank does not credit it until the following period. Nothing is wrong, but the difference still has to be explained before the period can close cleanly.

Smokeball's guidance on trust accounting gives a precise example of how to handle this: if you deposit a trust check on June 30, but it does not clear the bank until July, you must withhold that deposit for a later reconciliation after it clears the bank. That instruction applies to Smokeball's cited trust-accounting workflow, and your business may have different obligations. The underlying logic is still useful everywhere. A recorded item that has not cleared is a timing difference. It is not a mismatch to fix, and it should not be forced into this period's reconciliation just to make the numbers look tidy.

Illustrative example: a deposit clearing next period

Suppose an invoice payment of 100 is recorded at month-end, and the bank clears the 100 deposit in the next period. The bookkeeper should not reverse the entry or move it to the next month. Instead, the item goes on the timing list, with the recorded date, the amount, and the reason it is pending. When the deposit clears, it is matched against the timing list and removed. The next statement then shows a clean match, and the audit trail still explains why the item was once outstanding.

Work through timing like this:

Look at every payment recorded in the last few days of the period.
For each one, find the bank line and note the date it cleared.
If it cleared within the period, mark it matched.
If it did not clear, add it to a timing list with the date you recorded it.
At the next period, check the timing list first. Items that cleared are closed. Items that still have not cleared need investigation.

The last step matters most. A deposit in transit is normal for a few days. A check that stays uncleared for a long stretch may have been lost, may have bounced without a notice reaching you, or may have been recorded twice. Do not let timing items age silently. Each one should have a reason and a next step written beside it.

Typical timing items include deposits recorded at the end of the period, checks the payee has not yet presented, and card or online payments that settle after the sale date. Each of these belongs on the timing list, not in a plug entry that makes the balance work.

Check 2: match the statement period and closing balance

At this check, confirm that you are looking at the right statement and the right window of time. Use the period dates printed on the statement to define the reconciliation period, retaining earlier invoices paid during it and outstanding payments carried forward. A month-end statement should be matched against records for that month. Records that run into the first days of the next month will create false differences, and records that stop early will leave real payments unmatched.

Smokeball's guidance shows how to anchor the reconciliation to the statement itself: if your bank statement is for the period March 1 to March 31, enter the closing date as March 31 and the balance at the bottom of the bank statement as of March 31. The principle applies to a spreadsheet as much as to any software. Pin your work to a closing date and to the ending balance printed for that date. Then every later step has a fixed target.

For file preparation, see manual bank imports.

Use this short sequence:

Write down the statement start date, end date, and ending balance.
Confirm that the opening balance on this statement matches the closing balance from the last period you reconciled. If it does not, stop here. A break in the chain means something from an earlier period is off, and you need to find it before you go on.
Include invoices linked to the period's payments regardless of invoice date, and retain outstanding items carried forward.
Note any bank activity that falls outside your records' window, such as a fee posted on the first day of the next month, so you can account for it later.

Testing the opening balance first is the cheapest check in the whole process. Matching consecutive statement balances checks statement continuity; it does not establish that the previous reconciliation or accounting close was correct. Skipping it is how small errors compound quietly across many periods.

Check 3: trace each payment from invoice to deposit

This is the detailed part of the work. For each payment in your log, find the invoice it was applied to, then find the bank line that holds the money. Document how the records connect, allowing for timing differences, combined payments, installments, and net fees. This is the three-way logic from earlier, applied one item at a time.

Pick a direction and stick to it. Some people start with the bank statement and work down, because every deposit is a fact that needs an explanation. Others start with the payment log, because it is usually shorter. Either works. What matters is that you finish one direction completely, then sweep the other direction for anything you missed. A deposit with no record is easiest to find from the bank side, and an invoice with no deposit is easiest to find from the invoice side. Running both sweeps is the cheapest way to catch what a single pass misses.

Payments and deposits can have different matching relationships:

One deposit, several invoices. A customer may pay three invoices with a single check. Record the deposit once and split it across the invoices it covers.
Several deposits, one invoice. A large invoice may be paid in installments. Each installment should match a separate deposit, and the invoice should show a running balance.
Partial payments. If a customer pays less than the full amount, the invoice stays open with the remaining balance. Do not mark it paid to make the list look finished.
Fees. Card processors and some payment platforms deposit the amount net of fees, so the bank shows less than the invoice. Record the fee as its own expense or adjustment, rather than forcing the invoice to show a short payment that looks like a customer problem.

For related payment handling, see deposits and partial payments.

As you go, sort every exception into one of three kinds:

Exception	What it usually means	What to do
Bank deposit with no payment record	Unapplied cash, or another source of funds	Establish its source; apply it to an invoice only with support, otherwise classify it by its actual source
Payment record with no bank deposit	Timing item, bounced payment, or duplicate entry	Check the timing list, then the customer's payment history
Invoice marked paid with no payment	Payment applied to the wrong invoice, or closed in error	Reopen the invoice and trace the payment that was meant to close it

Keep each exception on your open-items list until it is explained. The table is a starting point, not a list of certainties. Two different causes can produce the same symptom, so confirm before you correct.

A note on duplicates: when a payment shows up twice, one of the entries is probably wrong, and it is tempting to delete whichever one you noticed second. Look before you delete. Compare the source documents, check the bank line, and confirm which record is actually supported. Only then remove the entry that the evidence does not support, and note why.

Check 4: drive the difference to zero, then lock the period

The final check tells you whether the work is finished. A complete reconciliation leaves no difference between the adjusted bank balance and the adjusted book balance. Smokeball's guidance describes that as the ideal result, a Reconciliation Balance with a $0.00 difference, as set out in its trust accounting overview. If your number is anything else, the difference is a clue, and it is almost always traceable.

Start by calculating the difference. Take the bank's ending balance, add deposits in transit, subtract outstanding payments, and compare this adjusted bank balance with the adjusted book balance calculated from the full cash-account records, including opening balances, incoming and outgoing payments, and adjustments. Write this arithmetic out in full on your worksheet, even when it seems obvious. A line-by-line sum is easy to check later, and a reviewer who can see the math will spot a wrong sign or a missing item quickly. Any remaining gap points to one of a small set of causes:

A transaction entered in your books but missing from the bank, or the reverse.
A transaction entered with the wrong amount. A difference that looks like two digits were swapped is a classic sign.
A bank fee, interest credit, or returned item you have not recorded yet.
A timing item you forgot to list, or one you listed that has since cleared.

Work the gap by comparing its size with individual items. A difference that equals a single transaction is usually a missed or doubled entry. A difference that matches a small round charge often points to a bank fee. Resist the urge to post a plug entry to close the gap. A plug hides the problem and makes the next reconciliation harder.

Once the difference is zero, lock the period. Smokeball's guidance stresses the stakes of this step: it is very important to make sure all the fields are 100% correct, as you cannot edit trust transactions after they are processed. That warning comes from one product, but the lesson applies to other accounting records. Before you finalize, review each entry you are about to close. Confirm the amount, date, account, and customer. If you later find an error, correct it with a new, documented adjustment instead of editing history quietly.

Before closing the period, record:

The date of the reconciliation and the statement it covers.
The statement's ending balance and your final adjusted balance.
The name of the person who prepared the reconciliation and the person who reviewed it.
A short note on any timing items carried forward to the next period.

Common mistakes to avoid

Some errors come back every period. Watch for these:

Matching by amount alone. Two payments of the same size from different customers are easy to swap. Match on amount and date, and confirm the customer name on the bank line when the statement shows it.
Forgetting the statement's own entries. Bank fees, interest credits, and returned-item charges may appear on the statement before they are recorded in the books. If you match only your records against the deposits, these lines look like unexplained differences every period.
Reconciling against the wrong period. Using a statement from last month, or a file downloaded before the month closed, leaves transactions out. Check the download date and the closing date before you start.
Treating a zero difference as proof. A zero difference shows that the totals agree. It does not prove that each item matches, because two errors can cancel each other out. That is why the item-by-item trace in Check 3 matters even when the bottom line is clean.

Make it a routine

A reconciliation done once is a fire drill. Done on a schedule, it becomes a control. Set a calendar date for each period, and assign one person to prepare the work and another to review it, even if the owner is also the bookkeeper. A second pair of eyes catches the transposed digit and the forgotten fee that the preparer has stopped seeing.

How often you reconcile should follow your own policies and any rules that apply to your business. Some obligations set their own timing, so check those requirements rather than relying on a schedule that someone told you was standard.

Over time, track your results. If the same kinds of exceptions keep appearing, the cause is usually upstream. Perhaps your team records payments late, a payment processor changed its settlement pattern, or invoices are being applied to the wrong customer. Fixing the source saves time at every reconciliation after that.

Finally, keep the records. Save the statement, the reconciliation worksheet, the timing list, and the review sign-off together, so anyone who looks at the period later can follow the trail from invoice to bank without rebuilding it from memory.

Start today by gathering the records for your latest statement and tracing one invoice payment to its bank deposit.

Common questions

What if a recorded payment has not cleared?

Keep it on the timing list until it clears, and investigate items that remain outstanding.

Do invoice payments alone establish the adjusted book balance?

No, the calculation needs full cash-account records, including opening balances, incoming and outgoing payments, and adjustments.