Business

Expense tracker for a self-published author in India: what to record

How a self-published author in India can track book costs, royalties and launch spending title by title, with categories and a break-even worked example.

Editorial illustration for Expense tracker for a self-published author in India: what to record

A self-published author is both writer and publisher, so the tracker should work like a small publisher's: one ledger per title, listing what you spent to make the book and what the book has earned back. Record every payment to an editor, cover designer or printer against the title, and every royalty as it lands. That one habit tells you when a book breaks even.

Why keep a ledger for each title?

Spending on a book is front-loaded: editing, cover, formatting and proofreading all come before the first sale. Royalties then trickle in over months, often from several platforms, sometimes in another currency. If everything goes into one pool, a first book that is still repaying itself looks the same as a second book that is not selling at all. A ledger per title keeps the picture honest.

What are the cost lines?

  • Editing: developmental edit, line edit, copy edit, whichever you paid for
  • Proofreading before the final upload
  • Cover design and any illustration or photo licence
  • Interior formatting for print and e-book
  • Printing: author copies and any small print run
  • Advertising and promotion: social media ads, giveaways, bookmarks and posters
  • Launch: a reading event, hall hire, tea and snacks, flowers
  • Review copies: printing and courier to reviewers and bloggers
  • Registration and listing charges that you actually paid, kept with the bill

What does break-even look like?

Say, purely as an example, that your first title cost: editing ₹15,000, cover ₹6,000, formatting ₹3,000, proofreading ₹4,000, ads ₹5,000 and author copies ₹8,000. Total spend is ₹41,000. If royalties come to roughly ₹3,500 a month, you would need about twelve months to reach break-even, since 41,000 divided by 3,500 is a little under twelve.

ItemAmount (₹)
Editing15,000
Cover6,000
Formatting3,000
Proofreading4,000
Ads5,000
Author copies8,000
Total spent on the title41,000

Real royalties vary widely and may be nothing like this, so treat the example as arithmetic, not a forecast. The useful part is seeing, month by month, how much of the total has come back.

Think too about the second and third titles. Costs shared across books, such as a website, an author photo shoot or a newsletter tool, belong in a general category, not in one title. A simple rule is to split them evenly across the books you have published that year, or leave them general and look at them separately. Whichever you pick, do it the same way every time.

Which items do authors forget?

  • Copies you hand out free to family, reviewers and libraries, which are a cost of promotion
  • Cash taken at a launch event or book fair for copies you sold by hand
  • The auto fare or cab to a printer or a bookshop
  • Courier charges for review copies, paid in cash
  • A freelance designer's second round of changes, paid as a small top-up
  • Subscription for design or writing tools charged to a card

How do I treat cash sales and free copies?

When you sell copies at an event for cash, write down the date, the number of copies and the money collected, and deposit it. When you give copies away, record the number and who got them, so the cost of printing them has a purpose attached. If you keep stock at home, a count at the end of every quarter shows how many copies remain.

What routine keeps this up to date?

  1. Add every spend to the title's ledger as it happens, with the vendor and date.
  2. Record each royalty with the platform and month it covers.
  3. Tag your general costs, such as tools and internet, as practice and the household ones as personal.
  4. Update the stock count and cash sales.
  5. Check how much of the title's total cost is covered so far.

If your spending passes through bank and card statements, SpendixAI can import them as PDF, CSV or Excel, let you review rows, and sort them into categories you create, such as editing, cover and launch. Royalties by title are better held in your own sheet. Share the totals with your CA when it is time to file.

SPENDIXAI JOURNAL

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

Explore your reports