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-06'

Daily Fees Collection - Summary Report
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	A	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: 03-08-2026
2	86	PRIMARY SECTION	3	B	4413	HARSHIT ROSHAN YADAV	Tejas	6470(O)
3	87	PRIMARY SECTION	3	B	4413	HARSHIT ROSHAN YADAV	Tejas	600(O)
4	88	PRIMARY SECTION	3	B	4558	DEVIKA DHARMENDRA SINGH	Tejas	10870(O)
5	89	PRIMARY SECTION	3	B	4558	DEVIKA DHARMENDRA SINGH	Tejas	600(O)
6	90	PRIMARY SECTION	Balvatika	B	4769	MAHIKA DHARMENDRA SINGH	Tejas	10565(O)
Cash Received								0
Cheque Received								0
Online Received								29105
Phonepe Received								0
Swapcard Received								0
Total Received Amount :								29105
Receipt Date: 04-08-2026
7	91	PRIMARY SECTION	6	A	3762	DHRUVI MANOJKUMAR PADVI	Tejas	11180(P)
Cash Received								0
Cheque Received								0
Online Received								0
Phonepe Received								11180
Swapcard Received								0
Total Received Amount :								11180
Receipt Date: 05-08-2026
8	102	PRIMARY SECTION	Balvatika	B	4766	DHWANI VIVEKKUMAR PATEL	Tejas	10565(P)
9	103	PRIMARY SECTION	Balvatika	B	4794	DHYEY VIVEKKUMAR PATEL	Tejas	10565(P)
Cash Received								0
Cheque Received								0
Online Received								0
Phonepe Received								21130
Swapcard Received								0
Total Received Amount :								21130
Receipt Date: 06-08-2026
10	109	PRIMARY SECTION	3	B	4384	DHYAN PARESHBHAI PATEL	Tejas	10000(C)
Cash Received								10000
Cheque Received								0
Online Received								0
Phonepe Received								0
Swapcard Received								0
Total Received Amount :								10000
Receipt Date: 04-08-2026
11	49	SECONDARY SECTION	10	B	1417	HEM SAHILKUMAR PATEL	Tejas	5000(C)
12	50	SECONDARY SECTION	10	B	1417	HEM SAHILKUMAR PATEL	Tejas	2950(P)
Cash Received								5000
Cheque Received								0
Online Received								0
Phonepe Received								2950
Swapcard Received								0
Total Received Amount :								7950
Receipt Date: 05-08-2026
13	54	SECONDARY SECTION	10	B	1456	BHUMI BHARATBHAI SONI	Tejas	7950(P)
Cash Received								0
Cheque Received								0
Online Received								0
Phonepe Received								7950
Swapcard Received								0
Total Received Amount :								7950
Receipt Date: 03-08-2026
14	6	HIGH SECONDARY SCIENCE	12 SCI	B	1119	HIYA ALKESH NAIK	Tejas	17750(O)
Cash Received								0
Cheque Received								0
Online Received								17750
Phonepe Received								0
Swapcard Received								0
Total Received Amount :								17750
Receipt Date: 04-08-2026
15	45	HIGH SECONDARY	12	A	1166	JAY RAJIV MAHIDA	Tejas	25000(P)
Cash Received								0
Cheque Received								0
Online Received								0
Phonepe Received								25000
Swapcard Received								0
Total Received Amount								25000
FINAL TOTAL								141,230
Receiver Cash Cheque Online Phonepe Swapcard Total Tejas 26,165 0 0 115,065 0 141,230 Rs