Pick an industry

Revenue and margin

the shape of the year, and what the margin did while revenue moved

Revenue, cost and marginclick a bar to drill in, double-click for the lines

Revenue to net incomeevery step between the two

Cash and net incomemonth end bank balance against monthly net

Where the money comes from and goes

Account mixclick any card to filter to that account

Revenue accountsclick to filter

Direct cost accountsclick to filter

Overhead accountsclick to filter

The statements

The file runs 36 months, September 2023 through August 2026, so 2023 and 2026 are part years. Switch the statement to quarters or months to compare like for like.

Profit and lossclick a row to filter, double-click a cell for the lines

Balance sheetassets, then what is owed against them

Transaction mixlines in the current filter, click to filter

Which ones make money

revenue and direct cost are both coded to the same thing, so the margin below is real rather than allocated

Ranked by revenue, coloured by marginclick to filter every chart, double-click for the lines

Concentrationshare of revenue in the filter

The other sidetop 14 in the current filter

Month by month

Revenue heatmapdarker means a bigger month

Revenue by month, top fivestacked, everything else in grey

The numbers behind it

Profit and loss by unitclick a header to sort, click a row to filter, double-click for the lines

Timelineone unit, every line, by month

Click a row above.

The balance over time

revenue is what was billed. this tab is what cleared the bank, built from the same ledger lines, so the two always tie

Bank and card balances, month enddouble-click a point for that month's lines

Cash in against cash outbank accounts only, click a bar to drill

Who it moves between

Cash out by payeebank and card lines, click to filter

Cash in by sourcedeposits and receipts, click to filter

Revenue against all spendingby month, in the current filter. spending is direct cost plus overhead

What is owed on the balance sheet

Loans and notesprincipal outstanding, double-click for the entries

The aging

a snapshot of what is still open at the end of the file. it does not move with the filters, everything under it does

Aging by bucketsnapshot

Collection speed against the normdays, measured off this file

Payment behaviourdays to pay by month, darker is slower

Who is on the aging

Largest open balancessnapshot, top 15. click to filter, double-click for the lines

Open itemslargest first
NameRefDateBalanceDays past dueStatus

Vendor spendbills, checks and card charges by payee

Money received by customerpayments applied

Against the typical range

the band on each bar is the middle half of this file's own monthly readings, so the mark shows where the business sits inside its own history

Key measureseach one computed from the ledger

Thirteen months of each

Trend by measurethe last thirteen months in view

The tables

Month by monthlast eight months in view. click a row to filter to it

Year by yearclick a row to filter to that year

What stands out

Notes from the filewritten against this file, not a template

Build any cut

pick a row dimension, an optional column dimension, and dollars or line counts. every cell opens the lines behind it, and the filters at the top apply here too

Pivotclick a row label to filter, click a cell for its lines

Transactionsevery line in the current filter, sortable, 50 per page
Built by Turnkey CFO. Your dashboard is built from your own QuickBooks file and refreshes every close. turnkeycfo.com Get an instant estimate