Income and work

Selling on Instagram part-time: tracking orders, packaging, payouts

Track Instagram orders one by one: payment received, courier, packaging, returns and net per order, plus how to match payouts when they arrive in batches.

Editorial illustration for Selling on Instagram part-time: tracking orders, packaging, payouts

To track an Instagram business, keep one row per order with the price paid, what you spent on the product, courier and packaging, any refund, and the net you kept. Add up the rows each month and compare them with the credits in your bank account. Orders that you cannot find in the bank are the ones to chase.

What columns does the order sheet need?

  1. Date and customer handle or order number.
  2. Item and quantity.
  3. Amount received, and how it arrived: UPI, cash, or a courier remittance.
  4. Product cost: what you paid for that item.
  5. Courier charge you paid.
  6. Packaging cost for that order.
  7. Refund given, if any.
  8. Net: received minus product, courier, packaging and refund.

In a sheet, if amount received is in D, product cost in E, courier in F, packaging in G and refund in H, the net in I2 is =D2-E2-F2-G2-H2. Drag it down.

What does one order look like?

Say a seller sells a kurti set for ₹1,200 that she bought for ₹550. Courier costs ₹80 and the polybag and tag cost ₹35. Net is ₹1,200 minus ₹550 minus ₹80 minus ₹35, which is ₹535.

Now a return. Another customer returns a ₹1,200 set. The seller refunds ₹1,200, pays ₹90 to send it back, and has already spent ₹80 on the first courier and ₹35 on packaging. The item goes back into stock, so the product cost is not lost. The loss on that order is ₹80 plus ₹90 plus ₹35, which is ₹205. Record it as -₹205 in the net column, not as a missing sale. If the item comes back damaged and cannot be resold, the product cost of ₹550 is lost as well, which makes the order -₹755. Add a Return reason column so you can see whether the pattern is size, colour or delay.

How do payouts fit in?

Customers who pay by UPI to you directly show up as separate credits. Others may pay through a courier on delivery or through a payment partner, and the money reaches your bank later, in one lump covering several orders. The lump will be less than the sum of the order prices if fees or charges were deducted. Check the remittance statement from your courier or payment partner for the exact deductions; do not guess them.

Add a column called Settled, with a date and a payout reference. When a lump arrives, find the orders it covers, mark them as settled with the same date, and check that the order amounts minus listed deductions equal the credit. A gap means an order is missing or a charge was higher than you thought.

How should I count free samples and giveaways?

Give a row to each one. Amount received is zero, and the product cost, packaging and courier are still filled in. Net is negative. That is what a giveaway really cost, and it helps you judge whether the reach was worth it. The same goes for items you gift to a friend who promised to post about them. Treat them like any other order with zero money received.

Can a tracker do some of this?

Packaging, courier and supply spends all arrive as debits in your statements, and your sales as credits. SpendixAI lets you upload the statement of the account you use, review each row before saving, and keep categories for packaging, shipping and stock. Cash spends can be added by hand. It does not track order-by-order status, so the order sheet stays useful for net per order.

A weekly routine

  • Update the order sheet every few days, not once a month.
  • Mark each payout against its orders.
  • List orders that are delivered but unpaid.
  • Count returns separately so you can see the return rate: returned orders divided by total orders.
  • Review the five lowest-net orders and ask why.

If the business is growing and you need to know what you owe in tax or GST, ask a CA. Keep the order sheet and bank statements, because that is what they will ask to see.

SPENDIXAI JOURNAL

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

Explore your reports