School Fee Receipt Format in Excel (Free) – Receipt Register + Printable Receipt

school fee receipt format

Advertisement

Quick answer: A school fee receipt is proof that a parent has paid fees. It should show:

  • the school’s name and address, a receipt number and the date
  • the student’s name, admission number, class and father’s name
  • the period the fees are for
  • each fee head (tuition, transport, exam…) and any late fee
  • the total in figures and words, and the payment mode

The free Excel template below keeps a receipt register and prints any receipt in a parent copy + office copy format with automatic receipt numbers.

Key takeaways

  • Name your own 8 fee heads: tuition, admission, annual charges, transport, exam, computer, activity, other.
  • Keep a receipt register of up to 500 receipts with automatic receipt numbers.
  • Print any receipt: parent copy and office copy on one A4 page, amount in words, only the heads actually paid.
  • Free, with no macros. It works in Excel, Excel for Mac and Google Sheets.

↓ Jump to the free download

FOR SCHOOLS & TUITIONSCollect every rupee of fees — without the register.XploreFees keeps class-wise fees, prints receipts and lists defaulters with WhatsApp reminders.See XploreFees — from ₹499 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreFees

School fee receipt format in Excel with parent copy and office copy
A fee receipt with parent and office copies. Fee heads with no amount are left blank automatically.

What a fee receipt should include

PartWhy it matters
School name, address, phone, sessionIdentifies who received the money
Receipt number (serial) and dateEvery receipt can be traced and none can be missed or duplicated
Student name, admission number, class, father’s nameMatches the payment to the right student
Period (for example Oct-2026 or Oct–Dec 2026)Shows which months are paid, so there are no disputes later
Fee heads and late feeParents can see exactly what they paid for
Total in figures and words, mode and referenceProof of payment; the UPI or cheque number helps reconcile with the bank
Signature of the accountant or authorised personMakes the receipt valid

How to use the template

  1. Setup: enter the school name, address, phone, session and receipt prefix (for example BFPS/26-27/), and rename the 8 fee heads.
  2. Receipt Register: one row per payment, with date, admission number, student, class, father, period, the amount under each head, late fee and mode. The receipt number and total fill in automatically.
  3. Print Receipt: type the receipt number (the latest one shows by default) and print, or save as PDF to send on WhatsApp.
Fee receipt register in Excel with automatic receipt numbers and fee heads
The receipt register: one row per payment with automatic receipt numbers.
School details and fee heads setup for fee receipt in Excel
Set up the school details and your own fee heads once.

Is GST charged on school fees?

Fees charged by schools for education up to higher secondary (Class 12) are generally exempt from GST. Coaching centres and private tuition classes are usually not covered by this exemption, so a GST-registered coaching institute has to charge GST on its fees. Confirm your own case with a CA.

Outgrown the free sheet? Here’s what XploreFees adds

Free sheetXploreFees
Class-wise fee structure—✓
Monthly, quarterly or one-time fees—✓
Student fee ledger—✓
Monthly collection report—✓
Up to 1,000 students—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreFees — from ₹499 →

Download the free School Fee Receipt Format

It is free for life and has no macros. It works for schools, play schools, tuition centres, coaching institutes, music and dance academies, and hostels: just rename the fee heads.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

Can I change the fee heads?

Yes. Rename any of the 8 heads on the Setup sheet and the register and receipt update automatically.

Advertisement

How do I give one receipt for three months?

Enter the total for the three months under each head and write the period as, for example, “Oct–Dec 2026”.

Can I send the receipt on WhatsApp?

Yes. Save the Print Receipt sheet as PDF and send the PDF.

Is this a school ERP?

No. It is a simple receipt book in Excel. For automatic dues and defaulters, see XploreFees.

More free templates for schools

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.