Fleet P&L — 2026-W27 (Jun 29 – Jul 5)
Verdict: $1,700 real fleet revenue this week, but only 1 of 9 vehicles (the Taurus) collects through Stripe — the other 8 earn off-Stripe (Zelle/cash) or not at all, so their net is uncapturable. Costs (insurance, notes) still unrecorded. Every number below traces to a source; nothing estimated.
Revenue (source: SABRONMBC Stripe, acct_1DXnhfAxLtpglkE1, real)
| Charge | Amount | Attribution |
|---|---|---|
| Subscription "$400/week × 27 — Taurus lease-to-own" (sub_…tEdUMNg7, active) | $400.00 | 2016 Ford Taurus (Carlyle Roberts) ✓ |
| One-off card charge ch_…88YeG (Apple Pay, Mastercard …2216) | $1,300.00 | unattributed — no customer/description; metadata redacted by the connector |
| Total W27 Stripe revenue | $1,700.00 |
Only 1 active subscription exists in this account (the Taurus). The other 8 vehicles have no Stripe recurring charge.
Per-vehicle (9 vehicles, source: SwiftRide Hasura)
| Vehicle | Org | Wk rate | Status | W27 Stripe rev | Lifetime maint | W27 net (recorded) |
|---|---|---|---|---|---|---|
| 2016 Ford Taurus | SABRONMBC | $449 (lease $400) | rented | $400 | $136.14 | +$400 (pre-insurance) |
| 2015 Nissan Altima | SABRONMBC | $399 | rented | $0 | $653.17 | — off-Stripe |
| 2020 Chevrolet Malibu ·072930 | SABRONMBC | $449 | rented | $0 | $0 | — off-Stripe |
| 2019 Kia Optima ·319749 | SABRONMBC | $449 | maintenance | $0 | $0 | — idle |
| 2022 Chevrolet Malibu ·115654 | SABRONMBC | $475 | rented | $0 | $0 | — off-Stripe |
| 2017 Chevrolet Malibu ·102939 | SABRONMBC | $449 | rented | $0 | $66.59 | — off-Stripe |
| 2018 Chevrolet Malibu ·159969 | SABRONMBC | $449 | maintenance | $0 | $393.72 | — idle |
| 2019 Kia Optima ·339132 | SABRONMBC CHATTK | $449 | damaged | $0 | $0 | — idle |
| 2020 Chevrolet Malibu ·114941 | SABRONMBC TTK | $449 | rented | $0 | $0 | — off-Stripe |
| Unattributed Stripe | $1,300 |
Read
- Taurus is the only clean P&L line: $400 collected vs $400 expected = 100%. Net +$400 before insurance/note (both unknown).
- 5 "rented" vehicles show $0 through Stripe (Altima, 2×Malibu 072930/115654, Malibu 102939, Malibu 114941). Their rental income is collected off-Stripe — real money not in any connected system.
- 3 vehicles idle/non-earning: Optima ·319749 (maintenance), Malibu ·159969 (maintenance), Optima ·339132 CHATTK (damaged).
- The $1,300 charge is real fleet income but can't be tied to a vehicle here (connector redacts metadata; charge has no customer/description).
Data gaps (capture to-do)
- 8 of 9 vehicles collect rent off-Stripe. Only the Taurus subscription runs through Stripe. → Fix: set up weekly Stripe subscriptions per rented vehicle (like the Taurus), or log Zelle/cash collections into
Fleet/Vehicles/weekly. Until then, 5 rented vehicles' revenue is invisible. - Metadata redaction blocks per-vehicle attribution. The read-only connector redacts charge metadata, so even tagged charges (e.g. the $1,300) can't be auto-attributed. → Fix: put the VIN/plate in the charge
description(not just metadata), or accept manual attribution. - No insurance cost (SwiftRide insurance_rates = 0). → enter per-vehicle premium.
- No car-note payments tracked → add
monthly_note_paymentto vehicle notes. - Rideshare (Uber/Lyft) income not exported (all 9 on rideshare plans) → drop CSVs in
Fleet/Raw/.
Sources
- Revenue: SABRONMBC Stripe (acct_1DXnhfAxLtpglkE1, MCP
stripe-sabronmbc, read-only), W27 charges + active subscriptions, queried 2026-07-06. - Fleet/status/rates/maintenance: SwiftRide Hasura (MCP
hasura-prod, read-only).