Business

Expense tracker for a online course creator in India: what to record

A tracker guide for an online course creator in India: gateway fees and refunds, ad spend, editing, tools, foreign subscriptions and a worked sample month.

Editorial illustration for Expense tracker for a online course creator in India: what to record

An online course creator's money arrives in a way that confuses most trackers: the platform or payment gateway pays you after taking its fee and subtracting refunds. Record the sale, the fee and the refund as three lines, and your profit stops being a guess.

Why does the money in your bank not match your sales?

Say 40 students buy a ₹1,499 course. Sales come to ₹59,960. Two students ask for refunds, which is ₹2,998. The gateway's fee for the month is ₹1,800. The bank shows 59,960 minus 2,998 minus 1,800, which is ₹55,162. If you record only the ₹55,162, you cannot see how much went on fees or how many refunds you gave. If you record only the ₹59,960, you overstate what you earned. Record all three.

What does a course creator spend on?

  • Ads on social platforms and search to bring students in.
  • A video editor, thumbnail designer or caption writer paid per project.
  • Hosting or course-platform fees, a domain name, an email-sending tool.
  • Camera, microphone, lights, a laptop and a backdrop.
  • Subscriptions billed in dollars, such as design or scheduling tools.
  • A community platform, a webinar plan, an online whiteboard.
  • Co-working or a quiet studio hour if home is too noisy.

Which categories fit this work?

CategoryNotes
SalesGross course revenue before fees
Gateway feesDeducted before settlement
RefundsMoney returned to students
AdvertisingCampaign spend on each platform
Editing and designFreelancers and one-off projects
Software and hostingMonthly and yearly subscriptions
EquipmentCamera, mic, lights, laptop
Foreign-currency toolsDollar subscriptions with the rate actually charged
Learning and communityCourses and groups you pay for

What does a hypothetical month look like?

Taking the sample sales above, the net settlement is ₹55,162. Spending: ads ₹12,000, editor ₹6,000, software ₹2,400 and hosting and domain set-aside ₹500. Those add to ₹20,900. The month leaves 55,162 minus 20,900, which is ₹34,262. Note that ad spend came in before most of the sales did. A launch that spends ₹12,000 in one week and sells over three months will look poor in the first month and rich in the next, so look at a quarter.

How do foreign subscriptions fit in?

Tools billed in dollars arrive on your card statement as a rupee amount that includes the exchange rate and any card charges. Record the amount your bank actually charged, with the currency and original amount in the note. How tax treats overseas subscriptions is a question for your CA, so just keep the invoice.

What gets forgotten in a creator's books?

  • Free trials of tools that quietly became paid after the first month.
  • Ad credit received as a promotion, which is not the same as money you spent.
  • Payments to a friend who edits videos, made by UPI with no invoice.
  • A yearly domain or hosting renewal that hits the card once and is missed in the monthly view.
  • Equipment bought for the first course, such as a ring light, which belongs in your records even when it was bought years ago.

A monthly routine for a creator

  1. Download the gateway settlement report and note sales, fees and refunds.
  2. Import the bank statement and match each settlement credit.
  3. Add ad and freelancer invoices, with the invoice number in the note.
  4. Review subscriptions and cancel any you no longer use.

SpendixAI supports expenses in their own currency with totals in a base currency, which suits dollar subscriptions. Choose the base currency before you import anything, because it cannot be changed once transactions exist.

SPENDIXAI JOURNAL

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

Explore your reports