Gopal Ji Memorial School

Total Students

—

live roster

Collected This Year

—

Current Outstanding

—

this session, unpaid

Previous-Year Dues

—

Students Present Today

—

Staff Present Today

—

Buses Moving

—

Needs Attention

Loading…

Total Students

—

Period Income

—

Period Expense

—

Net (Income − Expense)

—

period total

Today Income

—

cash + UPI

Today Expense

—

manual entries

Cash Collection

—

period total

UPI Collection

—

UPI / BharatPe

Last 30 Days · Income vs Expense

Income Sources

Target ₹72L tracker — waiting for live data

↓ Below this point: a point-in-time ERP ledger snapshot (see the freshness bar above for its age) — not live. For always-current figures use the "LIVE" card above and the Collections tab.

Period Income

—

Period Expense

—

Net

—

surplus / deficit

Transactions

—

period total

Daily Income vs Expense

Top Expense Categories

Total Collection

—

period total

Cash

—

UPI / BharatPe

—

Today Cash

—

notes & coins

Today UPI

—

digital

Daily Cash vs UPI

Payment Mode Mix

Income by Source

Collections by Date Range

From To

—

Income in range

—

Tuition in range

—

Transport in range

—

Expense in range

—

Net in range

—

income − expense

Active days

—

days with activity

Date	Income	Expense	Tuition	Transport

All Students — Fees · Marks · Attendance · App Activity

—

Class	Adm No	Name	Payable Now	Full-Session Due	Marks Avg %	Failing Subjects	RFID Tap Coverage (30d)	App Last Login

Total Students

—

all classes

Gender

—

Classes

—

distinct

Avg per Class

—

students

Students per Class

Class Strength Table

Class	Students

Total Students

—

Previous Year Dues

—

2025-26 carry-forward

Current Year Dues

—

2026-27 unpaid

Annual demand (incl. months not yet billed)

—

prev + current, WHOLE 2026-27 year — budget context, not a call-list number

Payable Now

—

what's actually due today — quote THIS on calls

Students with Any Dues

—

Annual Fee Demand (full year)

—

2026-27 budget (full year, context only)

Previous years' dues (LIVE)

—

enrolled vs left split

Student Dues

—

Class	Adm No	Student	Father	Phone	Prev (₹)	Current (₹)	Total (₹)

Selected Month

—

Students with Billing

—

Fully Paid

—

Partial

—

Unpaid

—

Month Fee Demand

—

expected this month

Month Collected

—

Total Outstanding

—

incl. carryover + prev year

Student Payment Status

For the selected month: Month Fee = annual fee ÷ 12. Paid is allocated sequentially — April first, then May. Prior months pending = unpaid balance from earlier months in this session (April unpaid carries into May, etc.). Total Due = this month's remaining + prior months pending + previous year dues — the full amount the parent owes when you call them.

—

Class	Adm No	Student	Father	Phone	Month Fee (₹)	Paid (₹)	Remaining (₹)	Status	Prior Months Pending (₹)	Prev Year Dues (₹)	Total Due (₹)

Village data not loaded. Make sure /villages.json deployed.

Villages mapped

—

within 22 km of Reoti

Total population

—

Census 2011

Est. school-age kids

—

@22% of pop

GJMS students from these villages

—

Market capture

—

of school-age kids

Untapped kids

—

market opportunity

By Corridor

Direction-grouped to plan transport routes. South + SE + West/SW are mostly unexplored.

Corridor	Villages	Population	School-age kids	GJMS students	Capture %	Untapped kids

Map

Click any village in the table or on the map — draws a red line from school to village with straight-line distance.

No village selected.

Village Detail

—

#	Village	Block	Corridor	Distance (km)	Population	School-age	GJMS	Capture %	Untapped	Notes

Recent Transactions (latest 50)

Date	Source	Name	Type	Mode	Amount	Remark

Severe DOB Errors

—

impossible age vs class

Moderate DOB Issues

—

age off by 1–3 yrs

Placeholder DOB

—

01-01-XXXX entries

Phone Issues

—

bad length / placeholder

Total Flagged

—

students needing review

Data Health — Live Coverage (D1)

Field-completeness of the live roster, computed straight from the gjms D1 database on every /api/live refresh. Green = well covered, amber/red = needs office follow-up.

Flagged Students

Data-quality flags from the Simption scrape . Send this list to the office to verify against admission forms / Aadhaar.

Name	Father	Class	Phone	DOB	Age	Issue

Students With Dues

—

payable now > ₹0

Payable Now (Total)

—

quote THIS on calls — not the full year

Contactable

—

valid phone number

Fee Reminder Message

Edit the template — placeholders {name} {father} {class} {amount} {adm} {paylink} fill in per student. {paylink} becomes a one-tap UPI payment link with the exact amount pre-filled. Click a row's WhatsApp button to open WhatsApp with the parent's number and this message ready to send.

