Excel
Cin7
01
Where it sits
Behind the answer, the 41 products over 120 days are split by location, read live from Cin7.
£23,900 across 3 places
Behind Kate's question at 09:40
Aged stockChat · Kate Lowe, 09:40Live
Read stock over 120 days
Split by location
Ask
reports
Aged stock, by time on the shelf.
Ask for the aged stock report. Centrus reads stock from Cin7 and groups it by how long it has been in: up to 60 days, 60 to 120 days and over 120 days. The workbook comes back by product and location, from the depot to the field service vans.
Centrus chat, with finance
KLKate LoweFinance
Today
Type a message…
- how it runs
- Asked in chat, on WhatsApp or in Teams.
how it runs
From the shelf to the workbook.
Kate asks on Fri 02/10. Here is where the slow stock sits, the Daikin line behind the largest figure, and the same report on the 1st.
01
Where the slow stock sits
Behind the answer, the 41 products over 120 days are split by location, read live from Cin7.
£23,900 across 3 places
Works with Cin702
The 18 Daikin units
Kate asks on Teams what they are. 18 outdoor units, in since 12/05/2026, £15,480 at cost.
18 units, £15,480
Works with Teams, Cin703
On the 1st, to Matt
An agent reads the aged stock on the 1st and emails Matt the workbook, without anyone asking.
38 products, £21,400
Works with Cin7, Excel, Outlook, Gmail
Behind Kate's question at 09:40
Aged stockChat · Kate Lowe, 09:40Live
Read stock over 120 days
Split by location
01 / 03
01 / 03
before and after
The same aged stock, two ways.
Stock on hand at 09:40 on Fri 02/10, grouped by how long it has been in at Harlow depot, the workshop and on the vans.
The bands
Without Centrus: Counted in a stock take
With Centrus: Read from Cin7 in three bands
Over 120 days
Without Centrus: Found when someone walks the racks
With Centrus: 41 products, £23,900 at cost
The largest
Without Centrus: A part code nobody recognises
With Centrus: 18 Daikin units, in since 12/05/2026
The file
Without Centrus: Exported, then tidied by hand
With Centrus: Aged stock, October, back in the reply
keep going
More in reports and numbers.
Answers, reports and alerts from the systems you already run.
- Excel reports, described in a sentenceDescribe the report once. On the 1st it's written from your job system and Xero, in the format you already send.AutomationWorks with BigChange, Joblogic, Simpro, Excel, Word, Xero, Google Sheets, Google Docs
- Cost alerts before a job overruns its quoteWhen a job passes 90% of its quote, the contracts manager and a director get a text, and it's in Monday's cost report.AutomationWorks with BigChange, Joblogic, Simpro, Phone and SMS
- Margin by category, and why it movedJob costs against invoices for each contract, by category, with the jobs that pulled the margin down.AutomationWorks with BigChange, Joblogic, Simpro, Outlook, Gmail, Excel, Xero, Sage Intacct
- Group job financials in one viewMulti-job packages reviewed in one place instead of opening each reference by hand.AskWorks with BigChange
- First-time fix this month against lastDirectors see where return visits come from without commissioning a report.AskWorks with BigChange, Joblogic, Simpro
- A chart of the numbers, made in chatAsk for the chart, not the spreadsheet.AskWorks with BigChange, Joblogic, Simpro, Excel, Xero
Centrus AI
in the 30 minutes
- 01We start with how your operation actually runs, on the desk and in the field.
- 02We show "Aged stock by time on the shelf" on a setup that matches yours.
- 03We pick out the admin that should run itself first.
Book 30 minutes. Bring a real question.
Ask this every week, or need something that isn't on the list? Bring the question the way your team would put it, and we will show it on a setup like yours. You leave with a plan.
30 minutes / UK team / No lock-inOr see pricing