askROI Blog
How to make a monthly budget for 2027 from your bank export
How to make a monthly budget for 2027: export last month, sort it into about ten categories, spread yearly bills across the months, and see what is left.
By askROI · · Updated
Try it
Paste a month of transactions, say what you take home, and askROI sends back a budget spreadsheet with categories, planned and actual columns, and formulas for what's left. The button fills in a sample September export so you can watch it work before you use your own.
Opens a new chat with a message you can edit before sending
If you're working out how to make a monthly budget for 2027, the usual first step is typing last month's spending into a blank spreadsheet, which is where good intentions tend to run out, somewhere around row 14. You can skip that part. Your bank has already written down every grocery run and every rent payment, with the date and the amount. What's missing is the sorting, and that's the part you can hand off. With no export to hand, the monthly budget template page starts from your income and bills instead.
Here's what that looks like with the sample above: 25 rows from one September, each tagged with a category, then every category set against its plan.

Step 1: get one full month out of your bank
Pick last month, the whole of it, and get the transactions out in whatever form your bank allows. Include the salary line, so income sits next to spending, and include any transfer to savings, since that's a budget line like any other. One month is enough to start. Three months tells you which categories swing, so add them once the first budget exists.
How you get them out decides what you send. Pick yours to see the prompt.

Step 2: sort the rows into about ten categories
Every merchant name needs a category, and the list works best kept short. Name categories the way you think about money, not the way your bank does:
- Fixed bills: rent or mortgage, utilities, phone, insurance.
- Everyday spending: groceries, transport, eating out and takeaway.
- The rest: shopping, subscriptions, entertainment, health and fitness.
- Savings and debt: transfers to savings, loan or card payments.
This is the slow part by hand. Five Tesco lines become one groceries figure, the pub goes under eating out, and Amazon needs a decision every single time. If you have house rules ("Amazon is household unless it's over 50"), put them in your message so the sorting matches how you think.
Step 3: put a plan next to every actual
A list of actuals is a spending report. It becomes a budget when each category has a planned figure beside it and a column for the difference. Fixed bills are easy to plan because they are what they are. For everything else, start from last month's actual rounded to a figure you'll remember, then lower the ones you want to change.
The formulas matter more than the first set of numbers. Totals, differences and what's left should all be calculated in the sheet, so changing one planned amount updates everything below it.
What came back from the sample export
We sent the September sample from the Try it button to the budget planner. It came back as an Excel workbook with a Budget sheet and a Transactions sheet. The Transactions sheet lists all 25 rows with a category beside each. On the Budget sheet, every actual is a formula over that list, so moving a transaction to a different category moves its money with it.

The sums check out. Spending came to £2,523.18 of the £3,650 take-home, savings transfer included, which leaves £1,126.82. Four categories ran over plan: shopping by £30.19, groceries by £28.27, eating out by £16.20 and utilities by 30p. Entertainment came in £16 under, and subscriptions, health and transport a little under. Net, the month finished £53.18 short of the plan.
The export had no planned amounts, so where did "plan" come from? askROI said so itself: it set starting targets, highlighted them in yellow, and asked for real ones before anyone trusts the differences. It also listed the calls it made, like Amazon and Zara under shopping and the O2 bill under utilities and phone.

Before a workbook reaches you, askROI recalculates it and checks every formula for errors. It arrives as a file card in the chat: Open it to read each sheet before downloading anything, change a planned amount with Edit, or ask in the same conversation for something bigger, like splitting groceries from household or adding a category for the car, and askROI rebuilds the file.
Setting up 2027: give yearly bills a monthly line
One month of spending can't show you the bills that land once a year, and those are what break a budget in March. So before you trust a 2027 budget, list everything irregular: car insurance, car tax or registration, gifts, subscriptions you pay annually, a holiday. Divide each by 12 and give it its own line. That line is a sinking fund: money you set aside each month for a bill you already know is coming.
Here's a made-up list to show the sums:
| Bill | A year | A month |
|---|---|---|
| Car insurance | £540 | £45 |
| Car tax | £180 | £15 |
| Gifts | £480 | £40 |
| Yearly subscriptions | £120 | £10 |
| Total | £1,320 | £110 |
That £110 comes out of what's left each month, whatever the month looks like, and it builds up until the bill arrives. You can ask for this in the same chat: list your bills, say what each costs a year, and ask for a sinking funds section with a monthly amount for each.
Starting the year from a December export
December is the easiest export to grab in January and the worst one to copy, because gifts, travel and eating out all run high. Use it for the fixed bills, which don't change. For the rest, say so in your message: "This is a December export, so treat gifts and travel as one-offs and plan January from the fixed bills and three normal months." If you only have December, plan the everyday categories from what you expect to spend rather than what you just did.
Next month is the easy one
The first budget takes one export and one message. From the second month on, go back to the same chat, paste or attach the new month, and ask askROI to keep the categories and planned amounts and add the new actuals. Then read one column: the differences.
A category that runs over three months in a row is telling you something: the planned amount was never realistic. Change the plan and find the money somewhere else, rather than promising yourself a better month.