Business

Expense tracker for a online marketplace seller in India: what to record

How an online marketplace seller in India can track expenses: fees, packaging, returns, ads, ten categories, personal items and a monthly routine.

Editorial illustration for Expense tracker for a online marketplace seller in India: what to record

An online marketplace seller should track five groups of cost: what you paid for stock, what the marketplace deducted, what you spent to pack and ship, what you spent on adverts and returns, and what you spent running the business from home. Put each under a fixed category, tag personal spending separately, and review monthly against what the marketplace actually paid you.

Why does the money received not match the sales?

The payout that lands in your bank account is usually smaller than the sale value, because deductions happen before payment. Fees, shipping charges, penalties and returns are netted off. If you record only the payout, you hide your costs; if you record only the sale value, you overstate what you earned.

Record both. The sale value goes to income, and each deduction goes to its own expense line, using the figures on the settlement statement. Take the figures from that statement and do not rely on memory or a standard rate.

What categories suit a marketplace seller?

CategoryExamples
StockGoods bought from suppliers or made by you
Marketplace deductionsCommission, fixed fees, collection fees as shown on the statement
ShippingCourier charges you pay, return shipping
PackagingBoxes, tape, bubble wrap, labels, poly bags
Returns and write-offsGoods lost, damaged or not resaleable
AdvertisingMarketplace ads and promotions
Photography and listingProps, lights, editing apps
Software and phoneSubscriptions, internet, a second SIM
StorageShelving, a rented room, inventory bins
DrawingsPersonal withdrawals, kept apart

Which items are business and which are personal?

A phone used to scan packages and also to scroll at night is the classic grey area. So are electricity, internet and the table you pack on. Mark each as business, personal or ask the CA. If you buy a gift for yourself with the marketplace payout, that is a withdrawal, not an expense.

What do sellers most often forget to record?

  • Small cash payments to a local packer or helper.
  • Return courier costs that appear only as a lump in the settlement.
  • Samples bought to test a product before listing.
  • Free items sent to a customer to settle a complaint.
  • Ad budget topped up through a UPI payment with no invoice.
  • Stock that never sold and was thrown away.

A quick fix is to keep a small box or a phone folder called unbilled. Every time you pay for something without a bill, drop a note in it with the amount and the reason. At month end, empty the box into the tracker, so cash spending is not left out just because it had no paper.

What does a hypothetical month look like?

Say a seller makes sales of 80,000. The marketplace deducts 9,000 in its fees and 6,000 in shipping, so the payout is 65,000. The seller also paid 28,000 for stock sold, 4,000 for packaging and 5,000 for ads, outside the payout. The arithmetic: 9,000 + 6,000 + 28,000 + 4,000 + 5,000 = 52,000 of costs, and 80,000 - 52,000 = 28,000 left before personal and home costs. These are invented numbers to show the method.

What routine keeps it simple?

  1. Download the settlement statement for the month and enter income and deductions as separate lines.
  2. Import the bank statement and tick off each payout.
  3. Add cash and UPI payments for packaging, helpers and ads.
  4. Mark personal items.
  5. Set aside what you will need for the CA, and ask them what they want in addition.

SpendixAI helps with the bank side: upload a statement, review the rows, and let categories carry over from your own corrections. Receipts can be kept with each transaction, which suits small packaging bills. The settlement figures still need to come from the marketplace itself.

SPENDIXAI JOURNAL

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

Explore your reports