5 November 2026

Export Inventory COGS to Xero, QuickBooks & Sage — Plus Live Job Profitability for Contractors

Month-end shouldn't mean retyping stock into your accounting software, and you shouldn't find out a job lost money after it's finished. Two new StockSimple features fix both.

One-click accounting CSV for Xero, QuickBooks and Sage

Go to Reports, pick Xero, QuickBooks or Sage and a month, then download: Monthly COGS (every stock out that month at cost price, excluding transfers between your own locations), Inventory valuation (quantity on hand × cost per SKU) and CONTRACTOR invoices (net, VAT and totals per invoice).

Column headings follow each package's common import layouts, with default account codes (for example Xero 310 cost of sales and 630 inventory). Your accountant can change account codes in the file before importing; check them against your own chart of accounts.

Live job profitability in CONTRACTOR

Every job now shows a Live job profitability panel: the quoted contract value, the cost of material actually taken from stock for that job, gross profit and gross margin %.

It updates the instant a crew member taps Use on a job material. A colour badge flags healthy margins (40%+), jobs to watch (20–40%) and margins at risk (under 20%). Labour and other costs aren't included, so treat it as material margin.

How to use them together

Quote the job, track materials as they're used, watch the margin live, invoice from CONTRACTOR and at month-end download COGS and invoices for your accountant — from one login and one stock record.

FAQ

How do I import inventory COGS into Xero?

Download the Xero Monthly COGS CSV from Reports. It's laid out as a manual journal (cost of sales vs inventory) you can import or copy into Xero.

Does it work with QuickBooks Online?

Yes. Choose QuickBooks to get item and COGS columns named the way QuickBooks imports expect.

How is job gross margin calculated?

(Quoted price − material cost used) ÷ quoted price. Material cost uses each product's current cost price.