I AM CFOFree Money Leak Check

I AM CFO › Money leaks

Revenue counted twice: the deposit that should have been matched

When a customer pays an invoice and the bank deposit is categorized as income instead of being matched to that invoice, QuickBooks records the sale twice: once when you invoiced, and again when the money arrived. Your revenue looks bigger than it is, and the invoice still shows as unpaid.

Why it happens

  • The bank feed suggests a category, and "Add" is one click while "Match" takes a search.
  • The deposit amount does not exactly equal one invoice (a customer paid two invoices at once, or short-paid one).
  • Someone new to the books does not know the invoice exists.

What it costs you

  • Revenue and profit are overstated, so every decision built on them is off.
  • If your books are kept on the accrual basis, the same sale is in your income twice, and your taxes can be prepared from that inflated number.
  • Receivables look bigger than they are, so you chase customers who already paid you.

How to check your own QuickBooks

  1. Run the Open Invoices report (or A/R Aging Detail) and note invoices older than 30 days.
  2. For each one, search the bank deposits from that customer around the due date.
  3. If you find a deposit for the same amount booked to an income account while the invoice is still open, the sale is counted twice.
  4. The fix is to record the deposit as a payment against the invoice (Receive Payment) instead of income. Your bookkeeper can reclassify past ones.
Or let us check it for you. I AM CFO checks every deposit booked to income against your open invoices, by customer and amount, and lists the ones that should have been matched.

Free Money Leak Check

Twenty minutes with our founder. You connect QuickBooks before the call, and we run the checks on your real books with you:

Like what we find? Your first month of I AM CFO is free.

Book my Money Leak Check

Questions

Does this mean I paid tax twice?

Only if your income is reported on the accrual basis. On the cash basis the open invoice is not taxed, but your accrual P&L, your receivables and anything a lender sees are still overstated.

How common is it?

Very. It is one of the most frequent bank-feed mistakes, because categorizing a deposit is faster than matching it.

Other money leaks

You paid that vendor. Twice.Same vendor, same amount, days apart. How duplicate bill payments happen, what they cost, …Money sitting in “Uncategorized”Uncategorized Expense, Uncategorized Income and Ask My Accountant: what ends up there, why…Your books say one number. Your bank says another.Why the QuickBooks bank balance and the real bank balance drift apart, what it costs, and …