Deposits to income with no customer in QBO: why AR goes sideways

When "money in the bank" doesn’t mean your AR is right

You open a new QBO file for an invoicing client. A/R Aging shows $85,000 open. The owner swears, "Those customers paid months ago. My bank is reconciled every month."

You pull up the operating bank register and start scrolling. There it is: a stream of deposits coded straight to Design Income, Consulting Income, Other Income. No customer names. No Undeposited Funds. Just raw deposits to income.

On the surface, cash and bank recs look fine. But under the hood, you’ve got a classic cleanup problem: customer payments never applied to invoices, income double-counted, and an A/R ledger that’s basically fiction.

This pattern is incredibly common when:

• The client uses bank feeds and "Add" instead of matching.
• Staff doesn’t understand Undeposited Funds or Receive Payment.
• Someone "simplified" things by posting deposits directly to income.

If your firm does diagnostic reviews, this needs to be a deliberate, repeatable check—not something you stumble into halfway through the cleanup.

Where this problem hides inside QuickBooks Online

You’re looking for deposits in bank accounts that:

• Belong to a business that does use invoicing and A/R, and
• Are posted straight to income accounts, and
• Have no customer on the deposit.

Here’s how it shows up in practice.

Step 1: Confirm this is actually an invoicing business

Before you chase ghosts, make sure the file really uses A/R:

• Run a Transaction Detail by Account report filtered to Account Type = Accounts Receivable for the last 12 months; or
• Run Sales by Customer filtered to transaction types = Invoice and Receive Payment.

If there’s no real A/R activity (no invoices, no payments), this pattern is mostly noise. Move on.

Step 2: Scan the bank register the right way

Focus on active bank-type accounts, especially the main operating account. In the register (or Transaction Detail by Account for that bank):

• Filter Transaction Type = Deposit.
• Date range: last 12 months (or your cleanup window).
• Add columns for Name, Memo/Description, and Split/Account.

Now look for deposits where:

• Name is blank or not a customer.
• At least one line is coded directly to an income or other income account.
• The line is not coming from Undeposited Funds or an A/R clearing account.

A concrete example

Say you find this in the operating bank:

• 3/10/2025 Deposit for $2,100
• Name: (blank)
• Split: Design Services Income $2,100

Then you check open invoices and see:

• Invoice #1043 to Customer A
• Date: 3/5/2025
• Amount: $2,100
• Status: Open

That’s a textbook misapplied payment: the cash hit the bank, income was recognized again via the deposit, but the invoice is still sitting open.

By contrast, a clean deposit looks like:

• 3/10/2025 Deposit for $2,100
• Name: Customer A
• Lines: one line from Undeposited Funds tied to a Receive Payment for $2,100
• No direct posting to income

Key red flags to watch for:

• Deposits over a reasonable threshold (e.g., $100+) with no customer name
• Deposits coded directly to income when the business uses invoices
• Repeated patterns with the same memo (e.g., "Stripe Payout", "Square Deposit") but no customer detail
• Open invoices that match deposit amounts or dates closely
• A/R Aging that looks huge while cash and revenue also look high

What happens if you just live with it

The damage inside your numbers

When deposits are posted straight to income instead of applied to invoices, you get a double hit:

1. Income is overstated.
2. A/R is overstated.

Using the $2,100 example:

• Invoice posted $2,100 to income and A/R.
• Deposit posted another $2,100 to income, but never cleared A/R.

Result: revenue is $2,100 too high and A/R is $2,100 too high. If this happens dozens of times, you can easily be tens of thousands off on both the P&L and Balance Sheet.

It also wrecks:

• Cash vs. accrual comparisons
• KPI tracking (DSO, collection rates)
• Bank covenant reporting

And when tax returns have already been filed, you’re now dealing with amended returns or awkward current-year adjustments.

The damage in client conversations

From the client’s perspective, this is maddening:

• They see cash in the bank and assume invoices are paid.
• You show them an A/R Aging with "old" balances they swear are collected.
• You have to explain that their prior process double-counted income and left invoices open.

