Inventory valuation and movement
Updated:
Item groups with their own accounts, inventory movement per period for the accountant and the provision for obsolete inventory.
Open Inventory in FiattoIn this article
For the period close and the accountant, Fiatto expresses the inventory in money: per item group, as movement over a period and with a provision for obsolete stock. Cost prices, weighted average costs and inventory value are visible only to the finance circle (approver, accountant, auditor); quantities remain visible to everyone on Inventory (/dashboard/voorraad).
Steps
- On the item, under Edit, choose an Item group: a node from the category tree. The inventory valuation via Export → Export CSV then ends with a Subtotal per item group.
- To post a group to its own inventory and cost-of-sales account, set the accounts in the ledger setup (
/dashboard/grootboek/inrichting) under Accounts per item group. An item posts to the account of the nearest group with its own account, otherwise to the company account. - In the report centre (
/dashboard/rapportage), download the report Inventory movement per period (CSV, from and to). Per item it shows opening stock, receipts, sales, consumption, production, corrections and transfers up to the closing stock, in quantity and value, with a revaluation column. If the period ends at the end of an accounting period, the file also contains the difference with the inventory account in the ledger. - Open Provision for obsolete inventory (
/dashboard/grootboek/voorraad-voorziening) and choose the Reference date (the end of a period). Per item, the required provision is shown next to what has already been posted; select the proposals and post them. Each item gets a journal entry.
Tips
- The required provision is the higher of the Scale (days without outflow × percentage of the inventory value) and the difference with the selling price, never more than the inventory value. A decrease after a sale becomes a release. An approver or accountant confirms; an administrator sets the scale, to be agreed with your accountant.
- Signals in Actions report Negative stock per item and location, and Inventory postings not in the ledger when inventory entries have been missing from the internal ledger for more than two days.
- See also managing inventory and counting inventory.