Management

Connecting to Google Sheets & Google Drive...

⚠️ Google Sheets URL Not Set Yet: To save data permanently across all devices, paste your deployed Google Sheet Web App URL into GOOGLE_SHEET_WEB_APP_URL at the top of the script (or in the Settings tab).

School Management System

100% Google Sheets & Google Drive Cloud Dashboard

☁️ Google Cloud Active Session: 2026-2027 Admin

Staff & Management Login

Connected to Google Sheets & Google Drive Cloud

Staff Username

Password

Students with Pending Fee Balances

Student ID	Admission No	Full Name	Class / Sec	Mobile	Pending Balance	Action

Recent Fee Transactions

Receipt	Student	Period	Amount	Method

Recent Student Admissions

Student ID	Adm No	Name	Class	Status

Register New Student Admission

Student ID * (Auto: 26EEC0001)

Admission Number * (Auto: ENGLV0001)

Full Name *

Father's Name *

Mother's Name

Date of Birth *

Gender * Male Female Other

Student / Primary Mobile *

Parent / Guardian Mobile *

Email Address

Class * Class 1Class 2 Class 3Class 4 Class 5Class 6 Class 7Class 8 Class 9Class 10 Class 11Class 12

Section * Section A Section B Section C

Roll Number *

Admission Date *

Academic Session *

Monthly Tuition Fee *

Other Monthly Charges

Student Portal Password

Student Status * Active Inactive Transferred

Full Residential Address *

Registered Students Directory (Edit or Delete Anytime)

All Classes Class 1Class 2 Class 3Class 4 Class 5Class 6 Class 7Class 8 Class 9Class 10 Class 11Class 12

Student ID	Admission No	Full Name	Father's Name	Class / Sec	Roll	Mobile	Tuition Fee	Status	Actions (View / Edit / Delete)

Monthly Fee Collection & Receipt Counter

Select Student * -- Choose Student --

Student ID & Class

Academic Session *

Fee Month * AprilMayJune JulyAugustSeptember OctoberNovemberDecember JanuaryFebruaryMarch

Fee Year *

Tuition Fee

Admission Fee (if applicable)

Examination Fee (if applicable)

Other Charges (Transport/Lab)

Discount / Scholarship (-)

Late Fee (+)

Other Payments Made (This Month)

Previous Months Pending Dues

Net Payable (This Month)

Amount Received *

Remaining Balance (This Month)

Payment Date *

Payment Method * Cash UPI Bank Transfer Other

Transaction Reference No.

Remarks

Fee Transactions & Receipt Ledger (Edit or Delete Any Payment)

All Months AprilMayJune JulyAugustSeptember OctoberNovemberDecember JanuaryFebruaryMarch

Receipt No	Date	Student	Class	Period	Paid Amount	Balance After	Method	Status	Actions (Receipt / Edit / Delete)

1. Create Examination

Examination Name *

Exam Type * Unit Test Half-Yearly Annual Examination Test Examination

Academic Session *

Class * Class 1Class 2 Class 3Class 4 Class 5Class 6 Class 7Class 8 Class 9Class 10 Class 11Class 12

Section * Section A Section B Section C

Exam Date *

2. Add Subject to Examination

Select Examination *

Subject Name *

Subject Code *

Maximum Marks *

Passing Marks *

3. Enter Student Marks, Save Draft & Publish Results

Management Reports & CSV / PDF Exports

1. Student Admission Register 2. Monthly Fee Collection Report 3. Outstanding Fee Balances Report

School Settings & Google Drive / Sheets Backup

School Name *

School Tagline

School Logo URL

School Phone Number

School Email

Currency Symbol

Active Academic Session

Show Address on Student Portal? Yes No

School Full Address

⬆️ Upload & Restore Backup (.JSON) to Cloud

Security Audit Trail (Recent 50 Logs)

Timestamp	Actor	Role	Action	Entity	Target ID	Details

Document View