It erodes trust fast if you can’t explain clearly what happened and how you’re going to fix it without making a bigger mess—especially when prior-year books are closed or already used for lending and tax.

How strong cleanup firms tackle these deposits

Here’s a practical way to deal with this pattern during a cleanup, without getting lost in the weeds.

1. Confirm invoicing is in use.

   • Verify there is real A/R activity in the last 12 months.
   • If not, don’t waste time on this check.

2. Define your materiality threshold.

   • Decide a minimum deposit size to review (e.g., $100, $250, or higher for big clients).
   • Stay consistent within the engagement.

3. Pull a targeted deposit list.

   • For each active bank account, run a Transaction Detail by Account:
     • Filter Transaction Type = Deposit.
     • Date range = your cleanup window.
   • Export to Excel/Sheets if needed.

4. Filter to suspect deposits.

   • Keep only rows where:
     • Name is blank or not a customer, and
     • At least one line is coded to an income/other income account, and
     • The line is not from Undeposited Funds or an A/R clearing account.

5. Cross-check against open invoices.

   • For each suspect deposit, compare to open invoices around the same date:
     • Exact amount matches first.
     • Then near-matches (e.g., within $1 or 1%).
   • Mark likely matches for reclassification.

6. Correct with a clear method.

   • For current/open periods, typical fixes:
     • Create Receive Payment to clear the invoice.
     • Reclass the original deposit line from income to Undeposited Funds or a clearing account, then link properly; or
     • If you can’t unwind cleanly, use a journal entry to adjust income and A/R, with tight documentation.
   • For prior closed years, consider current-period-only adjustments and document why.

7. Document patterns and whitelists.

   • Identify recurring legitimate non-customer deposits (interest, owner contributions, merchant payouts net of fees).
   • Add these to your internal "whitelist" so you don’t chase them every year.

Tools like CleanupOwl can run this kind of check automatically, scanning deposits across all bank accounts, applying thresholds, and even suggesting likely matching invoices by amount and date. Instead of burning an hour building the list, you start directly in review and decision mode.

Turning this into a standard diagnostic habit

This shouldn’t be a heroic one-off. It should be a checkbox in your cleanup diagnostics:

• "Review bank deposits to income with no customer for invoicing clients."

Bake it into your:

• New-client diagnostic template
• Year-end review checklist
• Staff training on A/R and bank feeds

Ideally, your workflow looks like:

• Before scoping a cleanup, run a diagnostic scan (manually or with a tool like CleanupOwl) to quantify how many suspect deposits exist and in which periods.
• Use that to estimate effort, set expectations with the client, and decide how far back you’ll correct.
• During cleanup, work from a single, controlled list of deposits instead of hunting ad hoc inside the bank register.

The patterns you’ll keep seeing in client files

For low-level, isolated cases, you might decide to fix only those above your threshold and document the rest as immaterial. For recurring or systematic patterns, you’re looking at a deeper process fix: retraining staff, changing how bank feeds are handled, and possibly reworking multiple years.

When you see historic issues in closed years, you’ll often choose a pragmatic approach: leave the old entries in place, use current-year adjustments to true up balances, and clearly document the gap between books and prior tax returns.

Making this part of your cleanup playbook

Deposits posted straight to income with no customer name are one of those quiet problems that make A/R reports useless and inflate revenue without anyone noticing. Once you start looking for it, you’ll see it in a lot of invoicing clients—especially those living in bank feeds.

Giving this its own line item in your diagnostic checklist means:

• You catch misapplied payments early, before you build anything on top of bad A/R.
• You can explain clearly to the client what went wrong and what you’re fixing.
• Your team has a consistent standard for how far back to go and what "good enough" looks like.

Diagnostic tools like CleanupOwl can hand you the list of suspect deposits it used to take an hour to build by hand, so your time goes into judgment and cleanup instead of report gymnastics. If you’re a business owner reading this, this is exactly the kind of question to ask your accountant: "Are you checking for deposits posted straight to income instead of applied to invoices? How are you catching that—manually or with a diagnostic tool?"

Tightening up this one pattern goes a long way toward making your A/R aging something you can actually trust.