Inventory Cost Ledger

Track receipt lots, issue costs and remaining stock with FIFO or moving weighted-average decimal arithmetic.

On-device No sign-up Free to use

Calculate ledger costs controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Issue 12 units after receiving 10 at a unit cost of 2 and five at a unit cost of 4.

    Receipts of 10 units at 2 and 5 at 4, followed by a 12-unit issue, cost 28.00 under FIFO. Three units remain at cost 4, value 12.00. Weighted average instead costs 32.00 and leaves value 8.00.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/inventory-cost-ledger · 20 November 2026

    Was this helpful?

    How to use Inventory Cost Ledger

    1. Enter dated inventory receipts, issues and costed return-in rows.
    2. Choose FIFO or moving weighted average for the entire calculation.
    3. Review each movement cost and the remaining quantity and value.
    4. 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.

    You add
    Inventory movements: sku,date,type,quantity,unit_cost A,2026-01-01,receipt,10,2 A,2026-01-02,receipt,5,4 A,2026-01-03,issue,12,0 Cost method: fifo
    You get
    Receipts of 10 units at 2 and 5 at 4, followed by a 12-unit issue, cost 28.00 under FIFO. Three units remain at cost 4, value 12.00. Weighted average instead costs 32.00 and leaves value 8.00.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with Inventory Cost Ledger