This free monthly budget template lists your income and every planned cost in one place, shows how much is left to assign, and lets you download the result as a spreadsheet for Excel, Google Sheets or Numbers. You can also download a blank copy to fill in later or print.
What the template includes
The template works as a simple monthly expenses list grouped into income, needs, wants and goals:
| Group | Lines |
|---|---|
| Income after tax | Pay after tax; other income after tax |
| Needs | Rent or home payment; utilities; groceries; transport; insurance; phone and internet; minimum debt payments; childcare; health costs |
| Wants | Subscriptions; dining out and takeout; entertainment and hobbies; personal care; gifts and giving; shopping and other |
| Goals | Emergency fund; savings goals; extra debt payments |
Leave any line blank if it does not apply. For costs the template does not name, such as pet care or annual fees, the list of budget categories shows where they usually fit.
How to fill in the template
- Start with income you actually receive after tax this month. If your pay varies, use a cautious figure.
- Fill in needs from your most recent bills and statements rather than from memory.
- Add wants at the level you really spend, then decide what to change.
- Give your goals an amount, even a small one.
- Adjust until the amount left to assign is zero or a little above.
If this is your first budget, the step-by-step guide to how to make a budget explains each step in more detail.
Example: Priya’s monthly budget
Priya is hypothetical. This teaching example uses US dollars, not typical costs or an affordability recommendation.
Priya’s take-home pay is 2,900 and side work adds 300, so income is 3,200. Needs come to 2,260: rent 1,100, utilities 160, groceries 420, transport 200, insurance 140, phone and internet 90 and minimum debt payments 150. Wants come to 340: subscriptions 35, dining out 120, entertainment 60, personal care 45, gifts 30 and other shopping 50. Goals are 450: 200 for the emergency fund and 250 toward a savings goal. The plan totals 3,050, leaving 150 to assign. Priya can add it to a goal or keep it as a buffer for next month.
Open your budget in Excel or Google Sheets
Both downloads are CSV files, a plain spreadsheet format that most spreadsheet apps open directly:
- Excel: double-click the downloaded file, or use File, then Open, and choose it.
- Google Sheets: open a new spreadsheet, choose File, then Import, upload the file and select it.
- Numbers: open the file from your Downloads folder.
To keep a paper copy, open the blank template in any of these apps and print it from there. Once the file is in your spreadsheet, you can add rows, rename categories or add your own formulas.
Needs, wants and goals
The template groups costs the same way as the 50/30/20 budget calculator and shows each group as a share of income. In this hypothetical example, needs are 70.6% of income. That describes these inputs only; it does not establish what is typical or affordable. The shares are information, not a pass or fail mark.
Using the spreadsheet download
The download is created in your browser from the numbers on screen, so nothing is uploaded. Text that a spreadsheet could treat as a formula is saved as plain text.
The download includes working formulas. Each section total adds up its own rows, Planned adds needs, wants and goals, and Left to assign subtracts Planned from income, so changing an amount in Excel, Google Sheets or LibreOffice updates every total. The blank template has the same formulas. The form has fixed categories; in the spreadsheet, insert new rows inside a section so its total includes them. Downloaded files remain on your device and need your own protection. Enter all income and costs in the same currency: Display currency changes labels only, and the CSV amounts do not include a currency code.
A positive remainder is still unassigned money, not guaranteed savings. Name its purpose and check bill dates; monthly totals alone do not show whether money is available before payday. Keep existing reserves separate from new income, and do not count a transfer between your own accounts as new income or a second expense. This template is general education, not personalized financial advice.
If you are paid weekly or every two weeks
The template is monthly, so convert your pay first. Multiply weekly pay by 52 and divide by 12, or multiply pay every two weeks by 26 and divide by 12. For example, 700 a week and 1,400 every two weeks both come to about 3,033.33 a month. Months with an extra paycheck then give you money to assign to a goal.
Where the method comes from
Need help preparing your income line? Use the salary to hourly calculator for gross-pay comparisons, then use your actual take-home pay in this budget. For the grocery line, the unit price calculator helps compare package costs. A 52-week savings challenge can give a weekly saving schedule, provided each deposit fits your plan.
Listing income, listing expenses and comparing the two is the basic budgeting method described by the Federal Trade Commission’s consumer.gov guide to making a budget and the CFPB budget worksheet. For costs that do not arrive every month, add the monthly set-aside from the sinking funds calculator as a goal line.