Syntha Lab RU

Stock balance by category

Stock movement at cost for a month: opening, receipts, supplier returns, cost of sales, write-offs, closing.

Layouts for documents 8 columns 4 example rows

Download CSV ↓

What the template is for

Reconciling the warehouse with the books and calculating turnover.

What one row is
one row = category × month

Columns

ColumnCodeTypeRequiredValidation rule
MonthmonthTextyesmonth as YYYY-MM
CategorycategoryList valueyesa value from the category reference
Opening stock, thousand, at costbeginNumberyesa number not below 0
Receipts, thousandreceiptsNumberyesa number not below 0
Supplier returns, thousandsupretNumberyesa number not below 0
Cost of sales, thousandcogsNumberyesa number not below 0
Write-offs and losses, thousandwriteoffNumberyesa number not below 0
Closing stock, thousandendNumberyescalculated: opening + receipts − returns − cost of sales − write-offs

Example rows

MonthCategoryOpening stock, thousand, at costReceipts, thousandSupplier returns, thousandCost of sales, thousandWrite-offs and losses, thousandClosing stock, thousand
2027-01women24,8009,2003007,60026025,840
2027-01men10,4003,30003,3009010,310
2027-02women25,8408,1002006,90031026,530
2027-02men10,3103,000503,1007010,090

The example data is illustrative: an exercise, replace it with your own.

Note

The next month opening stock must equal the previous closing stock; settle a gap against the stocktake on a separate losses line. The example data is illustrative: an exercise, not a norm or an industry benchmark.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →