The Client Paid. Why Does the Invoice Still Show Open?

TL;DR: An invoice, the payment against it, and the bank deposit are three separate records. When the deposit gets recorded as its own income line instead of being matched to the payment, the invoice stays open, the client looks overdue, and the revenue is often counted twice. Trace the chain for one invoice, apply the payment, match the deposit, clear anything stuck in undeposited funds, then change the habit: match before you add. Prosper shows the invoice, the payment, and the deposit together and asks whether they're the same money. TidyMonth keeps the chain linked every month with a bookkeeper reviewing the close.

You sent a reminder to a client about an overdue invoice. They replied, a little annoyed, with a screenshot of the payment they made three weeks ago. You check the bank. The money is there. You check the invoice. Still open.

This one is embarrassing because it's visible to the client. It's also one of the most common tangles in a set of books that runs on invoices and a bank feed, and the cause is almost always the same.

Three records, one chain

When a client pays an invoice, most bookkeeping software creates or expects three things.

The invoice. What you billed. Until it's marked paid, it sits in accounts receivable, which is the accounting term for money clients owe you.

The payment. The record that the client paid the invoice. Applying a payment is what closes the invoice. In some software, that payment first lands in a holding account called undeposited funds, waiting for the actual bank deposit.

The deposit. The money arriving in your bank account, which shows up in the bank feed as a line waiting to be categorized.

The chain works when the payment is applied to the invoice and the deposit is matched to the payment. Invoice closed, receivable cleared, deposit accounted for, revenue counted once.

The chain breaks at the bank feed. The deposit arrives, and instead of matching it to the existing payment, it gets added as new income. Now the invoice is still open because no payment was ever applied to it. The revenue is counted from the deposit. If the invoice was already counted as revenue when it was created, the job is counted twice. And the client looks overdue on a bill they paid.

Intuit's own documentation for QuickBooks Online describes the match step for exactly this reason: link downloaded bank activity to existing records instead of creating new ones. The feature exists. The add button is just closer.

How to find the broken chains

The receivables check. Run an accounts receivable aging report, which lists every open invoice by how overdue it is. For each invoice older than your usual payment terms, check the bank for a deposit of that amount from that client. If the money arrived, the chain is broken.

The undeposited funds balance. If your software uses this account and it has a balance that never goes to zero, those are payments that were applied to invoices but never matched to a deposit. Different symptom, same problem.

The revenue check. Compare revenue for the year to customer deposits. If revenue is higher by the amount of several invoices, those invoices were counted both when created and again when the deposit was added. See How Income Gets Counted Twice for that case in detail.

How to fix it in any bookkeeping software

Step 1: Pick one open invoice and trace it. Find the invoice. Find the deposit in the bank for that amount from that client. Confirm they're the same job.

Step 2: Look at how the deposit was recorded. If it was added as new income, that entry is the problem. If a payment was applied to the invoice but sits in undeposited funds, the problem is that the deposit was never matched to it.

Step 3: Apply the payment to the invoice. Record a payment against the invoice for the amount received, dated when the client paid. The invoice closes.

Step 4: Match the deposit to the payment. Go to the bank feed line for the deposit. Undo the add if it was added as income. Match it to the payment you just recorded, or to the payment that was sitting in undeposited funds. The deposit is now the bank side of the payment, not a second piece of income.

Step 5: Check the three numbers. The invoice shows paid. Accounts receivable went down by the invoice amount. Revenue didn't go up, because it was already counted when the invoice was created, or it went up exactly once if you record revenue on payment.

Step 6: Work the list. Repeat for every open invoice that's actually been paid and every stuck payment in undeposited funds.

Step 7: Change the order of operations. From now on, when a client pays, record the payment against the invoice the day you see it. When the deposit shows up in the feed, look for the match first. If you invoice, the payment is almost always already there.

Illustrative example. A consulting firm's receivables report showed $31,000 in invoices more than 60 days overdue. Tracing them against the bank found $24,000 had been paid. Each deposit had been added as income from the feed without touching the invoice. After applying the payments and matching the deposits, receivables dropped to $7,000, which was the real overdue amount, and revenue dropped by $24,000 that had been counted twice. Two clients who were about to get a second reminder didn't.

How this works in Prosper

Prosper is the platform TidyMonth uses for the monthly work, and you can use it yourself with your CPA.

When a deposit arrives from a connected bank account and there's an open invoice or a recorded payment for a matching amount from the same client, Prosper doesn't add the deposit as income. It shows the invoice, the payment if there is one, and the deposit together as one decision and asks whether they're the same money.

That grouping is the difference. The three records don't arrive as three separate items on three different screens. They arrive as one chain with one question. You confirm, and the invoice closes, the payment is applied, and the deposit is matched in one step. Every change is reversible.

If a deposit doesn't match any invoice, Prosper flags it as a question instead of guessing that it's revenue. If a client pays two invoices with one deposit, or pays short, the decision shows the mismatch so you can split or annotate it.

When you prepare the CPA packet, each invoice carries its payment and its deposit as one traceable chain. Your accountant can see that receivables are real and that revenue was counted once.

If you'd rather hand it off: TidyMonth by Prosper

If you'd rather someone else kept invoices, payments, and deposits linked every month, that's part of the monthly bookkeeping TidyMonth by Prosper does.

Start with a free Books Check. No card required, and nothing in your accounts is changed while we look. The results show which months reconcile, where receivables may need review, and what couldn't be verified from the records available. A Books Check reads bank activity, so it can't confirm the status of every invoice on its own. That's part of what gets reviewed once the work starts.

If your business fits, monthly bookkeeping is $199 per month, with catch-up scoped and priced before checkout. TidyMonth handles the agreed work in Prosper. A bookkeeper reviews the close. You answer the questions only you can, like whether a short payment was a discount you agreed to.

If the first close isn't worth it, your first $199 is refunded in full. Cancel in one click. Export your books any time.

What your CPA still decides

Linking the chain gets receivables and revenue back to reality. It doesn't decide when revenue is recognized for your accounting basis, how to handle a client who paid short, or how to correct a prior year that was filed with doubled revenue. Those are your CPA's calls. Prosper and TidyMonth keep the invoice, payment, and deposit together so your accountant can see what happened and decide.