When Clients Mix Sales Tax Accounts: How to Untangle Mixed Payment Books
Sales flowing through invoices, sales receipts, and Square often end up posting tax to the wrong accounts. Here is a practical way to sort out the mess.
Bookkeeping breaks quietly when a business takes payments several ways. One client invoices some customers, takes cash for others, and runs the rest through Square. None of that is unusual. The problem is that each channel was set up differently, so sales tax ended up in three different places, and nobody noticed for years.
Why mixed payment channels create account chaos
Every transaction in double-entry bookkeeping touches two accounts. When a business sells through invoices, sales receipts, and a processor like Square, each channel needs its own mapping. If the mappings disagree, sales tax lands in a liability account in one place and an expense account in another.
The books can still reconcile. Bank deposits match, clearing accounts zero out, and the owner believes everything is fine. Reconciliation only proves the bank account is accounted for. It says nothing about whether income, tax, and fees were classified correctly.
The clearing account trap
A common shortcut is to route every deposit through a clearing account and force the balance to zero each month. If Square is known, and invoiced deposits are known, the remainder is assumed to be cash. It balances, so it must be right.
This is backwards. The residual method hides errors instead of exposing them. Cash sales are never actually counted; they are just whatever is left over. Fees, timing differences, and mispostings all disappear into the plug.
A cleaner structure for mixed sales
We suggest keeping it simple and consistent:
- Route invoiced sales and sales receipts through the standard QuickBooks receive-payment and deposit flow, matching bank deposits to open invoices.
- Record processor activity with a monthly journal entry that captures merchant fees and moves net sales to the correct income account.
- Post sales tax to one sales tax payable liability account, regardless of which channel collected it.
- Reconcile each clearing account to the processor’s own settlement reports, not to a residual balance.
How to fix years of mixed postings
Start by picking a cutoff date rather than rewriting history. Identify where tax currently sits for each channel, then post correcting journal entries to move misplaced tax into the single liability account. Verify the liability balance against filed returns for the period.
If the file is large, messy, or headed for a sale of the business, a cleanup is easier on a condensed copy. Our guide to condensing an oversized QuickBooks company file covers how to shrink the data before the review, and our QuickBooks file repair service can help when the file itself has grown unstable.
Talking to clients who insist their logic is right
Owners often reason from their checking account: money came in, money matched, done. That mental model has no room for double entry. Rather than debating, show them one transaction on screen. Point at the two accounts it touches, then show the same sale posted three different ways across their channels. The inconsistency makes the case better than an argument does.
The practical next step: pick one month, trace every deposit back to its source channel, and document the mapping you settle on. That map becomes the standard the client, and any future bookkeeper, can follow.