A useful monthly budget should reflect your real life. Bank statements show what you actually earned and spent, making them a better starting point than guesses about an ideal month. The CFPB financial toolkit similarly recommends understanding current spending before deciding what to change.
This guide is educational and does not provide personalized financial advice.
Download the monthly budget CSV template and open it in Excel, Google Sheets, or another spreadsheet application. The template separates income, fixed costs, variable essentials, flexible spending, goals, and irregular expenses.
Gather Three Months of Transactions
Download the most recent three months of statements for every account you use for everyday spending. Three months will expose recurring bills and occasional expenses without making the first review overwhelming.
Keep the original PDFs in a secure folder. Then convert each bank statement to CSV so you can sort, filter, and categorize the transactions in a spreadsheet.
Calculate Your Monthly Income
List reliable after-tax income first. Include salary deposits, regular client payments, benefits, and other predictable income. Keep irregular income in a separate row so it does not make the base budget look safer than it is.
If your income changes each month, use the lowest normal month as the starting point. Our guide to budgeting with irregular income provides a more detailed method.
Categorize What You Actually Spend
Add a category column beside each transaction. Begin with a short list:
- Housing and utilities
- Groceries and household supplies
- Transportation
- Insurance and health
- Debt payments
- Savings
- Subscriptions
- Restaurants and entertainment
- Other spending
Do not create dozens of categories immediately. A simple system is easier to maintain and still reveals where the money goes. Learn a repeatable workflow in How to Categorize Bank Transactions.
Separate Fixed, Variable, and Irregular Costs
Fixed expenses stay similar each month, such as rent or insurance. Variable expenses change, such as groceries. Irregular expenses happen less often, such as annual renewals, repairs, and gifts.
Convert annual expenses into monthly amounts. A $600 annual insurance payment, for example, represents a $50 monthly cost. Setting aside that amount each month makes the eventual bill predictable.
Worked Example
Imagine that three months of statements show average take-home income of $3,600. Average essential expenses are $2,250, flexible spending is $620, and irregular expenses represent another $230 per month. That leaves $500 before additional savings or debt payments:
$3,600 - $2,250 - $620 - $230 = $500
This calculation does not decide what to do with the $500. It shows the amount available for goals and tradeoffs. The person could assign part to an emergency fund, upcoming expense, or debt according to their circumstances.
Now imagine that dining accounted for $310 of the $620 flexible total. A first target of $260 would free $50 without assuming an unrealistic lifestyle change. The next monthly review will show whether that target worked.
Build the First Version of Your Budget
For each category, compare the three-month average with the most recent month. Choose a target that is realistic enough to follow. If restaurant spending averaged $280, setting the first target at $250 is more useful than pretending it will instantly become zero.
Your basic equation is:
income - expenses - savings = remaining money
If the result is negative, adjust large flexible categories first and review recurring charges. The subscription audit guide can help you identify easy reductions.
Avoid These Common Budgeting Mistakes
Do not count transfers between your own accounts as income or spending. Doing so inflates both sides of the budget. Treat credit card payments carefully too: if individual card purchases are already categorized, categorizing the card payment again duplicates the expense.
Also avoid building the plan from one unusually quiet month. Look for annual fees, seasonal utilities, travel, school costs, and repairs. A budget that ignores predictable irregular costs will appear successful until the bill arrives.
Review It Every Month
A budget is a feedback system, not a test you pass or fail. Compare the plan with actual transactions, investigate large differences, and change targets when reality changes.
Use the 30-minute monthly money review as a repeatable routine. Over time, your budget will become more accurate because it is built from evidence instead of memory.
Start With Clean Transaction Data
Statementsify turns bank statement PDFs into structured spreadsheet data. Use the bank statement converter, add your categories, and build a budget based on what really happened.