Guide · 7 min read · November 16, 2026
Year-end inventory count: a guide for DTC and eCommerce brands
Your December 31 inventory balance sets cost of goods sold for the whole year, so a sloppy count misstates profit directly. This year-end inventory count guide is for founders and finance leads at DTC and eCommerce brands, whether stock sits in your own space or at a 3PL. It covers how to plan the count, run it, handle cutoff and post the adjustment to your books.
What's inside
- · Why the ending count drives your gross margin
- · Planning the count before December 31
- · A count-day procedure that holds up
- · Getting cutoff and goods in transit right
- · Reconciling the count to your books, with a worked example
- · Damaged stock and what to hand your CPA
Why the ending count drives your gross margin
For a product business, cost of goods sold for the year is a simple equation: beginning inventory + purchases − ending inventory. Beginning inventory is last year's ending count, and purchases come from your bills and landed costs. Ending inventory is the one number you have to go and prove. Every dollar of error in it moves straight into gross profit.
Say a DTC apparel brand starts the year with $180,000 of inventory and buys $620,000 during the year. Its books show $210,000 on hand at December 31, so cost of goods sold looks like $590,000. The physical count comes in at $196,500. Corrected cost of goods sold is $603,500, and gross profit drops by $13,500. Without the count, the brand would report profit it never earned and carry inventory it doesn't have into next year.
| Line | Per the books | Per the count |
|---|---|---|
| Beginning inventory | $180,000 | $180,000 |
| Purchases | $620,000 | $620,000 |
| Ending inventory | $210,000 | $196,500 |
| Cost of goods sold | $590,000 | $603,500 |
The gap usually comes from ordinary leaks: unrecorded damage, returns that were refunded but never restocked, samples and influencer sends taken off the shelf, and receiving errors. A careful count catches all of them at once.
Plan the count before December 31
Most count problems are planning problems. Settle these points a few weeks ahead, and write them down so the people counting follow the same rules.
- 01
Pick the count date
Count as close to December 31 as you can. If you count a few days earlier or later, you'll need to roll the count forward or back using the receipts and shipments in between, which adds work and risk.
- 02
Clean up the item list
Merge duplicate SKUs, retire dead ones and make sure every item in your store, your 3PL and your accounting system uses the same SKU. Mismatched SKUs are the most common reason a count won't tie out.
- 03
Set the cutoff
Decide the exact moment the count represents, then plan to pause receiving and shipping from that location while you count, or tag anything that moves so it isn't counted twice or missed.
- 04
Coordinate with your 3PL
If a warehouse holds your stock, ask early how it handles year-end counts, what it charges, and whether it can send an on-hand report by SKU and location as of your cutoff. Get the report in writing.
- 05
List stock that isn't on the shelf
Gather what's in transit from suppliers, at Amazon or other marketplaces, on consignment, at a photographer or in a returns pile. Each needs a decision about whether it belongs in the count.
- 06
Prepare count sheets
Print or load sheets by location, with SKU and description but no expected quantity. Counters who can see the book number tend to find it.
A count-day procedure that holds up
Run count day the same way every year, so the result is something you, your CPA and any lender can rely on.
- 01
Count in pairs
One person counts and one records. Assign each pair specific shelves or bins so nothing is skipped or counted twice.
- 02
Tag what's done
Mark each bin or pallet once it's counted. A simple sticker or tag makes gaps obvious before anyone leaves.
- 03
Separate damaged and returned goods
Count damaged, expired and customer-returned items on their own sheet, not mixed in with sellable stock. They may be valued differently.
- 04
Recount a sample
Have a second pair recount high-value SKUs and any location where the count looks off. Resolve differences on the spot, while the stock is still in front of you.
- 05
Sign and keep the sheets
Each pair signs its sheets. Keep the originals or the system export, with the date and the names of who counted. That's your evidence for the ending balance.
Get cutoff and goods in transit right
A perfect count can still produce the wrong number if the books and the shelves describe different moments. The test is simple: anything counted as inventory should have its cost recorded, and anything that left as a sale should have its revenue recorded, both on the same side of the cutoff.
| Situation at December 31 | What to check | Common mistake |
|---|---|---|
| Goods received, supplier bill not entered | Record the bill or an accrual dated in December | Inventory counted but no matching cost or payable |
| Bill entered, goods still on the water | Check the shipping terms on the purchase order to see whether you own them yet | Including or excluding in-transit goods without looking at the terms |
| Order paid, not yet shipped | Stock stays in inventory; on accrual books the payment usually sits as a liability until you ship | Counting the sale and the stock at the same time |
| Order shipped, payout arrives in January | Record the sale in December and leave the stock out of the count | Sale pushed to January while the stock is already gone |
| Stock at a marketplace warehouse | Use the marketplace's on-hand report as of your cutoff | Leaving it out because nobody can count it physically |
Reconcile the count to your books
Once the count is final, compare it to quantities on hand in your inventory system, SKU by SKU. Investigate large variances before you adjust anything: a missed bin or a mislabeled SKU is a counting error to fix, not shrinkage to write off.
| SKU | Book qty | Counted qty | Unit cost | Variance |
|---|---|---|---|---|
| Organic tee | 1,200 | 1,150 | $8.00 | −$400 |
| Fleece hoodie | 640 | 655 | $22.00 | +$330 |
| Ceramic mug | 900 | 820 | $6.00 | −$480 |
| Canvas tote | 400 | 400 | $5.00 | $0 |
| Net adjustment | — | — | — | −$550 |
In this hypothetical, the hoodie overage turned out to be a receipt entered short in October, so it was corrected on the original receipt. The tee and mug shortfalls held up on recount and become a $880 inventory adjustment for the year.
If you track inventory in QuickBooks Online Plus or Advanced, record the adjustment with + Create > Inventory qty adjustment. Enter the adjustment date, choose the inventory adjustment account, then enter either the new quantity or the change for each item and explain it in the memo. QuickBooks updates your inventory asset and cost of goods sold for you. If your inventory lives in a separate app that syncs to your books, adjust it there instead so the two systems stay in step.
Finally, tie the inventory asset account on your balance sheet to the valued count. The two should match to the dollar. Any remaining difference is an account reconciliation problem to solve before you close the year.
Damaged stock and what to hand your CPA
Damaged, expired and slow-moving stock is where judgment comes in. Your books should show what you found, and your CPA decides how it's treated for the return. Don't write items down or off on your own based on a guess.
- Signed count sheets or the count export, with the date, locations and counters
- The SKU-level reconciliation of book to counted quantities, with notes on large variances
- 3PL and marketplace on-hand reports as of your cutoff
- A list of damaged, expired and slow-moving items, with quantities, cost and what you plan to do with them
- Open purchase orders and goods in transit at year-end, with their shipping terms
- How you assign cost to inventory, such as average cost or first in, first out
The count also belongs in your wider year-end close. Our year-end bookkeeping checklist covers the rest of the balance sheet, and our eCommerce bookkeeping team handles counts, cutoff and COGS for product brands every month.
Frequently asked questions
- Do I need a physical count if my inventory software tracks every unit?
- Yes. Software tracks what was recorded, not what actually happened, so damage, theft, receiving errors and unrecorded samples only show up when someone counts. A year-end count is the check on the system.
- Can my 3PL's report replace a count?
- It's often the best evidence you have for stock you can't reach, but treat it as a report to reconcile, not a final answer. Compare it to your own records by SKU and ask the 3PL to explain material differences.
- What if I can't count on December 31?
- Count as close to year-end as you can, then roll the result to December 31 using the receipts and shipments recorded in between. Keep the roll-forward with your count sheets so your CPA can follow it.

