Home›Money›Budget guide

Monthly Budget Template: Every Category, With a Filled-In Example

The complete category template shown blank and filled — one household, $5,200 of take-home, every line summed and every share computed.

10 min readUpdated October 2026Budget Calculator

A template earns its keep only when someone has filled it in. This article is a complete monthly expenses template — every category a household budget needs, with guideline thinking behind each line — shown twice: once blank, as structure, and once filled in for a stated household on a stated income, every line summed and every share computed. Treat it as your personal monthly budget template: copy the rows, replace the numbers with yours, and the template becomes your budget. It works identically as paper, as a spreadsheet, or typed straight into the calculator this article hangs off.

Key takeaways
  • The filled template sums exactly to the household’s $5,200 take-home — a template that doesn’t sum teaches arithmetic you’ll have to unlearn.
  • Paper, spreadsheet and browser versions are the same rows re-sorted: categories answer “where”, due dates answer “when”, planned-vs-actual answers “how did we do”.
  • Savings sits mid-table at 6.5% and the sinking-funds line pre-pays $1,920 a year of lumpy bills — the two lines that make the template survive.

The filled-in example

The household: two earners, one child in part-time care, a moderate-rent city, combined take-home pay of $5,200 a month. Here is their month, complete:

CategoryAmountShare of take-home
Housing (rent or mortgage)$1,56030%
Utilities$2404.6%
Groceries$65012.5%
Dining out$2003.8%
Transportation$4709%
Insurance$3206.2%
Health$1803.5%
Childcare & school$4007.7%
Debt minimum payments$2204.2%
Entertainment$1502.9%
Shopping & personal$2304.4%
Giving$801.5%
Sinking funds$1603.1%
Savings$3406.5%

Three features make this a template worth copying rather than a photograph to admire. First, it sums: the lines add to exactly $5,200, because a template that does not sum teaches arithmetic you will have to unlearn. Second, savings is a line in the middle, at 6.5% here — modest, deliberate, and senior to the shopping line that sits above it. Third, the buffer is honest: the sinking funds line pre-pays the year’s lumpy bills, so the emergencies this budget cannot see are the only ones the emergency fund will meet. Photocopy the structure and the shares will move to fit your life; the summing and the ordering should not.

How to fill it in, line by line

The template fills in a strict order, and the order is the method. Income first, from the payslip, take-home only. Fixed lines second, copied from the bills themselves — rent, premiums, minimums — never estimated, because a guessed fixed line corrupts every percentage below it. Flexible lines third, and these come from evidence: your last three months of statements. This household’s groceries line is the worked example — the three months read $612, $688 and $655, an average of $652, written into the template as $650. The first month you fill in will feel slow because you are excavating; from the second month on, you are updating, and it takes minutes.

Two conversions recur while filling. Non-monthly bills become monthly lines by division: a $189 quarterly water bill is $63 a month, a $1,140 annual insurance premium is $95 — both belong in the template at their monthly slice whether or not this is the month they land, which is precisely what the sinking funds line exists to hold. Weekly habits convert by × 52 ÷ 12, not by × 4: a $35 weekly cost is $151.67 a month, and the × 4 shortcut — which would say $140 — quietly under-budgets fifty-two weeks into forty-eight, a $140-a-year error in a single line. Fill every line with its true monthly weight and the template’s total becomes the first honest number in the household’s finances.

A month in the life of this template

Templates are usually abandoned in week two, so here is week two, worked. Mid-month, this household checks the difference column and finds groceries at $355 spent of the $650 planned — 55% of the line gone at 50% of the month, a projected $710 finish and a $60 overrun in the making. The template’s response is boring, which is its virtue: move $60 from a line that is running cold — dining out, at $70 spent of $200, gives up $60 without pain — and write both edits down. Groceries now plans $710, dining $140, the total still sums to $5,200, and the overrun has been absorbed by a decision instead of discovered by an overdraft. That ten-minute, mid-month correction is the difference between a template and a budget: the template records the month, the budget steers it. By month’s end the actuals column becomes next month’s evidence — the groceries line, having finished at $705, is next written in at $700, and the template quietly becomes a portrait of this household rather than of a textbook one.

One template, every format it gets asked for

