Free monthly budget spreadsheet template: how to build a budget

Or try it now: use the free 50/30/20 monthly budget calculator to split take-home pay and, if you want, compare the plan with actual spending. It is an educational tool, not financial advice.

You can build this in a blank spreadsheet

You do not need a paid file to start a monthly budget. A blank workbook in Microsoft Excel, Google Sheets, or LibreOffice Calc is enough: one place for income, one for spending, a plan you write at the start of the month, and a space for what actually happened. The file stays on your computer and does not need a bank login. This guide covers the columns, a simple savings-rate formula, and the mistakes that usually make a first budget feel unusable after two weeks. If you later want the formulas already built, there is a workbook at the end. The method itself is free.

Decide what “a month” means

Pick a calendar month, or a cycle that starts on payday, and stay with it. Mixing the two — a rent due date from one cycle and a grocery total from another — makes the leftover figure hard to trust. If two people share the household, agree which file is the official one and when you will sit down with it. A budget that only one person sees tends to miss the other person’s cash spending.

Write the year and the month at the top of the sheet. Pick one currency for the whole file and convert occasional foreign amounts before you enter them.

List income first, then spending

Start with money that actually arrives this month: salary after tax and deductions if that is what hits the account, side income, benefits, and regular household transfers. If your pay varies, enter a cautious estimate in the plan column and the real figure later. Tax refunds and one-off gifts belong in the month they arrive, clearly labelled, so they do not look like a new normal.

Then list spending in two groups, because they behave differently:

• Fixed costs — amounts that are the same, or almost the same, each month: rent or a mortgage payment, insurance premiums that you pay monthly, a phone plan, a commute pass. If a cost is yearly or quarterly, either spread a monthly equivalent here or keep those bills in a household bills calendar and put only this month’s payment on the budget. Do not count the same bill twice.
• Variable costs — amounts that move: groceries, fuel, household goods, eating out, gifts, clothing. These are the rows you will adjust most often.

Subscriptions can live with fixed costs if they are predictable, or in their own list if you already track renewals separately. Bring only the monthly total into the budget so you are not maintaining two detailed catalogues of the same streaming services.

Treat savings transfers as a move, not a cost

When you move money from a checking account to a savings account, the household still has that money. If you also count the transfer as an expense, your leftover will look worse than it is, and your savings rate will be muddled. A clean approach is a separate group of rows for savings and debt payments you chose to make, sitting below expenses, not inside them.

Required debt payments are usually treated as expenses. Extra principal you choose to send can sit with savings transfers — be consistent, and do not put the same payment in both places.

A simple sheet layout

One working layout looks like this. Column A is the category name. Column B is the planned amount for the month. Column C is the actual amount. Column D is the difference (pick a direction and label it). You can repeat those plan/actual/difference blocks for each month of the year on a wide sheet, or put each month on its own tab.

Reserve one row for total income, one for total expenses, one for leftover (income minus expenses), and one for the savings rate. A commonly used savings-rate formula is:

• Savings rate = (income − expenses) ÷ income

If income is 4,000 and expenses are 3,200, the leftover is 800 and the savings rate is 20%. That arithmetic is only as good as the rows above it. If you forgot cash, or counted a savings transfer as an expense, the percentage will mislead you. If income is zero in a given month, leave the rate blank rather than dividing by zero.

Colour the cells you type into so you can see them at a glance, and leave formula cells in a quieter colour. You do not need charts on day one: a leftover figure and a plan-versus-actual column already tell you where a month went.

Plan first, then fill actuals

At the beginning of the month, fill only the plan column. Use last month’s actuals as a starting point, not as a rule. If a quarterly insurance premium falls due this month, the plan should show it; a “typical” month that ignores irregular bills will always look broken when those bills arrive.

During the month, or in one sitting at the end, fill the actuals from statements, receipts, and a cash note if you still use one. You are not building a forensic audit; you are trying to get close enough that the leftover figure feels true. A grocery row that is repeatedly over plan is information: the plan was hopeful, or a habit changed. A fixed cost that suddenly jumps is a prompt to check the bill. The file does not decide what you should cut. It only shows what you planned and what happened.

Common problems, and a calmer fix

• Too many categories. Twenty grocery sub-rows will be empty by week three. Start with a dozen or two you can actually fill, and split a row only if you keep needing the detail.
• Forgotten cash and person-to-person payments. If a category is always under its real life, add a weekly cash note.
• Mixing the household. A shared rent and a personal hobby can live in one file if you label who it belongs to. What does not work is leaving a housemate’s share off the income side but keeping the full rent on the expense side.
• Never closing the month. Pick a day and fill the last actuals. A budget that stays half-open is hard to compare later.

If you like a named rule for splitting needs, wants, and savings, the 50/30/20 budget rule can sit on top of this same sheet as a check, not as a replacement for your own categories.

Keep the file modest

You do not need to connect a bank. An ordinary .xlsx file is enough. Do not store passwords, PINs, or full account numbers in it. Back it up the same way you back up other household documents, and check sharing settings if you use Google Sheets.

This is an organizational habit, not financial, tax, or investment advice. Confirm amounts with your own statements, and speak with a qualified adviser if you need advice for your situation. The spreadsheet will not move money or pay a bill. It only records what you put in.