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, 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-06' AND frm.feesrec_date <= '2026-08-06' order by frm.feesrec_no ASC
S.V.P. SECONDARY SCHOOL
S.V.P. SECONDARY SCHOOL
Opp. Lake view Garden, Piplod, Surat-395 007
Phone: 7016253999
HSC Index No: 18.0583
SSC Index No: 68.0451
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
1 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
FINAL TOTAL 10,000
 
Receiver Cash Cheque Online Phonepe Swapcard Total
Tejas 10,000 0 0 0 0 10,000 Rs