← James M. Owens
Runs in your browser · nothing is uploaded

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.

Forest City Seniors Connect

Sample data · all figures invented

Budget vs. actual by line

Cumulative spend against phased budget

Variance by line

Variance table · click a line to drill down
Commentary · drafted from the numbers

    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.

    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.

    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.

    Static-budget variance = activity variance + spending variance. The activity piece is the cost of the decision to do more (or less) than planned; the spending piece is what the people running the events actually controlled. Holding an event coordinator responsible for an activity variance is a classic management-accounting mistake.

    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.

    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.