TOOLS CLUB TEMPLATE

Inventory Ledger Template

Not knowing exactly what’s in stock — or what it’s worth — makes it impossible to answer basic questions like whether you’re about to run out of a bestseller or sitting on dead stock. This ledger tracks stock in, stock out, and running quantity and value for every product you carry.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Product-based businesses tracking physical inventory
Online sellers managing stock across one or more sales channels
Business owners preparing an accurate cost of goods sold figure
Anyone who has been surprised by an inventory count that didn’t match expectations

What's included

Per-product log of stock received and stock sold
Automatic running quantity on hand
Inventory value tracking based on cost per unit
Built-in AI prompt to flag products trending toward a stockout or overstock

Why use a template instead of starting from scratch?

Guessing at stock levels, or relying on a periodic physical count alone, means you often find out you’re out of a popular item only after a customer tries to order it. A running ledger gives you a real-time view of quantity and value on hand, based on what’s actually moved.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Set up a row for each product you carry

Include a starting quantity and cost per unit for each.

Log stock received as new inventory arrives

Quantity, date, and cost per unit for each shipment.

Log stock sold as it moves out

The running quantity on hand updates automatically as you record sales.

Run the built-in AI prompt periodically

Attach the saved file to ChatGPT or Claude and ask which products are trending toward a stockout or sitting as overstock.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on which products are trending toward a stockout or sitting as overstock, based on recent stock-in and stock-out activity, no accounting background required.

Common Mistakes to Avoid

Not logging stock movement in real time

The ledger is only useful as a decision-making tool if it reflects current reality — batch-updating it weeks later defeats the purpose.

Skipping a periodic physical count

A running ledger can drift from actual stock due to shrinkage, damage, or data entry errors — reconcile against a physical count regularly.

Using inconsistent cost per unit across shipments

If your cost per unit changes between purchases, decide on a consistent costing method (like average cost) and apply it consistently, rather than mixing methods.

Not distinguishing between committed and available stock

If you take orders before shipping, stock that’s already promised to a customer isn’t truly "available" — this matters for accurate reorder decisions.

Frequently Asked Questions

How does an inventory ledger connect to cost of goods sold?

The cost of the inventory that leaves as sold stock becomes your Cost of Goods Sold on the P&L — accurate inventory tracking here directly feeds an accurate COGS figure.

How often should I do a physical inventory count?

Quarterly is common for many small businesses, monthly for higher-volume or higher-value inventory — the goal is catching any drift between your ledger and reality before it becomes a large, hard-to-explain gap.

What’s the difference between FIFO and average cost for inventory?

FIFO (first-in, first-out) assumes the oldest stock sells first; average cost blends the cost of all units together. Both are valid methods with different tax and reporting implications — check with your accountant on which fits your business.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Profit and Loss Template, where your Cost of Goods Sold ultimately gets reported.

Can I track inventory across multiple locations or sales channels?

This template is built around a single running total per product — for multiple locations, consider a column per location or a separate tab per channel, then combine totals for the overall picture.

What should I do if my physical count doesn’t match the ledger?

Investigate likely causes — unrecorded sales, damaged or lost stock, or a data entry error — then adjust the ledger to match the physical count and note the reason for the adjustment.

Do service businesses need an inventory ledger?

Generally no — this template is built for businesses that hold physical stock. A pure service business typically doesn’t need inventory tracking at all.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club