A working demonstration of the workbooks, dashboard and weekly report we set up for owner-run businesses. It is built for Ridgeway Trade Supplies, an invented plumbing and electrical wholesaler, so every name and figure is invented.
What's in this demoUse the menu at the top to move between pages.
Profit, cash and the balance sheet month by month for five years, with scenarios, funding and valuation.
On the dashboard
Click the tabs to move between areas of the business. The Data state menu shows how the dashboard warns you when figures are out of date or a workbook has a problem.
In the workbooks
Each workbook page is a picture of the Excel file. Click a tab name at the bottom to change sheet, and click any cell to see what it holds and where it comes from.
All figures are invented for this demo.Prepared by Auxiliary Advisory, auxiliaryadvisory.com.au
How it works
Your numbers already live in Xero, your order system and your bank. This setup gathers them into a few well-built Excel workbooks that you own, lets an AI assistant do the weekly legwork through secure connectors, and turns the result into one dashboard and a one-page Monday report. You stay in charge of every decision.
Figure 1. The big picture: where the numbers start, where they are kept, what reads them, and what you see.
1. Where your numbers start
Xero or MYOBInvoices, bills, payments, profit and loss
Cin7 or your order systemCustomer orders, stock, purchase orders
Your bankAccount balances
Your teamThings no system holds: licences, targets, notes
Copied in each week
2. Where they are kept
Your workbooksOrdinary Excel files, one per area of the business
Kept in your SharePoint or OneDriveOr on your own computer. They stay yours, and you can open them any time.
Read through a connector
3. What reads them
Your AI assistantFor example Claude. It reads the workbooks you allow, checks them and drafts the weekly report.
ConnectorsSecure links you switch on, so the assistant can open SharePoint, Xero and similar. Also called MCP connectors.
Shows the results
4. What you see
DashboardCash, orders, stock, admin, sales, forecast and benchmarks on one screen
Weekly reportOne page every Monday: what changed and what needs a decision
What each piece does
The workbooks
Excel files laid out for your business: one for finance and cash, one for orders and stock, one for admin, one for sales, and a financial model if you want one. Every number on the dashboard is worked out in these files, so you or your accountant can open them and check any figure.
SharePoint or OneDrive
Where the workbooks live. It is the same Microsoft storage most businesses already pay for with Microsoft 365. Keeping the files there means the assistant can reach them through a connector, and you keep the usual version history if something goes wrong.
Your AI assistant
A tool like Claude. It does the reading and writing work a person would otherwise do: pulling in the week's figures, checking for problems, and drafting the plain-English parts of the report. It does not do the maths; the workbooks do.
Connectors (MCP)
A connector is a secure link between the assistant and another app, like a key you hand over for one door. You choose which apps to connect and can switch a connector off at any time. MCP, short for Model Context Protocol, is the common standard these connectors are built on.
Your accounting and order systems
Xero, MYOB, Cin7 and similar stay exactly as they are. Their figures come into the workbooks either through a connector, where the system offers one, or as an export file pasted in. Nothing in these systems is changed.
The dashboard and report
The view of everything. They read the Summary tab of each workbook and show it as figures, charts and short lists of what needs attention. They never calculate anything themselves, so they always agree with the workbooks.
How the workbooks stay up to date
Figure 2. Three ways to keep the workbooks up to date. Most businesses start with the first or second and move along as they get comfortable.
A. By hand
Your team does it, about the same work as today's spreadsheets.
Export the week's reports from Xero and Cin7
Paste each one into its tab in the workbook
Check the Checks tab is clear
The dashboard and report update themselves
Who: a staff member or bookkeeper. Needs: Excel only.
B. With the assistant
Someone asks the assistant to do the update, then reviews it.
Type a request, for example "update this week's figures"
The assistant fetches the figures through its connectors
It updates the workbooks and lists anything that looks wrong
You check its summary and approve
Who: anyone on the team, or us. Needs: an AI assistant with connectors switched on.
C. Automatically
A scheduled task runs the update every Monday morning. This is called an agentic workflow.
Early Monday, the scheduled task starts on its own
It fetches the figures and updates the workbooks
It runs the checks and drafts the weekly report
A person reads the draft and sends it
Who: set up by us, reviewed by you. Needs: an assistant that can run scheduled tasks.
The Monday routine
Figure 3. What happens each Monday, whichever way the update is done.
Bring in the weekBank balances, invoices, bills, orders and stock come into the workbooks, each with that week's date.
Check itThe Checks tab looks for missing dates, duplicates and anything that doesn't add up. Red checks stop the dashboard showing figures until they are fixed.
Plan stockThe orders and stock workbook works out what to order, when, and whether cash allows it.
Update cashThe planned stock payments go into the cash forecast, so they are counted once.
Refresh the viewThe dashboard reads the new Summary figures.
Draft the reportThe assistant writes the short sentences; every number comes from the workbooks.
A person signs offSomeone reads the report and decides what to act on. Nothing is sent or ordered without a person.
Where you see your dashboard
Figure 4. Two places the dashboard can live.
Option 1. Inside Claude, as an artifact
Your workbooks in SharePoint
Claude artifactA dashboard page inside Claude that reads the workbooks through the Microsoft 365 connector
YouOpen it any time; it shows the latest figures
Always up to date: it reads the files when you open it
You can ask Claude questions about what you see
Each person who views it needs a Claude subscription with the connector switched on
Option 2. A private web page or PDF
Your workbooks in SharePoint
Weekly buildWe turn the workbooks into a private page or PDF each week
YouOpen the link or the email
No AI subscription needed to view it
Easy to share with a partner, accountant or lender
Updated weekly rather than live
What joins it all together
Six linksThe small rules that let separate files and tools behave like one system.
The link
What it does
Why it matters to you
Shared IDs
Every customer, supplier and product has one code, such as CUS-0014, used in every workbook.
The dashboard can put a customer's overdue invoices next to their late orders without mixing them up.
The As at date
Each workbook has one date that every "overdue" and "this week" uses.
The report reads the same every time you open it, and old figures are never shown as current.
The Summary tab
Each workbook has one tab of headline figures, all formulas.
The dashboard and report read only this tab, so they always match the workbooks.
The Checks tab
Formulas that look for missing, duplicated or impossible data.
If something is wrong, the dashboard says what and where, instead of showing a wrong number.
Connectors
Secure links between the assistant and SharePoint, Xero and similar.
The assistant can do the weekly update without anyone copying files around.
The weekly order of work
Cash figures go to the stock plan, and planned stock payments come back to cash.
Stock payments are counted once, not twice.
Keeping it safe
Your data stays yours
The workbooks live in your own SharePoint or OneDrive. The assistant reads only the files and apps you connect, and you can switch any connector off.
People stay in charge
The assistant fetches, checks and drafts. It never places an order, pays a bill or sends a report on its own; a person does.
Every number can be checked
All figures are formulas in the workbooks. Each dashboard figure names the workbook tab it came from, so you or your accountant can trace it back to the rows behind it.
Private details are left out
Staff names, contact details and similar never appear on the dashboard or in the report. Staff show by ID and role only.
Words used on this page
AI assistant
Software you talk to in plain English that can read, write and summarise, such as Claude.
Agentic workflow
A task the assistant carries out on its own, step by step, usually on a schedule, with a person checking the result.
Artifact
A page Claude can build and keep, such as this dashboard, that you open inside Claude.
Connector, or MCP
A secure link that lets the assistant open a particular app or file store. MCP (Model Context Protocol) is the standard they use.
Export
A file you download from a system like Xero, usually a spreadsheet of a report.
SharePoint and OneDrive
Microsoft's file storage, included with most Microsoft 365 plans.
Workbook
An Excel file. Each one has tabs (sheets) for different things.
Ridgeway Trade Supplies is an invented business used to show the workbooks and dashboard.Prepared by Auxiliary Advisory
Dashboard. Every figure is invented. Click the tabs to move between areas of the business. Change Data state to see how the dashboard warns you when figures are old or a workbook has a problem.
Ridgeway Trade Supplies
As at 23 Nov 2026 Data 2 days old
Cash at bank
$184,320Up $12,480 on last week
Owed to you
$142,860$38,410 of it overdue
You owe
$178,540$81,200 due in the next 14 days
Lowest week ahead
$61,900Week of 11 Jan
Cash dips to $61,900 in the week of 11 Jan, then recovers
Cash at bank, next 13 weeks, Base scenario. Weeks start Monday.
Show the figures
Week of
Base
23 Nov
$184,320
30 Nov
$171,900
7 Dec
$163,400
14 Dec
$175,200
21 Dec
$158,600
28 Dec
$141,300
4 Jan
$118,700
11 Jan
$61,900
18 Jan
$77,400
25 Jan
$88,900
1 Feb
$97,600
8 Feb
$105,300
15 Feb
$112,800
From Finance and cash, Forecast tab.
Needs attentionLargest dollar amount first
Item
Why
Amount
Coastal Pipe bill
Due Fri 27 Nov
$34,400
Northgate Building Co
Overdue 46 days
$14,280
Bayview Plumbing
Overdue 38 days
$9,615
Hillside Electrical
Overdue 21 days
$6,940
Parkes Maintenance
Overdue 12 days
$2,910
Note. December supplier bills fall due in the first week of January, while counter sales are still slow after the shutdown.
Cash rose $12,480 last week: $75,500 came in and $63,020 went out
Cash at bank, week ending 22 Nov. Inc GST. Solid bars add cash; outlined bars take it away.
Show the figures
Opening
$171,840
Counter sales
$43,600
Account customers
$31,900
Suppliers
($48,200)
Other costs
($11,970)
Van leases
($2,850)
Closing
$184,320
From Finance and cash, Bank balances and the Xero bank export.
You owe, next 14 daysInc GST. Supplier bills by due date.
Supplier
Due
Amount
Coastal Pipe
Fri 27 Nov
$34,400
Hartley Steel
Wed 2 Dec
$18,760
Brightline Electrical
Fri 4 Dec
$16,180
Fixmore
Sun 6 Dec
$11,860
Total
$81,200
Owed to you, by ageInc GST. Days past the invoice due date.
Customer
Not yet due
1 to 30 days
31 to 60 days
Over 60 days
Total
Northgate Building Co
$3,120
-
$14,280
-
$17,400
Bayview Plumbing
$2,450
-
$9,615
-
$12,065
Hillside Electrical
$4,880
$6,940
-
-
$11,820
Marlow Fit-outs
$9,760
-
-
-
$9,760
39 other customers
$84,240
$7,575
-
-
$91,815
Total
$104,450
$14,515
$23,895
-
$142,860
From Finance and cash, Summary tab. Checks: all clear.Prepared by Auxiliary Advisory
Orders last week
212Up 7.1% on the 4-week average
Order value last week
$60,040Average $283 an order
Due to ship
3711 waiting on stock
Running late
6Five of them waiting on stock
Sales have run ahead of last year for six months, 7.4% up in October
Sales ex GST by month, this year against last year.
From Orders and stock, Benchmarks tab.
Needs attentionLargest order first
Item
Why
Amount
ORD-48210, Northgate Building Co
Late 5 days
$4,860
ORD-48231, Lakeside Roofing
Late 4 days
$3,270
ORD-48244, Marlow Fit-outs
Late 3 days
$2,940
ORD-48251, Hillside Electrical
Late 3 days
$1,985
ORD-48262, Bayview Plumbing
Late 3 days
$1,410
Note. Four late orders are waiting on 25mm copper elbows. A purchase order is due on 26 Nov.
Copper fittings are over a third of sales
Sales by product group, last four weeks, ex GST.
From Orders and stock, Order lines tab.
Late orders and what they wait onEx GST.
Order
Waiting on
Value
ORD-48210
25mm copper elbow
$4,860
ORD-48231
25mm copper elbow
$3,270
ORD-48244
20mm PEX pipe, 50m coil
$2,940
ORD-48251
25mm copper elbow
$1,985
ORD-48262
25mm copper elbow
$1,410
ORD-48270
Double GPO, white
$690
Total
$15,155
From Orders and stock, Summary tab. Checks: 1 failing, 1 to watch.Prepared by Auxiliary Advisory
Below reorder point
2318 already on order
Orders to place this week
5$20,482, all affordable
Stock value
$352,000Down $9,200 on last week
Slow movers
118$31,400 unsold for 90 days
Copper elbows run out this week; the order placed today lands on 7 Dec
25mm copper elbow, projected units on hand by week, Base case. Lead time two weeks.
From Orders and stock, Supply plan tab.
Needs attentionOrders to place this week, largest first
Order
Lands
Cost
20mm PEX pipe, 50m coil
7 Dec
$7,008
Tempering valve, 15mm
11 Jan
$4,640
25mm copper elbow
7 Dec
$4,340
Double GPO, white
30 Nov
$2,856
90mm PVC bend
7 Dec
$1,638
Note. 4 of these 5 products are already out of stock; the other is below safety stock.
Orders to place, next four weeksBase case. Ex GST. Quantity rounded up to carton and minimum order.
Product or group
Sales, last 12 weeksEach row to its own scale
Order week
Qty
Cost
Tempering valve, 15mm
23 Nov
80
$4,640
20mm PEX pipe, 50m coil
23 Nov
73
$7,008
25mm copper elbow
23 Nov
1,400
$4,340
90mm PVC bend
23 Nov
210
$1,638
Double GPO, white
23 Nov
340
$2,856
Hot water parts Product group, ordered by value
30 Nov
-
$7,000
Copper fittings, other lines Product group, ordered by value
30 Nov
-
$15,000
Electrical and other Product group, ordered by value
7 Dec
-
$9,000
Valves, other lines Product group, ordered by value
7 Dec
-
$13,000
Total
$64,482
Copper fittings have under a month of stock left
Months of stock cover by product group, against the next three months of forecast sales.
From Orders and stock, Supply plan tab.
Note. If sales miss, cash dips below the buffer in the week of 11 Jan. The plan would still place 13 critical orders and defer 7 others by a week or two. See Forecast.
From Orders and stock, Summary tab. Checks: 1 failing, 1 to watch.Prepared by Auxiliary Advisory
Overdue
1Van rego, expired 17 Nov
Due in the next 30 days
3Rego, fire test, forklift licence
Due in 31 to 90 days
5Includes workers comp, 31 Dec
No one responsible
2Test and tag, racking inspection
Coming up in 31 to 90 daysSoonest first. Items due sooner are under Needs attention. Staff appear by ID and role only.
Item
Responsible
Due
In
Workers compensation policy
Owner
31 Dec 2026
38 days
First aid (HLTAID011), STF-0002
Warehouse manager
6 Jan 2027
44 days
Electrical test and tag
Unassigned
8 Jan 2027
46 days
Forklift annual service
Warehouse manager
20 Jan 2027
58 days
Racking inspection
Unassigned
2 Feb 2027
71 days
Needs attentionSoonest first
Item
Why
Date
Van rego, Isuzu NPR
Expired
17 Nov
Van rego, Toyota HiAce 1
Due Wed 9 Dec
9 Dec
Fire equipment six-monthly test
Due Tue 15 Dec
15 Dec
Forklift licence (LF), STF-0004
Due Sat 19 Dec
19 Dec
Electrical test and tag
No one responsible
8 Jan
From Admin and compliance, Summary tab. Checks: 1 to watch.Prepared by Auxiliary Advisory
Businesses in play
8Still open
Quotes out
3$15,800 a month if all are won
New accounts this quarter
1Target 4
Contacts last week
8Target 8
Three quotes are waiting on a reply
Businesses by stage. Open and opened accounts only.
From Sales pipeline, Summary tab.
Needs attentionLargest monthly spend first
Business
Why
Spend a month
Harbour Hydraulics
Next step overdue 3 days
$6,500
Greenvale Builders
Next step overdue 5 days
$5,400
Clearflow Drains
Next step overdue 10 days
$3,900
Northshore Hot Water
No next step
$2,100
From Sales pipeline, Summary tab. Checks: 1 failing, 3 next steps overdue.Prepared by Auxiliary Advisory
Only the Miss case falls below the buffer, in 4 of the 13 weeks from 11 Jan
Cash at bank by scenario, next 13 weeks. Shaded: the range from Miss to Target.
Show the figures
Week of
Base
Target
Miss
What if
23 Nov
$184,320
$184,320
$184,320
$184,320
30 Nov
$171,900
$176,500
$166,200
$171,900
7 Dec
$163,400
$171,800
$152,700
$177,680
14 Dec
$175,200
$186,900
$158,100
$189,480
21 Dec
$158,600
$173,400
$135,900
$172,880
28 Dec
$141,300
$160,200
$116,000
$155,580
4 Jan
$118,700
$141,500
$83,400
$155,380
11 Jan
$61,900
$92,300
$21,700
$98,580
18 Jan
$77,400
$110,600
$46,922
$91,680
25 Jan
$88,900
$124,800
$47,000
$103,180
1 Feb
$97,600
$137,900
$35,100
$111,880
8 Feb
$105,300
$149,200
$63,000
$119,580
15 Feb
$112,800
$160,400
$50,386
$127,080
From Finance and cash, Forecast tab.
Scenarios side by sideWhat if: Coastal Pipe paid two weeks later and Northgate collected by 7 Dec.
Base
Target
Miss
What if
Lowest week
$61,90011 Jan
$92,30011 Jan
$21,70011 Jan
$91,68018 Jan
Weeks below the $50,000 buffer
-
-
4
-
Cash in week of 15 Feb
$112,800
$160,400
$50,386
$127,080
Funding needed
-
-
$28,300
-
Note. Miss means sales 15.0% under target and customers paying 10 days slower. The figures in each column come from the Forecast tab's scenario columns.
January is a loss-making month in every case; Miss stays below Base all season
EBITDA by month and scenario, Nov 2026 to Apr 2027.
From the Financial model, Outputs tab.
If sales miss: stock orders the plan defersCash would fall below the buffer. 13 critical orders are still placed; funding needed $28,300.
Order
Wanted
Placed
Cost
Copper fittings, other lines
7 Dec
14 Dec
$10,000
Hot water parts
7 Dec
21 Dec
$5,000
Valves, other lines
21 Dec
28 Dec
$12,000
Electrical and other
4 Jan
11 Jan
$9,000
90mm PVC bend
11 Jan
18 Jan
$1,014
Ball valve, 25mm
11 Jan
18 Jan
$3,408
Tempering valve, 15mm
15 Feb
After 15 Feb
$3,480
Total
$43,902
Note. No deferral loses sales: each product still has stock when its delayed order lands.
Stock running out or piling upBase case, by month, with this week's orders placed. Overstock means more than 16 weeks of stock. From Orders and stock, Supply plan.
Product
Nov
Dec
Jan
Feb
25mm copper elbow
Out of stock
-
-
-
Tempering valve, 15mm
Out of stock
Out of stock
Out of stock
-
20mm PEX pipe, 50m coil
Out of stock
-
-
-
Ball valve, 25mm
Out of stock
-
-
-
Tapware (group)
Overstock
Overstock
-
-
Purchase orders and their paymentsEx GST. Open orders and when the cash goes out.
Supplier
Arrives
Value
Payment
Coastal Pipe
Thu 26 Nov
$18,420
30 days
Brightline Electrical
Wed 25 Nov
$7,960
30 days
Valvex Imports
Thu 3 Dec
$21,600
Balance on arrival
Fixmore
Tue 24 Nov
$2,310
30 days
Total
$50,290
From Finance and cash Forecast and the Financial model Outputs tab. Checks: all clear.Prepared by Auxiliary Advisory
Cost of sales and days to pay sit outside their ranges
Last 12 months. Grey band: benchmark range. Tick: your target. Dot: you. Ranges here are invented for this demo, not ATO figures.
Cost of sales to turnoverIndustry range: 60.0% to 66.0%
66.5%
Above the range. Check supplier prices and discounts. Target 64.0%.
Labour to turnoverIndustry range: 11.0% to 17.0%
15.4%
Inside the range. Target 15.0%.
Rent to turnoverIndustry range: 3.0% to 6.0%
5.1%
Inside the range. Target 5.0%.
Average days to payYour last 12 months: 33 to 44 days
41 days
11 days slower than target. Target 30 days.
Stock turns a yearIndustry range: 4.0 to 6.5
5.1
Inside the range, below target. Target 5.5.
Against last year and targetLast 12 months unless stated.
Measure
You
Last year
Target
Result
Sales growth
4.0%
3.1%
8.0%
Below target
Gross margin
33.5%
32.8%
34.5%
Below target
Orders a week, last 4 weeks
201
188
210
Close to target
Late orders, share
2.8%
1.6%
2.0%
Above target
Overdue share of owed to you
26.9%
21.4%
15.0%
Above target
From each workbook's Benchmarks tab and the Financial model Benchmarks tab.Prepared by Auxiliary Advisory
Ridgeway Trade Supplies
Weekly report for the week ending Sunday 22 November 2026
Cash at bank$184,320Up $12,480 on last week
Overdue from customers$38,410Up $6,200 on last week
Orders last week212Up 7.1% on 4-week average
Lowest week ahead$61,900Week of 11 Jan
What changed
Cash rose, mostly from two large customer payments on Thursday.$12,480
Overdue from customers grew. Northgate Building Co is now 46 days late.$6,200
Orders were 212, up 7.1% on the four-week average of 198.$60,040
What needs a decision this week
Pay or reschedule the Coastal Pipe bill due Fri 27 Nov.$34,400
Chase Northgate and Bayview. Together they are most of the overdue total.$23,895
Tell the four customers waiting on 25mm copper elbows that stock lands on 7 Dec.$11,525
Stock to order this week
20mm PEX pipe, 50m coil: order 73 from Coastal Pipe, landing 7 Dec.$7,008
Tempering valve, 15mm: order 80 from Valvex Imports, landing 11 Jan.$4,640
25mm copper elbow: order 1,400 from Coastal Pipe, landing 7 Dec.$4,340
All 5 orders this week, all affordable from cash above the buffer.$20,482
Forecast
Cash stays above the $50,000 buffer in the Base case. The lowest week is 11 Jan at $61,900, when December supplier bills fall due and counter sales are still slow after the shutdown.
In the Miss case (sales 15.0% under target, customers paying 10 days slower) cash falls below the buffer in 4 weeks from 11 Jan and needs $28,300 of funding, even after deferring 7 stock orders.
As at 23 Nov 2026. Figures from the Finance and cash and Orders and stock workbooks. All figures are invented for this demo.Prepared by Auxiliary Advisory
Finance and cash workbook, 18 tabs. This is how the Excel file looks. Click a tab name at the bottom to change sheet, and click any cell to see what it holds and where it comes from.
Ridgeway Finance and cash.xlsx
A1fx
A
B
C
1
Ridgeway Trade Supplies: Finance and cash
2
Read this first. It explains what the workbook is for and how to keep it up to date.
3
4
What it is for
5
Shows where cash stands this week, who owes you, who you owe, and what cash looks like for the next 13 weeks.
6
7
How to keep it up to date
8
1. Each Monday, export the aged receivables and aged payables reports from Xero and paste each under the last paste on its Import tab. Type the As at date in column A of the new rows.
9
2. Type each bank account's balance on Bank balances with today's date.
10
3. Once a month, paste the paid invoices and monthly sales exports.
11
4. Check the Checks tab is clear. The dashboard and weekly report update themselves.
12
13
Tab
Who uses it
What it holds
14
Settings
You type
Business name, As at date, cash buffer, overdue thresholds.
15
Import Xero receivables
You paste
Xero aged receivables export, pasted weekly under the last one.
16
Import Xero payables
You paste
Xero aged payables export, pasted weekly under the last one.
17
Bank balances
You type
Each account's balance, typed weekly with its As at date.
18
Owed to you
You read
Open customer invoices, built from the receivables import.
19
You owe
You read
Open supplier bills, built from the payables import.
20
Paid invoices
You paste
Paid customer invoices, for days to pay.
21
Recurring costs
You type
Wages, rent, loans and other regular payments.
22
Sales by month
You paste
Monthly sales ex GST, for the forecast run rate.
23
Planned stock payments
You paste
Weekly payments for planned stock orders, from Orders and stock.
24
Targets
You type
Cash buffer, days to pay and other targets.
25
Forecast
You read
13-week cash forecast in four scenarios.
26
Benchmarks
You read
This business against its history, targets and industry ranges.
27
Summary
You read
The figures the dashboard and report read.
28
Checks
Checks
Data problems.
29
Lists
Dropdown values.
30
31
Cell colours
32
Blue text on white
Type here. These are the only cells you change.
33
Black text on grey
A formula. Locked so it isn't overwritten by accident.
34
Green text on grey
Copied by formula from another tab. Locked.
35
Black text, no fill
Pasted from Xero, MYOB or another system. Replace only by pasting a new export.
36
37
Sheets are protected with no password, so you can still sort, filter and resize columns. To change a formula, unprotect the sheet (Review, Unprotect Sheet), or ask us.
38
39
Prepared by Auxiliary Advisory
40
41
42
A
B
C
1
Settings
2
Set once at the start. The As at date drives every date formula in this workbook.
3
4
Setting
Value
What it does
5
Business name
Ridgeway Trade Supplies
Shown on every tab, the dashboard and the report.
6
As at date
23 Nov 2026
Every overdue, due soon and this-week formula uses this date. Clear it to use today.
7
Week starts
Monday
Weeks run Monday to Sunday, Sydney time.
8
Financial year starts
1 July
Used for year-to-date figures.
9
Warn when data is older than
10 days
The dashboard shows a stale-data warning after this.
10
Cash buffer
$50,000
The lowest balance you are comfortable holding. Forecast weeks below it are flagged.
11
Overdue: watch after
1 day
Invoices 1 to 30 days overdue show in amber.
12
Overdue: act after
30 days
Invoices more than 30 days overdue show in red.
13
Bills: due soon within
7 days
Supplier bills due within this many days are flagged.
14
Accounting system
Xero
Picks the import layout.
15
Miss: sales under Target
15.0%
How far the Miss case falls short of Target sales.
16
Miss: customers paying on time, below Target
20.0%
How many fewer customers pay on time in the Miss case.
17
Counter sales, typical week, inc GST
$44,000
Scaled by each week's factor on Lists.
18
Base case growth, at most
4.0%
Caps the Base case at a cautious rate even when recent growth is higher.
19
20
21
A
B
C
D
E
F
G
H
I
J
1
Import Xero receivables
2
Paste the Xero aged receivables detail export here, under the last paste. Type the As at date in column A.
3
4
As at
Contact
Invoice number
Invoice date
Due date
Current
1 month
2 months
Older
Total
5
23 Nov 2026
Northgate Building Co
INV-10418
8 Sep 2026
8 Oct 2026
-
-
$14,280
-
$14,280
6
23 Nov 2026
Bayview Plumbing
INV-10433
16 Sep 2026
16 Oct 2026
-
-
$9,615
-
$9,615
7
23 Nov 2026
Hillside Electrical
INV-10471
3 Oct 2026
2 Nov 2026
-
$6,940
-
-
$6,940
8
23 Nov 2026
Parkes Maintenance
INV-10486
12 Oct 2026
11 Nov 2026
-
$2,910
-
-
$2,910
9
23 Nov 2026
Cobalt Electrical
INV-10490
15 Oct 2026
14 Nov 2026
-
$2,365
-
-
$2,365
10
23 Nov 2026
Westside Gas and Water
INV-10493
19 Oct 2026
18 Nov 2026
-
$2,300
-
-
$2,300
11
23 Nov 2026
Marlow Fit-outs
INV-10502
5 Nov 2026
5 Dec 2026
$9,760
-
-
-
$9,760
12
23 Nov 2026
Northgate Building Co
INV-10507
7 Nov 2026
7 Dec 2026
$3,120
-
-
-
$3,120
13
23 Nov 2026
Bayview Plumbing
INV-10511
8 Nov 2026
8 Dec 2026
$2,450
-
-
-
$2,450
14
23 Nov 2026
Hillside Electrical
INV-10514
9 Nov 2026
9 Dec 2026
$4,880
-
-
-
$4,880
15
...
61 more rows from 36 customers
16
17
18
A
B
C
D
E
F
1
Import Xero payables
2
Paste the Xero aged payables detail export here, under the last paste. Type the As at date in column A.
3
4
As at
Contact
Bill number
Due date
Current
Total
5
23 Nov 2026
Coastal Pipe
BILL-2281
27 Nov 2026
$34,400
$34,400
6
23 Nov 2026
Hartley Steel
BILL-2290
2 Dec 2026
$18,760
$18,760
7
23 Nov 2026
Brightline Electrical
BILL-2294
4 Dec 2026
$16,180
$16,180
8
23 Nov 2026
Fixmore
BILL-2297
6 Dec 2026
$11,860
$11,860
9
23 Nov 2026
Coastal Pipe
BILL-2305
18 Dec 2026
$52,900
$52,900
10
23 Nov 2026
Brightline Electrical
BILL-2309
21 Dec 2026
$26,620
$26,620
11
23 Nov 2026
Valvex Imports
BILL-2312
24 Dec 2026
$13,000
$13,000
12
23 Nov 2026
Metro Couriers
BILL-2316
31 Dec 2026
$4,820
$4,820
13
14
15
A
B
C
D
1
Bank balances
2
Type each account's balance every Monday with its As at date. Add rows at the bottom; never overwrite last week.
3
4
As at
Account
Balance
Note
5
19 Oct 2026
Operating account
$118,420
6
19 Oct 2026
Tax holding account
$42,000
7
26 Oct 2026
Operating account
$131,760
8
26 Oct 2026
Tax holding account
$42,000
9
2 Nov 2026
Operating account
$124,300
10
2 Nov 2026
Tax holding account
$42,000
11
9 Nov 2026
Operating account
$137,950
12
9 Nov 2026
Tax holding account
$42,000
13
16 Nov 2026
Operating account
$129,840
14
16 Nov 2026
Tax holding account
$42,000
15
23 Nov 2026
Operating account
$142,320
16
23 Nov 2026
Tax holding account
$42,000
17
18
19
A
B
C
D
E
F
G
H
I
J
K
1
Owed to you
2
Open customer invoices from the latest receivables paste. Formulas in grey; type only in the blue Follow-up note column.
3
4
Invoice ID
As at
Customer ID
Customer
Invoice date
Due date
Amount inc GST
Days overdue
Age band
Flag
Follow-up note
5
INV-10418
23 Nov 2026
CUS-0014
Northgate Building Co
8 Sep 2026
8 Oct 2026
$14,280
46
31 to 60 days
Overdue
Called 20 Nov, promised Friday
6
INV-10433
23 Nov 2026
CUS-0008
Bayview Plumbing
16 Sep 2026
16 Oct 2026
$9,615
38
31 to 60 days
Overdue
7
INV-10471
23 Nov 2026
CUS-0021
Hillside Electrical
3 Oct 2026
2 Nov 2026
$6,940
21
1 to 30 days
Watch
Statement resent
8
INV-10486
23 Nov 2026
CUS-0041
Parkes Maintenance
12 Oct 2026
11 Nov 2026
$2,910
12
1 to 30 days
Watch
9
INV-10490
23 Nov 2026
CUS-0017
Cobalt Electrical
15 Oct 2026
14 Nov 2026
$2,365
9
1 to 30 days
Watch
10
INV-10493
23 Nov 2026
CUS-0026
Westside Gas and Water
19 Oct 2026
18 Nov 2026
$2,300
5
1 to 30 days
Watch
11
INV-10502
23 Nov 2026
CUS-0033
Marlow Fit-outs
5 Nov 2026
5 Dec 2026
$9,760
-
Not yet due
12
INV-10507
23 Nov 2026
CUS-0014
Northgate Building Co
7 Nov 2026
7 Dec 2026
$3,120
-
Not yet due
13
INV-10511
23 Nov 2026
CUS-0008
Bayview Plumbing
8 Nov 2026
8 Dec 2026
$2,450
-
Not yet due
14
INV-10514
23 Nov 2026
CUS-0021
Hillside Electrical
9 Nov 2026
9 Dec 2026
$4,880
-
Not yet due
15
...
61 more rows
16
17
18
A
B
C
D
E
F
G
1
You owe
2
Open supplier bills from the latest payables paste.
3
4
Bill ID
Supplier ID
Supplier
Due date
Amount inc GST
Days until due
Flag
5
BILL-2281
SUP-0003
Coastal Pipe
27 Nov 2026
$34,400
4
Due 27 Nov
6
BILL-2290
SUP-0007
Hartley Steel
2 Dec 2026
$18,760
9
7
BILL-2294
SUP-0005
Brightline Electrical
4 Dec 2026
$16,180
11
8
BILL-2297
SUP-0009
Fixmore
6 Dec 2026
$11,860
13
9
BILL-2305
SUP-0003
Coastal Pipe
18 Dec 2026
$52,900
25
10
BILL-2309
SUP-0005
Brightline Electrical
21 Dec 2026
$26,620
28
11
BILL-2312
SUP-0011
Valvex Imports
24 Dec 2026
$13,000
31
12
BILL-2316
SUP-0014
Metro Couriers
31 Dec 2026
$4,820
38
13
Total
$178,540
14
15
16
A
B
C
D
E
F
G
H
1
Paid invoices
2
Paste Xero's paid invoices export monthly, under the last paste. Used for average days to pay.
3
4
Invoice ID
Customer
Invoice date
Due date
Paid date
Amount inc GST
Days to pay
Days late
5
INV-10377
Lakeside Roofing
28 Aug 2026
27 Sep 2026
2 Nov 2026
$7,420
66
36
6
INV-10389
Cobalt Electrical
2 Sep 2026
2 Oct 2026
4 Nov 2026
$3,180
63
33
7
INV-10395
Marlow Fit-outs
7 Sep 2026
7 Oct 2026
30 Oct 2026
$11,260
53
23
8
INV-10402
Westside Gas and Water
11 Sep 2026
11 Oct 2026
9 Nov 2026
$2,840
59
29
9
INV-10406
Parkes Maintenance
15 Sep 2026
15 Oct 2026
28 Oct 2026
$1,960
43
13
10
INV-10411
Hillside Electrical
21 Sep 2026
21 Oct 2026
12 Nov 2026
$5,530
52
22
11
INV-10425
Lakeside Roofing
1 Oct 2026
31 Oct 2026
19 Nov 2026
$6,115
49
19
12
...
412 rows, last 12 months
13
14
15
A
B
C
D
E
F
1
Recurring costs
2
Regular payments the cash forecast schedules. Change a row when a cost changes.
3
4
ID
Item
Frequency
Amount inc GST
Next date
Note
5
REC-01
Wages and super
Fortnightly
$16,600
26 Nov 2026
6
REC-02
Rent, Smithfield warehouse
Monthly
$13,200
1 Dec 2026
7
REC-03
Equipment loan repayment
Monthly
$4,200
15 Dec 2026
8
REC-04
Van leases, three vans
Monthly
$2,850
20 Dec 2026
9
REC-05
Software subscriptions
Monthly
$1,240
1 Dec 2026
10
REC-06
Business insurance
Yearly
$9,400
15 Jan 2027
11
REC-07
BAS, October to December
Quarterly
$28,600
28 Feb 2027
12
13
14
A
B
C
1
Sales by month
2
Monthly sales ex GST from Xero's profit and loss, pasted monthly. Sets the forecast's run rate.
3
4
Month
Sales ex GST
Source
5
Aug 2025
$229,000
Xero profit and loss
6
Sep 2025
$238,000
Xero profit and loss
7
Oct 2025
$244,000
Xero profit and loss
8
Nov 2025
$251,000
Xero profit and loss
9
Dec 2025
$219,000
Xero profit and loss
10
Jan 2026
$156,000
Xero profit and loss
11
Feb 2026
$226,000
Xero profit and loss
12
Mar 2026
$245,000
Xero profit and loss
13
Apr 2026
$232,000
Xero profit and loss
14
May 2026
$221,000
Xero profit and loss
15
Jun 2026
$228,000
Xero profit and loss
16
Jul 2026
$236,000
Xero profit and loss
17
Aug 2026
$241,000
Xero profit and loss
18
Sep 2026
$252,000
Xero profit and loss
19
Oct 2026
$262,000
Xero profit and loss
20
21
22
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
Planned stock payments
2
Step 3 of the weekly refresh: paste the planned stock payments row from the Orders and stock workbook's Orders to place tab.
3
4
Week of
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
4 Jan
11 Jan
18 Jan
25 Jan
1 Feb
8 Feb
15 Feb
5
Planned stock payments, Base
$1,392
-
$3,900
-
$3,248
$16,864
$31,100
$13,500
-
$20,386
$34,000
$23,544
$28,802
6
7
8
A
B
C
D
1
Targets
2
The business's targets. Forecast scenarios and Benchmarks both read from here, so each target lives in one place.
3
4
Measure
Target
Set on
Used by
5
Cash buffer
$50,000
1 Jul 2026
Forecast, Summary
6
Average days to pay
30 days
1 Jul 2026
Forecast Target case, Benchmarks
7
Overdue share of owed to you
15.0%
1 Jul 2026
Benchmarks
8
Sales growth on last year
8.0%
1 Jul 2026
Forecast Target case
9
Customers paying on time
75.0%
1 Jul 2026
Forecast Target case
10
11
12
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
Forecast
2
Cash at bank for the next 13 weeks. Change the What if column to test an idea; Base, Target and Miss are fixed.
3
4
Assumption
Base
Target
Miss
What if
5
Share of customers paying on time
62.0%
75.0%
55.0%
62.0%
6
Average days late, those who pay late
18
10
28
18
7
Sales growth on last year
4.0%
8.0%
(8.2%)
4.0%
8
Supplier payment moved (Coastal Pipe, 11 Jan)
-
-
-
2 weeks later
9
Northgate overdue invoice collected by
-
-
-
7 Dec 2026
10
Miss is a set shortfall against Target: sales 15.0% under, customers paying 10 days slower.
11
12
Base case, week of
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
4 Jan
11 Jan
18 Jan
25 Jan
1 Feb
8 Feb
15 Feb
13
Opening cash at bank
$184,320
$171,900
$163,400
$175,200
$158,600
$141,300
$118,700
$61,900
$77,400
$88,900
$97,600
$105,300
$112,800
14
Counter sales
$44,000
$45,000
$46,000
$47,000
$30,000
$8,000
$22,000
$34,000
$40,000
$41,000
$42,000
$43,000
$43,000
15
Account customers paying
$24,000
$26,000
$25,000
$28,000
$22,000
$6,000
$12,000
$18,000
$24,000
$25,000
$25,000
$26,000
$26,000
16
Receipts
$68,000
$71,000
$71,000
$75,000
$52,000
$14,000
$34,000
$52,000
$64,000
$66,000
$67,000
$69,000
$69,000
17
Supplier bills already received
($34,400)
($46,800)
-
($52,900)
($39,620)
($4,820)
-
-
-
-
-
-
-
18
Planned stock payments
($1,392)
-
($3,900)
-
($3,248)
($16,864)
($31,100)
($13,500)
-
($20,386)
($34,000)
($23,544)
($28,802)
19
Suppliers paid on delivery
($28,028)
($18,260)
($38,700)
($31,650)
($9,832)
($476)
($43,100)
($9,400)
($33,050)
($22,474)
($8,700)
($37,956)
($10,448)
20
Wages and super
($16,600)
-
($16,600)
-
($16,600)
-
($16,600)
-
($16,600)
-
($16,600)
-
($16,600)
21
Rent and software
-
($14,440)
-
-
-
($14,440)
-
-
-
($14,440)
-
-
-
22
Loan and van leases
-
-
-
($7,050)
-
-
-
($4,200)
($2,850)
-
-
-
($7,050)
23
One-off payments
-
-
-
-
-
-
-
($9,400)
-
-
-
-
-
24
Payments
($80,420)
($79,500)
($59,200)
($91,600)
($69,300)
($36,600)
($90,800)
($36,500)
($52,500)
($57,300)
($59,300)
($61,500)
($62,900)
25
Closing cash at bank
$171,900
$163,400
$175,200
$158,600
$141,300
$118,700
$61,900
$77,400
$88,900
$97,600
$105,300
$112,800
$118,900
26
Below the buffer
27
Cash before new stock orders, for Orders and stock
$184,320
$173,292
$164,792
$180,492
$163,892
$149,840
$144,104
$118,404
$147,404
$158,904
$187,990
$229,690
$260,734
28
29
Opening cash by scenario
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
4 Jan
11 Jan
18 Jan
25 Jan
1 Feb
8 Feb
15 Feb
30
Base
$184,320
$171,900
$163,400
$175,200
$158,600
$141,300
$118,700
$61,900
$77,400
$88,900
$97,600
$105,300
$112,800
31
Target
$184,320
$176,500
$171,800
$186,900
$173,400
$160,200
$141,500
$92,300
$110,600
$124,800
$137,900
$149,200
$160,400
32
Miss
$184,320
$166,200
$152,700
$158,100
$135,900
$116,000
$83,400
$21,700
$46,922
$47,000
$35,100
$63,000
$50,386
33
What if
$184,320
$171,900
$177,680
$189,480
$172,880
$155,580
$155,380
$98,580
$91,680
$103,180
$111,880
$119,580
$127,080
34
35
36
A
B
C
D
E
F
G
H
1
Benchmarks
2
This business against its own history, its targets and an industry range. Ranges here are invented for this demo, not ATO figures.
3
4
Measure
You
Same time last year
Target
Range low
Range high
Range source
Result
5
Average days to pay
41 days
38 days
30 days
33 days
44 days
Industry range
11 days slower than target
6
Overdue share of owed to you
26.9%
21.4%
15.0%
-
-
Own history
Above target
7
Cash at bank, weeks of payments covered
2.9
2.4
3.0
-
-
Own history
Close to target
8
9
10
A
B
C
D
1
Summary
2
The figures the dashboard and weekly report read. All formulas. As at 23 Nov 2026.
=SUM('Sales by month'!$B$17:$B$19)/SUM('Sales by month'!$B$5:$B$7)-1
12
13
14
A
B
C
1
Checks
2
Data problems found by formula. The dashboard shows no figures while a red check fails.
3
4
Check
Result
What to do
5
Receivables paste has the expected Xero columns
OK
6
Every open invoice has a due date
OK
7
Duplicate invoice IDs in the latest paste
None
8
Bank balances typed for the As at date
OK
9
Data age
2 days
Paste this week's exports each Monday.
10
Customers in Owed to you missing a customer ID
1 found
Add the customer to Lists, or ask us to map it.
11
Paid date before invoice date
None
12
13
14
A
B
C
D
E
F
G
H
I
J
1
Lists
2
Dropdown values. Add to the bottom of a list; the dropdowns pick it up.
3
4
Customer ID
Customer
Frequency
Account
Age band
Week of
Counter factor
Paid on delivery
Supplier ID
Supplier
5
CUS-0008
Bayview Plumbing
Weekly
Operating account
Not yet due
23 Nov
1.00
$28,028
SUP-0003
Coastal Pipe
6
CUS-0014
Northgate Building Co
Fortnightly
Tax holding account
1 to 30 days
30 Nov
1.02
$18,260
SUP-0005
Brightline Electrical
7
CUS-0017
Cobalt Electrical
Monthly
31 to 60 days
7 Dec
1.05
$38,700
SUP-0007
Hartley Steel
8
CUS-0021
Hillside Electrical
Quarterly
Over 60 days
14 Dec
1.07
$31,650
SUP-0009
Fixmore
9
CUS-0026
Westside Gas and Water
Yearly
21 Dec
0.68
$9,832
SUP-0011
Valvex Imports
10
CUS-0033
Marlow Fit-outs
28 Dec
0.18
$476
SUP-0014
Metro Couriers
11
4 Jan
0.50
$43,100
12
11 Jan
0.77
$9,400
13
18 Jan
0.91
$33,050
14
25 Jan
0.93
$22,474
15
1 Feb
0.95
$8,700
16
8 Feb
0.98
$37,956
17
15 Feb
0.98
$10,448
18
19
20
A
B
1
_meta
2
Hidden. Used by the dashboard and the upgrade tool to check which template this is.
3
4
Key
Value
5
Template
finance-and-cash
6
Spec layers
base finance-and-cash 1.0, vertical wholesale 1.0, client ridgeway 1.0
7
Template version
1.0.0
8
Style tokens version
1.0
9
Generated
20 Nov 2026
10
Last upgrade
-
11
Dashboard may read
Settings, Summary, Forecast, Benchmarks, Checks, and data tabs tagged readable
12
13
14
Blue text, white: typed by youBlack text, grey: formula, lockedGreen text, grey: copied from another sheet, lockedBlack text, no fill: pasted from another systemTab colours: blue you type, ochre you paste, ink you read, purple checks, none for Read me and ListsClick any cell to see what it holds in the bar above the sheet.
Orders and stock workbook, 18 tabs. This is how the Excel file looks. Click a tab name at the bottom to change sheet, and click any cell to see what it holds and where it comes from.
Ridgeway Orders and stock.xlsx
A1fx
A
B
C
1
Ridgeway Trade Supplies: Orders and stock
2
Read this first. It explains what the workbook is for and how to keep it up to date.
3
4
What it is for
5
Shows customer orders and what's late, what stock you hold and what's coming, and what to order next: when, how much, and whether cash allows it.
6
7
How to keep it up to date
8
1. Each Monday, paste last week's Cin7 sales order lines under the last paste on Order lines, then the stock on hand and open purchase orders exports on their tabs.
9
2. Paste this week's cash rows from the Finance and cash Forecast tab into Cash for stock.
10
3. Read Orders to place. Raise the purchase orders you agree with in Cin7; the plan suggests, you decide.
11
4. Copy the planned stock payments from Orders to place back into the Finance and cash workbook.
12
5. Check the Checks tab is clear.
13
14
Tab
Who uses it
What it holds
15
Settings
You type
As at date, safety stock and cover, cash buffer.
16
Order lines
You paste
Cin7 sales order lines, pasted straight in each week; age and flags calculated on the right.
17
Customers
You paste
Customer list, pasted monthly.
18
Products
You paste
Product list, pasted monthly; ABC class calculated on the right.
19
Suppliers
You type
Terms, lead times, minimum orders.
20
Stock on hand
You paste
Cin7 stock export, pasted weekly under the last one.
21
Purchase orders
You paste
Open purchase orders, pasted weekly.
22
Cash for stock
You paste
Weekly cash before new stock orders, pasted from the Finance and cash Forecast.
23
Targets
You type
Service, cover and order targets.
24
Demand forecast
You read
Weekly demand for each A item and product group, in four scenarios.
25
Supply plan
You read
Week by week stock, reorder points and orders: needed and affordable.
26
Orders to place
You read
The action list: what to order, when, what it costs and whether cash allows it.
27
Benchmarks
You read
Against last year, targets and industry ranges.
28
Summary
You read
Figures the dashboard and report read.
29
Checks
Checks
Data problems and forecast accuracy.
30
Lists
Dropdown values.
31
32
Cell colours
33
Blue text on white
Type here. These are the only cells you change.
34
Black text on grey
A formula. Locked so it isn't overwritten by accident.
35
Green text on grey
Copied by formula from another tab. Locked.
36
Black text, no fill
Pasted from Xero, MYOB or another system. Replace only by pasting a new export.
37
38
Sheets are protected with no password, so you can still sort, filter and resize columns. To change a formula, unprotect the sheet (Review, Unprotect Sheet), or ask us.
39
Pasted columns sit on the left in Cin7's own order; grey formula columns sit on the right. If Cin7 changes its export, Checks flags it.
40
41
Prepared by Auxiliary Advisory
42
43
44
A
B
C
1
Settings
2
Set once at the start. The As at date drives every date formula in this workbook.
3
4
Setting
Value
What it does
5
Business name
Ridgeway Trade Supplies
Shown on every tab, the dashboard and the report.
6
As at date
23 Nov 2026
Every overdue, due soon and this-week formula uses this date. Clear it to use today.
7
Week starts
Monday
Weeks run Monday to Sunday, Sydney time.
8
Financial year starts
1 July
Used for year-to-date figures.
9
Warn when data is older than
10 days
The dashboard shows a stale-data warning after this.
10
Safety stock, A items
2 weeks of demand
Extra stock held against late deliveries or a busy week.
11
Order up to, A items
6 weeks of cover
Orders top stock up to safety stock plus this much.
12
Cash buffer
$50,000
The affordable plan never spends below this, except for orders that would otherwise run out.
13
A items
Top 40 products by sales value
Planned one by one. The rest are planned by product group.
14
Late: act after
3 days past promised date
Shown in red.
15
Order system
Cin7
Sets the expected column layout of each paste.
16
Cost of sales, share of price
66.5%
Turns product group sales into stock at cost.
17
18
19
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
Order lines
2
Paste Cin7's sales order lines export into columns A to K, under the last paste. Columns L to N are formulas.
3
4
Order number
Order date
Customer code
Company
Delivery date
Status
Product code
Product name
Qty
Unit price
Line total
Days late
Flag
Product group
5
ORD-48210
12 Nov 2026
CUS-0014
Northgate Building Co
18 Nov 2026
Waiting on stock
PRD-0142
25mm copper elbow
300
$4.85
$1,455
5
Late 5 days
Copper fittings
6
ORD-48210
12 Nov 2026
CUS-0014
Northgate Building Co
18 Nov 2026
Waiting on stock
PRD-0144
25mm copper tee
150
$6.20
$930
5
Late 5 days
Copper fittings
7
ORD-48210
12 Nov 2026
CUS-0014
Northgate Building Co
18 Nov 2026
Waiting on stock
PRD-0388
Ball valve, 25mm
60
$23.50
$1,410
5
Late 5 days
Valves
8
ORD-48231
13 Nov 2026
CUS-0039
Lakeside Roofing
19 Nov 2026
Waiting on stock
PRD-0142
25mm copper elbow
200
$4.85
$970
4
Late 4 days
Copper fittings
9
ORD-48231
13 Nov 2026
CUS-0039
Lakeside Roofing
19 Nov 2026
Waiting on stock
PRD-0611
Silicone sealant, clear
120
$9.90
$1,188
4
Late 4 days
Other
10
ORD-48244
16 Nov 2026
CUS-0033
Marlow Fit-outs
20 Nov 2026
Waiting on stock
PRD-0157
20mm PEX pipe, 50m coil
12
$142.00
$1,704
3
Late 3 days
PVC pipe
11
ORD-48244
16 Nov 2026
CUS-0033
Marlow Fit-outs
20 Nov 2026
Waiting on stock
PRD-0390
Ball valve, 20mm
40
$30.90
$1,236
3
Late 3 days
Valves
12
...
1,184 more lines this paste; 48,900 lines in the last 12 months
13
14
15
A
B
C
D
E
1
Customers
2
Paste Cin7's customer export monthly.
3
4
Customer code
Company
Type
Terms
Credit limit
5
CUS-0008
Bayview Plumbing
Plumber
Account, 30 days
$42,000
6
CUS-0014
Northgate Building Co
Builder
Account, 30 days
$60,000
7
CUS-0017
Cobalt Electrical
Electrician
Account, 30 days
$15,000
8
CUS-0021
Hillside Electrical
Electrician
Account, 30 days
$25,000
9
CUS-0026
Westside Gas and Water
Plumber
Account, 30 days
$12,000
10
CUS-0033
Marlow Fit-outs
Fit-out
Account, 30 days
$40,000
11
CUS-0039
Lakeside Roofing
Roofer
Account, 30 days
$20,000
12
CUS-0041
Parkes Maintenance
Maintenance
Account, 30 days
$10,000
13
CUS-0052
Counter sales
Walk-in
Card or cash
-
14
15
16
A
B
C
D
E
F
G
H
I
J
1
Products
2
Paste Cin7's product export into A to H monthly. ABC class and plan level are calculated.
3
4
Product code
Product name
Category
Supplier
Carton qty
Average cost
Sell price
Sales last 12 months
ABC class
Planned
5
PRD-0142
25mm copper elbow
Copper fittings
Coastal Pipe
50
$3.10
$4.85
$37,830
A
One by one
6
PRD-0388
Ball valve, 25mm
Valves
Valvex Imports
20
$14.20
$23.50
$41,548
A
One by one
7
PRD-0459
Tempering valve, 15mm
Other
Valvex Imports
10
$58.00
$96.00
$29,952
A
One by one
8
PRD-0157
20mm PEX pipe, 50m coil
PVC pipe
Coastal Pipe
1
$96.00
$142.00
$66,456
A
One by one
9
PRD-0705
Double GPO, white
Other
Brightline Electrical
20
$8.40
$13.90
$28,912
A
One by one
10
PRD-0233
90mm PVC bend
Other
Coastal Pipe
10
$7.80
$12.40
$16,120
A
One by one
11
...
1,414 more products
12
13
14
A
B
C
D
E
F
1
Suppliers
2
Terms, lead times and minimum orders. The supply plan reads lead times and payment timing from here.
3
4
Supplier ID
Supplier
Payment terms
Lead time, days
Currency
Minimum order
5
SUP-0003
Coastal Pipe
30 days end of month
10
AUD
$1,000
6
SUP-0005
Brightline Electrical
30 days
5
AUD
$500
7
SUP-0007
Hartley Steel
30 days
14
AUD
$2,000
8
SUP-0009
Fixmore
14 days
3
AUD
$250
9
SUP-0011
Valvex Imports
30% deposit, 70% on shipment
45
USD
$8,000
10
11
12
A
B
C
D
E
F
G
H
I
J
1
Stock on hand
2
Type the As at date in A, paste Cin7's stock on hand export into B to F, under last week's paste. G to J are formulas.
3
4
As at
Product code
Product name
Location
On hand
Average cost
Value
Sold last 4 weeks
Weeks of cover
Flag
5
23 Nov 2026
PRD-0142
25mm copper elbow
Smithfield
40
$3.10
$124
600
0.3
Below reorder point
6
23 Nov 2026
PRD-0388
Ball valve, 25mm
Smithfield
22
$14.20
$312
136
0.6
Below reorder point
7
23 Nov 2026
PRD-0459
Tempering valve, 15mm
Smithfield
4
$58.00
$232
24
0.7
Below reorder point
8
23 Nov 2026
PRD-0157
20mm PEX pipe, 50m coil
Smithfield
6
$96.00
$576
36
0.7
Below reorder point
9
23 Nov 2026
PRD-0705
Double GPO, white
Smithfield
55
$8.40
$462
160
1.4
Below reorder point
10
23 Nov 2026
PRD-0233
90mm PVC bend
Smithfield
22
$7.80
$172
100
0.9
Below reorder point
11
...
1,414 more rows this paste; earlier weeks sit above
12
13
14
A
B
C
D
E
F
G
H
I
1
Purchase orders
2
Paste Cin7's open purchase orders export into A to F each week. G to I are formulas.
3
4
PO number
Supplier
Order date
Expected date
Total ex GST
Status
Arrives week of
Still to pay
Payment due
5
PO-3318
Coastal Pipe
16 Nov 2026
26 Nov 2026
$18,420
Confirmed
23 Nov
$18,420
30 days end of month
6
PO-3321
Brightline Electrical
18 Nov 2026
25 Nov 2026
$7,960
Confirmed
23 Nov
$7,960
30 days
7
PO-3307
Valvex Imports
9 Oct 2026
3 Dec 2026
$21,600
On the water
30 Nov
-
On shipment, paid
8
PO-3324
Fixmore
20 Nov 2026
24 Nov 2026
$2,310
Confirmed
23 Nov
$2,310
30 days
9
10
11
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
Cash for stock
2
Paste from the Finance and cash Forecast tab each Monday. Excludes new stock orders, so they aren't counted twice.
3
4
Base case, week of
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
4 Jan
11 Jan
18 Jan
25 Jan
1 Feb
8 Feb
15 Feb
5
Cash before new stock orders, start of week
$184,320
$173,292
$164,792
$180,492
$163,892
$149,840
$144,104
$118,404
$147,404
$158,904
$187,990
$229,690
$260,734
6
Cash before new stock orders, Miss case
$184,320
$167,418
$153,918
$159,318
$137,118
$120,060
$105,502
$43,802
$69,024
$89,124
$96,724
$140,624
$155,810
7
Cash buffer
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
8
9
10
A
B
C
D
1
Targets
2
The business's targets. Forecast scenarios and Benchmarks both read from here, so each target lives in one place.
3
4
Measure
Target
Set on
Used by
5
Orders filled from stock
97.0%
1 Jul 2026
Benchmarks
6
Stock turns a year
5.5
1 Jul 2026
Benchmarks
7
Late orders, share of orders
2.0%
1 Jul 2026
Benchmarks
8
Sales growth on last year
4.0%
1 Jul 2026
Demand forecast, Target case
9
10
11
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
Demand forecast
2
Weekly demand. Weeks 1 and 2 use confirmed customer orders plus forecast; later weeks use forecast only. A items in units, groups in dollars at cost.
3
4
Assumption
Base
Target
Miss
What if
5
Demand change on recent average
-
4.0%
(15.0%)
-
6
Supplier delay, Valvex Imports
-
-
-
3 weeks
7
Safety stock, weeks
2
2
2
3
8
Seasonal factor source
Last year's same weeks
9
Christmas shutdown: demand drops to a fifth in the week of 28 Dec and recovers through January.
10
11
Base case, demand
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
4 Jan
11 Jan
18 Jan
25 Jan
1 Feb
8 Feb
15 Feb
12
Seasonal factor
1.00
1.00
1.00
1.05
0.70
0.20
0.55
0.80
0.95
1.00
1.00
1.00
1.00
13
25mm copper elbow
850
150
150
158
105
30
82
120
142
150
150
150
150
14
Ball valve, 25mm
34
34
34
36
24
7
19
27
32
34
34
34
34
15
20mm PEX pipe, 50m coil
9
9
9
9
6
2
5
7
9
9
9
9
9
16
Copper fittings, other lines (group, $ at cost)
$6,500
$6,500
$6,500
$6,800
$4,600
$1,300
$3,600
$5,200
$6,200
$6,500
$6,500
$6,500
$6,500
17
Tapware (group, $ at cost)
$1,500
$1,500
$1,500
$1,600
$1,000
$300
$800
$1,200
$1,400
$1,500
$1,500
$1,500
$1,500
18
...
34 more A items and 4 more groups
19
20
21
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
Supply plan
2
Base case. Stock week by week, with the orders the plan places. Reorder point = demand over the lead time + safety stock.
3
4
Week of
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
4 Jan
11 Jan
18 Jan
25 Jan
1 Feb
8 Feb
15 Feb
5
25mm copper elbow, lead time 2 weeks
6
Opening stock
40
-
-
1,250
1,092
987
957
875
755
613
463
313
1,213
7
Arriving
600
-
1,400
-
-
-
-
-
-
-
-
1,050
-
8
Demand
(850)
(150)
(150)
(158)
(105)
(30)
(82)
(120)
(142)
(150)
(150)
(150)
(150)
9
Closing stock
-
-
1,250
1,092
987
957
875
755
613
463
313
1,213
1,063
10
Reorder point
1,222
488
476
450
382
393
498
562
592
600
600
600
600
11
Order placed
1,400
-
-
-
-
-
-
-
-
1,050
-
-
-
12
Flag
Out of stock
Out of stock
13
Ball valve, 25mm, lead time 7 weeks
14
Opening stock
22
-
366
332
296
272
265
246
219
187
153
119
85
15
Arriving
-
400
-
-
-
-
-
-
-
-
-
-
240
16
Demand
(34)
(34)
(34)
(36)
(24)
(7)
(19)
(27)
(32)
(34)
(34)
(34)
(34)
17
Closing stock
-
366
332
296
272
265
246
219
187
153
119
85
291
18
Reorder point
252
248
247
247
245
255
282
297
304
306
306
306
306
19
Order placed
-
-
-
-
-
240
-
-
-
-
-
-
240
20
Flag
Out of stock
21
20mm PEX pipe, 50m coil, lead time 2 weeks
22
Opening stock
6
-
-
64
55
49
47
42
35
26
72
63
54
23
Arriving
-
-
73
-
-
-
-
-
-
55
-
-
-
24
Demand
(9)
(9)
(9)
(9)
(6)
(2)
(5)
(7)
(9)
(9)
(9)
(9)
(9)
25
Closing stock
-
-
64
55
49
47
42
35
26
72
63
54
45
26
Reorder point
31
29
28
27
23
24
30
34
36
36
36
36
36
27
Order placed
73
-
-
-
-
-
-
55
-
-
-
-
-
28
Flag
Out of stock
Out of stock
29
Copper fittings, other lines, lead time 2 weeks, $ at cost
30
Opening stock
$20,000
$25,500
$19,000
$12,500
$20,700
$16,100
$14,800
$11,200
$31,000
$24,800
$18,300
$32,800
$26,300
31
Arriving
$12,000
-
-
$15,000
-
-
-
$25,000
-
-
$21,000
-
-
32
Demand
($6,500)
($6,500)
($6,500)
($6,800)
($4,600)
($1,300)
($3,600)
($5,200)
($6,200)
($6,500)
($6,500)
($6,500)
($6,500)
33
Closing stock
$25,500
$19,000
$12,500
$20,700
$16,100
$14,800
$11,200
$31,000
$24,800
$18,300
$32,800
$26,300
$19,800
34
Reorder point
$22,600
$21,200
$20,700
$19,600
$16,700
$17,100
$21,600
$24,400
$25,700
$26,000
$26,000
$26,000
$26,000
35
Order placed
-
$15,000
-
-
-
$25,000
-
-
$21,000
-
-
-
$26,000
36
Flag
Below safety
37
...
Same block for every A item and product group
38
39
40
A
B
C
D
E
F
G
H
I
1
Orders to place
2
Base case, next four weeks. Needed: what demand calls for. Affordable: what cash above the buffer allows, in priority order.
3
4
Priority: soonest stock-out first, then margin at risk. Critical orders (stock runs out before an order placed now could land) are placed even if cash dips.
5
Product or group
Order week
Qty
Cost ex GST
Arrives
Payment
Critical
Affordable
Sales at risk
6
Tempering valve, 15mm
23 Nov
80
$4,640
11 Jan
30% now, 70% on shipment
Yes
Yes
-
7
20mm PEX pipe, 50m coil
23 Nov
73
$7,008
7 Dec
On terms, 5 weeks
Yes
Yes
-
8
25mm copper elbow
23 Nov
1,400
$4,340
7 Dec
On terms, 5 weeks
Yes
Yes
-
9
90mm PVC bend
23 Nov
210
$1,638
7 Dec
On terms, 5 weeks
Yes
Yes
-
10
Double GPO, white
23 Nov
340
$2,856
30 Nov
On terms, 5 weeks
Yes
Yes
-
11
Hot water parts (group)
30 Nov
-
$7,000
14 Dec
On terms, 5 weeks
Yes
Yes
-
12
Copper fittings, other lines (group)
30 Nov
-
$15,000
14 Dec
On terms, 5 weeks
Yes
-
13
Electrical and other (group)
7 Dec
-
$9,000
14 Dec
On terms, 5 weeks
Yes
Yes
-
14
Valves, other lines (group)
7 Dec
-
$13,000
25 Jan
30% now, 70% on shipment
Yes
-
15
Total, next four weeks
$64,482
16
17
Miss case: orders deferred
Wanted
Qty
Cost ex GST
Placed
Why deferred
Weeks to run out
Sales at risk
18
Copper fittings, other lines (group)
7 Dec
-
$10,000
14 Dec
Would take cash below the buffer
5
-
19
Hot water parts (group)
7 Dec
-
$5,000
21 Dec
Would take cash below the buffer
5
-
20
Valves, other lines (group)
21 Dec
-
$12,000
28 Dec
Would take cash below the buffer
9
-
21
Electrical and other (group)
4 Jan
-
$9,000
11 Jan
Would take cash below the buffer
3
-
22
90mm PVC bend
11 Jan
130
$1,014
18 Jan
Would take cash below the buffer
4
-
23
Ball valve, 25mm
11 Jan
240
$3,408
18 Jan
Would take cash below the buffer
9
-
24
Tempering valve, 15mm
15 Feb
60
$3,480
After 15 Feb
Would take cash below the buffer
9
-
25
26
Cash, week of
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
4 Jan
11 Jan
27
Base: cash after planned stock payments
$184,320
$171,900
$163,400
$175,200
$158,600
$141,300
$118,700
$61,900
28
Miss: cash after affordable plan
$184,320
$166,200
$152,700
$158,100
$135,900
$116,000
$83,400
$21,700
29
Miss: funding needed
$28,300
30
31
Planned stock payments, Base
23 Nov
30 Nov
7 Dec
14 Dec
21 Dec
28 Dec
32
Copy into Finance and cash, Planned stock payments
$1,392
-
$3,900
-
$3,248
$16,864
33
34
35
A
B
C
D
E
F
G
H
1
Benchmarks
2
Against your own history, targets and an industry range. Ranges invented for this demo, not ATO figures.
3
4
Measure
You
Same time last year
Target
Range low
Range high
Range source
Result
5
Orders filled from stock
94.1%
95.3%
97.0%
-
-
Own history
Below target
6
Late orders, share of orders
2.8%
1.6%
2.0%
-
-
Own history
Above target
7
Stock turns a year
5.1
4.7
5.5
4.0
6.5
Industry range
Inside the range, below target
8
Stock in slow movers
8.9%
10.2%
5.0%
-
-
Own history
Above target
9
10
11
A
B
C
D
1
Summary
2
The figures the dashboard and weekly report read. All formulas. As at 23 Nov 2026.
=COUNTIFS('Stock on hand'!$A:$A,Settings!$B$6,'Stock on hand'!$J:$J,"Below reorder point")
8
Stock value at cost
$352,000
Down $9,200 on last week
=SUMIFS('Stock on hand'!G:G,'Stock on hand'!A:A,Settings!B6)
9
Orders to place this week, Base
5
$20,482
=COUNTIFS('Orders to place'!$B:$B,TEXT(Settings!$B$6,"d mmm"))
10
Orders deferred, Miss case
7
Funding needed $28,300
=COUNTA('Orders to place'!$A$18:$A$24)
11
12
13
A
B
C
1
Checks
2
Data problems found by formula. The dashboard shows no figures while a red check fails.
3
4
Check
Result
What to do
5
Order lines paste matches Cin7's column layout
OK
6
Stock on hand pasted for the As at date
OK
7
Negative stock on hand
2 found
PRD-0812 and PRD-0815 show below zero. Check the last stocktake adjustment in Cin7.
8
Forecast accuracy, A items, last 4 weeks
12.4% average error
Above the 10.0% target. Review the seasonal factors for copper fittings.
9
Products with no supplier or lead time
None
10
Data age
2 days
11
12
13
A
B
C
D
E
F
1
Lists
2
Dropdown values. Add to the bottom of a list; the dropdowns pick it up.
3
4
Product group
Status
Week of
Season factor
PO status
ABC class
5
Copper fittings
Entered
23 Nov
1.00
Draft
A
6
PVC pipe
Picking
30 Nov
1.00
Confirmed
B
7
Valves
Ready to ship
7 Dec
1.00
On the water
C
8
Hot water parts
Waiting on stock
14 Dec
1.05
Received
9
Tapware
Shipped
21 Dec
0.70
10
Other
28 Dec
0.20
11
4 Jan
0.55
12
11 Jan
0.80
13
18 Jan
0.95
14
25 Jan
1.00
15
1 Feb
1.00
16
8 Feb
1.00
17
15 Feb
1.00
18
19
20
A
B
1
_meta
2
Hidden. Used by the dashboard and the upgrade tool to check which template this is.
3
4
Key
Value
5
Template
orders-and-stock
6
Spec layers
base orders-and-stock 1.0, vertical wholesale 1.0, client ridgeway 1.0
7
Template version
1.0.0
8
Style tokens version
1.0
9
Generated
20 Nov 2026
10
Last upgrade
-
11
Dashboard may read
Settings, Summary, Forecast, Benchmarks, Checks, and data tabs tagged readable
12
Replaces
Orders and Purchasing and stock, merged 20 Nov 2026
13
14
15
Blue text, white: typed by youBlack text, grey: formula, lockedGreen text, grey: copied from another sheet, lockedBlack text, no fill: pasted from another systemTab colours: blue you type, ochre you paste, ink you read, purple checks, none for Read me and ListsClick any cell to see what it holds in the bar above the sheet.
Admin and compliance workbook, 9 tabs. This is how the Excel file looks. Click a tab name at the bottom to change sheet, and click any cell to see what it holds and where it comes from.
Ridgeway Admin and compliance.xlsx
A1fx
A
B
C
1
Ridgeway Trade Supplies: Admin and compliance
2
Read this first. It explains what the workbook is for and how to keep it up to date.
3
4
What it is for
5
Keeps every insurance, registration, licence and deadline in one place, and flags what is due before it lapses.
6
7
How to keep it up to date
8
1. Add a row when you take out a policy, register a vehicle or a staff member gets a ticket.
9
2. When something is renewed, type the new expiry date over the old one.
10
3. Give every row a responsible role; unassigned rows are flagged.
A formula. Locked so it isn't overwritten by accident.
24
Green text on grey
Copied by formula from another tab. Locked.
25
Black text, no fill
Pasted from Xero, MYOB or another system. Replace only by pasting a new export.
26
27
Sheets are protected with no password, so you can still sort, filter and resize columns. To change a formula, unprotect the sheet (Review, Unprotect Sheet), or ask us.
28
This workbook has no Forecast, Targets or Benchmarks tabs. Staff names are kept off the dashboard: staff appear by ID and role only.
29
30
Prepared by Auxiliary Advisory
31
32
33
A
B
C
1
Settings
2
Set once at the start. The As at date drives every date formula in this workbook.
3
4
Setting
Value
What it does
5
Business name
Ridgeway Trade Supplies
Shown on every tab, the dashboard and the report.
6
As at date
23 Nov 2026
Every overdue, due soon and this-week formula uses this date. Clear it to use today.
7
Week starts
Monday
Weeks run Monday to Sunday, Sydney time.
8
Financial year starts
1 July
Used for year-to-date figures.
9
Warn when data is older than
10 days
The dashboard shows a stale-data warning after this.
10
Due soon: watch within
30 days
Shown in amber.
11
Overdue
Past the expiry date
Shown in red.
12
13
14
A
B
C
D
E
F
G
H
1
Register
2
Insurances, registrations, safety checks and equipment servicing.
3
4
ID
Item
Type
Responsible
Expiry
Renew this many days ahead
Days left
Flag
5
REG-001
Public and product liability insurance
Insurance
Owner
30 Jun 2027
60
219
6
REG-002
Workers compensation policy
Insurance
Owner
31 Dec 2026
45
38
7
REG-003
Van rego, Toyota HiAce 1
Registration
Warehouse manager
9 Dec 2026
30
16
Due 9 Dec
8
REG-004
Van rego, Toyota HiAce 2
Registration
Warehouse manager
14 Mar 2027
30
111
9
REG-005
Van rego, Isuzu NPR
Registration
Warehouse manager
17 Nov 2026
30
(6)
Overdue
10
REG-006
Fire equipment six-monthly test
Safety
Warehouse manager
15 Dec 2026
30
22
Due 15 Dec
11
REG-007
Forklift annual service
Equipment
Warehouse manager
20 Jan 2027
30
58
12
REG-008
Electrical test and tag
Safety
Unassigned
8 Jan 2027
30
46
Unassigned
13
REG-009
Racking inspection
Safety
Unassigned
2 Feb 2027
30
71
Unassigned
14
15
16
A
B
C
D
E
F
1
Staff tickets
2
Licences and certificates, by staff ID. Names live in your payroll system, not here.
3
4
Staff ID
Role
Ticket
Expiry
Days left
Flag
5
STF-0003
Storeperson
Forklift licence (LF)
4 Aug 2027
254
6
STF-0004
Storeperson
Forklift licence (LF)
19 Dec 2026
26
Due 19 Dec
7
STF-0006
Driver
Medium rigid licence (MR)
11 Feb 2028
445
8
STF-0002
Warehouse manager
First aid (HLTAID011)
6 Jan 2027
44
9
STF-0007
Counter sales
First aid (HLTAID011)
22 May 2028
546
10
11
12
A
B
C
D
E
F
1
Obligations
2
Deadlines that come round every quarter or year.
3
4
ID
Obligation
Frequency
Next due
Responsible
Days left
5
OBL-01
BAS lodgement and payment
Quarterly
28 Feb 2027
Bookkeeper
97
6
OBL-02
Superannuation payment
Quarterly
28 Jan 2027
Bookkeeper
66
7
OBL-03
Workers compensation wage declaration
Yearly
31 Aug 2027
Owner
281
8
OBL-04
Stocktake
Yearly
30 Jun 2027
Warehouse manager
219
9
10
11
A
B
C
D
1
Summary
2
The figures the dashboard and weekly report read. All formulas. As at 23 Nov 2026.
Data problems found by formula. The dashboard shows no figures while a red check fails.
3
4
Check
Result
What to do
5
Rows with no expiry date
None
6
Rows with no responsible role
2 found
Choose a role for each; they show on the dashboard as Unassigned.
7
8
9
A
B
C
1
Lists
2
Dropdown values. Add to the bottom of a list; the dropdowns pick it up.
3
4
Type
Responsible
Frequency
5
Insurance
Owner
Monthly
6
Registration
Warehouse manager
Quarterly
7
Safety
Bookkeeper
Six-monthly
8
Equipment
Unassigned
Yearly
9
Licence
10
11
12
A
B
1
_meta
2
Hidden. Used by the dashboard and the upgrade tool to check which template this is.
3
4
Key
Value
5
Template
admin-and-compliance
6
Spec layers
base admin-and-compliance 1.0, vertical wholesale 1.0, client ridgeway 1.0
7
Template version
1.0.0
8
Style tokens version
1.0
9
Generated
20 Nov 2026
10
Last upgrade
-
11
Dashboard may read
Settings, Summary, Forecast, Benchmarks, Checks, and data tabs tagged readable
12
Personal data
Staff tickets tab: never read by the dashboard except as counts
13
14
15
Blue text, white: typed by youBlack text, grey: formula, lockedGreen text, grey: copied from another sheet, lockedBlack text, no fill: pasted from another systemTab colours: blue you type, ochre you paste, ink you read, purple checks, none for Read me and ListsClick any cell to see what it holds in the bar above the sheet.
Sales pipeline workbook, 11 tabs. This is how the Excel file looks. Click a tab name at the bottom to change sheet, and click any cell to see what it holds and where it comes from.
Ridgeway Sales pipeline.xlsx
A1fx
A
B
C
1
Ridgeway Trade Supplies: Sales pipeline
2
Read this first. It explains what the workbook is for and how to keep it up to date.
3
4
What it is for
5
Tracks the trade businesses you are trying to win as new accounts: who, what stage, and what happens next.
6
7
How to keep it up to date
8
1. Add each business you pursue to Organisations and everyone you contact to People.
9
2. Log every conversation within 24 hours in Conversations.
10
3. Give every open business a next step and a date. The Flag column shows what's overdue or missing.
11
4. Each Monday, type last week's hours on sales in the Summary's weekly table. Everything else fills itself.
12
13
Tab
Who uses it
What it holds
14
Settings
You type
As at date, stage list.
15
Summary
You read
Counts by stage and the weekly table (the tracker's Scoreboard).
16
Organisations
You type
One row per business you are pursuing.
17
People
You type
Everyone you contact.
18
Conversations
You type
One row per conversation.
19
Targets
You type
Weekly activity and new-account targets.
20
Examples
Made-up rows showing the format. Nothing here counts.
21
Checks
Checks
Data problems.
22
Lists
Dropdown values.
23
24
Cell colours
25
Blue text on white
Type here. These are the only cells you change.
26
Black text on grey
A formula. Locked so it isn't overwritten by accident.
27
Green text on grey
Copied by formula from another tab. Locked.
28
Black text, no fill
Pasted from Xero, MYOB or another system. Replace only by pasting a new export.
29
30
Sheets are protected with no password, so you can still sort, filter and resize columns. To change a formula, unprotect the sheet (Review, Unprotect Sheet), or ask us.
31
Pipeline stages and flags follow a proven layout: every open business always has a dated next step.
32
33
Prepared by Auxiliary Advisory
34
35
36
A
B
C
1
Settings
2
Set once at the start. The As at date drives every date formula in this workbook.
3
4
Setting
Value
What it does
5
Business name
Ridgeway Trade Supplies
Shown on every tab, the dashboard and the report.
6
As at date
23 Nov 2026
Every overdue, due soon and this-week formula uses this date. Clear it to use today.
7
Week starts
Monday
Weeks run Monday to Sunday, Sydney time.
8
Financial year starts
1 July
Used for year-to-date figures.
9
Warn when data is older than
10 days
The dashboard shows a stale-data warning after this.
10
Stages
See Lists
Target, Contacted, Meeting booked, Meeting held, Quote sent, Account opened, Not a fit, Lost.
11
12
13
A
B
C
D
1
Summary
2
Counts fill themselves from the other tabs. The only cells to type in are the blue hours cells in the weekly table.
3
4
Stage
Businesses
Est. monthly spend
Calculated from
5
Target
1
$1,500
=COUNTIFS(Organisations!E:E,A5)
6
Contacted
2
$3,900
=COUNTIFS(Organisations!E:E,A5)
7
Meeting booked
1
$2,300
=COUNTIFS(Organisations!E:E,A5)
8
Meeting held
1
$4,200
=COUNTIFS(Organisations!E:E,A5)
9
Quote sent
3
$15,800
=COUNTIFS(Organisations!E:E,A5)
10
Account opened
1
$2,600
=COUNTIFS(Organisations!E:E,A5)
11
Not a fit
-
-
=COUNTIFS(Organisations!E:E,A5)
12
Lost
1
-
=COUNTIFS(Organisations!E:E,A5)
13
14
Week starting
Contacts made
Hours on sales
Meetings held
15
26 Oct 2026
6
4
1
16
2 Nov 2026
9
5
2
17
9 Nov 2026
7
3
1
18
16 Nov 2026
8
6
2
19
20
21
A
B
C
D
E
F
G
H
I
J
K
1
Organisations
2
One row per business you pursue, with its stage and next step.
3
4
ID
Business
Trade
Suburb
Stage
Est. monthly spend
Owner
Next step
Next step date
Flag
Notes
5
ORG-0101
Harbour Hydraulics
Plumber
Parramatta
Quote sent
$6,500
Owner
Follow up the price list
20 Nov 2026
Overdue
6
ORG-0102
Sparkline Electrical
Electrician
Blacktown
Meeting held
$4,200
Sales rep
Send account form
24 Nov 2026
7
ORG-0103
Greenvale Builders
Builder
Penrith
Quote sent
$5,400
Owner
Call about the project schedule
18 Nov 2026
Overdue
8
ORG-0104
Precision Gasfitting
Gasfitter
Liverpool
Contacted
$1,800
Sales rep
Second email
26 Nov 2026
9
ORG-0105
Ironbark Maintenance
Maintenance
Fairfield
Meeting booked
$2,300
Sales rep
Site visit Thu
26 Nov 2026
10
ORG-0106
Summit Roofing
Roofer
Castle Hill
Target
$1,500
Sales rep
11
ORG-0107
Clearflow Drains
Plumber
Bankstown
Quote sent
$3,900
Sales rep
Chase signed account form
13 Nov 2026
Overdue
12
ORG-0108
Volt Brothers
Electrician
Campbelltown
Account opened
$2,600
Owner
First order check-in
1 Dec 2026
13
ORG-0109
Kestrel Fit-outs
Fit-out
Alexandria
Lost
-
Owner
14
ORG-0110
Northshore Hot Water
Plumber
Chatswood
Contacted
$2,100
Sales rep
No next step
15
16
17
A
B
C
D
E
F
1
People
2
Everyone you contact. Never read by the dashboard.
3
4
Person ID
Name
Organisation ID
Role
Introduced by
Added
5
PER-0201
Sam Example
ORG-0101
Owner
3 Nov 2026
6
PER-0202
Alex Example
ORG-0102
Director
30 Oct 2026
7
PER-0203
Jo Example
ORG-0103
Project manager
26 Oct 2026
8
PER-0204
Chris Example
ORG-0107
Office manager
22 Oct 2026
9
10
11
A
B
C
D
E
F
1
Conversations
2
One row per conversation, logged within 24 hours.
3
4
Date
Organisation ID
Type
Led by
Summary
Next step date
5
17 Nov 2026
ORG-0102
Meeting
Sales rep
Uses two suppliers now; wants next-day delivery to Blacktown sites.
24 Nov 2026
6
12 Nov 2026
ORG-0101
Call
Owner
Asked for trade pricing on copper and valves.
20 Nov 2026
7
8
9
A
B
C
D
1
Targets
2
The business's targets. Forecast scenarios and Benchmarks both read from here, so each target lives in one place.
3
4
Measure
Target
Set on
Used by
5
Contacts a week
8
1 Jul 2026
Summary
6
New accounts a quarter
4
1 Jul 2026
Summary
7
8
9
A
B
C
D
E
1
Examples
2
Made-up rows showing the format for each tab. Nothing here counts.
3
4
ID
Business
Trade
Suburb
Stage
5
ORG-9001
Example Plumbing
Plumber
Example suburb
Contacted
6
7
8
A
B
C
1
Checks
2
Data problems found by formula. The dashboard shows no figures while a red check fails.
3
4
Check
Result
What to do
5
Open businesses with an overdue next step
3 found
Update the next step and its date on Organisations.
6
Open businesses with no next step
1 found
Add a next step and a date.
7
Duplicate organisation IDs
None
8
9
10
A
B
C
D
1
Lists
2
Dropdown values. Add to the bottom of a list; the dropdowns pick it up.
3
4
Stage
Trade
Owner
Type
5
Target
Plumber
Owner
Call
6
Contacted
Electrician
Sales rep
Meeting
7
Meeting booked
Builder
Email
8
Meeting held
Gasfitter
Site visit
9
Quote sent
Roofer
10
Account opened
Fit-out
11
Not a fit
Maintenance
12
Lost
13
14
15
A
B
1
_meta
2
Hidden. Used by the dashboard and the upgrade tool to check which template this is.
3
4
Key
Value
5
Template
sales-pipeline
6
Spec layers
base sales-pipeline 1.0, vertical wholesale 1.0, client ridgeway 1.0
7
Template version
1.0.0
8
Style tokens version
1.0
9
Generated
20 Nov 2026
10
Last upgrade
-
11
Dashboard may read
Settings, Summary, Forecast, Benchmarks, Checks, and data tabs tagged readable
12
Adapted from
Auxiliary Advisory Pipeline Tracker, 11 Nov 2026
13
14
15
Blue text, white: typed by youBlack text, grey: formula, lockedGreen text, grey: copied from another sheet, lockedBlack text, no fill: pasted from another systemTab colours: blue you type, ochre you paste, ink you read, purple checks, none for Read me and ListsClick any cell to see what it holds in the bar above the sheet.
Financial model workbook, 21 tabs. This is how the Excel file looks. Click a tab name at the bottom to change sheet, and click any cell to see what it holds and where it comes from.
Ridgeway Financial model.xlsx
A1fx
A
B
C
1
Ridgeway Trade Supplies: Financial model
2
A monthly model over 60 months: what the business may look like if it hits or misses its targets.
3
4
How the model flows
5
1. Control sets the active scenario and the business's structure.
6
2. Assumptions holds every driver, one column per scenario. Only the What if column is for experimenting.
7
3. Actuals holds the pasted Xero profit and loss and balance sheet. Account mapping ties each Xero account to a model line.
8
4. Demand, Subscriptions, Supply plan, Purchasing and cash, Operating costs and Capital spending build the forecast.
9
5. The P&L, Balance sheet and Cash flow are linked. Funding and debt shows the gap if cash runs short.
10
6. Sensitivity, Valuation and Owner returns read the statements. Outputs feeds the dashboard and report.
11
7. Checks must be clear before any figure is relied on.
12
13
Roll forward at month end
14
Paste the month's Xero profit and loss and balance sheet into Actuals. On Control, move the first forecast month on by one. The month turns grey and its figures now come from Actuals.
15
16
Colours
17
Blue on white
An input. Change these.
18
Black on grey
A formula on this tab.
19
Green on grey
Linked from another tab.
20
Grey month header
An actual month. A thin rule marks the first forecast month.
21
22
Prepared by Auxiliary Advisory
23
24
25
A
B
C
1
Control
2
Set the active scenario and the business's structure. Every statement uses these.
3
4
Setting
Value
What it does
5
Active scenario
Base
Base, Target, Miss or What if. The statements show this one.
6
First forecast month
Nov 2026
Months before this are actuals.
7
Timeline
Nov 2025 to Oct 2030
60 months, monthly throughout.
8
Business structure
Company
Company, trust or sole trader. Sets how tax is shown.
9
Company tax rate
25.0%
Base rate entity rate. A setting: confirm with your accountant.
10
GST registered
Yes
Adds GST to receipts and payments and schedules BAS.
11
BAS frequency
Quarterly
12
Automatic overdraft
Off
Off: a cash gap shows as funding needed. On: the overdraft covers it up to its limit.
13
Cash buffer
$50,000
Lowest balance to hold.
14
15
16
A
B
C
D
E
F
1
Assumptions
2
Every driver, one column per scenario. Base, Target and Miss are agreed with you; What if is yours to change.
3
4
Driver
Base
Target
Miss
What if
Note
5
Demand
6
Sales growth on same month last year
4.0%
8.0%
(8.2%)
4.0%
Miss is Target less 15.0%.
7
Price change from 1 Jan 2027
-
2.0%
-
2.0%
8
Website share of sales
7.0%
7.0%
7.0%
7.0%
9
Returns, share of units
1.5%
1.5%
1.5%
1.5%
10
Margin and stock
11
Gross margin
33.5%
34.5%
32.5%
33.5%
From landed cost on Purchasing and cash.
12
Stock cover, months of next 3 months' cost of sales
2.5
2.2
2.8
2.5
13
Safety stock, months
1.0
1.0
1.0
1.5
14
Write-offs, share of stock a year
0.5%
0.5%
0.5%
0.5%
15
Working capital
16
Debtor days, account customers
41
30
51
35
17
Account sales, share of sales
35.0%
35.0%
35.0%
35.0%
The rest is paid at the counter.
18
Creditor days, local suppliers
30
30
30
30
19
Import supplier deposit
30.0%
30.0%
30.0%
30.0%
Balance paid on shipment.
20
Costs
21
Wages growth from 1 Jul 2027
3.5%
3.5%
4.0%
3.5%
22
Super guarantee rate
12.0%
12.0%
12.0%
12.0%
A setting. Current rate unverified.
23
Freight out and vans, share of sales
2.5%
2.5%
2.5%
2.5%
24
Exchange rate, AUD to USD
0.66
0.68
0.62
0.66
For Valvex Imports.
25
26
27
A
B
C
D
1
Account mapping
2
Ties each Xero account to a model line. Unmapped accounts show on Checks.
3
4
Xero code
Xero account
Model line
Statement
5
200
Sales, trade accounts
Sales, wholesale
P&L
6
205
Sales, counter
Sales, wholesale
P&L
7
210
Sales, online shop
Sales, website
P&L
8
310
Cost of goods sold
Cost of sales
P&L
9
477
Wages and salaries
Wages and on-costs
P&L
10
478
Superannuation
Wages and on-costs
P&L
11
469
Rent
Rent
P&L
12
449
Motor vehicle expenses
Freight out and vans
P&L
13
610
Accounts receivable
Receivables
Balance sheet
14
630
Inventory
Stock
Balance sheet
15
800
Accounts payable
Payables
Balance sheet
16
900
Equipment loan
Loan
Balance sheet
17
...
48 more accounts
18
19
20
A
B
C
D
1
Actuals
2
Xero profit and loss and balance sheet, pasted each month end. $000.
3
4
Xero account
Aug 26
Sep 26
Oct 26
5
Sales, all accounts
241
252
262
6
Cost of goods sold
160
168
174
7
Wages and salaries
36
36
36
8
Rent
12
12
12
9
Accounts receivable
115
121
125
10
Inventory
429
416
361
11
Accounts payable
141
126
98
12
Bank
143
162
190
13
14
15
A
B
C
D
E
F
G
H
I
J
K
1
Demand
2
Sales by channel and product group, ex GST, $000. Active scenario: Base.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Same month last year
-
-
-
251
219
156
226
245
232
Sales by month
7
Sales growth
-
-
-
4.0%
4.0%
4.0%
4.0%
4.0%
4.0%
Assumptions
8
Sales, wholesale
224
234
244
243
212
151
219
237
224
Last year x growth
9
Sales, website
17
18
18
18
16
11
16
18
17
Website share
10
Total sales
241
252
262
261
228
162
235
255
241
11
12
Copper fittings
83
87
90
90
79
56
81
88
83
Group share, last 12 months
13
PVC pipe
61
64
66
66
58
41
59
64
61
Group share, last 12 months
14
Valves
38
40
42
41
36
26
37
41
38
Group share, last 12 months
15
Hot water parts
27
28
29
29
26
18
26
29
27
Group share, last 12 months
16
Tapware
20
20
21
21
18
13
19
21
20
Group share, last 12 months
17
Other
12
13
13
13
11
8
12
13
12
Group share, last 12 months
18
19
20
A
B
C
D
E
F
G
H
I
J
K
1
Subscriptions
2
Switched off on Control: Ridgeway sells no subscriptions. The layout is shown for businesses that do.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
Subscribers
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Opening subscribers
-
-
-
-
-
-
-
-
-
Off
7
New subscribers
-
-
-
-
-
-
-
-
-
Off
8
Cancellations, first 3 months
-
-
-
-
-
-
-
-
-
Off
9
Cancellations, after 3 months
-
-
-
-
-
-
-
-
-
Off
10
Closing subscribers
-
-
-
-
-
-
-
-
-
Off
11
Average revenue per subscriber
-
-
-
-
-
-
-
-
-
Off
12
Subscription sales
-
-
-
-
-
-
-
-
-
Off
13
Cost to win a subscriber
-
-
-
-
-
-
-
-
-
Off
14
Lifetime value
-
-
-
-
-
-
-
-
-
Off
15
Months to earn back the cost to win
-
-
-
-
-
-
-
-
-
Off
16
17
18
A
B
C
D
E
F
G
H
I
J
K
1
Supply plan
2
Units for the top products. Orders are placed in the month stock is needed less the lead time.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
Units
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
25mm copper elbow
7
Opening
374
684
380
664
349
675
479
796
488
8
Arrivals
600
-
600
-
600
-
600
-
600
9
Sales
(289)
(302)
(314)
(313)
(273)
(195)
(282)
(306)
(290)
10
Write-offs
(1)
(2)
(2)
(2)
(1)
(1)
(1)
(2)
(1)
11
Closing
684
380
664
349
675
479
796
488
797
12
Safety stock
300
300
300
300
300
300
300
300
300
13
Order placed
-
600
-
600
-
600
-
600
-
14
Flag
15
Ball valve, 25mm (Valvex, 45 days)
16
Opening
207
330
208
321
195
325
247
133
250
17
Arrivals
240
-
240
-
240
-
-
240
-
18
Sales
(116)
(121)
(126)
(125)
(109)
(78)
(113)
(122)
(116)
19
Write-offs
(1)
(1)
(1)
(1)
(1)
-
(1)
(1)
(1)
20
Closing
330
208
321
195
325
247
133
250
133
21
Safety stock
120
120
120
120
120
120
120
120
120
22
Order placed
240
-
240
-
-
240
-
240
-
23
Flag
24
25
26
A
B
C
D
E
F
G
H
I
J
K
1
Purchasing and cash
2
Landed cost and when suppliers are paid, $000.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Purchases at landed cost
171
154
119
159
166
152
153
160
163
Cost of sales + stock change
7
Import deposits paid (30% at order)
9
9
8
7
8
9
9
8
9
Suppliers
8
Import balances paid (on shipment)
22
19
15
20
21
19
19
20
21
Suppliers
9
Local suppliers paid
140
140
126
99
131
135
124
126
131
Creditor days
10
Supplier payments
171
169
149
126
160
163
152
155
160
11
12
Landed cost, Ball valve 25mm
13
Supplier price, USD
$6.20
14
At 0.66 AUD to USD
$9.39
15
Sea freight per unit
$0.85
16
Duty, 5.0%
$0.47
17
Inbound handling
$0.30
18
Landed cost per unit
$11.01
19
20
21
A
B
C
D
E
F
G
H
I
J
K
1
Operating costs
2
$000, ex GST. Negative figures are costs.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Salaries
(32)
(32)
(32)
(32)
(32)
(32)
(32)
(32)
(32)
7 staff
7
Super, 12.0%
(4)
(4)
(4)
(4)
(4)
(4)
(4)
(4)
(4)
Assumptions
8
Workers compensation, 2.1%
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
Assumptions
9
Payroll tax
-
-
-
-
-
-
-
-
-
Below NSW threshold
10
Wages and on-costs
(36)
(36)
(36)
(36)
(36)
(36)
(36)
(36)
(36)
11
Rent
(12)
(12)
(12)
(12)
(12)
(12)
(12)
(12)
(12)
Lease
12
Other overheads
(7)
(7)
(7)
(7)
(7)
(7)
(7)
(7)
(7)
Run rate
13
Freight out and vans
(6)
(6)
(7)
(7)
(6)
(4)
(6)
(6)
(6)
2.5% of sales
14
Marketing
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
Run rate
15
Operating costs
(63)
(63)
(63)
(63)
(62)
(61)
(62)
(63)
(63)
16
17
18
A
B
C
D
E
F
G
H
I
J
K
1
Capital spending
2
Equipment purchases and depreciation, $000.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Warehouse racking
-
-
-
-
-
8
-
-
-
Typed
7
Depreciation
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
Straight line
8
Fixed assets, net
83
81
79
77
75
80
78
76
74
9
10
11
A
B
C
D
E
F
G
H
I
J
K
1
P&L
2
Profit and loss, $000, ex GST. Active scenario: Base (set on Control).
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Sales, wholesale
224
234
244
243
212
151
219
237
224
Demand
7
Sales, website
17
18
18
18
16
11
16
18
17
Demand
8
Total sales
241
252
262
261
228
162
235
255
241
9
Cost of sales
(160)
(168)
(174)
(174)
(151)
(108)
(156)
(169)
(160)
Purchasing and cash
10
Gross profit
81
84
88
87
76
54
79
85
81
11
Gross margin
33.5%
33.5%
33.5%
33.5%
33.5%
33.5%
33.5%
33.5%
33.5%
12
Wages and on-costs
(36)
(36)
(36)
(36)
(36)
(36)
(36)
(36)
(36)
Operating costs
13
Rent
(12)
(12)
(12)
(12)
(12)
(12)
(12)
(12)
(12)
Operating costs
14
Other overheads
(7)
(7)
(7)
(7)
(7)
(7)
(7)
(7)
(7)
Operating costs
15
Freight out and vans
(6)
(6)
(7)
(7)
(6)
(4)
(6)
(6)
(6)
Operating costs
16
Marketing
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
Operating costs
17
EBITDA
18
22
25
24
14
(6)
16
22
18
18
Depreciation
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
Capital spending
19
Interest
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
Funding and debt
20
Profit before tax
15
18
22
21
11
(9)
13
19
15
21
Income tax
(4)
(5)
(5)
(5)
(3)
-
(3)
(5)
(4)
Control
22
Net profit
11
14
16
16
8
(9)
10
15
11
23
24
25
A
B
C
D
E
F
G
H
I
J
K
1
Balance sheet
2
Month-end balances, $000.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Cash at bank
143
162
190
266
286
241
192
223
229
Cash flow
7
Receivables
115
121
125
125
109
78
112
122
115
Debtor days
8
Stock
429
416
361
346
361
405
402
392
395
Supply plan
9
Supplier deposits
9
9
8
7
8
9
9
8
9
Purchasing and cash
10
Fixed assets
83
81
79
77
75
80
78
76
74
Capital spending
11
Total assets
780
789
763
821
839
813
794
822
822
12
Payables
141
126
98
131
136
124
126
131
133
Creditor days
13
GST payable
20
27
24
31
35
33
16
23
17
BAS schedule
14
Income tax payable
11
16
9
15
17
17
7
12
8
15
Equipment loan
167
164
161
158
155
151
148
145
141
Funding and debt
16
Overdraft
-
-
-
-
-
-
-
-
-
Funding and debt
17
Total liabilities
339
334
292
334
343
326
297
311
300
18
Share capital
50
50
50
50
50
50
50
50
50
19
Retained profits
391
405
421
437
445
436
446
461
472
20
Equity
441
455
471
487
495
486
496
511
522
21
Check: assets less liabilities less equity
-
-
-
-
-
-
-
-
-
Must be zero
22
23
24
A
B
C
D
E
F
G
H
I
J
K
1
Cash flow
2
Cash flow, indirect method, $000.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
EBITDA
18
22
25
24
14
(6)
16
22
18
P&L
7
Change in receivables
(2)
(5)
(5)
-
16
31
(35)
(9)
6
8
Change in stock
(11)
13
55
14
(15)
(44)
3
10
(2)
9
Change in supplier deposits
-
-
1
-
-
(1)
-
-
-
10
Change in payables
-
(14)
(29)
33
6
(12)
1
5
3
11
GST collected less BAS paid
4
7
(4)
7
4
(1)
(17)
7
(6)
12
Income tax paid
-
-
(12)
-
-
-
(13)
-
(8)
13
Operating cash flow
9
23
32
80
24
(33)
(45)
35
11
14
Capital spending
-
-
-
-
-
(8)
-
-
-
Capital spending
15
Interest paid
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
Funding and debt
16
Loan principal repaid
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(3)
Funding and debt
17
Dividends
-
-
-
-
-
-
-
-
-
Owner returns
18
Net cash flow
5
19
28
76
20
(45)
(49)
31
7
19
Opening cash
139
143
162
190
266
286
241
192
223
20
Closing cash
143
162
190
266
286
241
192
223
229
21
Check: closing cash equals balance sheet
-
-
-
-
-
-
-
-
-
Must be zero
22
23
24
A
B
C
D
E
F
G
H
I
J
K
1
Funding and debt
2
Equipment loan, overdraft and covenants, $000.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Loan, opening
171
167
164
161
158
155
151
148
145
7
Interest at 7.4%
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
Opening balance x rate
8
Principal repaid
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(3)
$4,200 a month less interest
9
Loan, closing
167
164
161
158
155
151
148
145
141
10
11
Overdraft limit
100
100
100
100
100
100
100
100
100
Typed
12
Overdraft drawn
-
-
-
-
-
-
-
-
-
Automatic overdraft: Off
13
Cash above the buffer
93
112
140
216
236
191
142
173
179
14
Funding needed
-
-
-
-
-
-
-
-
-
Shown, not drawn
15
16
Covenant, last 12 months to Oct 2026
Result
Limit
17
Interest cover, EBITDA over interest
13.4x
3.0x
Met
18
Debt over EBITDA
0.9x
2.5x
Met
19
20
21
A
B
C
D
E
F
1
Sensitivity
2
EBITDA for the next 12 months (Nov 2026 to Oct 2027) as price and volume change together. Base case in the centre.
3
4
Volume change, price change across
(4.0%)
(2.0%)
No change
2.0%
4.0%
5
(10.0%)
$24,334
$74,871
$125,408
$175,945
$226,482
6
(5.0%)
$63,353
$116,698
$170,042
$223,387
$276,731
7
No change
$102,372
$158,524
$214,676
$270,828
$326,980
8
5.0%
$141,390
$200,350
$259,310
$318,270
$377,229
9
10.0%
$180,409
$242,176
$303,944
$365,711
$427,478
10
11
12
A
B
C
D
1
Valuation
2
What the business might sell for. Normalised earnings times a multiple leads; the DCF is a cross-check.
3
4
Normalised earnings, 12 months to Oct 2026
$
Note
5
EBITDA, last 12 months
$180,390
P&L
6
Owner's salary to market rate
($45,000)
Paid $95,000; a manager would cost $140,000
7
One-off legal costs added back
$12,000
Lease dispute, Mar 2026
8
Normalised EBITDA
$147,390
9
10
Value range
Low
High
11
Earnings multiple
3.0x
4.5x
Typical for small trade distributors; agree with an adviser
12
Enterprise value
$442,170
$663,255
13
Less net debt (net cash adds)
$29,069
$29,069
Balance sheet, Oct 2026
14
Value of the owner's shares
$471,239
$692,324
15
16
DCF cross-check
$
17
Discount rate
22.0%
Small private businesses carry high discount rates
18
Growth after year 5
2.5%
19
Value of five years' free cash flow
$224,037
20
Value after year 5
$166,870
21
DCF enterprise value
$390,907
Within the multiple range
22
23
24
A
B
C
D
E
F
G
1
Owner returns
2
Drawings, return on equity, and whether an investment pays back. The example is a fourth delivery van.
3
4
Investment case: fourth van
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
5
Cash flow after tax
($62,000)
$24,700
$24,700
$24,700
$24,700
$39,700
6
7
Result
8
Van cost
$62,000
9
Extra EBITDA a month
$2,400
10
IRR over five years
31.7%
11
Payback
30 months
12
13
Return on equity, last 12 months
22.0%
14
Owner drawings, last 12 months
-
15
16
17
A
B
C
D
E
F
G
1
Benchmarks
2
Ratios on the same definitions as each source, using Account mapping. Ranges invented for this demo, not ATO figures.
3
4
Ratio, last 12 months
You
Target
Range low
Range high
Source
Result
5
Cost of sales to turnover
66.5%
64.0%
60.0%
66.0%
Industry range
Above the range. Check supplier prices and discounts.
6
Labour to turnover
15.4%
15.0%
11.0%
17.0%
Industry range
Inside the range.
7
Rent to turnover
5.1%
5.0%
3.0%
6.0%
Industry range
Inside the range.
8
Average days to pay
41 days
30 days
33 days
44 days
Your last 12 months
11 days slower than target.
9
Stock turns a year
5.1
5.5
4.0
6.5
Industry range
Inside the range, below target.
10
11
12
A
B
C
1
Checks
2
Every check must be clear before a figure is relied on. The dashboard's Forecast view shows a warning while any fails.
3
4
Check
Result
What to do
5
Balance sheet balances, every month
OK
6
Closing cash equals the balance sheet, every month
OK
7
Actual months tie to the pasted Xero figures
OK
8
Every Xero account is mapped
OK
9
No negative stock in the supply plan
OK
10
Every scenario has every driver
OK
11
12
13
A
B
C
D
E
F
G
H
I
J
K
1
Outputs
2
The figures and series the dashboard and report read. $000.
3
4
Actual
Actual
Actual
Forecast
Forecast
Forecast
Forecast
Forecast
Forecast
5
$000
Aug 26
Sep 26
Oct 26
Nov 26
Dec 26
Jan 27
Feb 27
Mar 27
Apr 27
Source
6
Cash at bank, Base
143
162
190
266
286
241
192
223
229
Balance sheet
7
Cash at bank, Target
142
158
183
309
366
319
280
319
325
Scenario run
8
Cash at bank, Miss
148
183
222
254
235
188
131
147
151
Scenario run
9
EBITDA, Base
18
22
25
24
14
(6)
16
22
18
P&L
10
Funding needed, Base
-
-
-
-
-
-
-
-
-
Funding and debt
11
Stock, Base
429
416
361
346
361
405
402
392
395
Balance sheet
12
13
14
Blue text, white: typed by youBlack text, grey: formula, lockedGreen text, grey: copied from another sheet, lockedBlack text, no fill: pasted from another systemTab colours: blue you type, ochre you paste, ink you read, purple checks, none for Read me and ListsClick any cell to see what it holds in the bar above the sheet.