Filter your card transactions down to two dates, then group by what the money was for. A plain total tells you how much; a total by category tells you where it went. For a one-card report you need three columns: date, description and amount, plus a category you add yourself.
What is the situation?
Imagine a self-employed photographer who keeps one card just for the business. Over September, October and November, she wants to see what the card was used for, perhaps before a conversation with her bookkeeper. Nothing outside those three months matters, and nothing from her personal accounts should appear.
How do I set up the sheet?
- Column A: date of the transaction.
- Column B: description exactly as the statement shows it.
- Column C: amount in pounds, with refunds as negative numbers.
- Column D: category you assign, such as Equipment, Software, Travel, Printing.
- Cells G1 and G2: the first and last date of the period you want.
Add the category column yourself even if the export has one. Issuer categories tend to be broad and may not match how you think about your costs.
Which formulas give a total by category?
Set G1 to 1 September 2026 and G2 to 30 November 2026 as real dates. The category total for Equipment is =SUMIFS($C$2:$C$500, $D$2:$D$500, "Equipment", $A$2:$A$500, ">="&$G$1, $A$2:$A$500, "<="&$G$2).
Repeat with a different category name in each row of a small summary table. To avoid typing the name again each time, put the category names in column J and refer to the cell: =SUMIFS($C$2:$C$500, $D$2:$D$500, J2, $A$2:$A$500, ">="&$G$1, $A$2:$A$500, "<="&$G$2), then fill down.
What does the summary look like?
| Category | Sep to Nov total |
|---|---|
| Equipment | £1,284.00 |
| Software | £216.45 |
| Travel | £352.10 |
| Printing | £98.75 |
| Refunds | -£45.00 |
Adding them up: 1,284.00 + 216.45 + 352.10 + 98.75 - 45.00 = £1,906.30. Compare this with the sum of the amount column for the same dates, which should give the same figure. If the two differ, a transaction has either no category or a spelling that does not match the summary.
How can I catch uncategorised rows?
Add one more line to the summary: the total of everything minus the sum of your categories. In a sheet where the all-rows total is in K1 and the category totals sit in K3 to K7, use =K1-SUM(K3:K7). It should read 0.00. Anything else means a row slipped through.
What if the card statement dates do not match calendar months?
Most cards run on a statement cycle that does not start on the first of the month. That is why working from the transaction dates, not the statement dates, is safer. Download as many statements as you need to cover the whole window, merge them, and filter by transaction date.
Is there a quicker way?
If you import card statements into SpendixAI, its reports can be filtered by account and date, then exported as CSV. It is built around India and INR and we do not say it covers UK banks or cards, so use it as a model for what to look for. The spreadsheet route above works with any tool that gives you a CSV.
Handling refunds and reversed payments
Refunds are the usual reason a card report does not match expectations. A refund can arrive weeks after the purchase, outside your window, so the purchase is in the report and its refund is not. Decide whether to follow transaction dates strictly, or to pair each refund with its original charge and report them together. Either approach is acceptable if you state it. A one-line note under the totals, such as a refund of £45.00 on 4 December that relates to a November purchase, saves a reader a lot of puzzling.
What to hand over
Whether it is for your bookkeeper or just for yourself, send the filtered rows, the category totals and a note stating the dates covered. Ask your bookkeeper or accountant if they want anything else; requirements vary, and we would rather you ask than guess.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

