Reviewed & updated by WordNExcel Team — Updated October 31, 2026
An inventory count sheet template helps you record a physical stock count and compare it with what your records say you should have. On this page you can download three free inventory count sheet templates in Excel: a full inventory count sheet with variance value, a cycle count sheet with ABC class and accuracy, and a stock reconciliation sheet that checks opening stock, receipts and issues against the physical count.
Each file is a real, editable .xlsx spreadsheet created for this page. You type the item codes, descriptions and quantities in the yellow cells, and the formulas calculate the variance for each line, the total variance value, the number of lines with differences and your count accuracy. The sheets print in landscape on one page, so counters can also fill them in by hand on a clipboard.
Free download: 3 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is an Inventory Count Sheet?
An inventory count sheet, also called a stock count sheet or stocktake sheet, is a list of the items held in a store, warehouse or stockroom with space to record how many of each item were physically counted. It usually shows the item code, description, location, unit of measure, the quantity the system expects and the quantity counted.
Comparing the physical count with the system quantity shows the variance: the difference between what you should have and what you actually have. Variances can come from damage, theft, receiving errors, picking mistakes or simple data entry errors. Regular counts help you find and fix these problems, keep your records accurate and give you a true value for your stock.
Download the Free Inventory Count Sheet Templates
The three Excel files below cover a full stocktake, ongoing cycle counts and stock reconciliation.
Inventory Count Sheet
The main count sheet has columns for item code, description, location, unit, system quantity, counted quantity, variance, unit cost and variance value. Totals at the bottom show the total value of all variances and the number of lines with a difference. Use it for a full stocktake at the end of a month, quarter or year.
Cycle Count Sheet
Cycle counting means counting a small part of your stock on a regular schedule instead of everything at once. The cycle count sheet adds an ABC class, the count date and the counter’s name for each line, and calculates count accuracy: the share of lines counted with no variance.
Stock Reconciliation Sheet
The reconciliation sheet starts with the opening quantity, adds stock received and subtracts stock issued to calculate the expected closing quantity. You then enter the physical count, and the sheet shows the difference for each item. It is useful for small stockrooms, kitchens, workshops and storerooms that do not use an inventory system.
How to Prepare for a Stock Count
- Choose a date and time when stock movement can be stopped or kept to a minimum.
- Process all receipts, shipments and returns in your system before the count, so the system quantities are up to date.
- Tidy the storage areas and make sure every location is labelled.
- Print the count sheets, sorted by location, so counters can work through each area in order.
- Assign counters to areas, and if possible use teams of two: one to count and one to record.
- Agree how to handle damaged items, items without labels and stock in transit.
How to Carry Out the Count
- Count each location in order, shelf by shelf.
- Record the quantity counted in the unit shown, such as each, box or pack.
- Mark each location as counted so nothing is missed or counted twice.
- Do not look at the system quantity while counting, if you can avoid it. This is called a blind count and gives more honest results.
- Write down any items found that are not on the sheet.
- Recount any lines with large variances before accepting the result.
- Enter the counts into the spreadsheet and review the variance report.
Understanding Variances
A negative variance means you have fewer items than your records show. Common causes include damaged or expired stock that was thrown away without being recorded, goods issued without paperwork, theft or picking errors. A positive variance means you have more than your records show, often because a receipt was not entered or an order was not picked.
Look at both the quantity and the value of each variance. A difference of a few low-cost items may not matter much, while a small difference on an expensive item can be significant. Investigate large or repeated variances before adjusting your records, and keep a note of the reason for each adjustment.
Cycle Counting and ABC Classes
Cycle counting spreads the work of counting over the year. A common method is to sort items into ABC classes:
- A items are the small number of items that make up most of your stock value. Count them often, for example monthly.
- B items have a medium value. Count them less often, for example quarterly.
- C items are the many low-value items. Count them once or twice a year.
Regular cycle counts find problems sooner, reduce the need for a large shutdown stocktake and keep accuracy high all year round.
Tips for Accurate Stock Counts
- Use clear location labels so each item has one home.
- Count in standard units and note the unit on the sheet.
- Freeze stock movement during a full count wherever possible.
- Use two-person teams for valuable or fast-moving items.
- Recount large variances before making adjustments.
- Track accuracy over time to see whether your processes are improving.
- Fix the cause of repeated variances, not just the numbers.
After the Count
When the count is complete and variances have been checked, update your inventory records with the counted quantities. Record the total variance value, which affects the value of stock in your accounts. Share the results with the team, and agree actions for any problems found, such as better receiving checks, clearer labelling or more secure storage for high-value items.
Inventory Counts for Small Businesses
You do not need a warehouse system to keep good stock records. A small shop, café, salon or workshop can use the reconciliation sheet each week or month: enter the opening quantity, add deliveries, subtract what was used or sold and compare the result with a quick physical count. Over time, the differences show where stock is being lost or where records need improving.
Physical Counts and Your Accounts
Many businesses count all their stock at least once a year, usually at the end of the financial year, so the value of inventory in the accounts is based on a real count. Keep the signed count sheets with your year-end records, together with the variance report and any adjustments, in case your accountant or auditor needs to see them.
Choosing How Often to Count
How often you count depends on the value of your stock, how fast it moves and how accurate your records need to be. A business with expensive or fast-moving items may count part of its stock every week, while a business with a small range of slow-moving items may only need a full count each quarter. Start with a schedule you can keep to, measure accuracy with the cycle count sheet and count more often if accuracy is low.
Inventory Count Checklist
- Count sheets are printed and sorted by location.
- All receipts and shipments are entered in the system.
- Stock movement is stopped or controlled during the count.
- Counters know their areas and the units to use.
- Damaged and unlabelled items have a separate area.
- Large variances are recounted before adjustments.
- Signed sheets are filed with the variance report.
Related Templates
You can also check these important templates like the purchase order templates for ordering new stock, and the packing slip templates for checking what is shipped.
You may also like the bill of lading templates for recording goods in transit.
Frequently Asked Questions
What is an inventory count sheet?
It is a list of stock items with space to record the quantity physically counted, so you can compare it with the quantity in your records.
What is the difference between a full count and a cycle count?
A full count checks every item at once, often at year-end. A cycle count checks a small group of items on a regular schedule throughout the year.
How is variance calculated?
Variance equals the counted quantity minus the system quantity. The variance value multiplies that difference by the unit cost.
What is a blind count?
A blind count is when counters record quantities without seeing the expected system quantity, which gives more honest results.
Can I print the sheets to count by hand?
Yes. The sheets print in landscape on one page. Enter the counts into the spreadsheet afterwards to calculate variances.
Can I use the templates in Google Sheets?
Yes. Upload the .xlsx files to Google Drive and open them with Google Sheets. All formulas keep working.
