Growth & scenario
volume and priceGrowth is applied to bins per week, not revenue, so dump cost and capacity scale with it. Price inflation is applied to the ticket price separately.
Enter today's numbers
Bins sold today
Bins collected today
Dumping & revenue
m³ across all tips
$ paid to tips
$ inc GST
optional — excess weight, upgrades
truck drivers only
Yard position
Opening count, less every bin sold, plus every bin collected since that date. Correct the opening count whenever you do a physical stocktake.
Recent entries
Revenue · 7 working day average
$0
Gross profit bridge · 7 working days
Window
Click any line on a chart for its calculation.
Top customers
From Xero invoices. One invoice is counted as one bin until job-level data is available, so bin count is an approximation.
Operating drivers
what the forecast is built fromThese drive revenue and dump cost in the model. Each driver has its own Actual and Revert buttons — Actual takes the figure straight from the tracker, Revert puts back what was last saved to the Sheet. The two buttons underneath do the same thing to every driver at once. Nothing is overwritten without you clicking.
Cost categories
how lines group in the P&LAdd whatever categories suit the business. Where it lands decides the treatment: Cost of sales sits above gross profit, Staff attracts payroll tax and wage inflation, Operating expense gets overhead inflation. Each category is its own line in the P&L.
Cost lines
Enter the amount as it appears on the bill and pick the tax rate, using the same names your accountant sees in Xero. Amounts are works exactly like Xero's setting and applies to the whole table. The P&L always reports ex GST; the tax rate decides what is claimable and feeds the BAS position in the cash flow.
Tax, GST & working capital
Australian settingsFleet on hand
drives the yard position
FY2026 actual
FY2027–29 forecast
Setup — Xero account mapping
The list below is the accounts still waiting for a home. Once you assign one it drops off the list. An account can only go to one place, so nothing can be counted twice. Leave anything irrelevant on not used and it will drop off too. Nothing changes in the model until you flick the switches.
Scenario
applies to the three statements below
Profit & loss
ex GST · click any line label to edit its formulaCash flow
indirect methodBalance sheet
as at 30 JuneClosing cash
projected bank balance at 30 JuneRevenue & EBITDA
FY2026 actual, then forecast
Revenue
EBITDA
CAPEX schedule
capitalised, depreciated, and cash-flowedUnlike the original workbook, capex here becomes a fixed asset and is depreciated from the year it is bought.
Financial liabilities
Every facility amortises on its own terms. Set Drawn to a future year and the money arrives as cash that year — that is how you fund a truck. A facility with a zero annual payment (a director loan) simply sits there and accrues nothing.
Depreciation schedule
applied to the whole register
The register is editable. Cost is what it was bought for, WDV is the written-down value carried into FY2026, and Rate is the annual depreciation rate.
Equity schedule
retained earnings roll-forwardCapital introduced and dividends can be set year by year. Leave a dividend blank and the yearly figure from the Assumptions tab is used instead, capped at the profit available so retained earnings cannot be driven negative.
Google Sheet backend
source of truthPaste the Apps Script web app URL from your deployment. Every submit writes a row to the sheet; assumptions save as a JSON blob on a second tab. The sheet stays readable and exportable if you ever move platforms.
Deploy › New deployment › Web app › Execute as me › Anyone
Remembered on this device only — never written to the sheet
Not connected
Xero
not connectedThe Google Sheet holds the Xero keys, not this file. It refreshes every 24 hours on its own; Sync now forces it early.
Import from Xero
paste or uploadNo API and no app registration. Run the report in Xero, select the whole table, copy, and paste it in below — or upload a CSV. Everything downstream behaves exactly as it would with a live connection.
CSV or tab separated
Check the columns
These are best guesses from the headings. Correct any that are wrong, then import.
Offline backup
works with no connectionDownloads everything — entries, assumptions, cost lines, capex, overrides — as a single JSON file. Import restores the exact state.