Skip to main content

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.

LinePer the booksPer 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.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  1. 01

    Count in pairs

    One person counts and one records. Assign each pair specific shelves or bins so nothing is skipped or counted twice.

  2. 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.

  3. 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.

  4. 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.

  5. 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 31What to checkCommon mistake
Goods received, supplier bill not enteredRecord the bill or an accrual dated in DecemberInventory counted but no matching cost or payable
Bill entered, goods still on the waterCheck the shipping terms on the purchase order to see whether you own them yetIncluding or excluding in-transit goods without looking at the terms
Order paid, not yet shippedStock stays in inventory; on accrual books the payment usually sits as a liability until you shipCounting the sale and the stock at the same time
Order shipped, payout arrives in JanuaryRecord the sale in December and leave the stock out of the countSale pushed to January while the stock is already gone
Stock at a marketplace warehouseUse the marketplace's on-hand report as of your cutoffLeaving 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.

SKUBook qtyCounted qtyUnit costVariance
Organic tee1,2001,150$8.00−$400
Fleece hoodie640655$22.00+$330
Ceramic mug900820$6.00−$480
Canvas tote400400$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.

Want your year-end inventory to tie out?

We'll walk through your count plan, cutoff and COGS setup on a short call and show you what clean year-end books look like.