To track Instagram orders and payments, keep one sheet per month with a row for every order: the customer, the item, the price, how and when they paid, the courier slip number, and any return or refund. Each chat order then has a payment and a parcel attached to it, so you can tell at a glance what has been paid, shipped, returned or is still pending.
What columns does a month sheet need?
| Column | Heading | What goes in it |
|---|---|---|
| A | Order date | The day the customer confirmed |
| B | Customer | First name or handle, as in the chat |
| C | Item and quantity | Short description, for example blue kurti, 1 |
| D | Item price | Price agreed in the chat |
| E | Delivery charge | What you charged for delivery |
| F | Payment mode and date | UPI, cash on delivery or transfer, with the date |
| G | Courier slip no. | The tracking or slip number |
| H | Status | Packed, shipped, delivered, returned |
| I | Refund | Amount refunded, if any |
| J | Net | Price plus delivery minus refund |
The net for row 2 is =D2+E2-I2, filled down the column. Total the month with =SUM($J$2:$J$200). Both work in Excel and Google Sheets.
What does a small month look like?
The numbers are invented. A home seller has four orders in a month.
| Customer | Item | Price | Delivery | Paid by | Refund | Net |
|---|---|---|---|---|---|---|
| Kavya | Saree | ₹1,800 | ₹60 | UPI | ₹0 | ₹1,860 |
| Neha | Earrings | ₹450 | ₹40 | UPI | ₹0 | ₹490 |
| Isha | Kurti | ₹1,200 | ₹50 | UPI | ₹1,200 | ₹50 |
| Pooja | Top | ₹999 | ₹50 | Cash on delivery | ₹0 | ₹1,049 |
Orders are worth ₹1,860 + ₹490 + ₹1,250 + ₹1,049 = ₹4,649. After Isha's refund of ₹1,200, net sales come to ₹3,449. Money received so far: three UPI payments of ₹1,860, ₹490 and ₹1,250 minus the ₹1,200 refund leaves ₹2,400, and Pooja's ₹1,049 is still with the courier. Add them and ₹2,400 + ₹1,049 gives ₹3,449, matching net sales, which is the check you want.
How do you tie a chat to a payment?
Take a screenshot of the chat where the price and address were agreed, and a screenshot of the payment. Save them in a folder for the month, named with the order date and customer. For a UPI payment, copy the reference number from your bank statement into the sheet. For cash on delivery, the courier pays you later in a batch, so write the date and amount when the batch credit arrives and tick off the orders it covers.
What should you record when something is returned?
- The date the customer asked for the return and the reason, in a note.
- The date the item reached you and whether it was resaleable.
- The refund amount, the mode you used and the date, with a screenshot of the refund payment.
- Whether any delivery charge was kept, as you told the customer.
Note one-off or last-piece items in the Notes column when an order uses your final stock. Then a refund or exchange request for an item you no longer have is easy to understand, and you can offer a swap or a credit rather than discovering the problem halfway through the chat.
How do you close the month?
- Check that every order has a status and no row says pending without a reason.
- Match the UPI credits and courier batch credits to your bank statement.
- Compare the month's total received with the sum of the Net column and explain any difference in a note.
- Save the sheet and the folder of screenshots with the month name.
- Note any unpaid orders to chase next month.
Whether and how GST or other rules apply to your selling depends on your situation. Rules and limits change, so ask your CA, and take the monthly sheets with you.
Your selling costs, such as packaging, courier charges and ad spend, are separate. SpendixAI can take an uploaded bank or card statement for them, or manual entries with the receipts attached, so the sheet stays about sales.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

