Are these official stocktake forms?

No, they are working forms modeled on the usual ones. If you need an approved form, transfer the totals into it.

How are surpluses and shortages calculated?

If the actual count is greater than the recorded one, it is a surplus; if less, a shortage; amounts use the item price.

Can I check in stages?

Yes, unchecked items without an actual count are excluded from the discrepancies, and «Totals» shows how many remain.

How many items are supported?

Up to 500 in the inventory list and up to 100 discrepancies in the statement.

← All templates

Stocktake (Inventory Count) — Excel Template

An inventory list, reconciliation statement and report with totals: surpluses, shortages and committee signatures.

390 ₽

≈ 4 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

A stocktake is tiring because of the paperwork, not the counting. Enter the recorded and actual quantity for each item — the spreadsheet finds surpluses and shortages in units and in value and builds a reconciliation statement with totals.

What is inside

«Details»: organization, order, dates, committee, custodian.
«Inventory list»: up to 500 items with recorded and actual quantity.
«Reconciliation»: only items with discrepancies, up to 100 rows, ready to print.
«Totals»: totals per records and actual, surpluses and shortages, share of discrepancies, signatures.

Who it is for

Office and facilities managers, storekeepers, accountants and committee chairs in organizations, public bodies, shops and warehouses.

What you get

The package includes a blank spreadsheet and a filled-in sample with fictional data, so you can see how the formulas and checks work. It is a spreadsheet built on ordinary formulas, not an accounting program. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. Rates, thresholds and reference values are kept in settings: check them against the rules that apply to you before use. Calculations are approximate. The file is in English.

Questions and answers

Are these official stocktake forms?: No, they are working forms modeled on the usual ones. If you need an approved form, transfer the totals into it.
How are surpluses and shortages calculated?: If the actual count is greater than the recorded one, it is a surplus; if less, a shortage; amounts use the item price.
Can I check in stages?: Yes, unchecked items without an actual count are excluded from the discrepancies, and «Totals» shows how many remain.
How many items are supported?: Up to 500 in the inventory list and up to 100 discrepancies in the statement.