Business

Expense tracker for a reseller in India: what to record

How a reseller in India can track expenses: buying stock, delivery, platform fees, returns, storage, categories, personal items and a monthly routine.

Editorial illustration for Expense tracker for a reseller in India: what to record

A reseller makes money on the gap between buying price and selling price, so the one number to protect is the cost of each item you sell. Record what you pay for stock, add what it costs to bring it to the customer, and track every other cost separately. Ten categories keep the picture honest without taking over your evenings.

What is a reseller's real cost of an item?

The price on the supplier's bill is only the start. Add the delivery you paid to receive it, any repacking, the courier you pay to send it on, and the share of fees taken by wherever you sell. Only then do you know whether a sale at a given price was worth making.

Say you buy a lot of 40 phone covers for 6,000 and pay 400 for delivery. The landed cost is 6,400, so each cover costs 6,400 / 40 = 160 before you pack or ship it. If you sell each for 249, the gap per piece is 249 - 160 = 89 before packaging, courier and fees. Numbers like these are invented, but the method is real.

Which categories does a reseller need?

CategoryWhat goes in it
Stock boughtSupplier bills, wholesale market purchases
Inward deliveryTransport and loading to bring goods in
Outward courierCourier, local rider, return freight
Selling feesPlatform or app deductions shown on statements
PackagingCovers, boxes, tape, stickers
StorageRent for a room or shelf, bins
MarketingAds, samples, banners, WhatsApp broadcasts
Returns and damageRefunds, damaged goods, unsold waste
Phone and toolsData pack, apps, printer, scales
DrawingsPersonal withdrawals

Which items are business and which are personal?

Resellers often buy items they like for themselves from the same supplier. Mark those as drawings. The family phone that you also use for orders is shared, so tag it shared and ask your CA how to treat it.

What do resellers most often fail to record?

  • Wholesale market trips: autos, tea, hamali and parking.
  • Goods given as samples or free gifts to build a customer.
  • Damaged items that you simply put aside.
  • Cash given to a helper for packing during the festive rush.
  • Small stock bought on a friend's card and repaid later by UPI.

An easy rule: if money left, write it down that day. If you cannot, text yourself a one-line note. The tracker is only as complete as these small entries.

Pricing mistakes are the other big leak. A reseller who copies a rival's selling price without knowing their own landed cost can sell dozens of pieces and still end the month with nothing. Once a quarter, pick your five fastest-selling items and work out the gap per piece after delivery, packing, courier and fees. If one of them turns out to leave only a few rupees, either raise the price, negotiate with the supplier, or stop pushing it.

What does a routine look like?

  1. Enter every supplier bill with a quantity and a landed cost per piece.
  2. Mark which stock sold and which is left, even approximately.
  3. Import the bank statement and tag the account.
  4. Add cash costs and tag personal items.
  5. Review the categories and note one thing to change next month.

SpendixAI can import your statements, let you review the rows before saving, and keep a receipt with the transaction it belongs to, which suits small supplier bills. It will not track your stock levels, so keep a simple stock list alongside.

SPENDIXAI JOURNAL

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

Explore your reports