Customer payments bypassing A/R in QuickBooks Online cleanups

When customer payments never touch Accounts Receivable

You open a new QBO file and run an A/R Aging. There it is: Customer ABC showing an open invoice for $2,000 from March. You flip over to the bank register for that same week and see a $2,000 deposit from ABC coded straight to "Sales Income".

The client swears everything is fine: "But my bank is reconciled every month." And technically, yes, the bank is right. Cash hit the account. But A/R still shows the invoice as unpaid, and income just got bumped twice.

This is one of the most common cleanup patterns in QuickBooks Online: customer money recorded directly to a bank and income account instead of being applied to specific invoices. Layer on top of that a pile of unapplied credits and overpayments, and your A/R subledger stops meaning anything.

If your firm does a lot of QBO cleanups, you’ve seen this movie. The trick is turning it from a one-off detective job into a standard diagnostic you can run on every file.

Where this problem hides inside QuickBooks Online

There are two sides to this mess:

1. Payments that bypass A/R entirely (deposits or sales receipts straight to income and bank).
2. Credits and payments that sit unapplied in A/R (credit memos, overpayments, stray receive payments).

You’ll see the first pattern when an owner or inexperienced bookkeeper uses the bank feed and just "adds" deposits to an income account, or uses Sales Receipts for everything even when they’re invoicing. You’ll see the second when they try to fix things by guessing at credits, or when they accept partial matches from the bank feed without finishing the application.

Here’s how it shows up in QBO:

• A/R Aging Summary / Customer Balance Detail: customers with open invoices that "should" be paid.
• Bank register / Transaction Detail by Account on bank accounts: deposits and sales receipts coded directly to income.
• Transaction List by Customer or Customer Balance Detail: unapplied credit memos, overpayments, and unapplied receive payments.

A classic example:

• Invoice to Customer ABC for $2,000 dated 03/01/2025.
• On 03/05/2025, a bank deposit for $2,000 coded to "Sales Income" with Customer ABC in the Name field.
• No Receive Payment exists, and the invoice is still fully open in the A/R Aging.

Red flags you’ll keep seeing:

• Customer shows a large open balance, but the client insists "they paid that months ago".
• Deposits or Sales Receipts coded to income with a customer name that match invoice amounts and dates.
• A/R Aging is full of old invoices, while the P&L shows strong income for the same period.
• Customer Balance Detail shows big or numerous unapplied credits sitting for months.
• Transaction List by Customer shows "Unapplied Payment" or overpayments with remaining credits.

What happens if you just live with it

Ignoring this isn’t just a cosmetic issue. You end up with cash, revenue, and A/R all telling different stories.

The damage inside your numbers

When a customer payment is posted directly to income and a bank account instead of through A/R:

• Income is overstated: the original invoice hit income, and the deposit hit income again.
• A/R is overstated: the invoice still shows as open, even though the customer has paid.
• Collections reporting is useless: aging reports look terrible, and you can’t tell who actually owes money.
• KPIs go sideways: DSO, cash conversion, and revenue trends are all distorted.

Unapplied credits create a different flavor of distortion:

• Revenue may be understated in future periods when those credits finally get applied.
• Customer statements are confusing: they show "credits available" and "open invoices" that should net out.
• Refunds and write-offs get mishandled because no one trusts the balances.

For tax work, this can be a real problem. If you’re on accrual, overstated income and overstated A/R can mean paying tax on revenue that was already recognized, or mis-timing deductions and write-offs.

The damage in client conversations

From the client’s perspective, this shows up as:

• "My customers are calling saying they don’t owe this, but QuickBooks says they do."
• "Why does this customer show a big credit and a big balance at the same time?"
• "My sales look great in QuickBooks, but there’s no cash in the bank."

When you start your engagement by telling them their A/R is unreliable, it can either build trust (you caught it) or erode it (if you miss it and it surfaces later). This is one of those issues that separates a surface-level cleanup from a real diagnostic review.

A practical way to clean this up

You don’t need to brute-force every transaction. You do need a consistent process to:

• Find customers with open invoices.
• Find deposits and sales receipts that look like payments.
• Match them up where they clearly belong.
• Deal with unapplied credits in a controlled way.

Here’s a workable workflow:

1. Pull A/R Aging and Customer Balance Detail for at least the last 12–24 months. Focus on customers with non-zero open balances.
2. Scan bank deposits and sales receipts for that same period. Use a Transaction Detail by Account on bank accounts, filtered for Deposits and Sales Receipts, and look for lines coded to income.
3. Match obvious one-to-one cases: same customer name, same amount, and dates within about a week of each other. These are usually straightforward mis-posted payments.
4. Reclassify the payment properly: create a Receive Payment against the open invoice, then adjust the original deposit/sales receipt. Often that means changing the deposit line from income to Accounts Receivable with the customer name, or replacing a Sales Receipt with a Receive Payment.
5. Review unapplied credits per customer using Customer Balance Detail or a Transaction List by Customer filtered for A/R transactions. Identify credit memos, overpayments, and unapplied payments with remaining amounts.
6. Apply or resolve credits: apply them to the correct invoices, reclassify if they were mis-coded, or document and write off/refund if they truly shouldn’t be there.
7. Re-run A/R Aging and key reports to confirm that open balances, unapplied credits, and income all look reasonable and tie to what the client expects.

Tools like CleanupOwl can do the pattern-matching legwork here—scanning deposits and sales receipts, comparing them to open invoices by customer, amount, and date, and handing you a list of suspect items to review instead of you hunting through reports manually.

Building this into your standard review

The key is to stop treating this as a "nice to have" and make it a checklist item in every cleanup and monthly review:

• In your intake diagnostic, always include a step: "Compare open A/R to deposits and sales receipts coded to income for the last 12–24 months."
• Set a materiality threshold: for example, only chase mismatches over $X per customer or over Y% of total revenue.
• Document your decisions: when you decide not to fix older or immaterial items (e.g., closed tax years), note it in your workpapers.
• Use automation where it makes sense: CleanupOwl can run this check across the whole file and summarize how many customers, how many suspect receipts, and how much money is involved so you can scope the cleanup effort.

If you standardize this, your team stops reinventing the wheel on every new file, and partners can quickly review whether A/R and income are structurally sound before signing off.

The patterns you’ll keep seeing in client files

In some files, you’ll see just a handful of obvious one-to-one mismatches. Those are quick wins—fix them and move on. In others, you’ll see systemic misuse of Sales Receipts and direct-to-income deposits. That’s where you need to decide how far back to go and whether the cleanup is a one-time project or part of an ongoing engagement.

For unapplied credits, a few small items under a reasonable threshold might be fine to leave with documentation. But when you see big dollar credits or a high count of unapplied items for a single customer, it’s worth digging in and cleaning it up properly.

Making this part of your cleanup playbook

Customer payments that bypass A/R and credits that never get applied are exactly the kind of issues that quietly wreck the reliability of a QBO file. They don’t always jump out at first glance, but they have a big impact on revenue, A/R, and client trust.

This deserves its own line item in your cleanup checklist: "Identify and correct customer payments posted directly to bank and income; review and resolve significant unapplied credits." Whether your team runs the reports manually or uses a diagnostic tool like CleanupOwl to surface the patterns, the important thing is that the check happens every time.

If you’re a business owner reading this, this is a good question for your accountant: How do you make sure my customer payments are actually applied to invoices, and that I’m not double-counting income or sitting on unexplained credits? They should have a clear, repeatable answer.

When your firm bakes this into its standard diagnostic, you stop firefighting weird A/R issues months later and start delivering books where A/R, cash, and income all tell the same story.