District & tehsil-wise pending complaints by source
VTMS Working Hours
Fleet working below threshold hours, district & tehsil wise
UPLOAD ALL FILES — ONE TIME
Drop all your files here at once — Attendance (FMO/MO/DM), Penalties export, VTCS waste export, and Pending Complaints CSV. The system auto-detects which file belongs to which module (by filename and by column headers) and generates every report automatically. You can review / correct the detected module for each file before processing.
Drop all files here or click to browse
Select as many files as you like — FMO / MO / DM / Penalties / VTCS / Complaints, all in one go
Attendance Penalties VTCS Complaints
REPORTS READY
STEP 1 — UPLOAD ATTENDANCE FILES
Drop files here or click to browse
Select up to 3 files at once · Files are auto-detected as FMO / MO / DM
FMO MO DM
STEP 2 — STAFF ROSTER & FILTERS
District
Tehsil
Staff list (Name + Mobile)
STAFF ROSTER
District
Tehsil
Staff Name
Mobile
Designation (optional)
Current staff in selected tehsil
#
Name
Mobile
Status
Attendance Criteria
Location Counted
District Sargodha
Tehsil — DAT-AI Attendance Report
STEP 1 — UPLOAD PENALTIES FILE
District Revenue Authority — Sargodha Division. Upload one penalties export (CSV recommended; XLSX also works) — it powers the Day-wise / Tehsil-wise reports and the Category & Status report together.
Drop the penalties file here or click to browse
No file loaded yet
Day-wise / Tehsil-wise Reports
STEP 1 — UPLOAD PENALTIES CSV
District Revenue Authority — Sargodha Division. Upload the penalties CSV export to generate day-wise, tehsil-wise and overall reports.
Drop the penalties CSV here or click to browse
No file loaded yet
TEHSIL STAFF ROSTER
Staff added here show up as a 0-penalty row in every report for that tehsil, even before any CSV rows exist for them.
Tehsil Office
CNIC / ID (optional)
Staff Name
Designation (optional)
Current roster for selected office
Tehsil
Staff
Penalties
Amount (Rs.)
STEP 2 — CHOOSE VIEW
STEP 4 — EXPORT
STEP 3 — REPORT PREVIEW
Acumulative & Category Report
FILE STATUS
Fed automatically from the shared upload above. Columns are detected automatically — District, Tehsil / Office, Category, Penalty Amount, Penalty Imposed, Date.
Drop a file here or click to browse
CSV or XLSX up to ~50MB
0
Records
0
Districts
0
Tehsils
0
Total Rs.
STEP 2 — FILTER
Narrow the register by district, tehsil, or date range — every stat, preview table, and downloaded workbook below reflects this filter.
STEP 3 — ISSUE THE REPORTS
Report 01 — Category-Wise Penalties (quantity per category)
District → Tehsil breakdown showing the quantity (count) of penalties per category, with a grand-total row. District cells merged.
Report 02 — Penalty Status Summary (Rs. amounts)
Tehsil-wise Waived Off / Imposed / Pending amounts, reconciled to a grand total. Blank imposed-status treated as Pending.
STEP 4 — REVIEW BEFORE DOWNLOAD
This is exactly what will be written to each workbook.
Report 01 — Category-Wise Penalties
Report 02 — Penalty Status Summary
STEP 1 — UPLOAD VTCS EXPORT
Upload a VTCS Excel/CSV export to group trips by vehicle, tehsil and date, then filter, review and export the summarized report.
Drop the VTCS file here or click to browse
.xlsx, .xls or .csv export from VTCS
No file uploaded yet. Choose a VTCS Excel/CSV export above to generate the summary.
STEP 2 — CHOOSE VIEW
Summary report
Trip-wise detail report
TCP Fleet VTMS report
Waste Collection Report
TCP Summary
Set the fixed contract tonnage target for each tehsil — saved automatically and reused for every date.
Date
Tehsil
Vehicle name
No. of trips
Total approved waste (tons)
Grand total
0.00
Sr. No
Date
Tehsil
Vehicle name
Trip #
Approved waste (tons)
Grand total
0.00
STEP 1 — UPLOAD COMPLAINTS CSV
Upload a complaints CSV export. Pending records are grouped by District → Tehsil, with a column for each Source, and a Grand Total at the end — generated automatically.
Drop a CSV here or click to browse
Needs Status and Source columns · District and Office/Tehsil columns are used if present
STEP 2 — OVERVIEW & DISTRICT FILTER
0
Total rows read
0
Pending records
0
Districts covered
District
STEP 3 — REPORT PREVIEW
Complaints status — Pending report
RE-OPEN COMPLAINTS — DETAIL
Tehsil
Source
Complaint ID
Date & Time
STEP 4 — EXPORT
STEP 1 — UPLOAD VTMS ACTIVE LOGS
Upload the VTMS active logs CSV/Excel export (working hours per vehicle). Vehicles with total working hours below the threshold are counted district & tehsil wise against the fleet size as per RFP.
Drop the VTMS active logs file here or click to browse
Needs Vehicle, Date and either a Working Hours column or Start/End (login/logout) time columns · Tehsil column optional (matched from the VTCS trip file, if that module has been used, when missing)
No file uploaded yet. Choose a VTMS active logs Excel/CSV export above to generate the report.
STEP 2 — REPORT CONTROLS
Set the fixed fleet count as per RFP for each tehsil — saved automatically and reused for every date.