She Thought She Was Reconciling…
September in Anchorage has a way of making you notice what you’ve been putting off.
The mornings are cooler. The daylight is starting to retreat. Summer work is winding down for some businesses, while others are still trying to finish the season without dropping a plate.
And somewhere in the middle of all that, you open QuickBooks Online and see a reassuring message:
Reconciliation complete. Difference: $0.00.
Looks fine, right?
Not necessarily.
I’ve seen books that “reconciled” perfectly while the underlying activity was wrong. Sales were duplicated. Processing fees disappeared into nowhere. Credit card payments landed on the wrong liability accounts. Reports looked reasonable in isolation, but completely wrong when compared to the bank, POS system, processor, or actual card statements.
That kind of mistake doesn’t always explode immediately.
It sits there quietly, wearing a clean shirt.
Then tax reporting is wrong. Profit is overstated. Credit card balances become confusing. Cash-flow decisions get made on fiction.
That’s when bookkeeping stops being a useful business tool and starts becoming a slow, helpless slide toward financial failure.
Welcome to “What Broke Under the Hood?”
This is Part 1 of “What Broke Under the Hood?”, a recurring series about the real-world bookkeeping problems hiding behind tidy-looking reports.
These aren’t textbook examples. They’re the kinds of issues I’ve found while looking under the hood of actual small business books.
No client names. No identifying details. Just the problem, the root cause, and the practical lesson you can use in your own business.
Today’s lesson is simple:
Reconciliation is not checking a box. It is proving that your accounting system explains the activity that actually happened.
Let’s look at two cases.
Case 1: The Deposit That Wasn’t New Sales
The business used a point-of-sale system to record customer sales.
The POS showed the gross transaction amount. That was the amount customers paid before the payment processor deducted its fee.
Then the processor sent the net amount to the bank.
That’s normal.
For example, conceptually:
POS records the gross sale.
Payment processor withholds its processing fee.
Bank receives the smaller net deposit.
The books should show all three pieces:
Gross sales
Processing fee expense
Net deposit into the bank
Instead, the bookkeeper saw that the bank deposit did not match the gross POS activity.
Rather than tracing the difference, they entered the net bank deposit as a new transaction.
Now the accounting system had the original POS sale, and another income transaction for the deposit.
The mismatch was “fixed” later with a month-end journal entry.
On paper, the reconciliation could be pushed into agreement. The ending balance could be made to work. The books could look tidy enough to move on.
But the underlying activity was still wrong.
Where the mismatch lived
The bank statement showed one net deposit.
The POS report showed one gross sale.
The books showed the original sale plus the net deposit as additional income.
The processing fee, the piece that explained why the deposit was smaller, was not recorded correctly as an expense tied to the deposit.
That means income was elevated.
And because the duplicate income was treated as taxable sales, the sales-tax reporting was inflated too.
This is the kind of mistake that can make your eyes bleed when you finally find it. The bank balance may look right, but the Profit & Loss report is telling a story that never happened.
What actually went wrong?
The bookkeeper treated a movement of money as a new sale.
That is the root cause.
The bank deposit was not new revenue. It was the net settlement of revenue already recorded by the POS system.
A bank feed is not a second sales system. It is a record of money moving through the bank.
That distinction is a bookkeeping lifeline.
The proper diagnostic questions
If you use a POS system or payment processor, ask:
Does the POS report show gross sales, while the bank shows net deposits?
Is the difference between those amounts explained by processing fees, refunds, tips, chargebacks, or sales tax?
Are bank deposits being matched to existing sales or deposit records?
Are deposits being categorized as income a second time?
Is there a processor clearing account or Undeposited Funds workflow?
Does the processing fee appear separately in an expense account?
Does your sales-tax report agree with the taxable sales reported by your POS?
The basic rule is this:
Record the sale once. Record the fee separately. Treat the bank deposit as the settlement, not another sale.
In QuickBooks Online, that may mean using Undeposited Funds and a Bank Deposit transaction, or using a processor clearing account for systems with more volume.
The exact workflow depends on your setup. The principle does not.
Case 2: The Credit Card Payment in the Wrong Place
The second business had one master credit card with three secondary cards.
Think of it like this:
One master account
Three employee or department cards
Separate balances showing under each secondary card
Payments that need to be assigned to the correct liability
The statements told a clear story.
Each secondary card had charges. Payments were made against the overall credit card account. The master statement and secondary-card statements reflected what had actually happened.
But in the books, the payments were posted to the master card account rather than to the corresponding secondary-card liabilities.
The result was a mess that looked almost believable if you only viewed one account at a time.
What the books looked like
The master card showed a large overpayment.
The three secondary cards appeared unpaid, or at least significantly more outstanding than they should have been.
Meanwhile, the actual card statements told a different story. Payments had been made. The total liability was not what the individual QBO accounts suggested.
Nothing about that setup was proving the statements.
It was simply moving numbers around until some part of the file looked less uncomfortable.
Where the mismatch lived
The bank account reflected the payment leaving the business.
The credit card statement reflected the payment being applied to the overall card relationship.
But QuickBooks assigned the payment to the wrong liability account.
So the total may have appeared reasonable in some reports, while the account-level detail was false.
That matters.
If you rely on the wrong card balance when deciding whether you can make another purchase, pay yourself, or cover payroll, you are making decisions with a broken dashboard.
What actually went wrong?
The payment was recorded based on the master account structure rather than the account where the liability was actually being tracked in the books.
In other words, the transaction was technically entered, but not connected to the right accounting record.
A payment to a credit card is not correct merely because it reduces some credit card balance. It must reduce the liability account that represents the activity shown on the statement.
This is especially important when your card provider displays one master account with multiple secondary cards, while your QuickBooks chart of accounts tracks them separately.
The practical checks
If your business has multiple credit cards or subcards, review:
Does every QBO credit card account correspond to a real statement or clearly defined subaccount?
Are payments posted to the account that actually received the payment?
Does the master card show an unexplained credit balance or overpayment?
Do secondary cards show balances that don’t match their statements?
Are card payments being entered as expenses instead of transfers or credit card payments?
Do the combined balances of the master and secondary accounts agree with the statement?
Are transactions being downloaded into both the master and secondary accounts, creating duplicates?
Can you trace each payment from the bank account to the correct card liability?
Do not stop when the total “looks close.”
A number can look reasonable in isolation and still be wrong in context.
That is the entire point of reconciliation.
What Reconciliation Is Supposed to Prove
A proper reconciliation answers more than one question.
It does not merely ask, “Does the ending balance agree?”
It asks:
Did the transaction occur?
Is it recorded once?
Is it recorded in the correct account?
Does the amount agree with the source document?
Is the timing correct?
Does the transaction explain the movement of money?
Does the related liability, income, expense, or tax balance make sense?
Can another person follow the trail without guessing?
That last question is a big one.
If you have to explain a transaction with, “Well, it was entered that way to make the reconciliation work,” that is not a solution.
That is a warning flare.
A journal entry can be perfectly legitimate when it records a real, understood adjustment. But using a journal entry to bury an unexplained difference is not reconciliation.
It is camouflage.
A short owner-level reconciliation checklist
You don’t need to become a full-time accountant to perform a useful first check.
Pull the following for the same period:
Bank statement
POS sales report
Payment processor payout report
Credit card statements
QuickBooks Online reconciliation report
Profit & Loss report
Sales-tax report, if applicable
Then ask:
Do bank deposits tie to actual sales settlements: not duplicate income entries?
Can every difference between gross sales and deposits be explained?
Are processing fees recorded separately and consistently?
Do credit card payments reduce the correct card liabilities?
Do the combined QBO card balances match the real statements?
Are any journal entries being used to force a balance without documentation?
Does taxable income agree with the underlying POS activity?
Can you explain every unusual balance on the Balance Sheet?
If the answer is “I think so,” keep digging.
“Probably” is not a control.
Why This Matters for Small Business Owners
You may be thinking, “But my bank balance is right.”
That’s important: but it is not enough.
Your bank balance tells you how much cash is sitting in one account at one moment. It does not tell you whether:
Sales are overstated
Fees are missing
Sales tax is inflated
Credit card liabilities are assigned correctly
Expenses are duplicated
A processor clearing account is stuck
A journal entry is hiding a broken workflow
This is why good bookkeeping for small business is more than data entry.
It is the process of turning daily business activity into information you can trust.
When the books are right, your monthly Profit & Loss report becomes a game changer. You can see what is actually profitable. You can spot costs creeping upward. You can plan for taxes without discovering a nasty surprise at the worst possible time.
When the books are wrong, every report becomes suspect.
And that uncertainty is expensive.
You waste time checking numbers. Your CPA may spend more time cleaning up the file. You hesitate before making decisions. You lose peace of mind: the one thing your accounting system should be giving you.
The Way Forward: Diagnose Before You Optimize
If something under the hood is broken, guessing at the repair usually makes the mess worse.
Start by identifying where the explanation breaks:
Bank to QuickBooks
POS to processor
Processor to bank
Bank payment to credit card liability
Tax report to taxable sales
Journal entry to supporting documentation
Once the root cause is clear, the fix is usually much more straightforward.
That may involve cleaning up duplicate income, rebuilding a processor clearing account, correcting credit card payment postings, reviewing sales-tax treatment, or improving the monthly close routine.
This is where a focused QBO Diagnostic and Optimization review can provide a real lifeline.
The goal is not to make your file look pretty for one afternoon.
The goal is to make the accounting system explain the business consistently: month after month.
For some owners, that means continuing to handle daily transactions with a better workflow. For others, it means bringing in a QuickBooks Online bookkeeper for monthly bookkeeping services.
Either way, professional oversight can save you the hours of detective work, reduce expensive cleanup later, and help you make decisions from facts instead of financial fog.
I’m not here to tell you that every small business needs a complicated accounting system.
Most don’t.
But your system does need to be understandable, repeatable, and tied to what actually happened in the real world.
If you’re wondering whether your books are truly reconciled: or merely made to agree: I’m happy to take a look. No pressure, no lecture. We can identify what’s working, what broke under the hood, and what would restore your peace of mind.
You can contact Richard Evans Bookkeeping or review the available bookkeeping services.
Reconciliation should leave you confident: not confused.
Questions? Ask!
907- 615-3393
