A simple monthly budget worksheet
A step-by-step worksheet to build your first monthly budget in under an hour, with a worked example.
A budget does not have to be a complicated spreadsheet with forty categories. For most people, a single page with a handful of lines is enough to see where the money goes and decide where it should go next month. This guide gives you a simple worksheet you can copy into a notebook, a notes app or a spreadsheet, plus a worked example to show how it fits together.
Set aside about an hour for the first pass. After that, updating it takes ten minutes a month.
What you need
- Your last one or two pay stubs, or the amounts deposited into your account.
- Bank and card statements for the last one to three months.
- A list of any yearly or irregular costs you remember, such as subscriptions that renew once a year or car registration.
Part 1: Monthly take-home pay
Write down what actually arrives in your account each month after payroll deductions. If you are paid every two weeks, multiply one paycheck by 26 and divide by 12 to get a monthly figure. If your pay changes from month to month, use a typical low month.
Add any other regular income, such as a side job or support payments, but leave out one-off amounts like gifts or a tax refund. Those are better moved straight into savings than counted as part of the monthly plan.
Line 1: Total monthly take-home pay.
Part 2: Needs
List the costs you must pay each month to keep a roof over your head, the lights on and yourself fed and able to get to work. For each line, use the real amount from your statements.
- Rent or housing payment.
- Utilities: electricity, gas, water, trash and internet. If you share these with roommates, write only your share.
- Phone plan.
- Groceries.
- Transportation: transit, fuel, parking and car upkeep.
- Required health costs.
- Childcare or other care you need in order to work.
Line 2: Total needs.
Part 3: Wants
Next, list the spending that makes life better but could pause in a tight month.
- Dining out, takeout and coffee.
- Entertainment: streaming, games, concerts, movies.
- Hobbies and sports.
- Shopping beyond the basics: clothes, gadgets, home decor.
- Travel and weekends away.
- Gifts and celebrations.
Statements are especially useful here, because small purchases are easy to forget. Group them roughly; you do not need perfect categories.
Line 3: Total wants.
Part 4: Savings and buffer
Finally, list money you set aside for the future.
- Emergency fund contributions.
- Retirement or long-term savings that you pay yourself, not ones already taken from your paycheck.
- Sinking funds for yearly costs such as registration fees or holiday gifts.
- Savings for specific goals.
Line 4: Total savings.
Part 5: Compare with the plan
Now compare your lines with a simple target. With the 50/30/20 guideline, multiply Line 1 by 0.5 for needs, 0.3 for wants and 0.2 for savings. Write each target next to your real number and the difference between them.
Finally, add Lines 2, 3 and 4 together and subtract the result from Line 1. If the answer is positive, that money is not yet assigned; move it into savings so it does not drift into spending. If it is negative, you are spending more than you take home, and the comparison above shows where to look first.
A worked example
Jamie takes home $4,200 a month.
- Needs: rent share $1,350, utilities share $110, phone $45, groceries $380, transit $95, phone plan $60. Total $2,040.
- Wants: dining out $260, streaming $35, gym $40, shopping $150, weekends away $120. Total $605.
- Savings: emergency fund $250, retirement $150. Total $400.
The 50/30/20 targets are $2,100 for needs, $1,260 for wants and $840 for savings. Jamie's needs are $60 under target, wants are $655 under and savings are $440 under. Adding up the lines gives $3,045, leaving $1,155 unassigned each month.
That unassigned money is the most important finding. It is not really unspent; it is being spent somewhere that did not make the list, probably small everyday purchases. Jamie's next step is to check the statements again for the missing amount, then set up an automatic transfer of $440 more to savings on the day Jamie gets paid to meet the target.
When the numbers do not fit
If your needs alone take more than your take-home pay can carry, the worksheet has still done its job: it shows the problem clearly. Start with the largest needs line and ask what could change over the next few months, such as a roommate to share rent, a cheaper phone plan or a different commute. Protect a small savings amount, even $25 a month, so the habit survives the tight period.
Keep it to one page
The worksheet works because it is short. Resist the urge to add dozens of categories in the first month. Once the four totals are reliable, you can split a busy line, such as dining out, into more detail if it helps.
Update monthly
Pick one day each month, ideally just after you get paid, to fill in the real numbers. Compare them with the plan, choose one change for the next month and move on. Over a few months the worksheet becomes a clear record of progress, and the decisions get easier each time.
If you want the math done for you, enter the four totals, or the individual lines, into a 50/30/20 planner. It shows the targets, the differences and how the rest of your pay should be shared, in a few seconds.
For general information only. This is not financial, investment, insurance, tax or legal advice. Please check official sources or a qualified professional for your situation.