Skip to content
Blogs

Year-end inventory count for small businesses

· October 27, 2026

How do you do a year-end inventory count?

Count on or as close to December 31 as possible, with sales and receiving paused. Use 1 count sheet per area, have 2 people count every item, value it at cost, and hold back goods already sold or not yet owned. The difference between the count and the books becomes 1 adjusting entry to inventory and cost of goods sold.

A physical inventory count at year end is the one number in a retail or product business’s books that nobody can get from a bank statement. Every other balance on December 31 can be proven from a statement or a contract. Inventory can only be proven by walking the shelves, and the figure you write down sets cost of goods sold, gross profit and taxable income for the whole year.

Warehouse software vendors publish good guides to counting. Where they stop is what happens after the count: the cutoff decisions that make the number right and the entry that puts it in the books. This post covers both, for a small business on a calendar year, with the QuickBooks Online steps for a file that tracks quantities and for one that does not. Tax rules are cited to the IRS. Ledgerbrook keeps books and does not prepare or file returns.

Download the inventory count sheet

Excel count sheet with two count columns, a difference column, final count, unit cost and extended value, totaled. Sample rows match the example below.

Download Excel (.xlsx)

What is a physical inventory count?

A physical inventory count is a hand count of every item the business owns and holds for sale, on a set date, valued at cost. It is compared with what the books say is on hand, and the books are changed to agree with the count. IRS Publication 538 puts the rule for a business that keeps perpetual records this way: “You must take a physical inventory at reasonable intervals and the book amount for inventory must be adjusted to agree with the actual inventory” (Pub. 538, rev. January 2022, from Treas. Reg. §1.471-2(d)).

The count does two jobs. It finds shrinkage (theft, breakage, spoilage, miscounted receipts), and it fixes the closing inventory figure that cost of goods sold is built from:

Cost of Goods Sold = Beginning Inventory + Purchases − Ending Inventory

Ending inventory is subtracted, so every dollar it is overstated is a dollar of cost of goods sold missing from the profit and loss, and a dollar of profit that was never earned.

Is a physical inventory count required for all businesses?

No single federal rule says every business must count every December 31. What the tax rules require depends on the method:

  • A business that keeps an inventory values it at the beginning and end of each tax year to figure cost of goods sold, and one that keeps perpetual records must check them with a physical count “at reasonable intervals” (Pub. 538).
  • A small business taxpayer may choose not to keep an inventory under IRC §471(c), but must still use a method that clearly reflects income. For 2026, that means average annual gross receipts of $32 million or less for the 3 prior tax years, and not a tax shelter (2026 Instructions for Schedule C, draft dated October 8, 2026). Even then, goods treated as non-incidental materials and supplies are deducted when they are sold, not when they are bought, so the business still needs to know what is left on the shelf.

Lenders, investors and audited financial statements often require an annual count whatever the tax method. Schedule C itself asks for inventory at the beginning and end of the year on lines 35 and 41.

How often should physical inventory be taken?

At least once a year, at the year end, for any business that carries meaningful stock. Many add quarterly or monthly cycle counts: a rotating sample of items counted each week or month, so the year-end count finds fewer surprises. A cycle count program does not replace the year-end figure unless the records it produces are good enough to support the closing balance on its own, which is a decision for the business and its CPA.

When to count: December 31, or as close as you can

Count at the close of business on the last day of the tax year, with sales and receiving stopped while the count runs. For a calendar-year business that is December 31, 2026. A store that cannot close on the 31st has two workable options:

  1. Count after closing on December 31 or before opening on January 1. Nothing moves between the count and the year end, so no roll-forward is needed.
  2. Count a few days before or after, then roll the count to December 31. Start from the counted quantities and adjust for what moved in between. For a December 28 count, subtract units sold from December 29 to 31 and add units received in that window. A count on January 3 works the other way: add back January sales and subtract January receipts. Keep the roll-forward with the count sheets.

The shorter the gap, the fewer movements to reconcile. A count a week or more away from year end is hard to defend if the closing figure is questioned.

How to do a physical inventory count, step by step

Guides group the work into four steps, usually plan, count, price and reconcile. Here is the same work as eight steps, in the order it happens.

  1. Map the areas. List every place stock sits: sales floor sections, back room, warehouse bays, vehicles, a storage unit, goods at a third-party warehouse or out on consignment. One count sheet per area, numbered, so a missing sheet is noticed.
  2. Clean up the paperwork first. Enter every vendor bill and receipt dated on or before the count date, process returns, and finish fulfilling paid orders. Anything left open is a cutoff item (next section).
  3. Tag what is not yours, and what is already sold. Put goods held for customers, goods consigned to you, and items awaiting return to the vendor in a marked area so they are not counted.
  4. Freeze movement. No sales, no receiving, no transfers between areas during the count.
  5. Count twice, with different people. The first counter fills count 1. A second person counts the same area blind and fills count 2. Sheets show item and location but not the quantity the books expect, so nobody counts to the number.
  6. Recount every difference. Where count 1 and count 2 disagree, a third count settles it, and the agreed number goes in the final count column.
  7. Price the final counts at cost. Unit cost times final count gives the extended value. Pricing happens after counting, from purchase records, not on the floor.
  8. Total, check and sign. Add each sheet, add the sheets, and have someone other than the pricer check the math. IRS Publication 334 describes inventory forms with space to record “who made the physical count, who priced the items, who made the extensions, and who proofread the calculations” (Pub. 334, for 2025 returns). Keep the signed sheets: they are the support for the closing inventory figure.

