If you would rather not link an app to your bank, a spreadsheet fed by downloaded statements does the same work. Keep one row per transaction, a category on each row, and let SUMIFS total the months.
What are the columns?
| Column | Holds | Example |
|---|---|---|
| A | Date | 03/02/2027 |
| B | Category | Groceries |
| C | Amount in pounds | 42.60 |
| D | Description | As printed on the statement |
| E | Account | Joint current |
How do you total a category?
In a summary sheet, put the category name in A2 and the month's first day in B1 and the next month's first day in C1. Then use:
- =SUMIFS($C$2:$C$500,$B$2:$B$500,A2,$A$2:$A$500,">="&$B$1,$A$2:$A$500,"<"&$C$1)
- This adds the amounts in column C where the category matches A2 and the date falls in the chosen month.
- Fill the formula down for each category.
Check that your dates are real dates and not text; if SUMIFS returns zero, that is the usual reason.
What does a sensible plan look like?
Say take-home pay is £2,400. Some people use a rule of thumb such as 50 percent for needs, 30 percent for wants and 20 percent for saving, which would be £1,200, £720 and £480. It is only a starting point; your rent may take more than half. Adjust the split to your life and keep the arithmetic honest: 1,200 + 720 + 480 = £2,400.
How do you get the data in?
- Sign in to your bank yourself and download the statement as CSV or PDF.
- If it is a CSV, copy the columns into your sheet.
- If it is a PDF, copy the table text or retype the lines.
- Add a category to each row, using the same list every month.
What goes wrong?
- Two lines for one purchase, such as a pending and a settled entry.
- Refunds, which come in as positive amounts and need the same category as the purchase.
- A transfer between your own accounts counted as spending.
When the sheet gets heavy
Retyping PDF statements is the weak point. SpendixAI accepts uploads in PDF, CSV or Excel, lets you review rows before saving, and does not connect to your bank, but it is built around India and INR, so pound accounts should stay with the sheet.
How do you stop the sheet becoming a chore?
Keep to a handful of categories, such as rent, bills, groceries, transport, eating out, savings and other. Add a new one only when a single line is large enough to need its own total. A sheet with eight categories takes ten minutes; one with thirty takes an evening.
Reuse last month's sheet by copying the tab and clearing the rows, so formulas and layout stay the same. Name tabs by month, such as 2027-02, and keep a Summary tab with one row per month and one column per category. After a few months you can see which category moves and which stays put, and that is the insight a budget is for.
- Copy last month's tab rather than starting from nothing.
- Keep a Summary tab with one row per month.
- Review the same day each month.
How do you deal with pending and duplicate lines?
Statements sometimes show a card payment as pending and later as settled, and a downloaded file taken in between can include both. Before totalling, sort by date and amount and look for pairs with the same amount, the same merchant and dates a day or two apart. Delete the pending one, and keep a note so the count of lines still matches the statement's own total.
Checklist
- Set up the five columns.
- Write a plan for the month.
- Import and categorise.
- Total with SUMIFS.
- Compare, adjust, repeat.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

