A physical inventory means counting what is actually on the shelves and comparing it with the quantities in your books or inventory system. Collect handwritten count sheets in one sheet with book quantity, counted quantity and variance columns, and you can pick out only the items with a difference and check the reason.
Who does the physical count, and why keep the results as data?
A physical inventory (stock count) means counting the goods actually in the warehouse or store, writing them on count sheets, and comparing them with the book quantities. A full count of every item is typically done once or twice a year, and many companies do it near their fiscal year end. Warehouse staff usually count by zone, and accounting or operations staff gather the results and reconcile them with the books.
The most time-consuming part is often not the counting but the retyping. Re-entering handwritten count sheets into Excel or an inventory system in the office makes transcription errors easy. If the count sheets are kept in a sheet with the same columns, you can filter for the items with a variance and compare this year's results at the next count.
Which columns should an inventory count sheet have?
These nine columns hold one line of a count sheet as one row.
| Column | What to record |
|---|---|
| Count date | The day the items were counted. Use one format, such as 2026-12-28 |
| Warehouse and location | Warehouse name and zone or rack (e.g., Warehouse 2, B-03) |
| Item code | The key for matching to the books. If there is no code, record the item name and spec together |
| Item name | Including spec and unit (e.g., Bolt M8×30, each) |
| Book quantity | The quantity in your books or inventory system at the time of the count |
| Counted quantity | The quantity actually counted |
| Variance | Counted minus book. Negative (-) if short, positive (+) if over |
| Reason | The cause you confirmed: unrecorded shipment, damage, unit mix-up, etc. |
| Checked by | The person who counted and the person who checked |
If you print the book quantities on the count sheet in advance, one photo captures both book and counted quantities. Some companies count first and fill in book quantities later, so counters are not influenced by the expected number (a blind count).
How do handwritten count sheets end up in a sheet?
An inventory count sheet is not one of the default document types (quotes, customer orders, delivery notes, invoices), so it goes into a custom sheet. You confirm the sheet once, and later count sheets go in without asking.
- Photograph and upload each zone's sheetPhotograph each zone's count sheet and drag it onto the screen or paste it (Ctrl+V). On a phone you can take the photo and upload it directly, and PDF or Excel count sheets work too. For iPhone photos (HEIC), switch to Settings → Camera → Formats → Most Compatible to shoot in JPG.
- AI suggests a sheet name and columnsIf no sheet matches the first count sheet, AI reads it and suggests a sheet name and columns (3 to 15), with a preview of how the item lines will become rows.
- Review and approveYou can rename the sheet on this screen. If the columns and preview look right, approve to add the sheet and save the rows.
- Remaining zones are saved automaticallyCount sheets of the same kind go into that sheet without asking. Even if you upload the same file again by mistake, it is not registered twice.
- Filter for variancesIn Excel or Google Sheets, filter for rows where the variance is not zero, recount them and record the reason. Adjusting quantities in your inventory system is done by the person responsible after the check.
Create the sheet from one count sheet first, then upload the remaining zones.
What to watch for when preparing and organizing a count
- Split into zones and pre-fill locations. Dividing count sheets by warehouse and rack often reduces missed or double-counted items.
- Count in pairs. A common approach is for one person to count while the other records and checks. Write the checker's name on the sheet.
- Handle movements during the count. Goods received or shipped during the count create variances, so many companies pause receiving and shipping or record those movements separately.
- Write numbers and units clearly. Mixing each and cases makes variances look large. Handwriting and blurry photos are marked Needs review, so compare them with the original.
- Keep the original count sheets. Do not throw away signed paper count sheets; use the sheet for finding, totaling and checking.
You can see how a custom sheet is created with the sample files in the demo, no sign-up needed. The samples are two daily work reports: the first suggests a new sheet and the second goes straight into it. Inventory count sheets create a sheet the same way (see the daily work report guide). Keeping a log of the delivery notes you receive with incoming goods helps explain book quantities, so the delivery note Excel template is worth a look as well.
Frequently asked questions
Is an inventory count sheet the same as a stock take sheet?
Companies call it a count sheet, stock take sheet or physical inventory list, but they all record actual quantities by location and item for comparison with the books. What matters is that the columns above are all there, not the name.
What if book and counted quantities differ?
Recount the items with a variance, find the cause (unrecorded shipment, damage, unit mix-up and so on) and record it in the reason column. How to adjust the books depends on your accounting policies, so check with your accountant.
Are quantities in our inventory system (ERP) updated automatically?
No. AiutoForm records count sheet content in Excel or Google Sheets and does not connect to inventory systems. The person responsible enters the confirmed quantities in the system.
Once it is in a sheet, can we throw away the paper count sheets?
No. Count sheets used for year-end figures support your accounts, and tax authorities expect such records to be kept for a set period. Keep the originals as they are, use the sheet for finding, totaling and checking, and confirm retention periods with your accountant.
Will it work with your inbox?
Tell us which email service and document formats you use, and we will show you how it fits.