VSLP CAFE ONE · Canteen Attendance Monitoring System
Dashboard
Live canteen attendance overview across all meals and beneficiaries.
Daily Serves Trend
Total meals served per day.
Meal Split
Share of each meal for the selected period.
Beneficiary Type Split
Serves by beneficiary category for the selected period.
Today’s Order — Entity & Meal
Generated parcel orders, entity-wise and meal-wise.
Recent Meal Attendance
CAFE CONNECT
Use a USB 2D QR scanner (acts as a keyboard). Keep the cursor in the scan box and scan the beneficiary QR. The meal is detected automatically from the clock and the scan is saved on scanner Enter.
Scan Capture Details
Meal type is captured automatically by the clock: Breakfast 07:00–10:00, Lunch 12:30–14:30, Evening Snacks 18:00–19:30, Dinner 20:00–22:30. Every beneficiary type (employee, family, visitor, contractual, overtime) is recognised automatically from the Cafe Master.
CAFE MENU TODAY —
Live Scan Register
Meal Attendance Capture
Send / Export Capture Data
Export captured attendance for a selected period to share with HR, Accounts or vendor.
Today’s Capture Register
Master Data Locked
Enter master password to unlock master data & controls.
Employee Master
Save Employee updates the record by Employee ID. Add Employee creates a new record and rejects a duplicate ID. Delete Employee removes the record whose Employee ID is entered in the form. Excel columns (see Download Template): EMP ID, NAME, DEPARTMENT, DESIGNATION, RESIDENT, STATUS, MEAL ELIGIBILITY (Eligible / Not Eligible), TYPE OF MEAL. Only Active + Eligible employees flow into the Cafe Master and can scan at CAFE CONNECT.
Master Data Locked
Enter master password to unlock master data & controls.
Family Master
Save Family Member updates the record by Family ID. Add Family Member creates a new record and rejects a duplicate ID. Delete Family Member removes the record whose Family Member ID is entered in the form. Excel columns (see Download Template): FAMILY ID, EMP ID, NAME, RELATION, AGE, STATUS, MEAL ELIGIBILITY (Eligible / Not Eligible), TYPE OF MEAL. Only Active + Eligible members flow into the Cafe Master.
Visitor / Guest Entry Locked
Enter today’s Visitor password. Format: VISITOR<DDMMYY> (today: VISITORddmmyy). The master password also opens this sheet.
Visitor / Guest Entry
Save Visitor stores the visitor in the master only and generates the short visitor ID if blank. Generate Visitor Order will work only after the visitor has been saved. Add Visitor Meal saves the visitor and records a meal serve for the selected meal type, reflecting across all sheets and the dashboard.
Upload Visitor List (per Company / Entity)
Upload an Excel of visitor EMP / Visitor IDs. Only ID, NAME, COMPANY are pulled (auto-filled from the Employee Master where the ID matches, otherwise from the file). For each row choose Meal Type and Consent from the dropdowns — Meal Type enables only when Consent = Yes. Enter the Operator once, then Pull Consented → Visitor Meals. Only consented rows are recorded as visitor meals and reflect across all sheets and the dashboard.
Parcel Master Locked
Enter today’s Parcel password. Format: PARCEL<DDMMYY> (today: PARCELddmmyy). Valid only between 07:00 and 23:00 today.
Parcel Master
Record a meal parcel. Entity is the unit placing the order. Meal Type shows what kind of parcel it is. Saved parcels reflect across all sheets and the dashboard.
Save Parcel records one parcel for the selected meal type and clears the form. Add Parcel keeps Entity / Operator / Meal Type to add more beneficiaries quickly. Duplicate parcels for the same person, date and meal are blocked. Freeze times — Breakfast 07:30, Lunch 10:00, Snacks 15:00, Dinner 17:00. Exception request window remains open for 45 minutes after each cut-off.
Upload Parcel Master (per Entity)
Upload an Excel of EMP IDs for an entity. Only EMP ID, NAME, DEPARTMENT, DESIGNATION are pulled (auto-filled from the Employee Master). For each row choose Meal Type, Shift and Consent from the dropdowns. Meal Type and Shift become selectable only when Consent = Yes. Enter the Operator once for the whole list, then Pull Consented → Register. After pulling, Generate Order activates.
Today’s Parcel Register
Click Generate Order to roll up today’s parcels into entity-wise / meal-wise orders. Orders for a meal cannot be generated after that meal’s freeze time. Generated orders appear in the Today’s Order tab and on the dashboard.
Clear Today’s Parcel Data
🔒 LockedThis area is password protected. Unlock with the master password to clear today’s parcel register and the generated orders.
Today’s Order
Entity-wise and meal-wise order summary for the canteen.
Order Summary — by Entity & Meal
Order Lines
Master Data Locked
Enter master password to unlock master data & controls.
Meal Rate Master
Use agreed vendor rates. Once saved, rates lock automatically. Unlock with the master password to change them.
Cafe Menu Master Locked
Enter master password to maintain the day-wise cafe menu.
9. Cafe Menu Master
Enter the menu day-wise for Breakfast, Lunch, Evening Snacks and Dinner. Separate items with commas or new lines. The menu of the current day is displayed live in CAFE CONNECT → CAFE MENU TODAY.
Weekly Menu Overview
Controls Locked
Enter master password to unlock master data & controls.
Reports & Audit Trail
Daily report for today can be generated only after canteen closing (23:00); past dates any time. Weekly = Monday 00:00:01 to Sunday 23:59:59 of the chosen week. Monthly = 1st 00:00:01 to last day 23:59:59 of the chosen month.
Saved Report Log
Only the selected report and selected date range will be saved, exported or printed.
Controls Locked
Enter master password to unlock master data & controls.
Vendor Bill Processing
Controls Locked
Enter master password to unlock master data & controls.
Settings & Controls
HR Meal Eligibility Control
After uploading Employee Master or Family Master, HR can allow or block meal benefit here. If marked Not Allowed, the QR scan will be rejected at the counter.
Employee Meal Permission
Family Meal Permission
Parcel Exception Approval
Late parcel requests after the meal cut-off will appear here. HR can approve or reject. After approval, parcel entry and order generation are allowed for that meal and entity.
Password & Access Control
This replaces the separate Setting and Control tab. HR can control login, master and sheet-wise passwords from here.
Today’s Visitor password: - | Today’s Parcel password: -
IIS Server Save / Sync Control
The app saves inside the browser immediately. For live multi-user IIS usage, configure the API URL after backend deployment. Every save will then POST the full data to that endpoint as JSON.
Implementation SOP
| Step | Control | Owner |
|---|---|---|
| 1 | Build employee, family and visitor masters with unique ID / QR value (upload via Excel). | HR/Admin |
| 2 | Scan or enter ID before every meal issue. Parcel needs approval reference. | Canteen Counter |
| 3 | System blocks repeat entry for same person, date and meal type. | Application |
| 4 | Daily / weekly / monthly reports checked for override, visitor and parcel meals. | HR/Admin |
| 5 | Monthly vendor bill generated from system attendance only. | HR/Admin + Accounts |
Backup / Restore Locked
Enter master password to unlock backup, restore & data reset controls.
Backup & Restore
Download a full backup of all application data, or restore from a previous backup file. Take regular backups before any data reset.
🔗 Import Beneficiaries from VSLP ENTRY PRO
Load the CAFE ONE sync file exported from the VSLP ENTRY PRO ID-card application. Employees and family members issued there are pulled straight into the Employee Master and Family Master below, so their QR / ID cards resolve instantly at meal capture and the USB scan terminal — no re-typing. Existing records with the same ID are updated; new ones are added. Meal records, rates, passwords and settings are never touched.
Data Reset
Use with care. These actions are permanent and cannot be undone. Always take a backup first.
Clear All Records Only
Removes all recorded data — meal attendance, parcels, orders, duplicates, parcel inbox and live scan logs. Keeps the uploaded masters (Employee, Family, Visitor), meal rates and all passwords / settings.
Clear All Data
Removes everything — all recorded data and the uploaded masters (Employee, Family, Visitor) and meal rates. Login & passwords are retained so you can keep using the app.
🧹 Clear Data (date range, master-password protected)
🔒 LockedSelect the period and the type of data to clear. Unlock with the master password first. Every clear action is written to the Clear Data Log below, which is permanent and cannot be deleted from the application.