Expense categories

Tesco spend report: total your grocery runs from statements

Tesco spend report from your own statements: find grocery charges, total them by week and month, and compare against a budget, with a worked pound example.

Editorial illustration for Tesco spend report: total your grocery runs from statements

To build a Tesco spend report, search your card and bank statements for the store's name, list each charge, and total it by week and by month. That gives you what grocery shopping at one store costs you, from records you already hold. we do not describe any retailer's loyalty schemes, prices or return rules, so for order details use the store's own account page and terms.

Why do weekly totals help more than a monthly one?

Groceries are frequent and uneven. A month's total hides whether the spending is steady or comes in a few big shops. Weekly totals show the rhythm, and they are easy to compare with a weekly budget.

Worked example in pounds

Say a household pays in pounds and the statement shows four shops in the month: £62.40, £48.15, £71.90 and £39.55. The total is 62.40 + 48.15 + 71.90 + 39.55 = £222.00, and the average shop is 222.00 / 4 = £55.50. If the household's budget for groceries at this store is £240, the unspent part is 240 - 222 = £18. These are invented figures to show the arithmetic.

WeekChargeRunning total
1£62.40£62.40
2£48.15£110.55
3£71.90£182.45
4£39.55£222.00

How do you total it in a spreadsheet?

With descriptions in column B and amounts in column C, =SUMIFS($C$2:$C$500, $B$2:$B$500, "*tesco*") adds every row containing that word, ignoring case. Statement text varies, so check the word as printed on your own statement, and scan for rows that have the name but belong elsewhere, such as fuel or a different department. To get the count of shops, use =COUNTIFS($B$2:$B$500, "*tesco*").

Which rows belong in the report, and which do not?

  • Include every account and card you shop with, not just the main one.
  • Separate fuel or non-food spending if you want a pure grocery figure.
  • Treat refunds as negative amounts.
  • Do not count a transfer to your own account as spending.

What if you also have rupee accounts?

If your pound spending sits alongside rupee accounts, SpendixAI lets each expense carry its own currency and totals in a base currency using the rate saved with each transaction. Choose the base currency before the first import, since it cannot change once transactions exist. Statements can be uploaded as PDF, CSV or Excel and reviewed before saving, and a Foreign-currency spend report shows what went out in other currencies. It is built around India and the rupee, so I make no claims about availability outside it.

How do you compare a month with the last one?

Put two months side by side and look at three numbers: total, number of shops and average shop. Say last month was £222.00 over four shops, and this month is £263.50 over five shops. The average shop moved from £55.50 to 263.50 / 5 = £52.70, even though the total rose. More trips with a smaller basket explains the rise better than a general increase in cost, and that is the sort of insight a total alone hides. Write that one-line explanation next to the numbers while you remember it. Three months later a bare figure of £263.50 tells you nothing, whereas a note saying more trips, smaller baskets, guests in the second week tells you exactly what you were looking at.

A routine that takes ten minutes

  1. At month end, download or open each statement.
  2. Search the store name and copy rows into your sheet.
  3. Check the weekly totals against your budget.
  4. Write one sentence on what changed and why, for example a party, a trip, or a stock-up.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports