The Retail Books a Lender Would Believe
WHO: A retail store owner running a family business through a single physical location.
THE PROBLEM: A handful of card-processor deposits every month landed a few hundred dollars short of what the register said they'd sold, with no clean explanation, and it had been going on for over a year.
THE OUTCOME: When their bank asked for their numbers for a lending review, every deposit either tied to a sale or sat in a clearly labeled account with a plain explanation. Nothing needed a scramble.
The Challenge
Their card processor deposited money into the bank every day, and most days it matched the register to the penny. But on a handful of days most months, sometimes two, sometimes five, the deposit landed short of the day's sales by anywhere from fifty dollars to a few hundred. Nobody could say why, and it had been happening for more than a year before they called us.
They'd been doing what most owners do with a gap like that: closing their eyes and hoping it evened out by month's end. It mostly did, on paper. But "mostly" isn't a number a lender or a buyer will accept, and by the time anyone went looking, the trail was already cold.
What We Did
We pulled the real processor settlement reports next to the real bank deposits, day by day, going back over a year. Most days tied out clean once fees were backed out. The handful that didn't got the same question every time: what actually explains this gap?
That question is where every bookkeeper faces a choice, and it's the one worth teaching. The fast move is to plug the gap: drop the difference into a catch-all adjustment account, force the numbers to match, move on. Nobody notices for months. We don't do that. Instead, we park it: any deposit we can't fully explain goes into a dedicated, visibly named account on the balance sheet built for exactly that purpose, and it stays there, open and labeled, until the actual settlement statement explains it. True processor rounding, a penny or two, still goes to a real balance adjustment. Anything that could be real money stays parked in plain sight instead of buried.
We set a plain written rule so the next fifty deposits get judged the same way the first one did: under a dollar off, call it matched. Under fifty dollars off, verify it by hand. Over fifty dollars, stop and get an answer before it closes. No guessing, no exceptions.
The Results
- Over a year of card-processor deposits reconciled day by day against real settlement reports, not the software's guess. - Every unexplained deposit now lives in one labeled account, visible on the balance sheet, instead of hidden inside a catch-all adjustment. - A written variance rule now judges every deposit the same way: matched, verify, or stop and ask, with a hard dollar line at each step. - Zero unexplained variance when their bank pulled the numbers for a lending review, every deposit tied to a sale or carried a plain, on-the-record explanation. - No scramble. What used to be a once-a-year fire drill is now a number they can hand over on a Tuesday.
Start With a Diagnostic Review
If your card processor deposits never quite match your register and you've been closing your eyes and hoping it evens out, you're not alone, and it's fixable. We start every new client with a $497 Diagnostic Review: we open your actual books, compare them to your actual bank statements, and tell you plainly what we find.