You're offline — changes won't sync until reconnected
BurhaniHakimiSaifee
Three branches, one MTQ
Admin Dashboard
Waking up the spreadsheet…
MTQ VC Dashboard
Committee Portal · AY 2026–27
Your ITS Number
MTQ VC Commitment
AY 2026–27 · Admin Dashboard
Hall Ticket Module Live
LIVE
Who’s Online Now
Checking…
Who’s Online Now
Anyone active in the last 3 minutes.
0 online
Checking…
Updates on its own every 90 seconds.
Updated: —
0 open tickets
Overall Collection Progress
—
of Takhmeen Collected
AY 2026 Collection · —
—
Takhmeen 2026
—
Collected 2026
—
Balance 2026
—
Parents
—
Students
Year-wise Breakdown
2026
—
—
Balance—
Remaining—
— today
2025
—
—
Balance—
Remaining—
— today
Payment Distribution
—parents
0% Paid
No payment
—parents
1–50% Paid
Partial low
—parents
51–99% Paid
Partial high
—parents
100% Paid
Cleared
Branch Analysis
Key Insights
Collection Rate by Branch
Overall average line
MTQ AY 2026–27 · All amounts in AED
Select period
or custom range
Hall Ticket module is OFF
Parents cannot open the portal and no hall-ticket pills show anywhere. Children details still show on every card either way.
The module is live but no message is set. Committee members can see the Hall Ticket button, but tapping it will only tell them to come here. Write the message below and save it.
Hall Ticket Message
This is the message committee members send when they tap Send Hall Ticket. It is used nowhere else — it will never appear in the WhatsApp composer or the collection templates.
Placeholders
Data Update Drive
Loading data update drive…
All branches
Paid here means cash only. Everywhere else in this dashboard the waived amount sits inside Paid. On this screen it is pulled back out, so Takhmeen = Waived + Paid + Balance and the collection % reads lower than the Overview tab. Nothing here changes any other screen. Figures refresh on their own with the next Due070826 upload.
Read from what is already loaded. Every check below is computed in the browser from the roster this dashboard has already downloaded — it costs no extra requests and adds nothing to the payload. Fix a row in the sheet, then press Re-check and it disappears from this list.
Data Health
Compose Message
Your Name
Message Template
Use this message for WA
Tapping WA on any parent card will send exactly this text, with the placeholders filled in for that parent. Leave unticked to open a blank chat.
Parents Overview
Contact List
Last updated: — · MTQ AY 2026–27
LIVE
Committee Presence
Live status, independent of any date range.
—
Online now
—
Active today
—
Quiet 7d+
Checking who is around…
Star Performers
Every parent falls into exactly one bucket below, so the five numbers add up to your roster. Fully-paid parents are kept out of Not contacted — chasing someone who owes nothing is wasted effort. Tap a card to see the committee split.
Paid in last 30 days and Went quiet both read the Payment Ledger, which began recording on 19-08-2026. A parent who paid before that has no entry, so we know their balance but not their rhythm — they sit under No payment on record, which is a gap in the data, not a judgement about them. Both figures become meaningful once the ledger is older than 30 days.
Committee split
Today
Recalculated from the last dashboard refresh.
—
Messages today
—
Collected today
—
Needs a follow-up
Actual cash received today
Who did what today
Loading…
Longest silences
Outstanding balance, no contact in 14+ days
Loading…
Sessions & Messages in Range
Counts below cover the selected dates only. For who is around right now, use Overview.
to
—
Sessions
—
Msgs Sent
—
Members
Load the Committee tab to see activity.
Collection Report by Date Range
From Date
To Date
Pick a date range and tap Run to see collection stats.
Pick a date range and tap Run. Every committee member with allotted parents appears here as an A4 report you can download as a PDF.
Ledger Audit Trail
ITS (optional)
From Date
To Date
Pick a range (defaults to the last 30 days) and tap Run to browse every logged payment event — useful for tracing exactly why a parent's balance changed.
Compose Message
Your Name
Message Template
Saved Templates Default set
No saved templates yet. Compose a message and tap "Save Template".
Templates stored in Google Sheet · ★ = active default for committee
WA Message Templates (Anti-Block Rotation)
Committee sending sends one of these 4 at random (weighted so all 4 get used before any repeats) instead of always the same wording. Leave any blank to exclude it from rotation. Same placeholders as above.
Template 1
Template 2
Template 3
Template 4
WA Send-Rate Gauge Thresholds
Controls the fuel-gauge indicator committee members see while sending — turns yellow, then red, as a soft warning to slow down. Cools back down automatically as time passes.
Yellow at (messages)
…within (minutes)
Red at (messages)
…within (minutes)
Cooldown / lookback window (minutes)
Send a Notice
Every announcement goes to the whole committee, three ways: a push notification, a banner on their dashboard, and a popup the next time they open the portal. So it still lands even if the push never arrives.
One-tap templates
Title
Message
Enable notifications to get browser alerts when a reminder is due.
Sent Notices
No notices sent yet.
Upcoming Reminders
No reminders set.
Reminders check every 30 seconds. Keep this tab open.
Daily Digest & Follow-ups
These go out automatically each day, Gulf time: the collection digest at 20:30 and promise follow-ups at 08:00. Each one is private to a single committee member — only members with something to report receive anything. Preview below shows the exact message before it is sent.
Send log
Notification Registration
Push Devices
A device that has never been linked to an ITS can only be reached by broadcast, so it misses the daily digest and promise follow-ups. Most link themselves the next time that member opens the portal. This is for the ones that never do.
Re-enable Notifications Campaign
A browser will not deliver a push to a device that has never granted permission, so these are two separate channels and each reaches a different half of the committee. The in-app prompt is the only thing that can reach a member with notifications off. The reconnect push is the only thing that can reach a member who already has them on. Members with no parents allocated are not contacted at all.
Reading the committee roster…
Message shown in the prompt
Re-run any of these whenever you like. Each run recalculates who is still without a device, so anyone who has enabled notifications since the last run is dropped automatically and never sees the prompt again.
Push Send Trail
Notes & Tickets
Every note a committee member or admin has written on a parent, in one place. Click a pill to mark it Resolved (or reopen it).
Loading tickets…
My Assigned Parents
Committee Portal · MTQ AY 2026–27
Marhaba
My Collection Overview · AY 2025 + 2026
—
Takhmeen
—
Paid
—
Balance
Compose Message
Your Name
Message (leave blank for built-in default)
My Parents
Data synced live from Google Sheet · MTQ AY 2026–27
ESC
Waived Off
—
System health
Checks every part of the app against the current release
Collection forecast
Branch Detail
Loading…
Deep Analysis
Select range
Connection Diagnostics
Loading…
Notice from Admin
MTQ VC Dashboard · AY 2026–27
Save Message Template
Template Label
Payment Statement Card
Add Your Message (Optional)
Tap the card below to copy as image. Then tap Send WA Text — WhatsApp opens with your text pre-filled; paste the image (long-press / Ctrl+V) and press send.
Tap card to copy as image | Then paste in WhatsApp
Contact History
Loading…
Parents needing a follow-up
Outstanding balance and no message or note for 14+ days. Largest balance first.