Project 02Management accounting
Budget vs.
Actual
Compare a club’s budget with its spending and see which events or expenses explain the difference.
When I was VP Finance, I tracked reimbursements and explained budget changes to our executive team. If we spent more on food, I wanted to know why. Did we run an extra event, or did each event cost more than we planned? I built this dashboard around that question, using a fictional club’s accounts.
- Inputs
- Phased budget, transaction log with status, events held (sample included; CSV import supported)
- Variances
- Static, flexible-budget, and the activity / spending split for event-driven lines
- Outputs
- KPI strip, three charts, variance table with drill-down, reimbursement log, auto-written commentary, CSV export
- Sample data
- Forest City Seniors Connect (fictional club), Sep 2025 – Apr 2026
- Privacy
- Static page, no server. Everything is computed in your browser; nothing is sent anywhere.
DashboardExpenses
Forest City Seniors Connect
Sample data · all figures inventedBudget: one row per line with Kind = expense or revenue, Type = fixed or per-event (with a Rate), and one column per month (YYYY-MM). Add a row named Planned events with Type = events. Transactions: Status is Paid, Approved, Pending or Rejected; Approved counts as spent, Pending and Rejected don't. If no events file is given, events held are counted from the distinct Event values in the transactions.
Budget vs. actual by line
Cumulative spend against phased budget
Variance by line
ReimbursementsClaims log
Volunteer expense claims
Much of a club's spending happens on a volunteer's own card first. A claim is reviewed against the expense policy and the budget line, approved, and then paid. Approved claims count as spent the moment they're approved, even before the money moves, which is why the dashboard tracks "committed" separately from cash.
ActivityEvents held
Planned versus held
Three of the eight budget lines are driven by how many events the club runs. When the executive added an event, those lines were always going to go over the static budget. The flexible budget re-prices them at the approved per-event rate for the number of events actually held, so the remaining variance is about spending, not activity.
The accountingWhy it works this way
Static budget, flexible budget
The static budget is the plan the executive approved in September: twelve events at $80 of refreshments each is $960. The flexible budget re-computes the plan for what actually happened: thirteen events at the same $80 is $1,040. Comparing actual spend to the static budget tells you whether you're over the plan. Comparing it to the flexible budget tells you whether you overspent given what you did. Both are true at once, and a good report shows both.
Favourable and unfavourable
For an expense line, spending less than budget is favourable (F) and more is unfavourable (U). For revenue it's the reverse. The dashboard uses that convention throughout, shows the sign explicitly, and never treats "favourable" as "good": an unspent contingency is favourable on paper and meaningless in practice, and an underspent marketing line may just mean the recruitment posters never went up.
Why the bottom line can lie
In the sample year, the club spends about $59 less than its $3,600 expense budget. That includes a $250 contingency it never used. Take that out and the other lines are about $190 over budget. Looking only at the total would hide the extra spending.
Phasing
I split the budget by month so the comparison reflects the club’s calendar. Food and transit costs follow the events. The volunteer dinner falls in April, while printing for the club fair falls in September.
Committed, not yet paid
If we approve a reimbursement on Monday and pay it on Friday, that money is already spoken for on Tuesday. The dashboard includes approved claims when it calculates the remaining budget and shows how much is still unpaid. Pending claims are listed separately.
Thresholds
Small differences usually don’t need a follow-up. The flags use two tests together, a percentage and a dollar floor, so a $3 variance on a $5 line and a 1% variance on a $1,000 line are both left alone. The defaults are 10% and $25, which is roughly the scale at which a student club's executive would ask a question.
How it's builtNotes
The dashboard reads your budget and transaction files in your browser. Select a line in the charts to see which transactions make up the total.
- Stack
- HTML, CSS, vanilla JavaScript, inline SVG
- Dependencies
- None (fonts from Google Fonts)
- Data handling
- Entirely client-side; nothing leaves the page
- Palette
- Budget and actual colours checked for colour-vision deficiency and 3:1 contrast on this background
- Sample
- Forest City Seniors Connect, a fictional student club. All names, vendors and figures are invented.