Download a free School Fees Collection Excel Sheet Template to easily track and manage student fee payments. This ready-to-use Excel template helps schools and educational institutions record student details, fee amounts, payment dates, paid and pending fees, and collection records in a simple and organized format. It is useful for maintaining accurate school fee collection records and monitoring outstanding payments.
Key Features :
- Receipt No.
- Collection Date
- Student ID
- Student Name
- Class
- Section
- Fee Type
- Academic Year
- Due Amount
- Discount
- Net Amount
- Paid Amount
- Balance
- Payment Mode
- Transaction
- Status
- Remarks
- Dashboard
- Pie Chart
- Bar Chart
- KPI Card
Formulas :
Net Amount
=IF(D5=””,””,I5-J5)
Balance
=IF(D5=””,””,MAX(K5-L5,0))
Status
=IF(D5=””,””,IF(M5=0,”Paid”,IF(L5=0,”Pending”,”Partial”)))
Paid =COUNTIF(‘Fees Collection’!P5:P1002,A8) =SUMIF(‘Fees Collection’!P5:P1002,A8,’Fees Collection’!L5:L1002)
Partial =COUNTIF(‘Fees Collection’!P5:P1002,A9) =SUMIF(‘Fees Collection’!P5:P1002,A9,’Fees Collection’!L5:L1002)
Pending =COUNTIF(‘Fees Collection’!P5:P1002,A10) =SUMIF(‘Fees Collection’!P5:P1002,A10,’Fees Collection’!L5:L1002)
Overdue =COUNTIF(‘Fees Collection’!P5:P1002,A11) =SUMIF(‘Fees Collection’!P5:P1002,A11,’Fees Collection’!L5:L1002)
Tuition Fee =COUNTIF(‘Fees Collection’!G5:G1002,E8) =SUMIF(‘Fees Collection’!G5:G1002,E8,’Fees Collection’!K5:K1002)
Admission Fee =COUNTIF(‘Fees Collection’!G5:G1002,E9) =SUMIF(‘Fees Collection’!G5:G1002,E9,’Fees Collection’!K5:K1002)
Exam Fee =COUNTIF(‘Fees Collection’!G5:G1002,E10) =SUMIF(‘Fees Collection’!G5:G1002,E10,’Fees Collection’!K5:K1002)
Transport Fee =COUNTIF(‘Fees Collection’!G5:G1002,E11) =SUMIF(‘Fees Collection’!G5:G1002,E11,’Fees Collection’!K5:K1002)
Hostel Fee =COUNTIF(‘Fees Collection’!G5:G1002,E12) =SUMIF(‘Fees Collection’!G5:G1002,E12,’Fees Collection’!K5:K1002)
Library Fee =COUNTIF(‘Fees Collection’!G5:G1002,E13) =SUMIF(‘Fees Collection’!G5:G1002,E13,’Fees Collection’!K5:K1002)
Annual Fee =COUNTIF(‘Fees Collection’!G5:G1002,E14) =SUMIF(‘Fees Collection’!G5:G1002,E14,’Fees Collection’!K5:K1002)
Other =COUNTIF(‘Fees Collection’!G5:G1002,E15) =SUMIF(‘Fees Collection’!G5:G1002,E15,’Fees Collection’!K5:K1002)
