How to Find a Missing Payment in Your Books

A payment vanishes. You remember sending it. Your customer confirms they received it. But your books show nothing. The balance is wrong, and you can't move forward until you find where it went.

This happens to almost every small business owner and freelancer at some point. The good news: there's a systematic way to find a missing payment in your books, and a few simple habits that prevent it next time.

Start with the bank, not your books

Your bank record is the source of truth. When you're hunting for a missing payment, always begin there, not in your cash book. Pull up your bank statement for the month or period when you believe the payment left your account. Look for the amount, the date, and the recipient's name.

If the payment is there on your bank statement but not in your books, you have a recording problem. If it's not on your bank statement either, the payment may never have been sent, or it went from a different account.

Write down the exact amount, the date it cleared, and any reference number your bank shows (often called a transaction ID or confirmation number). You'll use this to match it against your records.

This first step saves hours of hunting through entries that don't exist. Too many people flip open their cash book first and waste time looking for something that's actually missing from the source.

Check for typos and small differences

A payment of 1500 in your books but 1450 on your bank statement is not the same entry. Neither is one dated 15 October versus 16 October. These differences are easy to overlook, especially if you're scanning quickly.

Go through your cash book entry by entry and compare:

• The exact amount (including cents or pence)
• The date the payment cleared (not the date you think you sent it)
• The payment method (credit card, bank transfer, cheque, cash)
• The recipient or vendor name

Searching by amount can be faster than scrolling. If your cash book has a search feature, use it. Search for the payment amount first. If nothing comes up, try nearby amounts. A decimal in the wrong place or a digit transposed will throw off your whole reconciliation.

If you find an entry with the right amount but the wrong date, edit the date to match your bank statement. The bank's date is correct.

Look for duplicate entries or reversals

Sometimes a payment appears twice: once as the original entry and again as a reversal or correction. Your bank may have cancelled a standing order, reversed a failed payment, or processed a duplicate by mistake.

If you see two entries for similar amounts with dates close together, check your bank statement. One might be the original and one a reversal. Delete the duplicate from your books. Your bank statement shows the net result; your cash book should match that.

Reversals often appear with negative amounts or marked as a refund, credit memo or cancelled transaction. Make sure you're not counting both the original and the reversal as separate cash outflows.

Check the right date range

Bank transactions sometimes take longer to clear than you expect. A payment you sent on 10 October might not appear on your bank statement until 12 October or later. If you're looking at the wrong statement period, you'll miss it entirely.

Pull bank statements for at least two consecutive months if the payment is near the month boundary. Payments in transit between months are a common reason for a mismatch. Once the payment clears, update your entry to show the cleared date, not the date you initiated it.

If you recorded the payment before it cleared (which many people do), you may be looking at statements from the wrong month.

Try a worked example

Say you're reconciling in mid-October. You remember paying a supplier 750 on 28 September. You recorded it in your cash book the same day. But when you check your bank statement for September, there's no payment for 750 to that supplier.

Here's what you do:

1. Pull up your September bank statement and search for amounts near 750. You find nothing.
2. Pull up your October bank statement. You see a payment for 750 on 3 October to the same supplier.
3. The payment cleared later than you expected. Edit your cash book entry to change the date from 28 September to 3 October.
4. Your books now match your bank statement.

If the bank shows the payment went out on 3 October, that's when it actually left your account. Your cash book should record it on that date, not the date you sent the instruction.

Build a habit to prevent missing payments

The best way to handle a missing payment is to avoid it in the first place. Record payments as soon as your bank confirms them, not when you send them. Many payments take a few days to clear, and recording them too early creates a mismatch.

For regular payments you make every week or month, use recurring entries if your cash book supports them. A recurring entry removes the risk of forgetting to record a payment at all. You can set them up to repeat weekly or every 2 weeks, which covers most regular expenses.

Set a rhythm for matching your cash book to your bank statement. Weekly is ideal if you're managing cash closely. Monthly is the bare minimum. The sooner you catch a discrepancy, the easier it is to trace.

If you receive receipts or invoices, attach them to the entry in your cash book. A photo of the receipt or a PDF invoice becomes part of the record. When you need to trace a payment later, the receipt is right there.

Keep your categories consistent too. If you pay a supplier for office supplies, don't record it as "admin" one time and "materials" the next. A clear, repeating pattern makes it easier to spot what's missing when you're reviewing.

When you still cannot find it

If you've checked your bank statement, looked for duplicates and typos, and searched the full date range, the payment may have failed silently. Some payment systems confirm a transaction on your screen but the money never actually leaves your account. Check whether your payment provider sent a notification email saying the payment failed or was pending.

Alternatively, the payment may have gone from a different bank account if you have more than one. Check all your accounts, especially if you use a personal account for some business payments. Business and personal money should be separate, but in practice many freelancers and small business owners mix them.

If you still can't find the payment after a thorough search, contact your bank or payment provider. They can trace a transaction by date and amount and tell you whether it cleared and where it went. This is faster than hunting alone.

Once you find it, record it correctly in your books, and then set a rule for yourself to prevent the same gap next time.

Keeping your books accurate takes discipline but saves far more time than chasing missing payments later. Start by signing up free at TheCashFox to record your cash in and out, search for payments instantly, and attach receipts so the proof is always on hand.