Who should count inventory?

Not the person who keeps the stock records or receives the goods. That is a control, not a tax rule: someone who can change the records and also count the stock can make a shortage disappear, by accident or otherwise. In a small store with two or three people, have the owner and an employee count in pairs and swap areas for the second count. If an outside bookkeeper or CPA observes the count, they watch and test-count; they do not count for you.

What is the 80/20 rule for inventory?

It is a rule of thumb, often called ABC analysis: in many businesses a small share of items, roughly a fifth, holds most of the value, roughly four-fifths. For a count, it means spending the most care on those items. Count the high-value lines first, while counters are fresh, and recount them even when the two counts agree. The low-value lines still get counted at year end; the rule decides where to look hardest, not what to skip.

The inventory count sheet

Each line on the sheet is one item in one location. The columns below match the free download above, and the sample lines are the totals used in the entries later in this post.

Location Item Description Count 1 Count 2 Final count Unit cost Extended value
Front floor A TS-100 Crew tee, black, M 120 120 120 8.50 1,020.00
Front floor A TS-101 Crew tee, black, L 96 98 98 8.50 833.00
Front floor B HD-200 Hoodie, gray, M 64 64 64 22.00 1,408.00
Back room HD-201 Hoodie, gray, L 150 150 150 22.00 3,300.00
Back room JK-300 Rain jacket, navy, M 85 84 84 41.00 3,444.00
Back room CP-400 Canvas cap 285 285 285 7.00 1,995.00
Total 12,000.00

TS-101 and JK-300 were recounted because the two counts disagreed; the final column holds the recount. The header of each sheet records the count date, the area, both counters, who priced it and who checked it.

Cutoff: what belongs in the count

Cutoff decides which goods count as yours on December 31. The test is ownership, not location. Pub. 538 says to include purchased merchandise “if title has passed to you, even if the merchandise is in transit,” and goods out on consignment, and to leave out goods sold where title has passed to the buyer, goods consigned to you, and goods ordered for future delivery that you do not yet own.

Situation on December 31 In the count? What the books need
Received, vendor bill not yet entered Yes Enter the bill dated on or before Dec 31 (or accrue it), so the cost and the payable are both in 2026
Shipped to a customer, not yet invoiced No Invoice dated Dec 31, so the sale and its cost land in the same year
Sold and paid for, customer collecting in January No, if title has passed Tag it and keep it out of the count
Bought, still in transit, terms say title passed at shipment Yes Bill entered in 2026; add the units to the count from the packing list
Your goods at a consignment store or third-party warehouse Yes Get a written count from them as of Dec 31
Customer goods or consigned goods on your shelf No Tag and exclude
Damaged or unsaleable stock Yes, at a lower value Value at bona fide selling price less direct cost of disposition (Treas. Reg. §1.471-2(c))

The two common errors are mirror images. Counting stock that arrived on December 30 while its bill sits in January puts the goods in ending inventory without the cost in purchases, which overstates profit. Excluding a shipped order that was not invoiced until January takes the goods out of inventory without the sale, which understates it.

Valuing the count

The count gives quantities. The value comes from the costing method the business already uses, applied the same way as last year. Schedule C asks for it on line 33: cost, lower of cost or market, or another method, with an explanation (Schedule C, 2026 draft). Corporations and partnerships report cost of goods sold on Form 1125-A instead.

  • Cost for goods bought during the year is “the invoice price minus appropriate discounts plus transportation or other charges incurred in acquiring the goods” (Pub. 538). Trade and quantity discounts reduce cost.
  • Lower of cost or market compares each item’s cost with its market value on the inventory date and uses the lower one, item by item. Pub. 538 is explicit that you cannot total the inventory at cost and at market and pick the lower total.
  • Goods that cannot be sold at normal prices because of damage, wear or style changes are valued at their bona fide selling price less the direct cost of selling them, under any method.

A change in method, for example from cost to lower of cost or market, is a change in accounting method that generally needs Form 3115. That conversation belongs with the CPA before the count, not after.

The adjusting entry: making the books agree with the count

