Monthly Budget Calculator

Plan and track monthly recurring income and expenses with category percentage benchmarks and surplus alerts.

Detailed monthly cash flow analyzer. Input recurring monthly paychecks, rental housing costs, utilities, groceries, subscriptions, and discretionary spending to visualize your monthly spending breakdown and savings potential.

How this calculator works

Net Cash Flow = Net Monthly Inflows - Total Monthly Outflows. Category Allocation% = (Category Outflow / Total Inflow) * 100.

Key benefits

Assumptions & exclusions

Frequently asked questions

How much should I spend on housing each month?

A standard personal finance rule is that housing costs (rent or mortgage principal, interest, taxes, insurance, and utilities) should not exceed 28% to 30% of your gross monthly income.

What is the difference between the planned and actual columns?

The planned column is the month you intended: the amounts you assigned before spending began. The actual column is what really arrived and was spent. Comparing the two nets shows whether the month followed the plan or drifted from it, and by how much.

Why does my savings transfer reduce the net cash flow shown?

On this page every non-income row counts as money committed out of the month, including transfers to savings. The remaining figure is therefore the completely unallocated share of income — money with no job assigned yet — not the amount you saved.

How do I handle income that arrives twice a month?

Add the two deposits together and enter the monthly total on one income row, or give each paycheque its own row. Either way the engine totals them the same; what matters is that the income figure matches the money that actually lands in the month.

What should I do when one category overruns every month?

Treat a repeat overrun as information about the plan, not just about discipline. Either raise that row's planned amount honestly and fund the increase by trimming another row, or change the routine behind the spending. A limit missed twelve times is the wrong limit.

Can I use this page for a weekly budget instead?

Yes, if every figure you enter is weekly. The engine simply totals the rows you give it, so a consistent weekly set of planned and actual amounts works the same way. Mixing weekly spending rows with monthly income rows, however, makes every total meaningless.

Formula-Based Calculator · By QalcTools Editorial Team. Formulas tested against independent reference values · Content reviewed November 2026 by the QalcTools Editorial Team.

Methodology note: Standard household budget accounting and Consumer Expenditure Survey baselines.

Related calculators

Category: Budgeting & Money Management Calculators

About this calculator

A monthly budget only earns its keep when the plan meets the actual month: what you meant to spend, what you really spent, and the difference between the two. This calculator is a planned-versus-actual ledger for one month. You list income and spending rows — each with a category, a type such as need, want or saving, a planned amount and an actual amount — and the page totals everything live: income received, total outgoings, the month’s net surplus or deficit, how far the month drifted from its plan, and each category’s share of your income. It is built for the regular monthly check-in, not for a one-time forecast.

How it works

Start from the preset rows or edit them in place: every row carries a planned and an actual figure, rows can be deleted, and the add-item form appends new rows with a name, a category, a type and an amount. Rows typed as income are summed separately; every other type — need, want, saving and general expense — is summed as outgoings. The engine then compares the two columns: planned net against actual net, with the gap reported as the month’s variance, and it groups non-income rows by category to show what each area actually consumed as a share of the income that arrived. A toggle at the top re-displays the same monthly figures multiplied by twelve as an annual view.

The formula, explained

Net cash flow = Total income − Total outgoings; Month variance = Actual net − Planned net; Unallocated share = Net cash flow ÷ Total income × 100

The engine walks the row list once, adding planned and actual amounts into income totals for rows typed income and into expense totals for every other type, including rows typed saving — a transfer to savings therefore reduces net cash flow on this page rather than adding to it. Category totals are built only from non-income rows, and each category’s share is its actual total divided by actual income, rounded to one decimal. Net cash flow is income minus outgoings for each column; the headline variance is actual net minus planned net; and the unallocated share the engine reports (labelled a savings rate in its output) is net cash flow divided by income. All money figures are rounded to cents. The annual toggle is display-only: the view multiplies the monthly results by 12 and the engine itself never sees annual figures.

Inputs and variables

