Products & stock · Guide 41 of 53
Products and stock: perpetual inventory
Build a product catalogue, pick items straight onto sales and purchase invoices, and let the ledger track stock in real time. Every receipt and sale posts its own balanced journal, so stock value ties to the Balance Sheet by construction. Stocktakes handle the variance; the valuation report and statutory stocks note fall out of the same numbers.
Inventory in IQ Books is perpetual, not periodic. There is no “count it all up at year-end and plug the difference”. Every time you receive or sell a tracked item, the ledger moves — capitalising cost to the inventory asset on the way in, releasing cost of sales on the way out. Stock value on the Balance Sheet is always live, and always equal to the sum of what you actually hold.
Where to find it
Products is a top-level workspace with its own sub-views: Catalogue, Stock levels, Stock movements, Stocktakes and Stock reports.
The three item types
When you add a product, you pick one of three types — this is the single most important decision, because it determines whether the item touches inventory at all:
- Tracked. Holds stock. Capitalises to the inventory asset when you buy it, and posts cost of goods sold automatically when you sell it. Use this for anything you stock and resell.
- Service. Labour, consultancy, anything with no physical stock. Sits on an invoice as a priced line; never touches inventory.
- Untracked. A physical thing you sell but don’t want to hold stock for — e.g. drop-shipped goods, or low-value items you expense directly. Priced on invoices, but no stock ledger.
Building the catalogue
- From
Products → Catalogue, click New product. - Enter a SKU (e.g.
PIN-001), a name, and the unit of measure (each, box, kg…). - Pick the type (tracked / service / untracked).
- Set a sales price ex-VAT and a default sales VAT code — these pre-fill the line when the item is picked onto an invoice.
- Optionally set a reorder level. Tracked items dip below it and get flagged low on the catalogue and in the metric strip.
- Optionally add a barcode (EAN, UPC or your own code). Each barcode belongs to one product, so a scan finds it.
- Save. The product is now available in the item picker on every sales and purchase document.
Importing products from a spreadsheet
To add or update many products at once, choose Import on Products → Catalogue and pick a CSV or Excel file with one product per row and a header row (Download a template gives one to fill in). IQ Books matches the columns by their names (SKU, name, type, unit, prices, VAT codes, account codes, supplier, reorder level and quantity, lead time, barcode, opening quantity and opening unit cost); open Columns to change any choice. If there is no name column, a Description column is used as the name.
Before anything is saved you see what every row will do: New, Update (a product whose SKU is already in the catalogue, with each change shown before and after), No change, or Problem with the reasons. Rows with a problem are left out and the rest are imported; correct them and import the file again, and the rows already in come back as no change.
Opening stock in the file (a quantity and a unit cost) goes onto tracked products that have no stock movements yet, at the opening stock date you give. Tick already in my opening balances when the stock is in your conversion balances, so nothing is posted twice. If the import adds the first stock to the books, you choose how stock is valued (weighted average or FIFO), because that choice is fixed once stock moves. Connected assistants can import products the same way through the connector.
Editing and retiring catalogue items
Open a product and choose Edit to change its SKU, name, description, selling price, unit, default sales VAT code or reorder level. Those are catalogue defaults for future documents: changing them never rewrites an invoice, bill or stock movement that has already been recorded.
The item type is editable only until the first stock movement. Once a tracked item has received, sold, opened or adjusted stock, its accounting identity is locked; archive it and create a replacement if the real-world item was classified incorrectly. This prevents a catalogue edit from turning a live stock ledger into a service line.
Choose Archive to retire a product. A tracked item must have zero quantity and zero value first. Archived products disappear from new invoice and bill pickers but keep their complete document and movement history. Turn on Show archived in the Catalogue and choose Restore to make one available again. Every create, edit, archive and restore is written to the audit log.
Opening stock
If you already hold stock when you start on IQ Books, open the tracked item and use Opening balance to record the quantity and unit cost on hand at day one. This posts Dr Inventory / Cr Opening balance equity — the standard opening-balance pattern, so it slots in alongside your other opening balances rather than distorting the P&L.
The item picker on invoices
On any sales invoice or supplier bill, each line has an item picker as its first cell. Choose a product and the line fills in: description, price (from the catalogue), and default VAT code. You can override any of these per-line — the catalogue value is a starting point, not a lock.
- On a sales invoice, picking a tracked item is what releases stock. When the invoice is issued, the item’s on-hand quantity drops and a cost-of-sales journal posts automatically at the item’s current weighted-average cost.
- On a supplier bill, picking a tracked item is what receives stock. The quantity goes up, the unit cost from the bill line feeds the running weighted average, and cost capitalises to the inventory asset rather than hitting an expense category.
The movement ledger
Open any tracked item and the Movement ledger tab is its full history — the same running-balance shape as a bank cashbook, but with a dual running balance: quantity and value, side by side. Every row is a real, balanced journal:
- Opening — opening balance equity.
- Receipt — from a supplier bill line.
- Sale (COGS) — from a sales invoice line; releases cost of sales.
- Adjustment — stock written off or found, shown by its reason (damaged, expired or obsolete, lost or stolen, samples given away, found, stocktake difference, correction).
- Write-down — value taken off stock still held, with no change to the quantity (and Write-down taken back when it is reversed).
- Stocktake — the variance posted from a physical count.
- Write-down / reversal / revaluation — valuation corrections.
Because each movement is its own journal with a source_doc_type back-reference, you can always trace a stock figure to the document that caused it — the bill, the invoice or the stocktake.
Live stock levels that tie to the Balance Sheet
Products → Stock levels shows every tracked item with its on-hand quantity, weighted-average unit cost, and total value. The footer compares the sum of all item values against the inventory account’s balance in the general ledger.
These two numbers tie by construction. The inventory asset on the Balance Sheet is the sum of the movement ledgers — same journals, same figures. If they ever diverge, that’s a signal worth investigating (usually a manual journal posted straight to the inventory account, bypassing the stock engine), and the report flags it with a “does not tie — review” note rather than hiding it.
Stocktakes
Products → Stocktakes is the count-and-correct workflow. Physical stock drifts from the book — breakages, theft, miscounts, samples given away. A stocktake reconciles them.
- Click New stocktake and give the date the stock is counted (the difference posts on that date; a date inside a locked period is refused here, before anything is counted). Choose what to count: every tracked product, one supplier’s products (those you buy from them), or products matching a SKU, name or barcode. Tick Blind count if the people counting should not see what the books expect. A product can only be on one count in progress at a time, and a count cannot be dated before one already posted for the same products: either would take the same difference twice.
- Count. Type each counted quantity (each one saves when you leave the box), or use the scan box: a handheld barcode scanner types the code and presses Enter, and each scan adds one to that product (or tick Set this quantity to set the number typed beside it, zero included). Take it back undoes the last scan. Products are found by SKU first, then barcode (spaces ignored), then SKU ignoring capitals where only one product has it; a code not on this count sheet, or not a product at all, is said. Several people can count at once, on the web and the phone: if a product was counted elsewhere after your screen opened, your figure is not saved over theirs and the box shows the count now held.
- Prefer paper? Print count sheet gives a sheet to fill in (without the expected quantities on a blind count), and Count sheet (CSV) the same as a file. Upload counts reads a CSV or Excel file of SKU or barcode and the quantity counted, such as that sheet filled in (a comma decimal such as 4,50 is read as four and a half). A product on several rows (several shelves) is added together. A product already counted keeps its count unless you tick Replace counts already recorded, so an old copy of the sheet cannot undo newer scans; the result lists every row not recorded and why.
- Review the variances — counted minus book on the count date, per item. On a blind count choose Show expected first; posting needs it.
- Post stocktake. IQ Books works out exactly what posting will do and shows it: each difference with its value at cost, stock down and stock up in total, and anything that stops it. A shortfall bigger than the stock held today (because sales recorded since the count date exceed what was counted) is shown as a problem to fix, usually purchases missing since the count, rather than cut down. A product counted above the books that has never been bought in asks for a unit cost. An archived product with a difference is named. Each non-zero variance then posts a balanced adjustment journal (inventory ↔ Stock write-offs, a cost of sales account) dated on the count date. Items not counted are left as they are. If anyone changes a count between the check and Post, posting stops and shows the new figures.
A posted stocktake is a permanent record: the worksheet stays viewable, showing exactly which items were adjusted and by how much. A stocktake that is not wanted can be cancelled while it is a draft; nothing posts and it stays on the list as cancelled. As your financial year end approaches, What RiQ found reminds you to count the stock while any product holding stock at the year end has not been counted by a count posted near it (a count of one supplier counts those products only), so the accounts use counted stock. RiQ can also start a stocktake, record counts you tell it (by name, SKU or barcode; it says which it could not record), and post the count in progress (posting is planned and confirmed first).
Write-offs and write-downs
Stock that is lost or spoilt is written off; stock that will now sell for less than it cost is written down. Both post to Stock write-offs, a cost of sales account IQ Books adds to the chart the first time it is needed (code 510, or 5010 on a four-digit chart; an existing expense account called Stock write-offs or Stock losses is used instead). Keeping them apart from cost of sales shows what was lost beside what was sold, and the statutory accounts include them in cost of sales.
- Write off (the product, Adjust stock): choose why — Damaged, Expired or obsolete, Lost or stolen, Samples given away, or Found when there is more than the books say — and the quantity. The stock leaves at its cost and the movement ledger shows the reason. Correction is for a quantity entered wrongly; it posts to cost of sales, as adjustments always did. Goods taken for your own use are not a write-off: for a sole trader they count as sold to yourself at what they would sell for, so ask your accountant how to record them.
- Write down (the product, Write down): enter what each unit can now be sold for. Stock is held at what it cost or what it can be sold for, whichever is lower, so the difference comes off its value; the quantity stays. On FIFO the value comes off each cost layer in proportion. Whatever is sold from it afterwards is costed at the lower value.
- Take back a write-down from the movement ledger while nothing else has happened to the product: the value goes back exactly where it was and the journal is reversed. Once stock has moved, part of the lower value has been sold, so it can no longer be taken back.
What RiQ found watches the stock for you: products that have not sold for a while or hold far more than they sell (Slow-moving stock), products that will run out before more could arrive (Stock running out), products whose margin has dropped (Margin dropping), and stock held above what it sells for, with a write-down to accept (Write stock down). RiQ can also write stock off or down when you tell it to ("write off 3 damaged mugs", "write the oak boards down to £5 each"); it plans first and asks.
The valuation report
Products → Stock reports produces the stock valuation report — weighted-average cost as at today, item by item, footing to the Balance Sheet Stocks line. This is the report you hand your accountant at year-end and the basis for the statutory stocks figure.
How stock is valued: weighted average
IQ Books offers both of the cost formulas UK GAAP permits, and you choose which one this organisation uses:
- Weighted average (moving average), the default. Every unit costs the running average of what you paid, so each receipt re-blends the average and each sale releases cost at it. Simplest to follow, and what Xero uses.
- FIFO, first in first out. Each delivery stays its own cost layer and a sale consumes the oldest layers first, so a sale costs what that particular delivery cost. What QuickBooks and FreeAgent use.
The choice lives in Settings → Organisation under Stock valuation. The Products section also offers it while you still have no stock, because that is where you actually are when the question starts to matter.
If you are unsure: weighted average suits interchangeable stock that turns over steadily, and FIFO suits stock where age or batch matters, or where a rising purchase price means you want cost of sales to follow the actual buying history — timber, materials, anything with a shelf life.
The statutory stocks note flows into the accounts
Stock isn’t a dead-end report. When you prepare statutory accounts (Reports → Statutory accounts), the inventory figure flows straight through to the Stocks caption on the balance sheet, and — for any entity that actually carries stock — IQ Books generates the Stocks disclosure note automatically, including the measurement-basis accounting policy: “Inventories are stated at the lower of cost and net realisable value, with cost determined on a weighted average basis.” The note is required under FRS 102 Section 1A and informative under FRS 105; either way you don’t write it by hand.
Related guides
How Buying And Selling Stock Reaches Your Accounts
Stock only moves when a line on a bill or invoice has a stock item attached — a plain expense or income line never touches inventory. Once an item is linked, IQ Books posts the stock side for you automatically the moment the document is issued.
- Receiving stock on a purchase bill. Add a line, pick the stock item, and enter the quantity and unit cost. When you issue the bill the cost lands in your Inventory asset account rather than going straight to an expense, and the item’s on-hand quantity and value both rise. The cost sits on your Balance Sheet until the goods are sold.
- Selling stock on a sales invoice. Add a line linked to the same item and enter a quantity. Issuing the invoice posts two things: the usual sale (money owed, income and VAT) and, separately, the cost of the goods — moved out of Inventory into Cost of Sales at the item’s current average cost, not the price you charged.
- The receipt cost and the sale cost are different numbers. Stock comes in at the exact unit cost you typed on the bill. It goes out at the live weighted-average cost across everything you hold. Your selling price never affects the cost side — it only drives the revenue and your gross profit.
A worked example. You buy 10 units at £4 (£40 into Inventory), then 10 more at £6 (£60). You now hold 20 units worth £100, an average of £5 each. You sell 5 units and invoice them at £12: the invoice books £60 of revenue, while the cost side moves 5 × £5 = £25 out of Inventory into Cost of Sales. You are left holding 15 units worth £75, still at £5 average, and £35 of gross profit on that sale.
Bringing Existing Stock Onto The Books
When you start using IQ Books with stock you already own, the goal is simple: every item’s on-hand quantity should be right, and the total value of all items should equal the Inventory figure on your Balance Sheet. The weighted-average engine needs a starting cost per unit, so you must load both the quantity and its value together.
- Load quantity and value together. For each tracked item, bring in your counted on-hand quantity alongside the total value you hold, dated to your migration cut-over. That seeds the average cost (value divided by quantity) and puts the matching amount into Inventory in one step.
- Never enter a quantity with no value. If you set an opening quantity but leave the value blank, the average cost starts at zero — your first sale of that item will post no cost of sales at all and overstate your profit. Always give the value.
- Non-tracked items need no opening stock. Services, and items you have chosen not to value, never sit in Inventory; they post straight to income or expense, so there is nothing to bring forward for them.
If you are moving across from Xero, QuickBooks or Sage, the migration brings your Inventory balance over as a single opening figure. It does not itemise your shelves, so set each item’s opening quantity and value yourself and check that the per-item total agrees with that Inventory balance.
Returns, Credit Notes And Voids That Adjust Stock
Undoing or reversing a stock transaction moves inventory as carefully as the original did — you never have to adjust the figures by hand.
- A customer returns goods (sales credit note). Raise a credit note against the stock line and the items come back into Inventory at the current average cost, reducing your Cost of Sales. They return at today’s average, which may differ from the average when they were first sold.
- You return goods to a supplier (purchase credit note). Raise a credit note against the bill’s stock line and the items leave Inventory again, lowering your on-hand quantity and value.
- Voiding a bill or invoice. Voiding a document that moved stock posts an exact reversal of every movement it created, cleanly unwinding both the quantity and the value. If a sales invoice already has a payment allocated to it, void is blocked — unallocate or refund the receipt first, or use delete, which releases the allocation for you.
Why you cannot simply edit a stock line after issuing. Once a sales invoice carrying stock has been issued, IQ Books will not let you change its lines in place, because reworking the quantities would distort the moving average for every later sale. To correct it, either void the invoice and raise it again, or issue a credit note for the difference.
When You Sell More Than You Hold
IQ Books never blocks a sale for being short of stock — you can always issue the invoice. If you sell more units than you have on hand, the item’s quantity and value simply go negative, and the extra units are costed at the last average IQ Books knew about.
Negative stock is a signal that a purchase bill is missing or was entered late, not a permanent state. To put it right:
- Enter the purchase bill or receipt that should have come first — once the goods are received, the quantity climbs back above zero and the average cost re-settles.
- If the count is genuinely wrong (breakages, miscounts), use a stocktake to reset the on-hand figure to reality and let IQ Books post the variance for you.
Until you have corrected it, treat any valuation taken while an item is negative as provisional.
Common Questions About Stock
- Does IQ Books use FIFO? Yes, if you choose it. An organisation runs on either weighted (moving) average or FIFO, set in Settings → Organisation under Stock valuation, or from Products while you still have no stock. Weighted average re-blends the cost of everything you hold on each purchase; FIFO keeps each delivery as its own cost layer and sells the oldest first. Pick before your first stock movement: the method locks once anything has been costed, because the accounting standards require one formula applied consistently and changing it would restate figures already posted. No. Stock is valued on a weighted (moving) average basis only — every new purchase re-blends the average cost of what you hold. First-in-first-out is not available.
- Why is my cost of sales not what I paid for that item? Because stock leaves at the blended average across all your purchases, not the cost of one specific batch, and never at the price you sold it for.
- I sold a service and stock didn’t move — is that a bug? No. Only tracked items with a stock item attached to the line move inventory. Services and non-tracked lines post straight to income or expense.
- Can IQ Books warn me when I’m running low? Yes — set a reorder level on an item and it is flagged on the stock levels and valuation report when the on-hand quantity drops to or below it.
- Do stock movements cost credits? No. Buying, selling and adjusting stock are ordinary bookkeeping actions and are free. Credits are only spent on the AI features, such as scanning a receipt or coding bank lines.