Need a customized project? We build it to your exact requirements.Contact us on WhatsApp

Free School ERP with Fees & Shop POS – Google Sheets

F23 Education & School ERP & Business Suite Free Apps Script Pass Pro Business
Need a Custom System? We Build It From Scratch
I Built a School ERP in Google Sheets with Claude Code
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help
  • AI prompts used to build it
Built and supported by

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

Student registration with a live profile preview beside the form Per-student fee history with printable fee receipt and fee challan Teacher records with a live profile preview and full salary history Printable teacher payslip per month Fee collection for a single student or a parent paying for several children Salary payments to teachers with previous payment history shown Income and expense recording with a financial overview on the dashboard School shop inventory for textbooks uniforms bags and stationery Point of sale for selling shop items to a named student Paid or credit pay-later option at the point of sale Returns that restock the item automatically Stock transactions for purchase in and sales out Vendor register for shop supplies Recent transactions and recent activity on the dashboard Two roles of super admin and admin with a live permission matrix Toggle view add edit and delete per module without touching code User management settings and activity logs Built on Google Sheets with SWR caching for instant page switching

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

Versionv1.0
PublishedAug 21, 2026
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryEducation & School, ERP & Business Suite
VideoWatch walkthrough
LicenseRegular License
Get this source code free F23
  • Full source code
  • Google Sheet
  • Setup guide
  • AI prompts

Unlock the source code + AI prompts in 1 step

Source codeApps Script + Google Sheet
AI promptsThe prompts used to build it
Subscription Verification Required
This is a free file. Subscribe to our YouTube channel to unlock the source code + Google Sheet. One click β€” no payment. Google only confirms you are subscribed.
Verify Now
Free download

Verify your subscription

Subscribed to the channel? Verify in one click and download the source code and AI prompts.

What you get

  • Code.gs + HTML filesThe complete Apps Script project
  • Google SheetYour own copy with the data
  • Setup guideInstall steps from start to finish

Google only checks your subscription No payment, no card

Not subscribed yet?

Subscribe on YouTube
4.928 ratings on this siteSee reviews
White label Resale allowed Free bug fixes Lifetime updates
Free download Full source code Setup guide Edit + resale rights License & unlock detailsHide details
  • Regular license, full rights

    White label: your own brand, no Rameez Scripts credit needed. Modify it, use it on unlimited projects and resell it. Only condition: no video content about the product.

  • How the unlock works

    No payment and no card. Google is used only to confirm your YouTube subscription.

  • Setup guide

    The step-by-step Apps Script setup guide opens right after the download.

Get a custom version for your business

Your features, branding and reports, built on this system. Free quote before any work starts.

Chat on WhatsApp
Custom development

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.

400+Projects delivered
91+Countries served

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.

Sort
@GokuKhan-k1m via YouTube
❀❀❀❀ love you ❀❀❀❀ ❀❀Sir Best Work Project❀❀
1 like on YouTube
@jnrarena via YouTube
Wow nice one. So what's the difference between the other school management system you posted months ago and this one? What is the difference
@wajahatali7608 via YouTube
bro can u uide how to sell this in best way
@ActiveDocus via YouTube
Using Google Sheets as the database is a clever constraint, but role-based permissions get brittle fast once you have concurrent edits from teachers and admin staff. Did you run into any race condition issues with the Apps Script triggers when multiple users hit the fee module at the same time?
@siyal_basha0086 via YouTube
bro whre is the prompt
@ClassicStudy via YouTube
Good best a I'm a Academy owner I Required
@dishtech5002 via YouTube
Purchase + Inventory + Weighing + Payment Receipt” support erp.please make a video for online E-waste scrap pickup and collection.simple and cost effective
@jcordones via YouTube
No soy programador pero con IA he logrado hacer algo similar
@aatiqahmad1301 via YouTube
Plz Build a Tour and travel agency accounting software service like visa, transport, hotel, land package etc payment receipt
@AbdallahibnsunneeMaikwano17 via YouTube
Very Amazing projects may God bless rameez scripts.
@jalalakbar360 via YouTube
How can i download all file's any repo plz
@jordanfelipe31 via YouTube
Muito bom. Completo como sempre.
@NzKhan-d8m via YouTube
❀ Always impressive projects done
@asrarazad8911 via YouTube
1 parent whatapp alert fee
@thegames_tws7871 via YouTube
Amazing System for School πŸŽ‰β€β€
@ImSadiqz via YouTube
πŸŽ‰great job. I love your work. Keep up the good work.
@WilsonAbeiku via YouTube
Great work done Sir
@hnourkonsult5329 via YouTube
Good as usual
@richarrh via YouTube
Great work, this is very useful! Keep working
@vipulchaudhari4437 via YouTube
Well bro... Most helpful for Schools....πŸŽ‰πŸŽ‰πŸŽ‰
@ShahadatAli-p3i via YouTube
Nice Work, It's Big Problem solving
@irfanchauhan495 via YouTube
Very Well Brother....πŸŽ‰
@manuelspctips via YouTube
God bless you Sir, I love your hardwork
@akinduyiteadeolu2640 via YouTube
How do I get the file
@MDRabbi-fo7gx via YouTube
thank you sir very helpfull
@khanasadullah5125 via YouTube
Bhai jaan always on top