How to Create a Simple Household Budget Spreadsheet

This guide is for anyone who wants a clear picture of their household money but has never built a spreadsheet, or has started one and given up. You will build a simple monthly budget from a blank sheet, with income, fixed bills, everyday spending and savings, plus a few formulas that do the adding up for you. By the end you will have a reusable template you can copy each month in a few minutes. General information, not professional advice.

Why a Spreadsheet Beats a Notebook or an App

Budgeting apps are convenient, but many charge a subscription, want access to your bank login, or change their features without warning. A notebook is private, but it cannot add up for you or show you a trend. A spreadsheet sits in the middle: it is free, private, flexible and does the arithmetic automatically. You decide exactly what categories matter to your household.

You can use Google Sheets (free with a Google account, works in a web browser and on phones), Microsoft Excel (part of Microsoft 365, with a free web version at office.com), or Apple Numbers (free on Mac, iPhone and iPad). The steps in this guide use features that all three share. Menu names differ slightly; where they do, look for the closest match.

Gather Your Numbers First

Before you open a spreadsheet, spend twenty minutes collecting real figures. A budget built on guesses tends to fall apart in the first month. You need roughly the last two or three months of information so that irregular costs show up.

• Payslips or deposit records showing take-home pay (after tax and deductions)
• Any other regular income: benefits, child support, side work, rental income
• Bank and card statements for the last two to three months
• Bills for rent or mortgage, energy, water, phone, internet and insurance
• Subscriptions: streaming, apps, gym, memberships, software
• Loan and credit card minimum payments
• Annual or occasional costs: car tax, renewals, school fees, gifts, holidays

Use take-home pay, not your salary before tax, because that is the money you can actually spend. If your income varies from month to month, write down the lowest typical month. Budgeting on your low month means good months become a bonus instead of a trap.