Data Quality & Fleet Routes
ReadyClean inconsistent uploads before saving, reconcile duplicate operators and vehicles, and manage operator default routes with vehicle-specific overrides.
Total Scans
Granted
Denied
Stored Operator Records
Stored Vehicles
Daily Payments
Weekly Payments
Sub Covered
Subscription Unpaid
Fleet Insights due rate is not configured
Unpaid vehicles are still identified, but the system will show “Rate not configured” instead of a misleading $0 balance.
Stored Operator Records
Active Fleet Operators
Unassigned Route Operators
Route rows count an operator once per route, so an operator working multiple routes appears in more than one row. Merged source records are deleted and are not counted.
Active Fleet
Covered
Unpaid
Collection Rate
Routes
Expected Due
30-Day Vehicle Revenue
Duplicate Reconciliation
Formatting differences are matched automatically. Names sharing four or more consecutive characters—such as Katiyo and W. Katiyo—are flagged for review only. Nothing is merged until you choose the record to keep.
Operator Groups
Operator Records
Vehicle Groups
Vehicle Records
Manual Operator Merge
Search by operator name only. Mark two or more operators, choose exactly one record to keep, then merge. Other fields are shown only to help you confirm the people.
1. Mark every duplicate record. 2. Select Keep on the authoritative record. 3. Click Merge Marked Operators. Unmarked records are never changed.
| Mark | Keep | Operator | Operator Licence | ID Number | Contact | Company | Route | Vehicles | Created |
|---|---|---|---|---|---|---|---|---|---|
No likely duplicates were found.
Possible Duplicate Operators
Suggestions use Operator Full Name only and each card compares exactly two records. Search a name to narrow the queue.
Possible duplicate operators
| Keep | Operator | Operator Licence | Contact | Company | Default Route | Vehicles | Created |
|---|---|---|---|---|---|---|---|
Possible duplicate vehicles
| Keep | Registration | Fleet | Operator | Route | Make | Driver | Status |
|---|---|---|---|---|---|---|---|
Import & Merge Ledger
Trace spreadsheet rows and every recorded merge within audit retention. Older events remain visible, although earlier releases stored IDs and counts without filenames or record labels.
Merge Events
Records Merged Away
Vehicle Records Merged
Recorded Imports
All recorded merges
| When | Type | Merged source records | Kept record | Linked history moved | Super User |
|---|---|---|---|---|---|
| No merge events have been recorded. | |||||
Import row accounting
| When / File | Import | Source Rows | Vehicle Rows | Added | Updated | Duplicate / Skipped | Contacts Saved | Issues | Super User |
|---|---|---|---|---|---|---|---|---|---|
| No import events have been recorded. | |||||||||
Smart Fleet Upload
Upload one inconsistent Excel/CSV list. The preview detects the header row, matches alternate column names, and separates operator, vehicle, route and payment information. You can correct every match before importing.
| Spreadsheet Column | Organize As | Sample |
|---|---|---|
Edit any cell below. Choose Skip to exclude a row.
| Row / Action | Match | Licence / OAN | Operator / Company | Contact | Optional Operator Route | Registration / Sticker | Optional Vehicle Route | Payment | Review Notes |
|---|---|---|---|---|---|---|---|---|---|
| No rows in this review filter | |||||||||
Rows needing attention
Scan Plate
Quick Tests
Operator: -
Payment:
Register Operator
Each number is saved separately. The first phone number is used for quick calls and reminders.
Vehicles inherit this route automatically.
Upload Inactive Operator List
Upload Excel or CSV, check the exact matches, then deactivate them in one step. Matching uses operator licence number, full operator name, national ID, or the complete contact number—never routes or partial contact digits. Linked vehicles can be made inactive while their sticker numbers remain unchanged.
| Spreadsheet Column | Use As | Sample |
|---|---|---|
| Row | Result | Matched Operator | Reason | Evidence |
|---|---|---|---|---|
Upload Operators
If a name is mapped into Operator Licence Number, it is moved to Full Name and the row is held for you to enter the correct licence and OAN. Ambiguous rows are skipped for review.
| Spreadsheet Column | Operator Field | Sample |
|---|---|---|
Skipped rows
Register Vehicle
Only enter this when the vehicle uses a different route.
Upload Vehicles
The operator lookup column may contain an operator licence number, OAN, or name. Map phone/contact columns to Operator Contact Number; missing contacts are filled even when an existing vehicle is kept.
| Spreadsheet Column | Vehicle Field | Sample |
|---|---|---|
Skipped rows
Record Payment
Save directly using an operator licence number or OAN. Vehicle details remain optional for operator-level payments.
Subscriptions are per vehicle. Select a registration or sticker number. The configured hybrid rates apply.
Matched
Operator
Operator No.
Company
Cell
Reg Plate
Sticker
Driver
Make
Payment
Fitness
Linked Vehicles — choose one only when this payment is vehicle-specific
Generate Invoice
Database Records
Client Display & Modules
Operator licence numbers always remain attached to historical records. A released OAN is remembered and restored on reactivation only if it has not been reassigned.
Entry Permissions
User Access Control
| Role | Area | View | Add | Edit | Delete | |
|---|---|---|---|---|---|---|
| - |
Security & Stability
Data Health
Checks stored values, including names accidentally saved as operator numbers.
No data consistency issues found.
58mm Invoice Template
Restored from the original MTA system. The preview and thermal-printer output use the same saved template, sizing and design controls.
Invoice Font Sizes
Invoice Print Design
Invoice Fields
Operator Fields
| Use | Label | Form | List | Upload | Excel Aliases |
|---|---|---|---|---|---|
Vehicle Fields
| Use | Label | Form | List | Upload | Excel Aliases |
|---|---|---|---|---|---|
Identifier Rules
Client Data Schemas
Fields & Inputs
| Label | Key | Type | Required | Unique | Form | List | Filter | Options | |
|---|---|---|---|---|---|---|---|---|---|
| Upload Excel/CSV or add fields manually | |||||||||
Excel / CSV Import
| Spreadsheet Column | Schema Field | Sample |
|---|---|---|
User Accounts
Portable Backup & Restore
Exact Reports
Expected subscriptions per active vehicle, with weekly and weekend charges calculated separately when the combined plan is selected.
Choose how MTA should calculate expected amounts.
Vehicle billing for Exact Reports
Create or correct the reporting rule here. Saving selects the plan immediately; no per-vehicle assignment is required.
Use the three-letter code, normally USD.
Optional internal identifier.
Only active vehicles and active operators are included. A route filter narrows the same obligations.
Subscription collected
Expected
Variance
Unmatched / unapplied
Expected and outstanding by route
| Route | Vehicles | Expected | Collected | Outstanding | Overpaid | Paid rate | Detail |
|---|---|---|---|---|---|---|---|
| No routes match these filters | |||||||
Advanced Data Tools
Review, reverse and reconcile sensitive changes without cluttering the everyday screens.
Stage a reviewed spreadsheet
| Spreadsheet column | Save as | Sample |
|---|---|---|
| Row | Status | Organized data | Review notes | |
|---|---|---|---|---|
Suggested fixes that still need a decision
Archive selected records safely
Select records in Operators, Vehicles or Payments, then move them here instead of permanently deleting them.
Optional numbering profiles
MTA registration continues to use the manually supplied Operator Licence Number and OAN. Profiles are available only for an explicitly configured future workflow and do not change normal registration or imports.
Exact Report billing plans
Billing setup now lives beside Exact Reports so the calculation and its rates can be reviewed together.
Extra record fields
Add client-specific fields to operator and vehicle entry without changing the everyday layout.
Encrypted full backup
Includes core records, contacts, chase history, archive history, staged imports, saved reports and configuration.