Personal Monthly Budget Builder

Create a tailored monthly budget spreadsheet outline for your income

Enter your income, fixed and variable expenses, and savings goals to build a structured monthly budget. Calculates total outgoings, surplus or deficit, and your savings rate, then exports clean Markdown or CSV. It runs free in your browser on Gera Tools, with nothing uploaded.

Last updated Source: Gera Tools

How is my monthly surplus calculated?

Surplus equals total income minus the sum of fixed expenses, variable expenses, and savings allocations. A positive number means money is left over; a negative number means you are overspending and the tool flags it.

Build a budget that actually balances

A monthly budget is simply a plan for every unit of income before the month begins. This builder lets you list income, fixed costs, variable spending, and savings goals, then does the arithmetic for you so you can see at a glance whether your plan balances. Each total recalculates as you type, and you can export the finished outline straight into any spreadsheet.

Why a written budget works better than mental arithmetic

Most people have a rough sense of their income and their biggest bills. The problem is the middle: small recurring subscriptions, irregular spending on social events, car costs that hit unpredictably, and the impulse purchases that feel harmless individually but accumulate. A written budget makes all of these visible in one place so there are no surprises mid-month.

The act of writing the plan also creates a reference point. Without a budget, any spending decision is evaluated in a vacuum. With one, each purchase can be checked against a plan you already agreed with yourself.

How the builder is structured

The tool groups your money into four buckets:

  • Income — net (after-tax) money arriving each month: salary, freelance earnings, rental income, side income, benefits. Use after-tax figures unless you are also tracking tax separately.
  • Fixed expenses — bills that stay roughly the same every month: rent or mortgage, loan repayments, insurance premiums, subscriptions, phone contracts.
  • Variable expenses — flexible spending that changes month to month: groceries, dining, entertainment, clothing, travel, hobbies. Estimate a typical monthly amount for each.
  • Savings and investing — amounts you plan to set aside. This is treated as a planned outgoing, not an afterthought.

The calculations

total outgoings = fixed expenses + variable expenses + savings

monthly result = total income − total outgoings
  (positive = surplus; negative = deficit)

savings rate = savings ÷ income × 100

A deficit is highlighted — the budget does not balance and something needs to change. The savings rate shows your progress against the 20% benchmark from the 50/30/20 rule.

Worked example

Take-home income: £3,200. Fixed expenses: £1,400 (rent £950, insurance £120, subscriptions £60, phone £40, gym £30, council tax £200). Variable expenses: £850 (groceries £350, transport £150, dining and social £200, clothing and personal £100, miscellaneous £50). Savings: £500.

Total outgoings: £1,400 + £850 + £500 = £2,750. Monthly surplus: £3,200 − £2,750 = £450. Savings rate: £500 ÷ £3,200 = 15.6%.

To reach 20% savings (£640), the variable spending would need to come down by about £140. The variable section is the most actionable lever because fixed bills are harder to change quickly.

Getting the most out of the export

Export the completed budget as CSV to import directly into Google Sheets or Excel, where you can track actual vs planned spending over multiple months. Or use the Markdown export to paste into a notes app or shared document. Build the template once in a good month, then make small adjustments each month rather than starting from scratch — the categories rarely change, only the amounts.

Everything runs in your browser. Your financial figures are never sent to a server or stored between sessions — close the tab and the data is gone, so export before leaving.