Skoop — EGAMS Fee & Despatch Tracker

Dashboard

📦 Orders Summary

🚚 Despatch Summary

🏫 Per-Class Breakdown

Class	Total	Skoop Paid	Tuition Paid	Ready	Despatched	Remaining

🕐 Data Freshness

All Orders

Orders

Order No.	Date	Customer	Student (entered)	Amount	Payment	Skoop Fee	Match Method

⚠ Non-Standard Totals

Order No.	Date	Customer	Student (entered)	Amount	Status	Action

Manual Matching

Unmatched OrdersType admission no. or search by name to match

Order No.	Date	Customer	Student (entered)	Class	Amount	Fuzzy Suggestion	Match Student

Class View

Select a class

Adm.	Student Name	Sec	Father	Fee Status	Expected	Paid	Order No.	Tuition	📚 Books	By/When	👕 Uniform	By/When	⚽ Sports	By/When

Despatch

Despatch Settings

Filter by Class

Delivery Type

Show

Courier Name

Despatch Date

Bulk Mark Despatched (XLSX/CSV)

Column: order_no (one per row). Choose which items to mark given.

Date: Courier:

Mark as given: 📚 Books 👕 Uniform ⚽ Sports Kit Select at least one

↩ Undo Despatch (XLSX/CSV)

Same order_no file. Unticks selected items and clears despatch status for those orders.

Undo items: 📚 Books 👕 Uniform ⚽ Sports Kit 🔄 Clear despatch status

Bulk Upload Tracking Numbers (XLSX/CSV)

Columns: order_no, tracking_no (header row required).

Despatch-Ready StudentsPaid Skoop fee + Tuition paid

Order No.	Student	Adm.	Class	Sec	Customer (Ship To)	Phone	Address	Ready ✓	Delivery (click to change)	Tracking No.	Status

Sync & Settings

Zoho Commerce Sync

Fetches any new orders missed by the webhook, then fills in missing student details automatically.

Sync Log

Upload Neverskip Reports Drop both files at once — Student Master + Tuition Fee

Drop one or both Neverskip export files here. The app will auto-detect which is which, show you a full preview of changes, and only update the database after you confirm.

📂

Drop files here or click to browse

Student Master (.xlsx) · Tuition Fee Report (.xls/.xlsx) · Both at once

These matches were created automatically. Review and delete any you don't trust — especially fuzzy ones.

Order	Customer	Matched To	Adm	Method

Audit Trail — Match History

All Matches Click × to delete a match and return order to Manual Match queue

Order No.	Date	Customer	Student	Adm.	Class	Match Method	Matched By	Matched At	Action

👕 Extra Uniform Orders

Orders containing "School Uniform EGAMS" line items purchased separately from the regular fee bundles (via the go.skoop.in/egams microsite) — shown here whether bought alone or alongside Bundle 1 / Bundle 2.

Extra Uniform Orders

Order No.	Date	Customer / Student	Items	Extra Uniform Amount	Order Total	Type	Delivered

Preview Changes Before Upload

Confirm Gender Before Printing