To make an Aldi spend report, list every card payment to that chain from your statements, convert each to rupees using what your bank actually charged, and total them by week and month. This only applies if you shop there while living or travelling abroad, since the report is just a filter on one merchant. The same steps work for any supermarket.
Where do the numbers come from?
Your card statement is the source. Each foreign purchase usually shows the local amount and the rupee amount debited; look at your own statement for how your bank prints it. Store receipts help with items, but the statement gives you the totals. Pull the lines for the shop's name, noting date, local amount and rupee amount.
How do I handle currency?
Do not convert everything at one rate you looked up later. Use the rupee figure charged for each visit, because that is the money that left your account. Say you made three visits: €32.40 charged as ₹3,020, €18.10 charged as ₹1,700 and €41.25 charged as ₹3,890. The rupee total is 3,020 plus 1,700 plus 3,890, which is ₹8,610. The euro total is 91.75, so the average rate you actually paid works out to about ₹93.8 per euro: 8,610 divided by 91.75. That figure is yours; it is not a market rate.
| Visit | Local amount | Rupees charged |
|---|---|---|
| Week 1 | €32.40 | ₹3,020 |
| Week 2 | €18.10 | ₹1,700 |
| Week 3 | €41.25 | ₹3,890 |
| Total | €91.75 | ₹8,610 |
What does a useful report look like?
- Spend per week, so a big shop does not hide in a monthly figure.
- Number of visits, and the average per visit.
- Share of your total food spend, set against eating out.
- Rupee cost and local cost side by side.
Can I get this without a spreadsheet?
In SpendixAI you can pick a base currency before importing, keep each expense in its own currency and see totals in the base currency using the rate saved with each transaction. The Foreign-currency spend report lists these. Import the statement for the card, put the shop in a groceries category, then use the Report builder to filter by merchant. The base currency cannot be changed once transactions exist, so choose it first.
How do I compare it with other shops?
Use the same method for each supermarket and compare per visit and per week, not only per month. Say one shop gives you €22 average per visit over four visits and another €35 over two visits. The first totals €88 and the second €70, so more visits do not always mean more spending. Check what you bought before drawing a conclusion, because basket size and items matter as much as the shop.
- Keep the same categories across shops.
- Separate household items from food.
- Note any bulk buys, which distort a single week.
What should the closing review ask?
Ask three things. Did the weekly average match what I expected? Which single visit was the biggest, and why? Did a refund or a hold distort any week? Write the answers beside the report in two lines each. Over a few months those notes show your real grocery pattern far better than a bare total, and they take only minutes to add.
What should I do with the result?
Compare weekly grocery cost with what you planned. If the weekly average is ₹2,870 against a plan of ₹2,500, decide whether the plan or the habit should change. Keep the receipts for any item you may need to return.
Last step: save the report with the date range in its name so you can repeat it next term or next trip.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


