Either the VOC's existing invoice workbook can be mapped automatically, or the City can build the template directly — both produce the same structured invoice.
Set up how each VOC's invoice template is captured — upload their existing Excel workbook, or build the line-item structure directly — and manage VOC branding on the invoice header.
.xlsx with Internal, Report, INVOICE, route sheets (T01…246_12m), Summary kms, Indices & Cost Adjustment tabs · max 25MB
| Workbook Sheet | Maps To | Status |
|---|---|---|
| INVOICE | Invoice Template — header & line items | Mapped |
| T01 … 246_12m (route sheets) | Route Master + Schedule Builder claims | Mapped |
| Summary kms | Consolidated KM roll-up (Type A–F) | Mapped |
| Duty Scheduling, Active Drivers, Driver Dismissals, Driver Traffic Fines | Driver & Regulator Cost inputs | Mapped |
| Regulators, Regulator Duty Summary | Regulator Cost line item | Mapped |
| Adjustments, Penalties | Adjustments & Penalties line items | Mapped |
| EVENTS INVOICE, Event Schedule | Event & Charter Services | Mapped |
| Indices, Cost Adjustment | Monthly Indices module | Review — 2 unmatched columns |
PNG or SVG, transparent background · used on the invoice header & VOC Portal
This header appears on the generated invoice in Invoice Report and on the VOC's own VOC Portal.
