The Two Numbers Should Match to the Cent
I was sitting in my office last Tuesday, staring at a stack of crumpled thermal paper receipts that looked more like a shredded document than a business record, when it hit me: most of my clients aren’t actually “managing” their sales tax; they’re just hoping they haven’t missed anything. There is this massive, dangerous myth that as long as you’re sending a check to the CRA every few months, you’re doing fine. But if you aren’t actively reconciling collected versus remitted amounts every single month, you aren’t running a business—you’re playing a high-stakes game of musical chairs with money that doesn’t belong to you.
I’m not here to give you a lecture on theoretical accounting principles or drown you in jargon that only makes sense in a textbook. My goal is to show you how to spot the gap between what your POS system says you took in and what actually left your bank account. I’ll give you the straight-talk version of how to tighten this up so you can stop worrying about a surprise audit and get back to actually running your company.
Spotting the Cash Collection vs Remittance Discrepancy Early
If you wait until tax season to look at your numbers, you aren’t managing a business; you’re just performing an autopsy. The easiest way to catch a cash collection vs remittance discrepancy is to stop treating your sales software and your bank account like they are the same thing. I see it all the time: a client’s POS system says they collected $5,000 in HST, but their bank deposits tell a different story. You need to build a routine where you’re matching the digital paper trail to the actual cash every single month.
Don’t make this a quarterly marathon. Instead, try to implement a simple revenue reconciliation process that happens while the ink is still wet. If you’re seeing a gap between what your invoices say and what’s actually sitting in your tax liability account, don’t just shrug it off as a “rounding error.” Those little variances are exactly how an audit starts. You want to be able to point to a clear audit trail for collected funds so that when the CRA eventually comes knocking, you aren’t scrambling through a shoebox of crumpled thermal paper to prove where the money went.
Building an Audit Trail for Collected Funds That Lasts
If you’re still relying on a single crumpled notebook or a messy spreadsheet to track what customers owe you, you aren’t building a business; you’re building a trap. To avoid a nightmare during tax season, you need a formal revenue reconciliation process that links every single sale directly to a specific payment method. I tell my clients all the time: if you can’t point to a specific invoice and match it to a line item on your bank statement, you don’t have an audit trail—you have a pile of guesswork.
A proper audit trail for collected funds means keeping your sales records and your bank deposits in two separate but perfectly synchronized lanes. I’ve seen too many owners try to “fix” things by just moving numbers around in a ledger when they notice a gap. Don’t do that. Instead, make it a habit to perform a weekly reconciliation of accounts receivable against your actual cash on hand. It takes twenty minutes on a Friday afternoon, but it’s the only way to ensure that when the CRA comes knocking, you aren’t left scrambling to explain why your books look like a work of fiction.
Five Ways to Stop the Bleeding Before the CRA Knocks
- Stop treating the sales tax in your bank account like it’s your own revenue. That money belongs to the government the second it hits your hand; if you use it to cover a slow month in payroll, you aren’t “borrowing” it, you’re digging a hole you’ll eventually have to climb out of with interest.
- Match your point-of-sale reports to your actual bank deposits every single week. If your software says you collected $450 in HST on Tuesday, but your bank statement shows a different reality, don’t just shrug it off—find out why before it becomes a month-long forensic investigation.
- Create a “Tax Reserve” sub-account. Every time you make a sale, move the tax portion into a separate account that you don’t touch for anything except remitting. It keeps your operating cash clean and ensures the money is actually there when the filing deadline looms.
- Watch out for the “rounding error” trap. If you’re manually calculating tax on a spreadsheet instead of using a system that tracks it per transaction, those few cents of discrepancy will snowball into a massive reconciliation nightmare by the end of the quarter.
- Keep a simple log of any adjustments or refunds you issue. If you refund a customer, you need to be able to show exactly how that reduces your collected tax amount, otherwise, you’ll end up paying tax on money you never actually kept.
The Bottom Line: Don't Let Your Sales Tax Become a Personal Loan to the CRA
Treat collected sales tax like it’s already gone; it’s never your money, so stop treating your tax collection account like a slush fund for operating expenses.
If your bank deposits don’t tell the same story as your sales reports, you aren’t just disorganized—you’re building a paper trail that leads straight to an audit.
Reconciliation isn’t a “once-a-year” spring cleaning task; it’s a monthly necessity to ensure the gap between what you took in and what you sent away stays at zero.
The Bottom Line on Your Bottom Line
At the end of the day, reconciling your sales tax isn’t about being a math whiz; it’s about closing the loop. You need to ensure that the tax you collected at the point of sale matches exactly what hits your bank account, and more importantly, what you actually remit to the CRA. By spotting discrepancies early and maintaining a bulletproof audit trail, you stop the bleeding before it becomes a formal inquiry. Don’t let your tax obligations become a “shoebox mystery” that you try to solve only when a notice arrives in the mail. Keep your records tight, keep your reconciliations frequent, and treat that tax money as if it were never yours to begin with.
I know it feels like a chore—an extra layer of paperwork on top of an already exhausting job. But remember, the goal here isn’t just to satisfy a government agency; it’s to protect the business you’ve worked so hard to build. When you master these small, boring habits now, you are buying yourself peace of mind for the future. You didn’t start this company to spend your weekends stressing over HST filings or chasing down missing cents. Get the system in place today so you can get back to the parts of your business that actually matter.
Frequently Asked Questions
What do I do if I realize I’ve been under-collecting tax from customers for the last six months?
First, take a breath. You aren’t the first person to realize they’ve been leaving money on the table, and you won’t be the last. Don’t try to hide it; the CRA has a way of finding things you thought were buried. Calculate the exact shortfall immediately. You’ll need to report the correction on your next filing and, frankly, prepare to pay the difference plus interest. It’s a bitter pill, but it beats an audit.
Is it enough to just match my bank deposits to my sales reports, or do I need to go deeper than that?
If you’re just matching bank deposits to sales reports, you’re essentially looking at the surface of a frozen curling sheet and assuming everything underneath is smooth. It’s a start, but it’s not enough. You need to dig into the “why” behind the numbers. You have to ensure the tax portion of every individual transaction actually matches the total you’re setting aside. If you don’t bridge that gap, you’re just guessing.
If I find a discrepancy during my own monthly check, do I have to report it immediately or can I just fix it in the next filing?
If you catch a mistake during your monthly check, don’t panic, but don’t just bury it in next month’s numbers either. If it’s a small oversight, you can usually adjust it in your next filing. However, if you’re looking at a massive gap—the kind that makes your stomach drop—you need to report it properly. Trying to “smooth it out” over several months is a red flag that smells like an audit waiting to happen.