How the count reaches the books depends on whether the QuickBooks Online file tracks item quantities. In QuickBooks Online, quantity tracking is available on Plus and Advanced (Intuit: adjust inventory quantity on hand). Simple Start and Essentials files keep a single inventory balance and adjust it by journal entry.

Perpetual file (QuickBooks Online Plus or Advanced)

Before counting, print the Physical Inventory Worksheet: go to Reports, then Standard reports, and search for it (Intuit: fix negative inventory). It lists every inventory item with room for the count. Use it to build the count sheets, but leave off the quantity-on-hand column so the counts stay blind.

In the example, the books showed $12,451.00 of stock and the shelves held $12,000.00. Four items were short:

Item Books Count Short Unit cost Value
TS-101 100 98 2 8.50 17.00
HD-200 70 64 6 22.00 132.00
JK-300 90 84 6 41.00 246.00
CP-400 293 285 8 7.00 56.00
Total 451.00

Record the difference with an inventory quantity adjustment, not a journal entry:

  1. Select + Create, then Inventory qty adjustment.
  2. Set the Adjustment date to December 31, 2026.
  3. Choose the Inventory adjustment account. The default is Inventory Shrinkage, a Cost of Goods Sold account.
  4. For each item, enter the new quantity from the final count (or the change in quantity).
  5. Add a memo naming the count, for example “Year-end physical count, sheets 1 to 6,” and save.

QuickBooks posts the adjustment to Inventory Asset and Inventory Shrinkage and updates each item’s quantity at the same time, so the balance sheet and the item records still agree. The entry it writes looks like this:

Date Account Account type Debit Credit
Dec 31 Inventory Shrinkage Cost of Goods Sold 451.00
Dec 31 Inventory Asset Other Current Assets 451.00

QuickBooks Online values removed units at its own FIFO cost layers, so the posted amount can differ slightly from the count sheet when an item was bought at more than one price during the year. After saving, run the Inventory Valuation Summary as of December 31: it should total the count. A manual journal entry to Inventory Asset would move the balance but not the item quantities, and the two reports would disagree from then on. The inventory journal entry post explains why. Stock the count finds damaged or selling below cost needs its own entry, covered in journal entry for an inventory write-off.

Periodic file (QuickBooks Online Simple Start or Essentials)

In a file without quantity tracking, purchases are posted straight to a cost of goods sold account during the year, and Inventory Asset still holds last year’s count. In the example, the balance was $10,000.00 from the December 31, 2025 count, and $40,000.00 of purchases went to Cost of Goods Sold during 2026. The 2026 count is $12,000.00, so Inventory Asset needs to rise by $2,000.00:

Date Account Account type Debit Credit
Dec 31 Inventory Asset Other Current Assets 2,000.00
Dec 31 Cost of Goods Sold Cost of Goods Sold 2,000.00

Cost of goods sold for 2026 is now $38,000.00 ($10,000.00 + $40,000.00 − $12,000.00), and the balance sheet shows the $12,000.00 on the shelves. If the count had come in below $10,000.00, the entry would run the other way, crediting Inventory Asset and debiting Cost of Goods Sold. Attach the count sheets to the journal entry, and date it December 31.

Common questions about inventory counts

What should be considered in a physical count of inventory?

Ownership on the count date (cutoff), condition (damaged goods are valued lower), location (stock away from the main site, including consignment and third-party warehouses), and unit of measure (cases versus units). Most count errors come from cutoff and units of measure, not miscounting.

What is the most effective way to count inventory?

Two blind counts by different people, a recount wherever they differ, and pricing done afterward from purchase records. Barcode scanners speed up the counting but do not fix cutoff or valuation; those still need the steps above.

What is the primary purpose of a physical count of inventory?

To establish the ending inventory figure that cost of goods sold is calculated from, and to correct the records for shrinkage. A count also tests whether receiving, sales and returns are being recorded properly: a large, unexplained variance usually points to a process problem, not only to theft.

When the count and the books are far apart

A $451.00 shrinkage adjustment is a normal year. A $25,000.00 gap between the books and the count is not, and booking it as one adjustment hides the cause. Large gaps usually come from inventory purchases coded to expenses in the bank feed, sales recorded without items, negative quantities, or an opening balance that was never set up. Fixing them means rebuilding the inventory records for the months involved before the count is posted.

$99per month of backlog20% off 6+ months

When to hand this off: if the count differs from the books by more than the shrinkage the business normally sees, or Inventory Asset has not been tied to a count for more than one year, the error sits in months already closed. A free file review finds where the difference started before you post anything.

The count is step 5 of the year-end bookkeeping checklist, and retailers carrying stock year-round will find the monthly side of it on the retail bookkeeping page. A business that wants the count reconciled to the books every month, not only in December, can see how monthly bookkeeping works.

Published October 27, 2026

Share this post