A spend report for quick-commerce orders is just your statement, filtered by merchant and added up by month. Find the lines for the seller, put them in one place, total them, and look at order count as well as rupees. You do not need the company's own data to do it, and your bank statement is the record you can trust.
Where do the numbers come from?
Start from your statement, not from memory. The statement shows what actually left your account, whether you paid by UPI, card or wallet. Download the last three to six months from your bank as PDF, CSV or Excel. A CSV or Excel file is easiest to work with because you can sort and filter it. For the company's own order history or invoices, look at the account section of its app and check its own help pages, since those screens change.
Step by step in a spreadsheet
- Paste the statement rows into a sheet with columns for date, description and amount.
- Add a column called Month and fill it with =TEXT(A2,"yyyy-mm") if column A holds real dates.
- Add a column called Quick-commerce and fill it with =IF(ISNUMBER(SEARCH("zepto",B2)),"Yes","No") so every matching line is marked.
- On a second sheet, list each month and total it with =SUMIFS(Data!$C$2:$C$500,Data!$D$2:$D$500,"Yes",Data!$E$2:$E$500,A2) where D is the Yes/No column and E is the Month column.
- Count orders with =COUNTIFS(Data!$D$2:$D$500,"Yes",Data!$E$2:$E$500,A2).
- Divide total by count to get the average order.
Merchant text on statements is often shortened or has extra codes, so run the SEARCH on a few different spellings if lines are missed. Look through the unmatched rows once to be sure.
A worked example with made-up numbers
| Month | Orders | Total spent | Average per order |
|---|---|---|---|
| August | 14 | ₹6,300 | ₹450 |
| September | 18 | ₹7,380 | ₹410 |
| October | 22 | ₹10,780 | ₹490 |
Here October is ₹10,780 across 22 orders, which is ₹490 each. Compared with August, spend rose by ₹4,480 and orders rose by 8. Most of the rise came from ordering more often, not from larger baskets. Without both columns you would not see that.
What should I look for in the report?
- Frequency: how many orders a week, and whether they cluster on weekends or late evenings
- Basket size: a rising average could mean bigger planned shops or lots of add-ons
- Small orders: many lines of a few hundred rupees add up faster than one large shop
- Delivery and handling lines: these are part of the real cost, so check whether they appear as separate rows
- Overlap: groceries bought in a quick order that you would otherwise buy at a kirana store or in a monthly shop
Can I split it into food, household and personal?
A single statement line does not tell you what was in the basket. If you want that split, use the order invoices in the app or your email and note the rough split yourself, or accept that the report measures the merchant and not the items. Be honest about which one your report is.
When a sheet stops being enough
Re-pasting statements every month gets tedious. SpendixAI can take the statement as PDF, CSV or Excel, let you review rows before they are saved, and apply your own rules so that lines from a merchant land in one category each month. You can add a merchant alias for messy statement text, and build a filtered report by merchant and month, then download it as CSV. Nothing connects to your bank.
Monthly routine
- Download the statement after the month closes
- Mark and total the merchant's lines
- Note order count and average order
- Write one sentence on what changed and why
Useful ideas start with a clearer picture of your own spending.
Explore your reports

