How to use Inventory Cost Ledger
- Enter dated inventory receipts, issues and costed return-in rows.
- Choose FIFO or moving weighted average for the entire calculation.
- Review each movement cost and the remaining quantity and value.
- Download the movement report and the remaining-stock JSON ledger.
Example: Inventory Cost Ledger
Issue 12 units after receiving 10 at a unit cost of 2 and five at a unit cost of 4.
Supported inputs and limits
- Up to 2,000 CSV rows, 80 columns and 2 MiB.
- Positive quantities and nonnegative unit costs allow up to six decimal places.
- Rows must be chronological per SKU; same-day movements use CSV order.
- Negative stock is refused.
- Return-in creates a new lot at the entered cost; supplier returns, automatic reversal of earlier issues, multi-currency costing, taxes and landed-cost allocation are unsupported.
More details
Values round half up to two places for display, after decimal processing.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Inventory Cost Ledger
How are returned items valued?
Use return-in with a positive quantity and an explicit unit cost. It behaves like a new receipt, so the tool does not invent the cost of an earlier sale or identify the original lot.
Why do FIFO and weighted costs differ?
FIFO consumes the oldest receipts. Weighted average values each issue using the current unrounded stock value divided by its quantity. Different receipt prices therefore produce different issue costs.
Can the ledger issue stock before it arrives?
An issue that exceeds the current available quantity is refused. Backdated rows are also refused rather than creating a temporary negative lot.