Free School ERP with Fees & Shop POS β Google Sheets
- Google Sheet link
- Source code file
- Resale rights
- Edit rights
- Setup guide
- AI setup help
- AI prompts used to build it

Mohammad Rameez Imdad
Founder of Rameez Scripts. I build these systems myself and help you set them up.
- 33K+YouTube subscribers
- 348+free tutorials
- 4+ yrsbuilding since 2022
Key Features
Description
A school ERP focused on the money side of running a school β fees in, salaries out, and the school shop in between β built on Google Sheets with Claude Code. Student and teacher records sit alongside fee collection, payroll, income and expense, and a point of sale for uniforms and textbooks.
What it does
Registering a student fills a form on the left while the profile builds live on the right, so you can see the record taking shape as you type. From the student list you can open their fee history, print a fee receipt, or print a challan for the next payment. Teachers work the same way: create the record, see the profile build, then open their salary history and print a payslip for any month. A parent with two or three children can settle all of their fees in one go rather than one child at a time.
The school shop
Schools sell things β textbooks, pencil boxes, bags, uniforms β and this includes the inventory and point of sale for it. Add items, sell them against a named student, and choose whether they paid now or on credit to pay later. Returns restock automatically, sales deduct automatically, and stock transactions record purchases in and sales out against your vendors.
Highlights
- Dashboard with financial overview, income, expense, recent transactions and recent activity
- Printable fee receipts, fee challans and teacher payslips
- Income and expense tracking alongside the fee and salary flows
- Two roles β super admin and admin β with a live permission matrix for view, add, edit and delete
- SWR caching, so moving between sections is instant rather than a reload
- The Claude Code prompts used to build it, split into staged steps
Who it is for
Small schools and academies whose real pain is fee collection, teacher salaries and shop stock rather than timetabling. If you need admissions, exams, hall tickets and daily attendance as well, the fuller school management system in the catalogue covers those instead.
Requirements 5
- A Google account (Gmail or Google Workspace)
- Google Sheets as the database β no server or MySQL needed
- Google Apps Script web app deployment access
- Modern browser (Chrome, Edge, Firefox or Safari)
- A printer for fee receipts, challans and payslips
What's Included 12
- Full Apps Script source code (Code.gs + index.html)
- Student and teacher records with live profile previews
- Fee collection with receipts and challans
- Teacher salary payments with payslips
- Income and expense tracking
- School shop inventory and point of sale
- Returns, stock transactions and vendors
- Two preset roles with a live permission matrix
- User management, settings and activity logs
- The staged Claude Code prompts used to build it
- Full video walkthrough
- Free support and paid customization on request
Item Details
| Version | v1.0 |
| Published | Aug 21, 2026 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Education & School, ERP & Business Suite |
| Video | Watch walkthrough |
| License | Regular License |
Need this customized for your business?
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
20–30% advance to start · Clear quote before work begins · Support after delivery
What we customize
- Features & functionsNew features, changes to existing scripts, custom formulas and automations
- API & integrationsWhatsApp, payment gateways, CRM and more
- Design & UI changesYour branding, layout redesign, dark mode, mobile layout
- Full custom projectsDashboards, billing, inventory, CRM, built from scratch
People choose these
Paid picks from the same category
Reviews & Feedback
What buyers and YouTube viewers say about this project.

