Key takeaways
- The template works out totals, what is left per category and the monthly balance: you only type in the yellow cells.
- It works in Excel, Google Sheets and LibreOffice, and asks for no email or sign-up.
- It includes a summary that compares your split with the 50/30/20 rule.
In this guide
A family budget does not need a complicated file. It needs three things: how much comes in, what you plan to spend it on and what you really spent. This template does that math for you.
Download the family budget template (.xlsx)
It is free, asks for no sign-up and works in Excel, Google Sheets and LibreOffice.
What is included
- Household income, with room for two salaries, other income and extra payments such as bonuses.
- 18 spending categories in three groups: needs, wants, and savings and debt.
- Planned, Actual and Difference columns for every row. When you go over in a category, the difference shows in red.
- Automatic totals per group and a monthly balance.
- A 50/30/20 summary showing what share of income goes to each group next to the guideline.
How to use it
- Enter the month and your net income, meaning what arrives after deductions.
- Fill in the Planned column. Assign your income across the categories until the planned balance reaches zero, so every unit of money has a job.
- During the month, fill in the Actual column with what was spent in each category. Once a week is enough.
- Check the Difference column. Positive is what is still available; negative is how far over you went.
- At month end, read the summary. If needs go past 50% or savings fall short of 20%, you know what to adjust next month.
You only type in the yellow cells. The rest are formulas.
Adapting it to your household
- Rename the categories you do not use to the ones you have: pets, childcare, gym.
- Add rows inside a group if you need more detail. Insert the row between two existing categories so the total includes it.
- Duplicate the sheet each month to keep a history and compare.
If you are not sure which percentages to start with, the 50/30/20 rule guide explains how to classify each expense.
Three common mistakes when budgeting in Excel
- Planning without tracking. A Planned column with no Actual column is a wish list.
- Forgetting non-monthly costs. Insurance, taxes, school fees and gifts come once or twice a year. Divide the amount by twelve and set it aside every month.
- Leaving the file on a computer nobody opens. If the budget is not at hand when you pay, it is out of date within two weeks.
If you would rather not use Excel
Two options with nothing to download:
- The family budget calculator builds the budget in your browser and lets you export it.
- If your spreadsheet keeps falling behind, an app on your phone lowers the effort. In Nidoo you log expenses by hand, with a photo of the receipt or from bank notifications, and you see how much you have used against the budget.
Common questions
Frequently asked questions
Is the template free?
Yes. It downloads directly, with no sign-up and no email required.
How do I open it in Google Sheets?
Upload the file to Google Drive and open it with Google Sheets, or from a new sheet use File > Import. The formulas are kept.
Can I change or add categories?
Yes. You can rename any category. To add one, insert a row inside its group and copy the formula from the Difference column; the group total picks it up automatically.
Does it work with any currency?
Yes. Cells use a number format with no currency symbol, so it works the same with dollars, euros, pesos or any other.