To make a spend report for a retailer such as Walmart, start from your own bank or card statement, not the retailer's pages. List every charge where the merchant name matches, note the date and amount, then add them up by month. If some were charged in a foreign currency, record both the original amount and the rupee amount your statement shows. Check the retailer's own account page and terms for order details and returns.
Which charges belong in the report?
Merchant names on statements can be abbreviated, so search for a few fragments of the name instead of the full spelling. Some purchases appear with the payment processor's name or an order reference. If a line looks unfamiliar, compare its date and amount with the confirmation email for that order before you decide it belongs. Keep a separate list for lines you could not identify.
How do I set up the sheet?
- Make columns: date, merchant text as it appears, amount in the statement currency, amount in rupees, order reference, notes.
- Paste the rows you picked from the statement, one per charge.
- Add a column for category, such as groceries, household or gifts, and fill it by hand.
- Sort by date, then add a month column.
- Total by month and by category.
In Excel or Google Sheets, with dates in column A and rupee amounts in column D, the total for one month can be =SUMIFS($D$2:$D$200, $A$2:$A$200, ">="&DATE(2026,10,1), $A$2:$A$200, "<"&DATE(2026,11,1)). Change the dates for another month. Test it against a month you can add by hand.
What if the charge is in a foreign currency?
Your statement will usually show the original amount and the amount debited in rupees. Record both, and do not recalculate the rupee figure from a rate you looked up yourself; the figure on your statement is what actually left your account. Say an order was 80 in the foreign currency and your statement debited ₹6,744. The implied rate is 6,744 divided by 80, or ₹84.30 for each unit. Use that rate to compare against other charges in the same month, but remember that card networks and banks may add their own markup, so check your own statement for what was charged.
| Date | Original amount | Debited (₹) | Implied rate (₹) |
|---|---|---|---|
| 3 Oct | 50.00 | 4,215 | 84.30 |
| 12 Oct | 80.00 | 6,744 | 84.30 |
| 27 Oct | 30.00 | 2,538 | 84.60 |
| Total | 160.00 | 13,497 | about 84.36 |
What proof should I keep for returns or disputes?
- The order confirmation and the invoice, saved as a file.
- The statement line with the date and the amount debited.
- Any message from the retailer about a refund or return.
- The date you sent the item back, if you did.
Check the company's own help and terms for how returns, refunds and disputes work. Do not rely on a blog or forum for those details; they change.
Can I do this without a sheet?
If you would rather not paste rows by hand, SpendixAI can take your card statement as a PDF, CSV or Excel file and let you review each row before saving. Each expense can be in its own currency, with totals shown in your base currency using the rate saved with that transaction, and a Foreign-currency spend report is part of its reports. Choose the base currency before importing, because it cannot be changed after transactions exist.
Before you close the month
- Match your list against the statement total for the merchant.
- Mark lines you could not identify and chase them with the retailer or your bank.
- Save invoices for anything you may return or need for warranty.
- Note any refund as a separate negative line.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


