Skip to content

Products & inventory

This guide shows you how to build your product/service catalog and, for goods you stock, how to track inventory, adjust stock, and read the inventory reports.

What this is

An item is a reusable catalog entry (a product or a service) with its HSN/SAC code, GST rate, unit, and prices. Adding items to your catalog means you can pick them on invoices and bills instead of retyping, and the correct tax and HSN flow through automatically. For physical goods, turning on inventory tracking also keeps a live count of stock on hand and its value, per GST registration.

Before you begin

  • Role required: Admin or Accountant. Stock increases through an adjustment need an Admin. View Only users can read the catalog and reports but cannot change anything.
  • Decide: is the item Goods (something you stock and count) or a Service (something you perform)? Only goods carry stock.

Activate inventory tracking (one-time)

Switching the module on is not enough on its own. You must also confirm how tracking starts before any stock moves. Until you do, you can create products, but purchases and sales post as accounting only (no stock movement), the inventory reports stay empty, and the sidebar entries Stock Adjustments, Inventory Reports, and Branch Transfers stay locked. A banner on the catalog page offers Complete Setup.

1. Turn it on and choose a costing method

Open Settings → Accounting Preferences and find the Inventory Tracking card. Turn the switch on. The Costing method selector appears: Weighted Average or FIFO. This is the basis used to value cost of goods sold; the Valuation report shows both regardless.

The Inventory Tracking card in Accounting Preferences, switched on, with Costing method and Set up inventory

2. Run the setup wizard

Under Set up inventory tracking, click Set up inventory. (The company's Books Beginning From date must be set first; the card tells you if it is missing.) The Set Up Inventory Tracking dialog offers three ways to start:

  • Start with zero stock (clean slate): you held no stock at your Books Beginning date. Click Confirm zero opening stock. No file is needed.
  • I have opening stock as of Books Beginning: upload what you held on that date.
  • Start mid-year (takeover): you ran the business before inventory tracking. Pick the first tracked date in Inventory starts from and upload stock as of that date. Earlier documents stay accounting-only.

For the two upload options, click Download the stock template (.xlsx), fill it in, attach it under Baseline stock file (.xlsx), and click Start tracking. A GST rate cell formatted as a percentage (so 18% is stored as 0.18) is read as 18%.

The Set Up Inventory Tracking dialog with its three choices

If the file has rows TrackBooks cannot accept, a Baseline blocked panel lists each one. Tick Exclude this row for the rows you want to drop and retry with the same file.

More than one GST registration

When your company has several registrations that can hold stock, the wizard becomes a checklist with one row per registration. Use Declare zero opening or Upload baseline on each. Stock does not move for a registration until its own row is confirmed. You can come back later through Review setup under Inventory setup by GST location.

Opening stock is a starting balance, not a correction

Opening stock is set only through this wizard. Once a registration is declared zero, you cannot add opening stock to it later; everything enters through purchases or adjustments. To fix a count after tracking starts, record a Stock Adjustment.

Add a product or service

Go to Products & Services → Catalog. The page is headed Products & Services and the catalog is shared across all your locations for billing and purchasing. Click Add product. The Add New Product form asks for:

  • Item Type: Goods or Service.
  • Item Code and Item Name, plus an optional Description.
  • Category: pick one or type a new name to create it. Manage the list later with Manage Categories on the catalog page (add with New category and Add, rename, deactivate, or Show inactive).
  • HSN Code (goods) or SAC Code (services): start typing to search. Picking a code pre-fills the GST Rate. Use Other rate... for a rate not in the list, or tick Nil Rated, Exempted, or Non-GST below it; those items carry no rate.
  • Unit of Measurement, Selling Price (₹), and Purchase Price (₹).
  • For goods, once inventory setup is complete: Minimum Stock and Reorder Level for the Low Stock report. Before setup, the form says the stock fields unlock after setup.

The Add New Product form: Item Type, Item Code, Item Name, Description, Category, HSN Code and GST Rate

Click Create Product. There is no "track inventory" tick box: once inventory is on, every goods item is tracked automatically. When you edit a tracked item, the form shows its on-hand quantity, average cost, and value, and an Active tick box (inactive items are hidden from invoice search).

In the catalog list, each tracked goods item has a chevron on the left. Click it to see the item's stock by location: Location, On hand, Average cost, Stock value, and Last movement.

The catalog with an item expanded to show stock by location

Adjust stock

When your physical count differs from the system (breakage, samples, a stock-take correction), go to Products & Services → Stock Adjustments. The page is headed Inventory Adjustments and records a Quantity Adjustment. Fill in the Date, a Reason (Write-off (damage/expiry), Physical count correction, Internal consumption, or Found stock), the Adjustment Account, an optional Description, and, when you have more than one stock location, the Location. The form reminds you: "Stock increases are limited to count corrections / found stock and require a company admin." For each line pick the Item; the current quantity at that location loads into the Available column. Enter the New Quantity and, if needed, the Unit Cost; the Change column shows the difference. Use Add line for more items.

The Inventory Adjustments form with a quantity adjustment line

Click Convert to Adjusted to apply it now, or Save Draft to apply later from the Recent Adjustments list. Increases are limited to the count correction and found stock reasons and need an Admin.

Read the inventory reports

Products & Services → Inventory Reports opens with the line "Closing stock as of" the end date of the period selected in the top bar, and three cards: Tracked Items, Quantity On Hand, and Inventory Value. Four tabs follow:

  • Stock on Hand: quantity, average cost, value, reorder level, and last movement per item. Items at or below their reorder level carry a Low badge.
  • Stock Movements: every in/out movement, with the columns Date, Item, Qty Change, Value Change, Balance Qty, and Balance Value. Narrow it with the date range, the movement type dropdown (All movements, Opening stock, Purchase bills, Sales invoices, Branch transfers, Adjustments), or the search box for a stock code or item name. Goods in transit between registrations show in a banner with a View branch transfers link.
  • Valuation: closing value under Weighted Average and FIFO side by side, with the method on your books marked.
  • Low Stock: only the items at or below their reorder level.

Inventory Reports on the Stock Movements tab with the date range and movement type filter

When the company has more than one GST registration, the reports follow the location you are working in: pick a registration to see its own stock, or stay on All Locations (Consolidated) for the whole company.

Tips & common issues

Set a reorder level

Filling in Reorder Level makes the Low Stock tab useful: items appear there automatically when they run low.

You can't sell more than you have

TrackBooks blocks a sale (or any stock-out) that would take an item's quantity below zero at that location, telling you exactly what's short. Record the purchase or adjustment first, then post the sale. This keeps your cost of goods sold and stock valuation accurate.

Inventory cannot be turned off once stock has moved

The switch on the Inventory Tracking card can only be turned off while no stock movement exists. After that, the card shows the setup summary and the switch is disabled.

Services don't carry stock

Mark labour, consulting, and the like as Service items. They still carry an SAC code and GST rate, but there's nothing to count.


Last checked against TrackBooks on 24 October 2026.