VariableMeaningExample
Income Rows (Planned and Actual)Each source of money for the month, entered twice: what you expected and what actually arrived. A side income shortfall shows up here before it shows up as overspending.Salary $4,800 planned and actual; side work $400 planned, $350 actual
Planned Amount (per row)The amount you assigned to a row before the month began. This column is the plan the month is judged against, so it should be set deliberately, not copied from last month’s actuals.Groceries planned at $600
Actual Amount (per row)What really came in or went out on that row. Updating actuals during the month, rather than after it, is what turns this page from a record into a control.Groceries actual $645
Row Type (Income, Need, Want, Saving, Expense)The type decides the arithmetic: income rows add to income, and every other type adds to outgoings. Saving rows are treated as money committed out of the month, like a bill you pay yourself.Rent as a need; dining out as a want; a savings transfer as saving
CategoryThe grouping used for the breakdown, such as Housing or Groceries. Rows sharing a category name are combined, and the breakdown reports that category’s actual share of income.Housing at 31.1% of income in the worked example
Period View ToggleA display switch between monthly figures and the same figures multiplied by twelve. It changes presentation only — the amounts you type are always monthly amounts.Annual view shows the $1,110 monthly surplus as $13,320

Worked example

A household plans a month on $5,200 of expected income — a $4,800 salary plus $400 of side work — and the month actually delivers $5,150, with side work at $350. Spending rows cover rent, utilities, groceries, transport, dining, subscriptions and a savings transfer, with actuals drifting modestly from plan in both directions.

  1. Planned position: income $5,200 minus planned outgoings of $3,990 gives a planned net of $1,210 — an unallocated share of 23.3% of planned income.
  2. Actual income: $4,800 + $350 = $5,150. Actual outgoings: $1,600 + $310 + $645 + $405 + $390 + $90 + $600 = $4,040.
  3. Actual net cash flow: $5,150 − $4,040 = $1,110, an unallocated share of 21.6% of the income that arrived.
  4. Month variance: $1,110 − $1,210 = −$100. The month finished $100 behind its plan: $50 of missing side income plus $50 of net extra spending.
  5. Category lens: housing took 31.1% of actual income and groceries 12.5%, while dining ran $90 over its plan — the single largest spending overrun.

Planned net of $1,210 on $5,200 of income versus an actual net of $1,110 on $5,150, a month variance of −$100, and unallocated shares of 23.3% planned and 21.6% actual.

A −$100 variance on a $5,150 month is a near-hit, and the breakdown shows it was not caused by one blowout: a $50 income shortfall, $90 of extra dining, and smaller drifts in utilities and groceries were partly offset by spending less on transport and transferring $100 less to savings. That last point deserves honesty — part of the plan was met by saving less, which keeps the month looking calm while quietly slowing the goal the savings row exists for. Next month’s plan should restore the transfer and trim dining, rather than simply re-baselining both.

Understanding your results

Read the variance before the surplus. A positive net figure feels like success, but the variance tells you whether the month obeyed the plan or merely got lucky — a surplus delivered by higher-than-expected income while every spending row overran is a warning wearing a good costume. The category shares then show where the month structurally sits: in the example, housing at about 31% of income is the fixed fact of this budget, and everything flexible has to fit around it.

Understand what the unallocated share is and is not. Because saving rows count as outgoings in this engine, the percentage reported is the share of income left completely unassigned at month end — money with no job yet. A household can show a modest figure here while still saving steadily through its saving rows, and a household can show a high figure while saving nothing at all. Decide which of those you are before celebrating or worrying about the number.

Assumptions and limitations

The ledger is only as complete as the rows you give it: cash spending, small card purchases you forget to log, and fees taken directly from accounts never appear unless you add them, so a tidy surplus can coexist with a shrinking bank balance. The engine treats the month as one undated block — it knows nothing of timing, so it cannot warn you that three bills land before payday even when the monthly totals balance. It also annualizes nothing on its own; the annual view is the monthly picture times twelve, which flatters irregular months and hides seasonal ones. Use the page as a monthly reconciliation habit, and check its bottom line against your real account balances, which remain the final authority.

Common mistakes to avoid

Sources

Related guides