Financial dashboard: the month against budget, explained

Revenue, costs, margin and cash against budget each month, for a leadership team.

Live example

The example: Tinsmith Tea Co.'s December and full-year numbers

Month or year to date, variances in sentences

Tinsmith Tea Co.'s December and full-year numbers

Open the exampleThe names and numbers are made up.

What to notice

  • Revenue minus costs equals the profit shown, and one line spells it out: $594k of sales, less $297k and $217k, leaves $80k.
  • The twelve monthly bars add up to the year-to-date figures, $4,767k of sales and $467k of operating profit.
  • A cost under budget is mint, like a sale over budget: December's people costs, $11k under, share a color with online sales, $38k over.

The prompt that starts one like it

Here are our monthly actuals and budget: [paste revenue, costs and cash by month]. Make a financial dashboard as a single dark HTML page. Open with two sentences on the month. Show revenue, gross margin, operating profit and cash against budget, with a switch between the month and year to date, a twelve-month trend, and a sentence on each variance. Work every total out from the monthly figures. Say the data isn't live. Then publish it on sharable.link so only [leadership team's emails] can open it.

The finance pack most leadership teams get is a spreadsheet with forty rows and no opinion. This page has the other kind: a month and a year against budget on one screen, with the variances explained in sentences. Its numbers were typed in after the books closed. They aren't live data, and the dashboard says so beside the close date.

Who it's for

A finance lead, controller or founder who closes the books each month and sends the result to the few people who run the company. They want to know if the month was good, why it differed from plan, and if there's enough cash.

The data is written into the page, so it shows the month you closed and nothing after it. Readers who need today's bank balance, or want to click from a total down to an invoice, need accounting software with a live connection.

What a good one contains

  • The month in words first. The sample says December sales beat budget by $14k, profit fell $15k short, and why.
  • Four headline figures, no more. Revenue, gross margin, operating profit and cash. Each tile gives the variance and the budget it's measured from.
  • Sums that reconcile on screen. A bar splits each dollar of sales into cost of goods, operating costs and profit, with the subtraction written underneath.
  • Month and year to date on one switch. December alone looks like a miss. The year shows operating profit $28k ahead of budget.
  • Variances in sentences. Cost of goods ran $24k over: about $7k from selling more, and $17k of air freight on a late shipment. A table shows the gap. Only you know what caused it.
  • Colors that mean better or worse. Marketing over budget is amber and people costs under budget are mint, so nobody reads a rising cost as good news.
  • Cash as a bridge. Opening balance, profit, stock, equipment, loan repayments, closing balance. The year's low point, $411k in October, sits beside a stated floor of $350k.

One set of figures, worked out once

Paste the monthly figures in once and have every total, margin and variance calculated from them. Type the year-to-date tile separately from the monthly bars and one day they will disagree in front of the CEO.

The sample works in whole thousands, so $594k less $297k less $217k is exactly $80k. Mixed rounding leaves a column a thousand out, and a room that stops trusting the page.

Define your lines at the bottom: here, operating profit is before interest and tax. Add the close date, so nobody compares it with a bank balance from a week later.

How to send it

To named people. It shows margins, what you spend on people and the bank balance. Open it to the leadership team's addresses, and add a board member's when they ask to see it.

Every page you publish gets one link that opens in any browser. You choose who can open it: anyone with the link, anyone with the password, or only the people and company domains you name, who sign in with Google or Microsoft. Change the page later and the link stays the same.

Make yours in Claude

Add the connector once, then publish from any Claude conversation and get a link to send.

Add Claude Connector

Already have the file? Upload it here.

More in strategy and finance

  • Business plan: A one-page plan an owner sends to a bank, a landlord or a partner ahead of the full version.
  • SWOT analysis: Strengths, weaknesses, opportunities and threats for one organization, each backed by evidence.
  • Gantt chart: One project's tasks as bars across weeks, with owners, milestones and a line for today.
  • Executive summary: One screen that tells executives what a longer report found and what they're being asked to decide.
  • Timeline: Dated events in order, for a history people will enjoy or a project they have to follow.
  • Org chart: Who reports to whom in a small company, with teams, open roles and what each person looks after.
  • All use cases

Keep reading