The “Missing Link” in QuickBooks: Why Deposits Don’t Reduce A/R (and How to Fix It)

Janice Henao
Apr 29
3 min read

By SJV-Executive Support

If you’ve ever looked at your books and thought:

“We got paid… so why is the invoice still open?”

You’re not alone.

This is one of the most common and costly issues we see when stepping into cleanup and reconstruction projects. Payments exist. Deposits exist. Bank accounts reconcile. Yet Accounts Receivable is overstated, invoices remain open, and financials don’t tell the true story.

This is what we call the “Missing Link.”

What Is the Missing Link?

In QuickBooks Desktop, there are two separate actions:

Receiving a Payment → impacts Accounts Receivable
Making a Deposit → impacts the bank account

These are not the same thing.

When deposits are recorded directly, especially through bank feeds and coded to Accounts Receivable, QuickBooks does not automatically apply them to invoices.

The result?

Payments exist, but are not applied
Deposits hit the bank, but don’t reduce A/R
Invoices stay open
Customer balances are overstated

Why This Matters More Than You Think

This isn’t just a “QuickBooks issue.”It affects the integrity of your entire financial system.

1. Accounts Receivable Becomes Inaccurate

Your A/R aging may show customers owing money that has already been paid. This leads to:

Misleading collections efforts
Damaged client relationships
Poor cash flow visibility

2. Revenue Reporting Gets Distorted

If deposits are coded incorrectly (often to income instead of A/R), you may:

Overstate revenue
Recognize income in the wrong period
Create discrepancies for your CPA

3. Bank Reconciliations Can Be Misleading

You can have a perfectly reconciled bank account while your A/R is completely wrong.

That’s because:

Reconciliation confirms cash movement, not proper accounting structure

4. Job Costing & Project Profitability Break Down

For industries like construction, where invoicing includes:

Contracts
Change Orders
Progress billing

Misapplied payments can:

Make jobs look unpaid
Distort profitability per phase
Complicate reporting to owners and stakeholders

How the Problem Happens

This issue typically occurs when:

Bank feed deposits are added directly
Deposits are coded to Accounts Receivable
No Receive Payment step is completed
Invoices are created after payments were already recorded

QuickBooks doesn’t “guess” the connection.It requires a deliberate link.

The Correct Workflow (The Fix)

To properly record and link payments:

Create a Receive Payment
- Select the correct customer
- Apply it to the appropriate invoice
- Deposit to Undeposited Funds
Open the Bank Deposit
- Remove any direct A/R-coded lines
- Use the “Payments” button to pull in the correct payment
Save the Deposit
- Now the payment is correctly linked
- The invoice is reduced
- The bank remains accurate

The Key Principle

Payments reduce Accounts Receivable. Deposits only move money into the bank.

If this link is missing, your books may look complete but they are not accurat

Why This Is a Crucial Skill

Understanding this process is not just technical, it’s strategic.

It allows you to:

Rebuild books without breaking reconciliations
Clean up years of misapplied transactions
Ensure financial statements reflect reality
Maintain audit-ready records

This is the difference between:

Entering transactions and Controlling financial data

The “Missing Link” is one of the most overlooked issues in QuickBooks, yet it impacts:

A/R accuracy
Revenue recognition
Cash flow reporting
Job profitability

At SJV-Executive Support, we specialize in identifying and correcting these structural gaps ensuring your financials are not just complete, but correct, compliant, and actionable.

Need Help Cleaning Up Your Books?

Whether you're dealing with:

Years of unlinked deposits
Reconciliation discrepancies
A/R that doesn’t make sense

We don’t just “fix numbers.” We rebuild financial clarity from the ground up.

SJV-Executive Support Financial Reconstruction. Operational Clarity. Executive-Level Support.