Stock Count Report Example (Excel Template)

A stock count report is a document, signed by the counting team, that records in writing the date and hours of the physical count, where it was carried out, its scope, the people who did the counting and the result. Its purpose is to put on record, in a way that cannot be disputed later, that "on that day, in that warehouse, these people counted and this was the result". The item-by-item count results are kept as an attachment to the report.

No. The count sheet is the working table that compares the system quantity with the counted quantity item by item; it is filled in during the count and the difference appears there. The report is the document that summarizes the result on a single page after the count is finished and is opened for signature. If you only need the difference table, the warehouse count (inventory) Excel template is enough; if you want to close the count with a signed document, this file gives you both in one.

Five sections are enough: (1) report no., date, count type and hours; (2) business, warehouse and scope of the count; (3) counting team — full name, role, signature; (4) result summary — items counted, items short and over, net difference amount; (5) remarks field and signature blocks. All five are ready in this template; you only fill in the details and the item list.

Whether an inventory must be taken at year-end, and in which books and documents it must be shown, depends on tax legislation and the business's bookkeeping type, so we do not state a firm rule here. Consult your accountant for legal book and document requirements. This template is a sample document for recording the count in an orderly way; it is not an official form, and if your accountant wants a different layout you can change the texts and fields.

The common practice is for the team that actually carried out the count, the warehouse manager and the business authority to sign. In a handover count, the person handing over and the person taking over always sign; the Role list in the template has these two roles separately. If one of the signatories has an objection, writing the objection in the remarks field and having them sign that way, rather than leaving the report unsigned, documents what was disputed later on.

The file is in Excel (.xlsx) format because the result figures are calculated by formula from the item list; this calculation cannot be done in Word. You can open it in Excel, Google Sheets or LibreOffice and print it directly, or save it as a PDF. If you must keep the document in Word, fill in the report tab, then copy it and paste it into Word; the figures are fixed at their current values.

First, have someone other than the first counter recount the item with the difference; the difference remaining after the second count goes into the report. The template lists short and over items and their amounts separately; the reason for the difference is chosen from the Difference Explanation column in the item list, and situations that need attention are written in the remarks field. Preparation for count day and the blind count method are explained step by step in the guide how to do a warehouse count.

Yes, it's free. The file doesn't ask for an email, sign-up or payment; it contains no watermark or cell protection. You can change the business name, the role list and the report text to suit you.