Operational, Financial, Analytics & TLC-compliant reports for NYC car & limo services.
| Res # | Booked | Pickup | Dropoff | Service | Driver | Status | Miles | Total |
|---|---|---|---|---|---|---|---|---|
| RSV-1012 | 2025-10-17 08:11 | JFK T4 | Midtown East | SUV | J. Perez | completed | 16.8 | $148.75 |
| RSV-1013 | 2025-10-17 08:42 | Upper West | LGA T-B | Sedan | M. Rivera | completed | 9.4 | $92.30 |
| RSV-1014 | 2025-10-17 09:05 | FiDi | JFK T1 | SUV | A. Chen | no_show | — | $0.00 |
| Driver | Trips | Hours Online | Acceptance | Cancel | Gross | Payout |
|---|---|---|---|---|---|---|
| J. Perez | 12 | 7.3 | 95% | 2% | $1,190 | $892 |
| M. Rivera | 9 | 6.1 | 89% | 3% | $822 | $615 |
| Date | Company | Gross | Discounts | Tips | Taxes | Net |
|---|---|---|---|---|---|---|
| 2025-10-15 | NYC Black Car LLC | $14,220 | $320 | $1,180 | $1,257 | $13,823 |
| 2025-10-16 | Uptown Limo Inc | $16,410 | $410 | $1,540 | $1,436 | $16,104 |
| Invoice # | Account | Period | Issued | Due | Total | Balance | Status |
|---|---|---|---|---|---|---|---|
| INV-8841 | Goldman Travel | Oct 1–15 | 2025-10-16 | 2025-10-30 | $12,480 | $12,480 | open |
| INV-8842 | Apex Media | Oct 1–15 | 2025-10-16 | 2025-10-30 | $6,920 | $0 | paid |
Columns compatible with TLC submission (CSV/XML):
| PU DateTime | DO DateTime | PU Loc ID | DO Loc ID | Drv Lic # | Veh TLC # | Base # | Payment | Miles | Fare |
|---|---|---|---|---|---|---|---|---|---|
| 2025-10-16 13:10 | 2025-10-16 14:02 | 132 | 236 | TLC-98A21 | VHC-77J | B01234 | Card | 16.8 | $126.50 |
| Entity | Name/Plate | Doc | Expires | Days Left |
|---|---|---|---|---|
| driver | J. Perez | TLC License | 2025-11-04 | 18 |
| vehicle | TLC 9K21 | Insurance | 2025-10-28 | 11 |
| Origin | Fulfillment | Jobs | Gross | Split |
|---|---|---|---|---|
| NYC Black Car | Queens Elite Limo | 34 | $4,920 | $1,476 |
| Uptown Limo | BK Executive | 19 | $2,710 | $813 |
| Zone | Trips | Avg Fare | Revenue |
|---|---|---|---|
| JFK | 142 | $118.40 | $16,813 |
| Midtown | 96 | $64.20 | $6,163 |
| Rule ID | Active | Zone | Time Window | Type | Value |
|---|---|---|---|---|---|
| DR-01 | Yes | JFK | 6–9 AM | multiplier | 1.25x |
| DR-07 | No | Midtown | 5–7 PM | flat | +$8.00 |
| Time | Source | Type | Reason | Count |
|---|---|---|---|---|
| 2025-10-16 09:12 | driver_app | cancel | Delayed pickup | 1 |
| 2025-10-16 10:41 | dashboard | error | Payment timeout | 2 |