To set a monthly budget when you have no idea where to start, download the last three full months of transactions, total every category for each month, and use the average as that category's starting budget. Your own history is better than any guess, and it takes about an hour the first time.
What to pull before you start
- Three complete calendar months, not a partial current month.
- Every account that money moves through: checking, savings, and each credit card.
- A way to mark transfers between your own accounts, so paying off a card is not counted twice, once as the card spending and again as the payment.
- Cash withdrawals as a single line for now. You can split them later if you remember what they were for.
How do you turn three months into category numbers?
Put the data in a spreadsheet with the date in column A, the category in column B and the amount in column C. Put the first day of the month in F1 and the first day of the following month in F2, then total one category with:
=SUMIFS($C$2:$C$400, $B$2:$B$400, "Groceries", $A$2:$A$400, ">="&$F$1, $A$2:$A$400, "<"&$F$2)
Change F1 and F2 for each month and repeat for every category. If your bank file arrives uncategorised, sort by merchant name first and label the repeating ones; the long tail of one-off purchases can go into a single Other line.
What does a finished table look like?
These numbers are made up, only to show the arithmetic.
| Category | Month 1 | Month 2 | Month 3 | Average | Starting budget |
|---|---|---|---|---|---|
| Groceries | $412 | $468 | $389 | $423 | $425 |
| Dining out | $180 | $95 | $240 | $172 | $175 |
| Fuel | $140 | $165 | $120 | $142 | $145 |
| Phone and streaming | $96 | $96 | $96 | $96 | $96 |
Groceries: 412 + 468 + 389 = 1,269, divided by 3 is 423, rounded up to 425. Dining out: 180 + 95 + 240 = 515, divided by 3 is about 172, rounded up to 175. Rounding up a little leaves a small cushion without hiding the real pattern.
What about bills that only arrive once or twice a year?
A three-month window can miss them completely, or catch one and make that month look terrible. Scan the statements for big one-off charges. Say a $600 yearly software bundle renewed in month two: that is $600 divided by 12, or $50 a month, and it belongs in its own line called Annual renewals. Do the same for anything you know is coming, such as a vet visit, a car service or a school fee, even if it was not in the window.
Average or highest month: which should you budget?
Use the average for lines you can flex, like dining out. Use the highest month for lines you cannot, such as fuel for a long commute. In the example, dining out at the average is $172 but the worst month was $240; if you set $175 you are choosing to cut back in busy months rather than let the line drift.
Does the whole budget fit your take-home pay?
Add the fixed costs. Say rent is $1,150 and utilities are $210. Take-home pay of $2,900 minus the variable lines ($425 + $175 + $145 + $96 = $841) leaves $2,059. Subtract rent to get $909, utilities to get $699, and the $50 annual renewals line to get $649. That $649 is not free money. Decide on purpose whether it goes to savings, debt, or a buffer, otherwise it quietly turns into extra dining out.
What if one of the three months was unusual?
Say one month included a trip, a wedding gift or a car repair. Do not delete the month; instead move the one-off into its own line called Irregular, and budget the other categories from the remaining ordinary spending. If the groceries line in that month was normal but the trip hotel sat in Dining out, relabel it first. Otherwise a single weekend will inflate the average for a category you spend little on in most months.
A quick test is to look at each category's three numbers and ask which one is far from the others. If one month is more than a third higher than the rest, read the transactions behind it before accepting the average.
A short checklist before you call it done
- Transfers between your own accounts are excluded.
- Each category has a starting number and a reason for it.
- Yearly bills are spread across twelve months.
- Fixed costs plus variable lines are less than take-home pay.
- A review date is in the calendar.
If you are in India and tracking rupee statements, SpendixAI reports show category history that serves the same purpose. SpendixAI is built around India and INR, so outside India a spreadsheet like the one above is the practical route.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

