The Payout Never Matches the Sale: An E-Commerce Cleanup Story
At a glance
Who: An online shop owner selling through an e-commerce platform, doing their own bookkeeping with no in-house accountant.
The problem: Every deposit that hit the bank was a lump sum that never matched what they'd actually sold, and the connection feeding bank activity into the books had quietly stopped working for over a month before anyone caught it.
The outcome: Every payout now splits into sales, fees, and refunds the moment it lands, and the checking account ties to the bank every month, to the penny.
They came to us the way most online sellers do: sales looked fine, but the bank balance never quite matched the story. A deposit would land for some odd number, $1,432 one day, $4,442 the next, and none of it lined up with what they remembered actually selling that week. They couldn't tell you their real margin on any given month, because the number hitting the account was never sales. It was whatever was left after the platform took its cut and processed whatever refunds went out, and none of that was broken out anywhere they could see it.
What we found
We started by pulling the actual bank record, not the dashboard number the bookkeeping software was showing. Once we lined it up against what should have been there, two things stood out.
First, the payouts. Every single deposit was really three numbers rolled into one: the sales, the platform's fees, and any refunds processed that period, all netted down to a single line before it ever reached the bank. The books had been recording the deposit as straight revenue, which meant sales were overstated and the real costs were invisible.
Second, and more serious: the connection between the bank and the books had broken. Silently. No error message anyone would have noticed, no missing-deposit alert, just a feed that stopped bringing transactions over and kept reporting old data as if nothing had changed. It had been down for over a month by the time we caught it. More than 70 transactions from that stretch had never made it into the books at all.
What we did
We pulled the real bank statement for the period and rebuilt the missing weeks transaction by transaction, off the actual record, not a guess at what probably happened. Then we went back to every payout and split it the way it should have been split from the start: sales as sales, the platform's fees as an expense, refunds as refunds, each one tied to the deposit that produced it.
Here's something any online seller can check today: pull one payout report from your sales platform and lay it next to the bank deposit it produced. If the two numbers match exactly, you're fine. If they don't, the gap is almost always fees and refunds sitting inside a number your books are calling pure revenue. That gap is real money you can't see until you break it apart.
While we were in there we also traced a reconciling gap of nearly $8,000 that had nothing to do with sales at all. It turned out to be money moving between the owner's own accounts that had never been recorded as a transfer. Once we found where it actually went, the gap closed to the penny.
The results
- Rebuilt over 70 transactions from the real bank record after a feed outage that ran silently for more than a month - Every payout now splits automatically into sales, fees, and refunds instead of landing as one guessed number - Traced and closed a nearly $8,000 reconciling gap down to the exact transactions behind it - The checking account now ties to the bank every month, $0.00 difference - The owner can finally see their real margin, not just what happened to be left in the account
If this sounds familiar
If you're selling online and your bank balance never quite matches what you know you sold, you're not imagining it. Payment platforms are built to move money, not to show you where it went. That's a bookkeeping problem, and it's a fixable one.
We start every new client with a $497 Diagnostic Review: we open your actual books, compare them to your actual bank and payout records, and tell you plainly what we find.