Defaulter List

Outstanding as of — — verify payment status in Simption before sending, the snapshot may be a few days old.

Name	Father	Class	Phone	Payable Now	Full-Session (context)	Send

Assigned Arrears

—

tracker students, 2 callers

Recovered So Far

—

arrears balance drop

Commission Due

—

at 3%

Match Rate

—

tracker ↔ live data

Not Covered by Any Caller

—

of live students with dues

Per-Caller Recovery

Commission rate % · Recovered = assigned arrear − payable-now (elapsed+current month + prev dues), from live snapshot —. ⚠ A balance drop is not proof a caller caused it — a parent may have paid at the office on their own.

Caller	Students	Assigned Arrears	Recovered	Recovery %	Commission

Student-Level Detail

Name	Father	Class	Caller	Assigned ₹	Payable Now ₹	Recovered ₹	Match

Total Vehicles

—

Moving

—

ignition on, in motion

Idle / Parked

—

stopped

Offline

—

GPS device not reporting

Fleet

Vehicle	Number	Status	Speed	Last Location	Last Update	Today KM	Map

Fleet Status

Today's KM by Vehicle

Optimization Insights

Connect live tracking

This tab renders vehicles.json. New vehicles appear here automatically once the live feed is wired up — no code change needed.
To go live: the GitHub Actions scraper needs to log into FleetTrack's tracking platform (the in.gpstrack.lite app's web portal — not the account.fleettrack.in store page) and write the vehicle list to vehicles.json. A scaffold is ready at scraper/fleettrack-scrape.js — it needs the FleetTrack tracking-platform URL + login added as the FLEETTRACK_USER / FLEETTRACK_PASS GitHub secrets.
Until then you can edit vehicles.json by hand with your real vehicle numbers and it works the same way.

Monthly KM

—

fleet, selected month

Expected fuel cost

—

km ÷ mileage × diesel ₹

Actual card spend

—

what you entered

Variance

—

paid − expected

Settings

Month
Diesel price (₹/litre)
Fuel card

Mileage (km/litre) is pre-filled with conservative real-world defaults per vehicle — edit any cell to your true figure and it's remembered. Enter what the card actually paid per bus for the month; the variance and the checklist below help you spot leakage, idling or a wrong mileage assumption. Distance is measured by GPS (sum of each day's km), bucketed in IST.

Per-vehicle — this month

Vehicle	Monthly KM	Days run	Mileage (km/L)	Litres	Expected ₹	Actual paid ₹	Variance ₹	Var %	Flag

Expected fuel-cost share

Variance by vehicle (paid − expected)

Reading the numbers

Buses Tracked

—

with papers on file

Papers Expiring in 30 Days

—

critical or warning window

Overdue or Blocked

—

expired docs + blocking flags

Awaiting Vahan Check

—

no date on file yet

Document Status

Vehicle	Insurance	PUC	Fitness	Permit	Registration (RC)	Road Tax	Valid

Issues & Open Checks

Total Staff

—

on RFID

Present

—

tapped in

Not Marked

—

didn't tap

Late Arrivals

—

after 08:30

Avg Attendance

—

of recorded days

Daily Present — this month

Present vs Not-marked

Late Arrivals

—

Staff

Name	Type	Latest day	In-time	Present days	Attendance %

Insights

Payroll & PF — waiting for live data

Total Payroll — All Staff (13 months)

—

Staff Paid

—

PF Deducted To Date

₹0

across every payslip ingested

PF — If Filed by Amnesty

—

employer 12% only, estimate

EPF Amnesty Deadline

—

31-Oct-2026

Unmatched Payslip Rows

—

could not be matched to current staff

Payroll Cost Trend — total net paid per month, matched staff (blue) + people who've since left (purple) stacked so nothing is hidden; the Jan–Mar 2026 gap is a missing source file, not zero spend

Per-Staff Pay — click a row for that person's month-by-month history

—

Name	Designation	Current Salary	Months Paid	Total Paid	Last Paid Month

PF Liability — Two Scenarios, Both Estimates

If filed under the EPFO amnesty (by 31-Oct-2026)

—

Employer's 12% share only — the employee's 12% is waived where PF was never deducted from wages, which this payroll confirms (0 of 468 rows show a deduction). Interest at 12% p.a. (s.7Q/127), admin charges, and a flat ₹100 damages figure are additional and not yet computed here.

If the window is missed

—

Full 24% (employee 12% + employer 12%), the no-relief statutory ceiling. Section 14B damages can run up to 100% of arrears on top of this — also not included in the figure shown.

—

