Clean up A/R so the aging is real.

What a QuickBooks accounts receivable cleanup is

A QuickBooks accounts receivable cleanup is the work of applying unmatched payments, merging duplicate customers, and clearing paid-but-open invoices — so your A/R aging shows what customers actually owe, not an inflated ghost of it.

The A/R aging report is built from your open invoices: every invoice still marked unpaid shows up as money owed to you. When a payment that settled an invoice never got applied, that invoice stays open on the report even though the cash is already in the bank. When one customer exists under two spellings, their balance splits across both. A cleanup corrects the records the aging is built from, so the total finally matches reality — it is one piece of a full QuickBooks cleanup, not a substitute for reconciling the bank or re-entering missing transactions.

How an accounts receivable cleanup works: apply, merge, resolve

Three operations do most of an A/R cleanup: applying each received payment to the invoice it settled, merging customers that exist under two names, and resolving what is left — collecting the real balances and writing off, only with your approval, the ones that are genuinely dead.

A/R aging

Applying a payment is careful, one-at-a-time work: we match each received payment to the invoice it settled, so the invoice closes and the customer's balance drops by the right amount. Merging is permanent in QuickBooks, so we map every duplicate customer before we combine them — the two names fold into one, their invoices and payments come together, and the joined balance comes out correct. Then we resolve the stragglers: the genuinely uncollectible invoices get surfaced with evidence for you to write off or keep, and everything still collectible stays open so you can pursue it.

Why unapplied payments and undeposited funds overstate your A/R

An unapplied payment overstates your books twice over: the invoice it should have closed stays open in A/R, and the cash it represents sits in Undeposited Funds instead of a real deposit — so both what customers appear to owe and your clearing account are wrong.

Apply the payment

Because the two problems travel together, we treat them together. As we apply each payment to its invoice, we also group the cash into the deposits that actually hit the bank, so Undeposited Funds drains down to what is genuinely still in transit. That is why our methodology reference for this work is the undeposited funds reference — untangling A/R and untangling the clearing account are the same motion done well. Where a payment turns out to be a genuine overpayment or a deposit on future work, we leave it as a customer credit rather than forcing it onto the wrong invoice.

What you get when the cleanup is finished

You get an A/R aging that shows real balances, a written log of every payment applied and duplicate merged, a list of the write-offs you approved, and a call to walk the whole thing through.

Nothing is a black box: the change log records each invoice that was open, what happened to it, and which payment closed it, so you — or your CPA — can audit the work. With a trustworthy aging in hand, you finally have a collections list you can act on, and a revenue figure that reflects what you actually earned. If the wider file also needs reconciling or a chart of accounts cleanup, we scope that separately rather than fold it in quietly.

Edge cases: write-offs, credit memos, retainers, and multi-currency

The details that decide an A/R cleanup: how write-offs are recorded, what to do with credit memos and overpayments, how customer retainers should sit, and how multi-currency or job-linked invoices change the work.

How are write-offs recorded?

Only with your approval, and always to an account you choose — usually bad debt expense — so the invoice closes without pretending it was paid. We give you the list with evidence first; nothing is written off on a guess, and everything still collectible stays open.

What about credit memos and overpayments?

A payment larger than its invoice, or a payment with no invoice at all, becomes a customer credit rather than being forced onto the wrong invoice. We leave those visible as credits the customer can draw against, so the balance is honest in both directions — not just when they owe you.

Customer deposits and retainers

Money taken before the work is done is not really revenue yet, and it should not sit as a random unapplied payment either. Where a file uses upfront deposits or retainers, we make sure they land as a liability or a customer credit until the invoice they belong to exists.

Multi-currency and job-costed invoices

Invoices in a foreign currency carry exchange-rate gains and losses that have to be respected as payments apply, and invoices linked to jobs must keep their job link so profit-by-job stays intact. We flag these before touching them, because a careless merge or write-off here can distort a report you rely on.

When NOT to hire us for an accounts receivable cleanup

Skip us when the fix is small or the balances are already right. A couple of payments to apply that you can match yourself in an afternoon does not need a paid engagement, and an aging that already ties out does not need touching at all.

If you can name the two or three invoices sitting open by mistake and you are comfortable applying the payments, our QuickBooks cleanup checklist walks you through it for free. If your real problem is that customers are slow to pay rather than that your records are wrong, that is a collections issue, not a cleanup — a clean aging helps, but it will not make anyone pay faster. And if your aging already shows real balances with every payment applied, leave it alone; there is no prize for re-doing work that is already correct. We will tell you which case you are in during the free review, even when the answer is "you don't need us."