StockTally Logo StockTally Contact Us
Menu
Contact Us

Stock Reconciliation: Physical Counts and Variance Analysis

Master the process of conducting physical inventory counts, identifying discrepancies between your records and actual stock, and resolving variances to maintain accurate financial statements.

10 min read / Intermediate / February 2026
Warehouse inventory shelves with organized products and barcode labels, stock taking in progress

Why Physical Counts Matter

Your inventory records and what’s actually on your shelves aren’t always the same. That’s where physical counts come in. They’re not just about finding lost boxes — they’re about catching errors that affect your financial statements, tax filings, and business decisions.

Here’s the thing: even well-managed businesses experience inventory variance. Shrinkage happens. Data entry mistakes happen. Items get damaged or misplaced. Without regular physical counts and proper variance analysis, you’re flying blind. You don’t know if your FIFO or weighted average cost calculations are working with accurate numbers, and that ripples through your entire accounting system.

In Canada, accurate inventory records aren’t just good practice — they’re a CRA requirement for businesses claiming deductions and calculating taxable income correctly. A thorough reconciliation process catches discrepancies before they become compliance issues.

Warehouse worker using barcode scanner to verify inventory items, clipboard in hand

The Physical Counting Process

A systematic approach to getting accurate numbers

01

Preparation and Planning

Don’t just start counting. You need a plan. Decide whether you’ll do a full physical count (everything at once) or cycle counting (smaller sections regularly). Most businesses find cycle counting more practical — it’s less disruptive and catches issues faster. You’ll want to freeze transactions temporarily, organize your counting teams, and prepare count sheets or use counting software.

02

Conducting the Count

Assign specific areas to different team members. Each person counts their section independently — no shortcuts. They’ll record quantities, item descriptions, and any damaged or unusable stock. Two-person verification works well here: one counts, one records. This catches mistakes immediately rather than discovering them later.

03

Recording and Verification

Physical counts need to match your system records. Enter the counted quantities into your accounting software and compare them against what your books say. This is where variances appear. You’ll spot items that don’t exist in your system, items that should be there but aren’t, and quantity differences.

04

Analysis and Reconciliation

This is the critical part. Compare your count results against your system records. Calculate the variance — the difference between what you counted and what your books show. Some variance is normal. The goal is understanding why it happened and fixing the underlying issues.

Understanding Variance Analysis

Variance isn’t failure — it’s a diagnostic tool. When your physical count differs from your records, you’re looking at one of several situations. Maybe you’ve got shrinkage (theft or breakage), maybe there’s a data entry error, maybe items are in transit, or maybe someone recorded a sale but didn’t update inventory.

Calculate your variance percentage: (Physical Count – Book Amount) Book Amount 100. If you counted 95 units but your books show 100, that’s a -5% variance. Most businesses accept 1-3% variance as normal. Anything higher signals a problem worth investigating.

You’ll want to categorize your variances. Is this shrinkage that’s ongoing? A one-time error? An obsolete item nobody realized was unsellable? Once you know what’s causing variance, you can address the root cause rather than just adjusting numbers.

Close-up of inventory tracking spreadsheet with variance calculations highlighted and notes
Accountant reviewing inventory adjustment journal entries in accounting software

Making Adjustments and Entries

Once you’ve identified your variances, you’ll need to adjust your records. This is where your journal entries come in. You’re essentially telling your accounting system: “Here’s what we actually have, not what we thought we had.”

If you counted less inventory than your books show, you’ll record a variance or shrinkage expense. If you counted more (rare, but it happens), you’ll record a gain. These adjustments flow through to your cost of goods sold calculation, which directly affects your taxable income — another reason why accuracy matters for CRA compliance.

Document everything. Why was there a variance? Was it damage? A data entry error? An unrecorded sale? This documentation protects you during audits and helps you prevent similar issues next time.

Best Practices for Accurate Reconciliation

Practical steps to reduce variances and maintain clean records

Use Cycle Counting

Instead of one massive annual count, count a portion of inventory regularly. It’s less disruptive, catches issues faster, and gives you better data throughout the year rather than a snapshot at year-end.

Implement Barcoding

Barcodes eliminate most data entry errors. Scanners don’t misread quantities or item numbers the way manual entry does. Your counts become more accurate and counting goes faster.

Control Physical Access

Shrinkage often starts with access. Limit who can remove inventory from storage. Track movements through your system. When only authorized people can touch stock, you’ve eliminated a major variance source.

Train Your Team

Counting isn’t complicated, but it needs to be done carefully. Train your team on proper counting procedures, how to handle damaged items, and how to record results accurately.

Reconcile Regularly

Don’t wait for year-end. Monthly or quarterly reconciliations catch problems while they’re small and fixable. You’ll spot trends in your variance patterns too.

Document Everything

Keep records of your counts, variances, and the reasons for adjustments. This documentation is crucial for audits and helps you track whether your variance reduction efforts are working.

Why This Matters for Your Business

Physical inventory counts and variance analysis aren’t just accounting exercises. They’re how you keep your financial statements honest and your tax filings compliant. When your physical inventory matches your records, your cost of goods sold calculations are reliable. Your FIFO or weighted average cost method works with real data. Your profit numbers mean something.

For Canadian businesses, the CRA expects accurate inventory records. If your numbers are off and you can’t explain why, you’re creating audit risk. Regular reconciliation with documented variance analysis protects you. It shows you’re taking your records seriously and managing your business systematically.

Start with your most valuable inventory items. Count them regularly. Understand your variance patterns. Fix the underlying causes. You’ll end up with cleaner records, better financial information for decision-making, and confidence that your numbers are accurate.

Important Disclaimer

This article provides educational information about inventory accounting practices and physical stock reconciliation methods. It’s intended to help you understand general concepts and best practices, not to serve as professional accounting or tax advice. Inventory accounting rules vary based on your business structure, industry, and specific circumstances. For guidance on your particular situation, consult with a qualified accountant or tax professional familiar with Canadian tax law and CRA requirements. The information presented reflects general practices as of February 2026 and may be subject to changes in accounting standards or tax regulations.