Tax and GST

Selling on Instagram: tracking orders, payments and returns by month

Track Instagram orders and payments with a monthly sheet tying each chat order to a payment, courier slip and any return or refund, for a home seller.

Editorial illustration for Selling on Instagram: tracking orders, payments and returns by month

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?

ColumnHeadingWhat goes in it
AOrder dateThe day the customer confirmed
BCustomerFirst name or handle, as in the chat
CItem and quantityShort description, for example blue kurti, 1
DItem pricePrice agreed in the chat
EDelivery chargeWhat you charged for delivery
FPayment mode and dateUPI, cash on delivery or transfer, with the date
GCourier slip no.The tracking or slip number
HStatusPacked, shipped, delivered, returned
IRefundAmount refunded, if any
JNetPrice 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.

CustomerItemPriceDeliveryPaid byRefundNet
KavyaSaree₹1,800₹60UPI₹0₹1,860
NehaEarrings₹450₹40UPI₹0₹490
IshaKurti₹1,200₹50UPI₹1,200₹50
PoojaTop₹999₹50Cash 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?

  1. Check that every order has a status and no row says pending without a reason.
  2. Match the UPI credits and courier batch credits to your bank statement.
  3. Compare the month's total received with the sum of the Net column and explain any difference in a note.
  4. Save the sheet and the folder of screenshots with the month name.
  5. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports