GJMS Dashboard
Enter password to view financial data.

GJMS Financial Dashboard

Gopal Ji Memorial School · FY 2025-26 · Apr 2025 → Mar 2026
Generated 03 May 2026
Sources: Simption · SBI · HDFC · GPay · Daily Reports
Headline numbers click any card for details
Total income
₹1.84 Cr
From daily collection reports · 12 months
Total expenses
₹1.27 Cr
From Simption ledger · 859 entries
Net surplus
₹56.6 L
Operating margin 30.8%
Cash & bank
₹12.6 L
SBI ₹7.8L + HDFC ₹4.7L
Active students
722
FY 26-27 · 451 dues pending
Operational health signals click for details
Profitability
30.8% margin · Healthy
Fee recovery
451 students unpaid · Critical
Bank reconciliation
₹42.5L cheques unverified
UPI penetration
53% of families · Target 80%
Cash audit trail
₹34.9L "reserve" needs verification
CBSE compliance
Affiliation valid till 2032
Penalty enforcement
₹0 collected · Policy not enforced
Maths academic
22 compartments · Avg 40.6/100
Monthly trends click chart bars to drill into Income/Expense tab

Income vs expense vs net

3 months ran negative net: May, Oct, Jan
Income Expense Net surplus
P&L by month

Cash vs UPI collection

63% cash · 37% online · UPI growing in Feb-Mar
Cash collected UPI/online
Cash vs UPI

Expense breakdown

Salaries dominate · ₹26.6L unmarked is the data gap
Expense breakdown

UPI app preference

PhonePe is the parent's #1 choice — but no PhonePe merchant
UPI app share
Income reconciliation across all sources

Money flows: cash collected at school → deposited to SBI bank · UPI received via GPay merchant → settles to HDFC bank. The table below reconciles each month: Daily Reports (Roshan) vs SBI cash deposits vs HDFC online credits.

Monthly reconciliation

Click any month to see daily breakdown

Cash vs UPI monthly

Stacked bars · Click on chart in Overview to drill
Income trend

Fee category mix

Tuition is 52% of all income
Fee categories

Daily income — every day with activity

Cash + Daily Report UPI + SBI cash deposit + HDFC online credits · loading…
Expense breakdown

All expenses sourced from Simption ledger · 859 individual entries totaling ₹1.27 Cr · Salaries dominate (45%). Red tag = "Banking/Transfers (unmarked)" or "Uncategorised" — needs ledger fixes.

Monthly expenses

Click any month to see all entries for that month

Monthly expense trend

Highest: Jul (₹17.5L) · Lowest: Jun (₹1.1L)
Monthly expenses

Categories

Click any row in table below to see all entries
Expense categories

By category

Click any category to drill down to individual entries

All expense entries (top 500 by amount)

Filter by category, month, or search · loading…
Investigation queue · click any row to drill down
₹42.5L in cheques to individuals · purpose unknown CRITICAL
₹42,50,000

6 cheques cleared from HDFC A/c 50200045020913. Recipients are not on the school's known payee list. ₹24.5L of these in March 2026 alone.

DatePayeeBranchCheque #Amount
15-May-25Roshan PrajapatiSahatwar60₹4,00,000
21-Aug-25Ram Sagar RaiBallia64₹7,00,000
21-Aug-25Ram Kumar SinghBallia65₹7,00,000
24-Mar-26Ram Kumar SinghBallia66₹8,00,000
25-Mar-26Ram Kumar SinghBallia68₹8,50,000
30-Mar-26Deepak Kumar SrivastavaBallia67₹8,00,000

Action: Get formal classification — vendor invoice, loan agreement, or settlement document. Owner: Ayush + Roshan. Deadline: 12 May 2026.

UPI-AYUSH transfers from HDFC · owner withdrawals not classified CRITICAL
₹11,65,001

17 transactions from school HDFC account flagged as UPI-AYUSH — 11 of them ₹1L each.

Transactions
17
₹1L transfers
11
Total amount
₹11.65 L
In Mar 26 alone
₹3.60 L

Action: Classify with Rajkumar — drawing / salary / reimbursement. Add Simption entries. Deadline: 15 May 2026.

Reserve for expenses · ₹34.9L cash withheld at school HIGH
₹34,91,724

Of ₹1.16Cr cash collected, only ₹77L deposited to SBI. Rest stayed at school as informal cash for expenses.

Cash flow componentAmount% of cash
Total cash collected₹1,15,56,836100%
→ Deposited to SBI₹77,06,37066.7%
→ Bhatta (informal labour)₹3,69,5003.2%
Reserve (un-banked)₹34,91,72430.2%

Action: Cap monthly reserve at ₹2L. Mandate vendor receipt + Simption entry within 48 hours. Deadline: 15 May 2026.

Salary mismatch · ledger ₹57.5L vs bank ₹78.6L HIGH
Δ ₹21,03,000

Simption shows ₹57.5L salary, SBI bank shows ₹78.6L salary cheques. ₹21L gap likely sits in 6 unmarked banking entries (₹26.6L total).

Action: Tag every salary cheque in Simption with month. Re-classify the 6 unmarked banking entries. Deadline: 15 May 2026.

HDFC online ₹61L vs daily reports captured ₹25L HIGH
Δ ₹35,82,371

HDFC bank received ₹61.07L (1,135 GooglePay txns). Daily reports captured only ₹25.24L as HDFC. Apr-Aug logged everything as SBI online.

Worse: Nov-Dec daily reports OVER-stated HDFC by ~₹3.8L each month — likely double-counting with SBI.

Action: Daily report template to have separate SBI online + HDFC online. Train Roshan to check both bank apps daily. Deadline: May 2026.

Fee defaulters · 451 students still unpaid HIGH
~₹40L est.

Out of ~669 fee-paying students in 25-26, 451 still have outstanding dues. Two-caller system active with 3% commission.

If recovered, operating margin pushes from 30.8% to ~38%. Penalty fee enforcement is currently zero — ₹2-5L/year opportunity.

Action: Q1 target: recover 60% of outstanding (₹24-30L). Enforce ₹50/day late fee. Deadline: 30 Jun 2026.

PhonePe gap · 64% of UPI but no merchant account HIGH
₹33,54,395

Parents prefer PhonePe (₹33.5L = 64% of UPI). School only has Google Pay. PhonePe payments route via inter-app rail (~25 min lag).

Action: Open PhonePe Business merchant with same HDFC settlement. Settlement instant, MDR comparable. Deadline: 20 May 2026.

Cash dependence · 63% of fees still cash MEDIUM
₹1.16 Cr

387 unique UPI payers vs 722 students = 53% UPI penetration. ~335 families still cash-only.

Action: Print laminated QR at fee counter. Per-student unique QR for auto-tagging. Deadline: 15 May 2026.

Mahavidyalaya ₹6L credit · 2-Jul-25 · purpose unclear MEDIUM
₹6,00,000

Single ₹6L credit from sister institution Mahavidyalaya. Could be loan, advance, fee transfer, or aid.

Action: Confirm purpose with Rajkumar. Document in Simption. Deadline: 10 May 2026.

Cross-session bug · Mar-25 salary booked under FY 25-26 MEDIUM
₹3,60,723

March 2025 salary cleared 11-Apr-25 was booked under FY 25-26. Inflates current expense, understates prior. Same issue applies to ₹18.30L "previous year fee" recovered in 25-26.

Action: Set Simption policy — book by accrual date, not clearance date. Deadline: 1 Jun 2026.

Top 12 prioritized actions
1
Critical
Identify the ₹42.5L cheque recipientsRoshan ₹4L · Ram Kumar Singh ₹23.5L · Ram Sagar Rai ₹7L · Deepak Kumar Srivastava ₹8L
Ayush + Roshan
12 May 2026
2
Critical
Classify ₹11.65L UPI-AYUSH transfersWith Rajkumar — drawing / salary / reimbursement classification
Ayush + Rajkumar
15 May 2026
3
High
Cap monthly cash reserve at ₹2LMandate vendor receipt + Simption entry within 48 hours
Roshan + Avinash
15 May 2026
4
High
Recover 60% of outstanding fees in Q1451 unpaid students · ~₹24-30L target · enforce ₹50/day late fee
Nandini + 2 callers
30 Jun 2026
5
High
Tag every salary entry in SimptionReclassify the 6 unmarked banking entries (₹26.6L total)
Avinash + Roshan
15 May 2026
6
High
Open PhonePe Business merchantCapture 64% of UPI directly · same HDFC settlement · faster + comparable MDR
Ayush + Roshan
20 May 2026
7
High
Update daily report templateSeparate lines for SBI online + HDFC online · check both apps daily
Roshan
May 2026
8
High
Push UPI penetration from 53% to 80%Laminated QR at fee counter · staff verbal push · per-student QR for auto-tagging
Nandini + Avinash
15 May 2026
9
Medium
Confirm Mahavidyalaya ₹6L purposeLoan / advance / fee transfer / aid — document in Simption
Roshan + Rajkumar
10 May 2026
10
Medium
Investigate RBIS0GOUPEP ₹4.8L creditRBI Govt UPI Ecosystem Program credit on 11-Mar-26 · purpose unknown
Roshan
20 May 2026
11
Medium
Fix Simption cross-session bugBook by accrual date, not clearance date · applies to fees and salaries
Roshan
1 Jun 2026
12
Medium
Capitalize Library/Books spend₹2.6L Apr-25 spend should be capex, not expense · review with auditor
Rajkumar + Roshan
30 May 2026