BBrightbench
Small-business owners, bookkeepers and freelancers

BudgetBook

Budget vs actual and the KPIs that matter, in 10 minutes a month.

BudgetBook is an Excel workbook that turns a yearly budget and monthly actual totals into a profit & loss by month, line-by-line variances marked favourable or unfavourable, a full-year profit outlook and a KPI dashboard with customer churn and cash runway.

Buy BudgetBook — $12

Instant download · one-time payment · 30-day refund if it doesn't work as described

BudgetBook cover

What it does

Monthly P&L

Actual, budget and variance by month, year to date and full year.

Variance report

Every line for any month and year to date, marked Favourable or Unfavourable.

Full-year outlook

Actuals for closed months plus budget for the rest of the year.

KPI dashboard

Revenue vs budget, gross margin, net profit, churn, revenue per customer, cash runway.

Where to look first

The five biggest unfavourable variances by profit impact.

Data checks

Untyped or duplicate lines, actuals in months not closed, stray amounts, missing metrics.

Screenshots

KPI dashboard with revenue and profit charts
KPI dashboard with revenue and profit charts
Variance by line, month and year to date
Variance by line, month and year to date
Monthly P&L: actual, budget and variance
Monthly P&L: actual, budget and variance
Monthly actuals entry
Monthly actuals entry

Requirements

  • Microsoft Excel 2010 or later
  • Tested in Microsoft Excel for Windows (Microsoft 365)
  • No macros or add-ins
  • Google Sheets, LibreOffice and Numbers not tested

Honest limitations

  • Does not connect to accounting software — enter monthly totals from your P&L report.
  • One financial year and one currency per workbook.
  • Net profit is an accounting figure, not cash flow.

FAQ

Does my financial year have to start in January?

No. Set the first month of your financial year in Settings; every sheet follows it.

How is cash runway calculated?

Cash at bank divided by the average monthly net loss of the last 3 months. If that average is a profit it shows "Profitable".

How many lines can I budget?

30 lines, each typed as revenue, cost of sales, operating expense, other income or other expense.

BudgetBook — $12, one-time

Version 1.0.0. Delivered instantly by Gumroad after payment. Questions before buying? Email altaitoondev@gmail.com.

Buy BudgetBook — $12