SELECT frm.feesrec_no, frm.feesrec_checkno, frm.feesrec_date, frm.feesrec_cash, frm.feesrec_no, frm.feesrec_refno, frm.feesrec_total, frm.feesrec_bankname, frm.feesrec_id, sm.student_id, frm.transaction_id, frm.payment_mode, um.user_role, sd.student_curdiv, CONCAT(sm.student_firstname,' ',sm.student_lastname,' ',sm.student_surname) AS student_name, sec.section_name, sd.student_grno, (select standard_name from sms_standard std where std.standard_id = sd.student_curstd) As standard_name, um.user_name FROM sms_feesrecmaster frm, sms_studentmaster sm, sms_sectionmaster sec, sms_studentdetail sd, sms_usermaster um WHERE sm.student_id=sd.student_id AND frm.student_id = sm.student_id AND frm.student_id = sd.student_id and frm.section_id = sec.section_id AND frm.section_id = sd.section_id AND frm.login_id = um.user_id AND sd.year_id=frm.year_id and frm.school_id = '1' AND sec.school_id = '1' AND frm.year_id = '1' AND frm.feesrec_date >= '2026-08-01' AND frm.feesrec_date <= '2026-08-13' AND frm.section_id IN(1) order by frm.feesrec_date ASC

Daily Fees Collection - Summary Report
Section: PRE PRIMARY SECTION Div: 2026-2027 C:cash, B:cheque, O:Online
Sr No	Receipt No	Section	Standard	Division	GR No	Student Name	Username	Amount
Receipt Date: 04-08-2026
1	46	PRE PRIMARY SECTION	Jr.Kg	B	2215	AARAV HARISHCHANDRA YADAV	Tejas	11165(C)
Cash Received								11165
Cheque Received								0
Online Received								0
Phonepe Received								0
Swapcard Received								0
Total Received Amount :								11165
Receipt Date: 07-08-2026
2	56	PRE PRIMARY SECTION	Jr.Kg	B	2114	PARTH BIRENDRA DHAMI	Tejas	6285(C)
3	57	PRE PRIMARY SECTION	Nursery	A	2205	KRISHIKA CHANDAN GUPTA	Tejas	14040(C)
Cash Received								20325
Cheque Received								0
Online Received								0
Phonepe Received								0
Swapcard Received								0
Total Received Amount :								20325
Receipt Date: 10-08-2026
4	58	PRE PRIMARY SECTION	Nursery	A	2203	TANAY SANAJYBHAI VALVI	Tejas	4280(P)
Cash Received								0
Cheque Received								0
Online Received								0
Phonepe Received								4280
Swapcard Received								0
Total Received Amount :								4280
Receipt Date: 13-08-2026
5	67	PRE PRIMARY SECTION	Nursery	A	2210	YUVAN GANESH RAWAL	Tejas	4280(P)
Cash Received								0
Cheque Received								0
Online Received								0
Phonepe Received								4280
Swapcard Received								0
Total Received Amount								4280
FINAL TOTAL								40,050
Receiver Cash Cheque Online Phonepe Swapcard Total Tejas 31,490 0 0 8,560 0 40,050 Rs