Inventory Count Sheet: Free Template and How to Do a Physical Count
Quick Answer
An inventory count sheet records the items, locations, units and quantities counted during a physical inventory, so you can compare what's actually on hand to what your records say. To do a physical count, plan the date, organize the space, assign count teams, count by location with sheets or tags, recount differences and adjust your records. The IRS says businesses that keep inventories must take a physical inventory at reasonable intervals and adjust the book amount to agree with the actual inventory. For hourly employees, count time is work time.
Your inventory records say you have 48 cases on the shelf. You walk back to check and find 41. Where did the other seven go? Miscounts, damage, theft and receiving errors all add up, and the only way to know what you really have is to count it.
This guide includes a free inventory count sheet, explains how to plan and run a physical count, the difference between full counts and cycle counts, how to reconcile differences, what the IRS says about physical inventory and how to handle pay for count time.
Note: This is general information, not tax or accounting advice. How you value and report inventory depends on your business and accounting method. Talk with your accountant.
What Is an Inventory Count Sheet?
An inventory count sheet is a form used to record how many of each item are physically on hand, usually organized by location. It's the working document for a physical count, and the results are compared to your inventory records.
Free Inventory Count Sheet Template
| Location | Item # / SKU | Description | Unit | Count | Recount | Counted by | Checked by |
|---|---|---|---|---|---|---|---|
| Aisle 1, Shelf A | Each | ||||||
| Aisle 1, Shelf B | Case | ||||||
| Back room, Bin 3 | Each | ||||||
Count sheet header
Date: ______ | Location/area: __________ | Sheet # ____ of ____
Count team: __________ | Start time: ______ | End time: ______
Supervisor sign-off: __________
Number every sheet before the count starts so you can confirm all sheets come back.
Full Physical Count vs. Cycle Counting
| Full physical count | Cycle counting | |
|---|---|---|
| What | Count everything at once | Count a portion on a rotating schedule |
| How often | Usually once or twice a year | Daily, weekly or monthly |
| Disruption | Often requires closing or a slow period | Minimal |
| Best for | Year-end, smaller inventories | Larger inventories, ongoing accuracy |
Many businesses do both: a full count at year-end and cycle counts during the year on high-value or fast-moving items.
ABC Cycle Counting
| Class | Items | How often to count |
|---|---|---|
| A | High-value or fast-moving | Monthly or more |
| B | Medium value or movement | Quarterly |
| C | Low value or slow-moving | Once or twice a year |
What the IRS Says About Physical Inventory
According to IRS Publication 538, an inventory is necessary to clearly show income when the production, purchase or sale of merchandise is an income-producing factor. The IRS says businesses that keep inventories must take a physical inventory at reasonable intervals, and the book amount for inventory must be adjusted to agree with the actual inventory.
IRS Publication 538 also explains that qualifying small business taxpayers, generally those with average annual gross receipts at or below an inflation-adjusted threshold, can choose not to keep an inventory but must still use a method that clearly reflects income. Ask your accountant which rules apply to your business.
How to Plan a Physical Count
- Pick a date and time, ideally when the business is closed or slow.
- Set a cutoff: stop receiving and shipping, or clearly separate items received or shipped during the count.
- Organize the space: put items away, group like items and label locations.
- Prepare count sheets or tags by location, numbered in order.
- Assign count teams of two: one counts, one records.
- Gather supplies: clipboards, pens, scanners, tape, calculators.
- Brief the team on units of measure, how to count cases and partials, and what to do with damaged items.
Running the Count
- Count one location at a time, left to right, top to bottom.
- Mark each counted area with tape or a tag so nothing is counted twice or missed.
- Use the right unit of measure: each, case, box, pound.
- Count damaged items separately.
- Write clearly and don't erase; cross out and initial corrections.
- Return sheets to the supervisor as each area is finished.
Blind Counts
In a blind count, counters don't see the expected quantity, so they count what's actually there instead of confirming a number. Blind counts are more accurate, especially for cycle counts.
Reconciling Differences
- Compare counts to records for each item.
- Recount items with significant differences, using a different team.
- Look for causes: receiving errors, unit-of-measure mix-ups, misplaced stock, unrecorded damage or returns, theft.
- Adjust records to match the verified count.
- Document adjustments and the reasons.
- Fix the process that caused repeated differences.
Example: Records show 120 units of SKU 4471. The count finds 108. A recount confirms 108. Investigation finds a delivery of 12 units was recorded as received but was actually back-ordered. The receiving record is corrected, and the receiving process is changed so items are counted before being entered.
Inventory Shrinkage
Shrinkage is the difference between recorded inventory and actual inventory. Common causes:
| Cause | Prevention |
|---|---|
| Receiving errors | Count deliveries against packing slips before entering them |
| Damage and spoilage | Record write-offs when they happen |
| Theft | Limit access, use cameras and reconcile often |
| Data entry mistakes | Use scanners and consistent units |
| Unrecorded returns or samples | Record every movement |
Shrinkage rate = (recorded inventory - actual inventory) / recorded inventory. Track it over time; rising shrinkage is a signal to look closer. See warehouse KPIs.
Pay for Inventory Count Time
For hourly, non-exempt employees, inventory counts are work time, including counts held after closing or on a weekend. The Department of Labor says work not requested but suffered or permitted to be performed is work time that must be paid for. Long counts can push employees into overtime, so plan staffing and track hours. See overtime approval policy.
Tips for Faster, More Accurate Counts
- Clean and organize the week before.
- Pre-count sealed cases and mark them.
- Use barcode scanners if you have them.
- Count high-value items with two people.
- Freeze transactions during the count, or clearly separate them.
- Do a quick test count with the team before starting.
Example: A Small Hardware Store
A hardware store used to close for a full day every January to count everything. The owner switched to ABC cycle counting: power tools and high-value items monthly, common hardware quarterly and slow-moving items twice a year, with a smaller year-end count. Two employees spend about an hour a week on cycle counts, records stay accurate year-round and the store no longer closes for a day.
Common Inventory Count Mistakes
- Counting during receiving without a cutoff.
- Mixing units like cases and eaches.
- Missing or double-counted areas.
- No recount of large differences.
- Adjusting records without investigating causes.
- Counting off the clock.
- Unnumbered count sheets that go missing.
Inventory Count Checklist
| Step | Done? |
|---|---|
| Choose full count or cycle count schedule | |
| Set the date and cutoff | |
| Organize and label locations | |
| Prepare numbered count sheets | |
| Assign teams of two | |
| Count, mark areas and turn in sheets | |
| Recount and investigate differences | |
| Adjust and document records | |
| Track and pay count time |
Count Teams and Roles
| Role | Responsibilities |
|---|---|
| Count supervisor | Plans the count, issues and collects sheets, resolves questions |
| Counter | Physically counts items |
| Recorder | Writes counts on the sheet and double-checks |
| Auditor | Spot-checks counted areas and recounts differences |
Pairing a counter with a recorder catches mistakes, and swapping pairs for recounts keeps results honest.
Count Tags vs. Count Sheets
| Method | How it works | Best for |
|---|---|---|
| Count sheets | Pre-printed lists by location; counters fill in quantities | Smaller stores and stable inventory |
| Count tags | Numbered tags placed on each item or bin as it's counted | Warehouses and large inventories |
| Scanners | Scan barcodes and enter quantities | Businesses with barcoded inventory |
With tags, every tag number is accounted for at the end, so you know nothing was missed or lost.
Units of Measure
Unit confusion is one of the most common count errors. Decide before the count how each item is counted: each, pack, case or weight, and write it on the sheet. If an item is stored in cases of 12 but sold individually, decide whether to count cases plus loose units and convert, and be consistent.
Example: Shelf holds 3 full cases of 24 plus 7 loose bottles. Count as 3 cases and 7 each, then convert: (3 x 24) + 7 = 79 bottles.
Year-End Count Timeline
| When | Task |
|---|---|
| 4 weeks before | Choose the date; confirm with your accountant; schedule staff |
| 2 weeks before | Clean and organize; label locations; print sheets or tags |
| 1 week before | Train count teams; finish processing receipts and shipments |
| Day before | Set cutoff; freeze movements; prepare supplies |
| Count day | Count, recount and collect all sheets |
| Within a week after | Reconcile, adjust records and review what to improve |
Getting Started This Week
If you've never done a formal count, pick one area, such as the back room or your top 20 items, and count it this week using the template. Compare the results to your records and investigate any differences. That small test shows you how accurate your records are and how long a full count will take.
Counting Partial Units and Bulk Items
- Liquids: estimate partial containers to the nearest quarter or tenth, and be consistent.
- Bulk items: weigh items like fasteners or flour and convert using a known unit weight.
- Rolls and lengths: measure remaining length or estimate by roll diameter using a chart.
- Open packs: count loose units rather than estimating.
Damaged, Expired and Obsolete Stock
Count damaged, expired and obsolete items separately rather than mixing them with sellable stock. Tag them, record them on a separate sheet and decide whether to write them off, return them to suppliers or discount them. Ask your accountant how write-offs should be recorded.
Restaurant Inventory Counts
Restaurants often count food and beverage weekly to track food cost. Count in the same order every time, such as walk-in, freezer, dry storage and bar, and use the unit you buy in. Weekly counts help catch waste, over-portioning and theft early.
| Area | Count frequency | Tips |
|---|---|---|
| Walk-in cooler | Weekly | Count by shelf, oldest first |
| Freezer | Weekly | Note dates on containers |
| Dry storage | Weekly or biweekly | Count cases and loose units separately |
| Bar | Weekly, high-value bottles more often | Measure partial bottles consistently |
Using Count Results
- Set reorder points so you don't run out of key items.
- Spot slow-moving items to discount or stop buying.
- Calculate shrinkage and set a target to reduce it.
- Improve receiving and storage processes where errors cluster.
A count is only worth the effort if you act on what it shows.
Questions to Ask After Every Count
- How long did the count take, and how can we speed it up next time?
- Which areas had the most differences?
- Were differences caused by receiving, storage, data entry or loss?
- What will we change before the next count?
- Did we have enough people, and were hours tracked correctly?
A short debrief right after the count captures lessons while they're fresh.
Inventory Count Policy Basics
Inventory Count Policy
• A full physical count is taken [annually on date], with cycle counts [weekly/monthly] for high-value items.
• Receiving and shipping stop during full counts, or items are clearly separated.
• Counts are done in pairs using numbered sheets or tags.
• Differences above [amount or percent] are recounted by a different team.
• Record adjustments are approved by [role] and documented with the reason.
• All count time is recorded and paid.
Inventory Count Quick Reference
| Step | Tip |
|---|---|
| Plan | Pick a slow time and set a cutoff |
| Prepare | Organize, label and number sheets |
| Count | Work in pairs, one location at a time |
| Verify | Recount large differences with a new team |
| Reconcile | Find causes, adjust and document |
| Improve | Fix the processes that caused errors |
Accurate inventory protects your cash, your margins and your customers' trust that what they want is in stock.
Start small, stay consistent and your counts will get faster and more accurate every time.
Inventory Counts and Insurance
Accurate inventory records also help if you ever need to file an insurance claim for fire, flood or theft. Keep recent count sheets, purchase records and photos of stock somewhere safe, such as a cloud folder, so you can document what you had. Review your coverage limits with your insurance agent after your year-end count, especially if inventory has grown.
Getting Your Team on Board
Counts go faster when everyone understands why they matter. Explain that accurate counts mean fewer stockouts, less waste and better ordering, and thank the team when the count is done. Small rewards, like lunch on count day, make a long count feel less like a chore.
Keep completed count sheets with your year-end records so your accountant can review them.
Share the results with your team after each count, including what improved since last time. Seeing shrinkage drop or accuracy rise shows everyone that careful receiving, storage and counting make a real difference to the business.
Keep a few blank count sheets on hand for spot checks between scheduled counts.
Plan Counts and Track Hours With Updoot
Updoot's scheduling makes it easy to staff inventory counts, the employee time clock records every hour of count time and the payroll report shows any overtime. SOP management keeps your count procedures consistent from year to year.
Sources
- IRS: Publication 538, Accounting Periods and Methods
- U.S. DOL: Fact Sheet #22, Hours Worked Under the FLSA
Related Reading