Business

Expense tracker for a stationery shop owner in India: what to record

How a stationery shop owner in India can track expenses: seasonal stock, photocopy costs, personal versus shop money, 10 categories and a monthly routine.

Editorial illustration for Expense tracker for a stationery shop owner in India: what to record

A stationery shop owner should track expenses with separate lines for school-season stock, the photocopy and printing counter, and everyday counter items. The year has sharp peaks around the school reopening and exam months, so a monthly view hides what a seasonal view shows.

What does a stationery shop actually spend on?

  • Notebooks, pens, files, art supplies and geometry boxes from wholesalers
  • Paper reams, toner or ink and servicing for the photocopier and printer
  • Lamination pouches, binding material and passport-photo supplies
  • Rent, electricity and the extra lighting a copy counter needs
  • Part-time help in the reopening weeks
  • Packaging: carry bags and polythene covers
  • Bulk orders from schools or offices, which need stock bought ahead

Which ten categories should I use?

CategoryWhat goes in it
Retail stockNotebooks, pens, files, craft items
Copy counter suppliesPaper, toner, ink, binding
Equipment and servicingMachine repair, new cartridges
Rent and powerRent, electricity
StaffSalary, seasonal help
PackagingBags, covers
MarketingSchool visits, pamphlets, boards
Fees and interestCard charges, borrowing cost
FreightTransport for bulk stock
Owner drawingsPersonal withdrawals

Where do business and personal blur?

The family's own school supplies, a printer taken home, and children's stationery picked up from the shelf all count as personal. Note each as a drawing. Your own phone bill paid from the shop's UPI is personal too, unless you use that number only for orders.

What gets missed most?

  • Cash paid for paper reams delivered by a local supplier
  • Free photocopies and samples given to a school clerk or teacher
  • Printer repair done by a visiting technician with no bill
  • Advance taken from a school for a bulk order
  • Unsold back-to-school stock carried into the next year

The last point is easy to overlook. Notebooks do not expire but exam-specific kits and dated diaries do. Write down what is left each June so next year's order can be smaller.

Photocopy and print charges are worth a line of their own. A single ream and a toner refill can be costed per page, and you can then check whether the price on your board covers paper, toner, electricity and the machine's wear. Do that sum once a year, not once a decade.

What could a seasonal month look like?

Say reopening month sales are ₹3,00,000, of which the copy counter brings ₹30,000. Retail stock bought is ₹1,60,000, copy supplies ₹12,000, servicing ₹3,000, rent and power ₹28,000, staff including two seasonal helpers ₹36,000, packaging ₹4,000, marketing ₹5,000, freight ₹6,000 and fees and interest ₹7,000. Total outgoings are ₹2,61,000, leaving ₹39,000.

Now compare an off-season month with sales of ₹1,10,000. Fixed costs of rent, power and one permanent helper come to ₹40,000, and stock bought is ₹50,000. Outgoings are ₹90,000 and the month leaves ₹20,000. That is lower than the reopening month's ₹39,000, yet it is no sign of trouble, because the stock bought for the season was already paid for in the busy weeks.

What routine works?

  1. Enter bank and UPI lines from the statement.
  2. Add the cash notebook, with copier and paper costs noted separately.
  3. Match each wholesaler bill to its payment.
  4. List unpaid school bulk orders and their due dates.
  5. Count the fast-moving items and decide the next order.

SpendixAI can import your bank or card statement as PDF, CSV or Excel, let you review rows before saving, and keep a receipt with each transaction. On Pro, budgets let you watch a month's spending against a limit. Cash goes in by hand.

Next step

Write down your three biggest seasonal peaks and the stock you need for each. Put the dates in your calendar six weeks ahead.

SPENDIXAI JOURNAL

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

Explore your reports