Wage basis (capped ₹15,000/month) — matched staff	—
Employee share (12%)	—
Employer share (12%)	—
Combined — matched staff only	—
Covered person-months (matched)	—
+ Unmatched rows — wage basis (net-paid proxy, capped)	—
+ Unmatched rows — combined estimate (24%, proxy)	—
Combined estimate — ALL payroll (matched + unmatched)	—

—

The unmatched-row PF figures use each row's net paid amount as a proxy for gross earned, because gross wasn't retained for rows that couldn't be matched to a staff record — so even the "ALL payroll" figures likely still understate true exposure slightly.

All figures on this panel are estimates, not filings. The wage basis uses MIN(gross,15,000) as a proxy for basic+DA — the actual PF-eligible wage is basic+DA specifically, which isn't reliably split out in the ingested payroll sheets, so this may over- or understate the true basis.

The relief structure above (employer-only 12%, flat ₹100 damages in place of s.14B) is verified against primary gazette text (G.S.R. 749(E), 10-Oct-2025, EPF Scheme 1952 para 82B). The widely-cited "EEC-2026" successor campaign's specific eligibility dates are corroborated only by secondary sources as of this writing, not yet confirmed in a primary EPFO notification — treat the 31-Oct-2026 deadline as the best available estimate, not a confirmed statutory date.

Unmatched Payroll Rows

Name (as on payslip)	Designation	Rows	Months	Total Paid

Mostly 2025 staff who left before the current 59-person roster snapshot. Not dropped silently — every row is accounted for here.

Total Students

—

on roster

Present

—

tapped in

Absent

—

marked absent

Not Marked

—

no tap recorded

Class-wise

Class	Total	Present	Absent	Not Marked	Present %

Present by Class

Insights

Marketing & Leads. One funnel for every admission enquiry — Meta/Facebook & Instagram ads, WhatsApp, YouTube and Google. Import your GJMS-Lead-Tracker.xlsx to load leads & conversions, then add each platform's numbers under Channel Connections. Data is saved in this browser — use Export backup to keep a copy. How it works

No data imported yet.

No leads loaded yet. Click Import Lead Tracker (.xlsx) above and choose your GJMS-Lead-Tracker.xlsx. The ad campaign launches 23 May 2026 — once enquiries arrive and your team logs them in the tracker, re-import here to see the funnel fill up.

Auto-Sync · Facebook + Instagram + Inbox

Checking…

Loading server-side Meta connector…

Setup Status

One row per integration — green check = live and refreshing, grey dot = action needed (deep link provided).

Total Leads

—

all channels

Contacted

—

Contacted ≤ 1 hr

—

speed wins admissions

School Visits

—

Admissions

—

converted

Lost

—

not converted

Lead → Admission

—

overall conversion

Visit → Admission

—

closing rate

Media Spend

—

campaign ad spend

Cost per Lead

—

spend ÷ leads

Cost per Admission

—

spend ÷ admissions

Est. Year-1 Fee Value

—

admissions × annual fee

Return on Ad Spend

—

(value − spend) ÷ spend

Conversion Funnel

Leads by Channel / Source

Channel / Source	Leads	Contacted	Visits	Admissions	Conv.

Leads by Village / Town

Where the ads are pulling enquiries from — cross-check against the Geo / Market tab.

Village / Town	Leads	Admissions

Leads Over Time

Channel Connections

Each platform's reach & engagement, side by side. YouTube connects live with a free API key. For Meta, Instagram & Google Business, type the numbers from each platform's own dashboard, then Save. Full auto-sync setup is documented in gjms-ads/Dashboard-Connections-Guide.md.

Meta Ads · FacebookNot connected

Reach, link clicks & results from Meta Ads Manager. This is where most leads originate.

Live connect (Facebook Graph API — one token unlocks Instagram too)

Page ID or username Page Access Token

Or enter manually from Meta Ads Manager:

Reach Link clicks Results / leads

InstagramNot connected

Followers, reach & profile visits — runs on the same Meta ad campaign.

Live connect (uses the Meta token above — Instagram business account auto-discovered)

Make sure your Instagram business account is linked to the Facebook Page above. Then click below — the same Page Access Token unlocks IG insights.

Or enter manually from Instagram Insights:

Followers Reach Profile visits

WhatsApp BusinessNot connected

The standalone WhatsApp Business app has no public data API — Meta intentionally doesn't expose one. What we CAN do is the school's outbound channel: wa.me click-to-chat links work without any API and don't risk a ban.

School WhatsApp: Default opener (Hinglish for parents)

Conversation count (from Meta Ads → "messaging conversations started"):

Conversations started

YouTubeNot connected

Connects live with a free YouTube Data API key. Use your @handle (easy) or paste the Channel ID directly.

API key Channel @handle (shortcut) Channel ID

Not connected yet.

