To build a BigBasket spend report, start from the record you control, your bank or card statement. Find each charge from the seller, note its date and amount, total them by month and net off any refund that came back. The seller's own order history is the place to match a charge to an order, and the company's own terms say what it can and cannot change after you order. This method works for any grocery delivery service.
How do I find the charges on my statement?
- Download or open the statement for the months you want.
- Search the description column for the seller's name. Descriptions vary by bank and by payment route, so look at one known order first to see how it appears.
- Note any other spellings of the same name, since the same seller can appear under more than one description.
- Copy the matching rows into a sheet with date, description and amount.
- Mark refunds as negative numbers.
What does a month look like in numbers?
These figures are made up. Say six orders in a month came to ₹1,240, ₹860, ₹1,675, ₹420, ₹2,110 and ₹695. The total is 1,240 + 860 + 1,675 + 420 + 2,110 + 695 = ₹7,000, an average of ₹1,166.67 an order. A refund of ₹420 for a missing item arrives later, so the net is 7,000 - 420 = ₹6,580.
| Item | Amount |
|---|---|
| Six delivered orders | ₹7,000 |
| Refund for a missing item | -₹420 |
| Net delivery spend | ₹6,580 |
| Neighbourhood kirana and market | ₹4,800 |
| Total groceries | ₹11,380 |
The delivery share of groceries is 6,580 / 11,380, about 58 percent. That is a useful number to look at, whether it surprises you or not.
Which formulas total this in Excel or Google Sheets?
With descriptions in B, amounts in C and dates in A, rows 2 to 500, a wildcard match totals the seller's charges, using text from your own statement in place of the placeholder:
- =SUMIFS($C$2:$C$500, $B$2:$B$500, "*sellername*") adds every row whose description contains that text.
- =SUMIFS($C$2:$C$500, $B$2:$B$500, "*sellername*", $A$2:$A$500, ">="&DATE(2025,4,1), $A$2:$A$500, "<"&DATE(2025,5,1)) limits it to April 2025.
- =COUNTIFS($B$2:$B$500, "*sellername*") counts the orders.
Both Excel and Google Sheets accept the asterisk as a wildcard in these functions. The dates need to be real dates, not text.
When does a sheet stop being enough?
A monthly sheet is fine for one seller. When you want every grocery source, quick-commerce and kirana together, SpendixAI can import statements as PDF, CSV or Excel, group matching merchants through aliases and put them in a Groceries category. Its reports can be filtered and downloaded as CSV, and you review rows before they are saved.
How do I spot a charge we do not recognise?
- Match each charge on the statement to an order in the seller's own history.
- If one has no order, ask the household whether anyone placed one.
- Check whether a card was saved on another device.
- Contact your bank with the date and amount if it is still unexplained.
SpendixAI also lists possible duplicate charges, meaning the same amount to the same merchant within two days, which helps you spot a double debit.
Once you have two or three months, compare the monthly net figure with the number of orders. Fewer, larger baskets often cost less in total than many small top-ups, though your own numbers will tell you whether that is true for you. A line in your sheet for orders per month and average basket makes the pattern visible without any app.
A short routine
- Once a month, import or paste the statement.
- Total orders, refunds and net.
- Compare with the previous month.
- Ask yourself which orders were planned and which were top-ups.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


