Business

Expense tracker for a handicraft seller in India: what to record

What a handicraft seller in India should record: materials, packaging, courier, fair stall fees, artisan pay and cash sales, with a worked month.

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

A handicraft seller should record raw materials, packaging, shipping, fair and stall costs, artisan payments and any platform fees, and match each to the sales it helped make. The most common gap is cash: a melas weekend can produce a lot of sales and a lot of small spending that never touches a bank statement. A short list of categories and a weekly habit fix most of it.

What are the real cost lines?

  • Raw materials: cloth, thread, beads, clay, wood, paint, dyes, depending on the craft.
  • Tools and small equipment, and their repair.
  • Artisan payments: piece-rate or daily wages to the people who make or finish products.
  • Packaging: boxes, bubble wrap, tags, tape, gift wrapping.
  • Courier and postage for online orders, and return shipping.
  • Platform fees on marketplaces, and payment fees on cards and UPI gateways.
  • Fairs and exhibitions: stall fee, travel, stay, display material, transport of stock.
  • Photography, product listing and advertising.

Which lines are personal and which belong to the business?

Your own food and travel at home are personal. The same meal at a three-day fair, eaten because you were stuck at the stall, is a business cost for many sellers, though how to treat it is for your CA. What matters for tracking is a clear rule: write down which side each line is on, and stick with it. Do not pay for materials from household cash without noting it, because that is how a craft business quietly loses track of its real margin.

What does a hypothetical month look like?

LineAmount
Sales (online and cash)₹68,000
Raw materials₹16,500
Artisan payments₹12,000
Packaging₹2,300
Courier₹3,200
Platform and payment fees₹4,000
Fair stall fee and travel₹5,500
Total costs₹43,500
Left before your own pay₹24,500

Costs: 16,500 + 12,000 + 2,300 + 3,200 + 4,000 + 5,500 = ₹43,500. Sales minus costs: 68,000 - 43,500 = ₹24,500. The numbers are made up. What the exercise shows is how the leftover compares with the sales: 24,500 ÷ 68,000 is about 36 per cent, which is worth checking against what you hoped.

Fairs deserve a line of their own. Say a three-day fair brings ₹14,000 in sales, with a stall fee of ₹3,000 and travel and stay of ₹1,500. Before materials and artisan pay, the fair left 14,000 - 3,000 - 1,500 = ₹9,500. Whether to go again next year is easier to decide with that figure than with a feeling that it was busy.

Which receipts and cash items get missed?

  • Small purchases at the market for thread, glue or buttons, paid in cash with no bill.
  • Auto and tempo fares carrying stock to a fair.
  • Cash advances to artisans before a festival rush.
  • Packaging bought in bulk for several months but entered once.
  • Returned orders, where you paid shipping twice and refunded the customer.

How should you treat unsold stock and returns?

Materials bought for a product you have not yet sold are a cost you have paid but not yet earned back, so note them rather than pretending the month was a loss or a win. If an order is returned, record the refund against the sale and the return courier as its own cost. After a few months you will know which products come back most often and what that quietly takes from the margin.

What routine keeps it manageable?

  1. After every market trip or fair, write down the cash spent before you forget.
  2. Weekly, list artisan payments and note which products they were for.
  3. Monthly, upload the bank or card statement and categorise the lines.
  4. Before festivals, review stock and materials, because that is when spending peaks.
  5. At year end, give your CA a clean export.

SpendixAI lets you add expenses by hand, several at a time, which suits a day of cash spending, and keeps receipts with their transactions. It will not manage your stock or invoices, so use it for the money side only.

SPENDIXAI JOURNAL

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

Explore your reports