Google Business ProfileNot connected

Public listing data (rating, reviews, photos, hours) loads automatically using the dashboard's existing Google Maps key — no extra setup. Performance metrics (views/calls/directions) still need manual entry: they require OAuth + verified Business ownership, which is overkill for now.

Live: public listing (rating + reviews + photos)

Search query (or paste Place ID)

Manual (from your Google Business Profile dashboard at business.google.com):

Profile views Calls Direction requests

Settings

Media spend (₹) Annual fee per student (₹)

Media spend auto-fills from the Lead Tracker's Daily Spend sheet on import; override it here if needed. Annual fee drives the Year-1 fee-value estimate.

Analytics — waiting for live data

Projected FY operating net vs ₹72L

—

Projected FY cash net (incl. capex+drawings)

—

YTD income vs plan

—

YTD opex vs plan

—

Required collection / remaining month

—

to still hit ₹72L

Where the Cash Actually Went

Operating profit is not money in the bank. This follows the FY-to-date surplus through asset purchases and owner drawings, then through borrowing, to the real change in cash.

Operating net (income − opex)

—

Capex (asset purchases)

—

Owner drawings

—

Cash before borrowing

—

Loans / inter-account in (net)

—

Actual cash movement

—

Cumulative Income, Expense & Net — Plan vs Actual

—

Monthly Income vs Expense

Bars are actual income/expense per month (₹L, left axis); the line is net (₹L, right axis). Future months are left blank, not zero.

Where the Money Goes

—

Excluded from P&L (not hidden, just not operating)

Capex, owner drawings and inter-account loan-ins are deliberately kept out of the income/opex numbers above so a big equipment buy or a personal draw never masquerades as an operating loss (or gain) — the amounts are shown here so nothing is hidden. See "Where the Cash Actually Went" near the top of this tab for how they flow into the real change in cash.

Fee Funnel — This Session

—

Cash vs Bank Split (Expenses)

No payment-mode field on expense entries in /api/live yet, so a real cash-vs-bank split can't be shown here without guessing. This matters — a recent audit found one expense head paid 80% in cash across 24 entries above ₹10,000, which is an Income-Tax s.40A(3) exposure. Add a mode column to the expenses table and this card will populate automatically.

Collection Velocity

No daily metrics history yet (metricsDaily is empty) — the collection-velocity trend needs at least a few days of the ERP metrics engine running.

—

Attendance Trend

No daily attendance history yet in metricsDaily.

—

Student Strength by Class

No live roster (strength.byClass) yet.

—

New Admissions Trend

No daily admissions history yet in metricsDaily.

—

Academics — waiting for live data

App Usage — waiting for live data

Needs Attention

Last 30 Days · Income vs Expense

Income Sources

Cumulative Net — Plan vs Actual

Monthly Plan vs Actual

Where it's leaking

Excluded from operating (CA reclass pending)

What moves the needle

Daily Income vs Expense

Top Expense Categories

Daily Cash vs UPI

Payment Mode Mix

Income by Source

Collections by Date Range

All Students — Fees · Marks · Attendance · App Activity

Students per Class

Class Strength Table

By Fee Category

Student Dues

Student Payment Status

By Corridor

Map

Village Detail

Recent Transactions (latest 50)

Data Health — Live Coverage (D1)

Flagged Students

Fee Reminder Message

Defaulter List

Per-Caller Recovery

Student-Level Detail

Fleet

Fleet Status

Today's KM by Vehicle

Optimization Insights

Connect live tracking

Settings

Per-vehicle — this month

Expected fuel-cost share

Variance by vehicle (paid − expected)

Reading the numbers

Document Status

Issues & Open Checks

Daily Present — this month

Present vs Not-marked

Late Arrivals

Staff

Insights

Payroll Cost Trend — total net paid per month, matched staff (blue) + people who've since left (purple) stacked so nothing is hidden; the Jan–Mar 2026 gap is a missing source file, not zero spend

Per-Staff Pay — click a row for that person's month-by-month history

Month-by-Month History

PF Liability — Two Scenarios, Both Estimates

Unmatched Payroll Rows

Class-wise

Present by Class

Insights

Auto-Sync · Facebook + Instagram + Inbox

Setup Status

Conversion Funnel

Leads by Channel / Source

Leads by Channel / Source

Leads by Village / Town

Leads Over Time

Channel Connections

Recent Post Performance

Facebook

Instagram

Settings

Where the Cash Actually Went

Cumulative Income, Expense & Net — Plan vs Actual

Monthly Income vs Expense

Where the Money Goes

Excluded from P&L (not hidden, just not operating)

Fee Funnel — This Session

Cash vs Bank Split (Expenses)

Collection Velocity

Attendance Trend

Student Strength by Class

New Admissions Trend

Score Distribution