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

school fee receipt format
Ads loading…

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.

Ads loading…
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.

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.

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.

Ads loading…

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

Ads loading…

Advertisement

Amanpreet Kaur Bharaj
Welcome to my profile! My name is Amanpreet Kaur, and I am a Freelance Microsoft Excel Specialist with an extensive background in data management and analysis. I offer top-tier Excel services, helping businesses optimize their processes, make informed decisions, and improve overall efficiency.Over the years, I have honed my skills in Excel to provide solutions tailored to each client's unique needs. I specialize in creating and maintaining complex Excel spreadsheets, utilizing advanced functions and formulas for optimal data processing, and designing macros to automate repetitive tasks.My expertise extends to crafting custom Excel VBA scripts, which allows me to cater to specific project requirements. Additionally, I am adept at building and managing pivot tables for robust data analysis and visualization. I also offer data cleaning services to ensure data integrity and reliability.With a keen eye for detail and a strong commitment to accuracy, I provide Excel-related technical support and training, always ensuring the highest quality in the work I deliver. My strong analytical and problem-solving skills, combined with excellent communication abilities, enable me to understand and fulfill your data requirements effectively.As a freelancer, I understand the value of meeting deadlines and deliver high-quality output within the agreed timeframe. I can work independently on projects, offering turnkey solutions that drive successful results. Staying updated with the latest developments and features in Microsoft Excel is a commitment I take seriously, always aiming to provide the most current and efficient solutions to my clients.Having worked with various industries, I have a broad outlook that allows me to adapt quickly to new environments and data structures. Whether it's a small business looking to streamline their data management or a large corporation in need of complex data analysis, I take pride in delivering the best possible results.I'm passionate about helping organizations make sense of their data and uncover insights that can propel their growth. So, if you're looking for a reliable, efficient, and professional Microsoft Excel expert, you've come to the right place.Thank you for visiting my profile. I look forward to the opportunity of working together and leveraging the power of data to drive your business forward!