Profit drivers · this month vs last, in the order they hit the P&L
Driver
This month
Last month
Divisions
Revenue by division · rolling by month
Profit margins · by month
Efficiency · revenue per person, by role
Role
Headcount
Revenue per person
What's left over · income statement
This month
Last month
What we own and owe · balance sheet
This month
Last month
Score
Metric
This month
Last month
Profit & loss · as booked, accrual
Balance sheet · as of month-end
Statement of cash flows
These are booked figures straight from QuickBooks (accrual), rebuilt to the penny. Use "Save as PDF" for a copy.
Where the cash went · cash flow waterfall
Cash receivedCash spent
Cash drivers
Profitability · breakeven
What-if · change the mix, see what it does to profit
What this does. It answers two questions: what profit a given month's
work would produce, and how much work it takes to hit a profit you name.
Step 1, below. Every line of work you do, its size against a normal month, and what
is left after its direct costs. Both columns are typed over: they open on this month's actuals, which add to 100%.
Going over 100% is the point, not a mistake. To ask "what if we added a lot more reconstruction
without cutting back anywhere else", raise that one line and leave the others where they are. A total of
130% is a month with 30% more work in it.
Or work in dollars instead: the $ column is the same edit said the other way, and typing in
either one moves the other. For work that is not on the list at all, use
+ Add a line, name it, and give it its own dollars and margin.
Step 2. What a normal month is worth and what it costs to open the doors, the overhead and
interest paid whether or not the phone rings. Both open on the month you are looking at; switch to
Average of the last 3 months if that month was not typical. The averages are worked out in
dollars, so a big month counts for what it was worth.
Step 3, the two panels. Type in either one. The left turns a work figure into profit;
the right turns a profit target into the work it needs.
Nothing here is saved and nothing here changes your books. It is a scratchpad, and
Reset to this month's actuals puts it all back.
Step 1 · Your mix
Division
Share of production
$ per month
Gross margin
Blended
for work that is not in the mix yet
Step 2 · The two figures behind it
Base a normal month on
what 100% in the table means. The mix above scales it.
overhead + interest, what the month costs before any work
Step 3 · The reverse question
Everything above answers "what would this mix earn". This asks it backwards: name the profit you want and it solves for the work that gets there, at the same mix and the same fixed costs.
Start from a target
Type the net margin you need, here's the monthly production it takes.
Monthly production
Gross profit
Fixed costs
Net at that level
KPIs · every month, in order
Blank means the figure is not available for that month, most often because an input it needs was not supplied. Nothing is estimated to fill a gap.
Cash flow · QuickBooks Statement of Cash Flows
The next 12 months · money in the bank, month by month
Month by month
What this is built on
Forecast vs actual · by account; click a parent to open its detail
Account
Budget
Actual
Variance
Summary · budget vs actual
This month
Plan
Variance
Plan is a run-rate baseline, the average of the months before this one, until you set targets in the budget workbook, then it swaps to those. It is a single figure, so it does not yet reflect seasonality.
Cash runway · own cash carried forward at the recent trend