Business

Expense tracker for a bookshop owner in India: what to record

What a bookshop owner in India should record: cost lines, publisher credit, personal versus shop money, 10 categories and a simple monthly routine.

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

A bookshop owner should track expenses in categories that separate stock bought from publishers and distributors, returns, and the shop's running costs. Because books can often be sent back for credit or sold on a consignment basis, the shop's real cost is not the same as the bills you pay.

What are the real cost lines of a bookshop?

  • Books bought outright from publishers, distributors and wholesalers
  • Books taken on sale-or-return terms, which may be sent back for credit
  • Rent for the shop and for any storeroom
  • Electricity and the lighting needed to let customers browse
  • Staff, including seasonal help when school textbooks arrive
  • Shelving, book covers, bags and bookmarks
  • Events: book launches, school visits, reading hours

Which ten categories work well?

CategoryWhat goes in it
Books boughtPublisher and distributor bills
Returns and creditsCredit notes for books sent back
Rent and storageShop and storeroom
Power and internetElectricity, broadband
StaffSalary, seasonal help
Shelving and fit-outRacks, lighting, signage
PackingBags, covers, tape
Events and promotionLaunches, school visits, ads
Fees and interestCard charges, loan cost
Owner drawingsPersonal withdrawals

How do returns change the picture?

Say you buy a lot of 100 copies of a title for ₹30,000 and sell 60. If the publisher accepts the unsold 40 back for credit, your real cost on that title is the cost of the copies you kept. If the supplier does not take them back, ₹12,000 of that purchase is still on the shelf, and it may not sell. Record each return as a credit note with the date and title. Do not net it silently against the next payment.

What is personal and what is the shop's?

Books taken home for yourself or the family are personal, even if you would have read them anyway. Record each as a drawing, with the title and price. A personal subscription or a family trip paid from the shop's account goes in the same place. Keep one jar or sheet for these and you will not have to reconstruct them.

What do owners usually miss?

  • Cash paid to a local binder or for book covering
  • Postage to send a special order to a customer
  • Free copies given to a school for a review
  • Damaged copies written off without a note
  • Advance paid to a distributor for a textbook order

What might a month look like?

Say takings are ₹2,40,000. Books bought are ₹1,50,000, with ₹20,000 in credit notes for returned titles, so the net book cost is ₹1,30,000. Rent and storage are ₹30,000, power and internet ₹6,000, staff ₹28,000, packing ₹3,000, events ₹8,000 and fees ₹5,000. Outgoings are ₹2,10,000, leaving ₹30,000.

What is the monthly routine?

  1. Enter bank and card lines from the statement.
  2. Add cash entries from the counter notebook.
  3. Record each credit note and pair it with its bill.
  4. List titles where you can still claim a return from the publisher.
  5. Save the month's totals.

SpendixAI can import the statement for the shop account as PDF, CSV or Excel, and show each row for review before it is saved. You can create your own categories and sub-categories, such as books bought and returns, and see their totals in a report. Cash can be added by hand.

Think about shelf life as well. A title that has not sold in six months may sit on the shelf for years. Mark the date each book was bought, note the discount you got from the publisher, and review anything older than a year. Such books are stock you paid for but cannot spend, and a markdown sale may bring back more cash than another year of waiting.

Next step

Pick your five slowest titles and write a note of the last date you can return them. That alone can release real money.

SPENDIXAI JOURNAL

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

Explore your reports