Budget vs. Actual Tracker
Compare planned budget against actual spending with visual charts
このツールについて
Set budget amounts for common spending categories such as housing, food, transport, entertainment, and more. Enter your actual spending for each category to see an instant visual comparison. A horizontal bar chart renders budget vs. actual side by side per category, colour-coded green for under budget and red for over. An overall summary shows total budget, total spent, and the variance as a percentage.
使い方
- 1 Choose a preset budget category or type a custom one.
- 2 Enter your planned budget amount for that category.
- 3 Enter your actual spending for the same category.
- 4 Repeat for all spending categories.
- 5 Review the bar chart: green bars are under budget, red bars are over.
- 6 Check the summary row for total budget, total spent, and overall variance.
Why "budget vs. actual" beats a plain budget
Writing a budget is the easy half. The half that changes behavior is the comparison: setting what you planned to spend in each category beside what you actually spent, then reading the gap. That gap is called variance, and it is the single most useful number in personal finance. A budget alone tells you your intentions; variance tells you the truth. This tracker keeps both columns side by side so a month's spending becomes a quick visual scan rather than a spreadsheet audit.
How variance is calculated
For each category the tool computes a dollar variance and a percentage:
- Variance ($) = Actual − Budget
- Variance (%) = (Variance ÷ Budget) × 100
A positive variance means you spent more than planned (over budget, shown in red); a negative variance means you came in under (shown in green). The sign convention is deliberately "over = positive" because the figure most people want to see is how much they blew past the limit. If a category's budget is zero, the percentage is shown as a dash, because dividing by zero has no meaning — you cannot be a percentage over a plan of nothing.
A worked example
Suppose your Food budget is $500 and you actually spent $560. Variance is 560 − 500 = +$60, and the percentage is (60 ÷ 500) × 100 = +12.0% — so the row turns red and reads "+$60.00 / +12.0%". Meanwhile your Transport budget of $300 saw only $210 of spending: variance 210 − 300 = −$90, or −30.0%, shown green. At the bottom, the summary sums every category. The tool ships with eight preset categories totalling a $2,950 monthly budget (Housing $1,200, Food $500, Transport $300, Savings $400, and so on). If your total actual came to, say, $3,010, the overall variance would be +$60, about +2.0% — useful because one category being over can be quietly offset by another being under.
Reading the chart correctly
Each category gets a horizontal bar where two layers overlap on the same track. A pale blue bar shows the budgeted amount; a colored bar drawn on top shows the actual amount — green when actual is within budget, red when it exceeds it. Crucially, every bar is scaled to the same maximum (the largest single budget or actual figure across all categories), so bar lengths are comparable across rows. A short red bar can still mean trouble: a $90 category that hit $180 is 100% over even though its bar is tiny next to your rent. Always read the percentage, not just the bar length.
Practical tips
- Add a "Savings" line and treat it like a bill. Budgeting savings as a category — and counting money moved to savings as "actual" spending against it — turns a vague goal into something you can be over or under on.
- Customize categories to match your statements. Use the "Add" row to create categories that mirror how your bank groups transactions, so filling in actuals is a copy job, not a reconciliation puzzle.
- Reset actuals each month, keep your budgets. "Reset Actuals" zeroes only the spending column and leaves your planned amounts intact, which is exactly what you want at the start of a new month. "Clear All" wipes everything for a fresh start.
- Watch the small categories. The biggest percentage overruns usually hide in low-budget lines like Entertainment or Clothing, where a single purchase can double the plan.
Common mistakes
- Confusing dollar variance with percentage variance. Being $60 over your $1,200 housing budget (5%) is minor; being $60 over a $100 budget (60%) is a real problem. The chart shows dollars, the row shows both — judge with the percentage.
- Setting budgets to what you hope rather than what you spend. A budget that is permanently red is not motivating, it is just wrong. Let last month's actuals inform next month's plan.
- Forgetting irregular costs. Annual insurance, holidays, and repairs do not fit a monthly grid. Reserve a category for them so a big quarter does not look like a failure.
Is my financial data private?
Yes. Your categories, budgets, and actuals are saved only in your browser's localStorage and computed on your device. Nothing is uploaded or transmitted, so your numbers persist across refreshes but never leave your computer. Clearing your browser data will erase them, so export important figures elsewhere if you need a permanent record.