Official Excel templates are generated from a revision card. “Inventory” with similar names produces a simple table and does not replace this path.
Select the source and form
- Open “Accounting → Revisions” and the required card. Check the office, saved contents and results. Viewing and separate export permissions are required.
- At the top of the card, select INV-3, INV-8 or “Collation statement (INV-19)” and click “Download”. Both open and closed revisions can be downloaded; a file does not prove the inspection is complete.
- Check the entire saved list of relevant categories. The top export ignores main-table filters, sorting, selected rows, views and “On screen”/“In Excel” lists.
| Form | Contents |
|---|---|
| INV-3 | Electronics and other goods, quantities and monetary values. |
| INV-8 | Jewelry, fineness, quantities and total weight. |
| INV-19 | Quantity shortages and surpluses in the main table according to saved results. |
Check quantities and discrepancies
In INV-3 and INV-8, the accounting quantity is one unit per row. Actual quantity is empty for “Unchecked”, zero for the “Missing” group, two for “Surplus” and one for the other “In stock” results.
Damage, overpriced goods, matching items and unchecked rows are not included as quantity discrepancies in the reconciliation statement. Separate “Surpluses” records are excluded too; they differ from a “Surplus” result on a main row.
Do not treat missing weight as zero. A missing cost price may produce a zero monetary value in the form; check source details before using the document.
Check the workbook and signatures
- In INV-3 and INV-8, check the three sheets: “Стр 1” is the cover, “Стр 2” contains all goods with page totals, and “Стр 3” contains overall totals and signatures. A long goods sheet can span several printed pages. A separate INV-19 uses its own three-sheet workbook.
- Open print preview for “Стр 2” in INV-3. Check that the paper size is A4, the orientation is landscape, and the scale is 100%. Each printed page holds up to 20 items. On every page, check the table header, continuous item numbering, totals for actual and recorded quantities and amounts, and totals written in words. Each total covers only the items on that page. To print the entire inventory, select all sheets in the workbook.
- Check document numbers, organization, office, dates, commission and responsible employees. INV-3 currently prints up to three commission members and two responsible employees. For larger lists, the file does not establish that every signature is included.
- Check calendar dates: INV-8 uses the office time zone; INV-3 and INV-19 do not yet convert dates to it. Saved timestamps do not replace checking the document's date.
Product details come from the revision's saved list; organization and office details, participant names and positions come from current records. Regenerating may differ after those records change. Downloading does not sign documents.
These files are saved separately from the ordinary table export, whose history button does not show them. After an error, keep the revision number, form type and message. Do not close a revision just to download it.