What happens if my inventory records don't match my physical count?
When your book count and physical count don’t agree, it means something went wrong between the last time the numbers were accurate and now. The discrepancy could be small or significant, but either way it needs to be investigated and corrected. Ignoring it leads to inaccurate financial statements, unreliable cost of goods sold, and potentially wrong tax filings.
The most common causes are data entry mistakes, receiving errors, unrecorded damage or spoilage, theft, and returns that weren’t processed correctly. Sometimes the unit of measure is off. You received a case of 12 items but entered it as 1 unit. Other times a sale was recorded but the inventory quantity wasn’t updated because the system wasn’t configured properly. Before you adjust anything, try to figure out why the numbers are off. The cause tells you whether this is a one-time mistake or a recurring problem in your process.
Once you’ve identified the discrepancy and done your best to find the cause, you need to record an inventory adjustment in your books. In QuickBooks Online, this is done through an inventory quantity adjustment that brings your book count in line with the physical count. The dollar difference flows through to an inventory shrinkage or adjustment expense account, which ultimately affects your cost of goods sold and your profit. If the adjustment is large, it can noticeably change your margins for that period.
Document every adjustment with notes about what you found and why you believe the discrepancy occurred. This matters for your own records, for your accountant at tax time, and in case you’re ever audited. “Adjusted inventory” with no explanation doesn’t help anyone. “Adjusted down 14 units of SKU 2045, likely damaged during July warehouse move” tells a story that makes sense.
The real goal is to reduce how often this happens. Regular cycle counts, where you count a portion of your inventory on a rotating schedule rather than waiting for one big annual count, help catch problems early. Tightening up your receiving process so every delivery gets verified before it’s entered into the system prevents a lot of errors. And making sure your inventory accounting is set up correctly in the first place means the system tracks quantities and values the way it should.
If you’re consistently finding discrepancies every time you do a physical count, that points to a systemic issue rather than the occasional mistake. It could be a workflow gap, a training issue, or a software configuration problem. A QuickBooks ProAdvisor in Long Beach can help you review your setup and processes to find where things are breaking down so you’re not just adjusting the same types of errors over and over again.
Long Beach's Trusted Bookkeeping Partner
The Next Step:
A Quick Discovery Call
Tell us where things stand with your books. We'll listen, ask a few questions, and give you a clear quote to get it handled.
More Questions
How do I track contractor expenses versus employee expenses?
Contractor payments and employee wages should live in separate accounts in your chart of accounts. Contractors are set up as vendors and reported on 1099s, while employees run through payroll and get W-2s.
Read answerHow often should a small business reconcile its books?
At minimum, reconcile monthly. But weekly is better for most small businesses because it keeps errors small, makes bank feeds easier to review, and gives you financial information you can actually act on.
Read answerWhat KPIs should a small business owner watch every month?
Focus on revenue trends, gross profit margin, net profit margin, cash on hand, and accounts receivable aging. These five metrics give you a clear picture of whether your business is healthy and where to take action.
Read answerHow should a real estate agent track commissions and expenses?
Record every commission at gross before the broker split, then track the split, transaction fees, and your net separately. For expenses, use a dedicated business account and categorize everything consistently so nothing gets missed at tax time.
Read answerHow do I track inventory costs for my Shopify store?
Shopify tracks sales and stock counts but doesn't handle inventory costing the way your books need it. You need an accounting system like QuickBooks Online connected to Shopify to properly track what you paid for products, landed costs, and cost of goods sold.
Read answerHow do I know it's time to outsource my bookkeeping?
If you're months behind on your books, can't confidently answer basic questions about your business finances, or spending hours on bookkeeping instead of running your business, those are strong signs it's time to hand it off.
Read answer