Readers ask for this table under half a dozen names, and it is worth saying plainly that they are all the same object. Kept in a spreadsheet with Planned, Actual and Difference columns beside the amounts, it is a monthly expenses spreadsheet — the format we recommend for the weekly review, because the difference column shows the month’s drift while there is still time to correct it. Printed and kept on the fridge, the identical rows become a free printable budget planner: planned figures in pen, actuals in pencil, one sheet per month in a folder that becomes your financial memory. Run in a browser instead, with the sums done for you and the percentages live, it is an online budget planner — our hub page is exactly this table with a calculator attached, which is why the category order matches. And for households whose month is organised around due dates rather than categories, the same lines re-sorted by payment date become a bill planner — a monthly bill planner view of the identical money. The rows do not change. Only the sorting does, and the sorting should follow the question you are asking: where does it go (categories), when does it leave (bills), or how did we do (planned versus actual).

The names are many; the rows are the same

Call it a money planner, a budgeting planner, a financial worksheet or a free budget worksheet — the marketplace of names is wide because the need is universal, and budget planners as a category mostly differ in decoration. Strip the decoration and every honest version contains what this table contains: income at the top, fixed lines before flexible ones, savings as a line, irregular bills converted to monthly slices, and a total that must equal the income. Judged by that standard, the best free online budget planner is whichever one you will still be opening in month six — which is why this article keeps returning to paper and spreadsheets: a digital budget planner you abandon in March loses to a fridge sheet you keep until December, every single year.

Adapting it: households differ, the skeleton doesn’t

This filled example doubles as a family budget template because the household includes a child — note the childcare line at $400 (7.7%) and how the entertainment and shopping lines bend to accommodate it without savings moving. Your adaptation follows the same rule: add the lines your life has (a second car, a parent’s support, a business’s lean months), delete the lines it does not, and never delete savings or the buffer to make the total fit — shrink the flexible lines instead, in the open, where you can see the decision. If your income is irregular, fill the template at your lowest recent month’s figure and let better months overflow into the buffer line; the skeleton holds at any income because it is a list of decisions, not a set of amounts. A monthly budgeting template — one more name for this same object, a monthly budget worksheet in its paper form — succeeds precisely when it stops looking like our household and starts looking like yours, one honest line at a time.

When your column won’t sum to your income

Your first fill will probably total more than you earn — nearly everyone’s does, because the statements tell the truth that the guesses hid. Close the gap in the template’s own order. First the flexible lines, trimmed to what the evidence says you can hold, not to what would be admirable: a groceries line you have never once met is not a plan. Then the subscriptions and the small autopay lines, audited one by one — this is where templates find their easiest hundred dollars. Then, and only then, look at the structural lines, knowing they move slowly: housing at the next lease, the car at the next change. If the column totals less than your income, the template has the opposite instruction, and it is just as firm: name the surplus. An unassigned remainder is next month’s mystery spending; assigned to savings, a sinking fund or a deliberate pleasure, it becomes part of the plan. Either way, the column must sum. A template whose total is “about” the income is a wish in table form.

What follows is a monthly budget template free of sign-ups, downloads and decoration: the table above, the sums checked, the method attached. Everything else is your numbers.

Frequently asked questions

Can I copy this template into a spreadsheet?

Yes — that is what it is for. Type the category rows into your sheet in the same order, keep the Planned / Actual / Difference columns beside them, and the copy becomes your working budget. The order matters more than the tool: fixed lines first, flexible lines estimated from statements, savings as a line of its own, and a buffer at the end. The table on this page is the template; your numbers are the budget.

How is a budget worksheet different from a budget?

The worksheet is the working surface; the budget is the decision it records. On paper, the worksheet is the printed table you fill in during the month — planned amounts on the left, actuals pencilled beside them. The budget is the set of decisions those numbers represent. People who “have a budget” but never fill a worksheet usually have a decision they made once, in January, and no surface on which the year can argue with it.

Should every household use the same percentages?

No. The shares printed here belong to this household: two incomes, one child in care, a moderate-rent city. A single renter in an expensive city will run housing far above 30% and childcare at zero; a mortgage-free household may run housing under 15%. The template’s value is the category list and the discipline of summing to your own income — the percentages are a photograph of one household, not a standard to be graded against.

What goes in the sinking funds line?

Monthly slices of bills that arrive less often than monthly: annual insurance premiums divided by twelve, property tax, car repairs, holidays, annual subscriptions. In the filled example the line is $160 a month, which quietly pre-pays $1,920 of the year’s lump sums. Anything you can name and date belongs here rather than in the emergency fund, which is reserved for the bills nobody can name in advance.

Do I need a separate template for irregular income?

The same template, filled differently: build the lines to fit your lowest recent month, not your average month, and let good months overflow into the buffer line first. The category list does not change; the sizing rule does. Our Budget Calculator guide works a six-month irregular example end to end if you want to see the method before adapting the template.

This template with a live calculator attached — totals and percentages done for you: the Budget Calculator.

Related guides
↑

Similar Posts