Truck 1361 — vida completa

12 mesesmonths

na Billor (chegada 22/07/2025)at Billor (arrival Jul 22, 2025)

$26,270

custo real — 11 service entriesreal cost — 11 service entries

$23,648

lançado em fintech (14 requests aprovadas)issued as fintech (14 approved requests)

$8,942

fintech recebida (Paid) · $32,7k em abertofintech received (Paid) · $32.7k pending

drivers: Jonathan (jul–out/25) → James (mar/26–)drivers: Jonathan (Jul–Oct/25) → James (Mar/26–)

tickets Zendesk (era James)Zendesk tickets (James era)

1Ficha do asset e garantiasAsset profile & warranties

AquisiçãoPurchase

Arrow Truck Sales · down 06/06/2025 · full 25/06/2025 · investor Leste

Chegada → 1ª entregaArrival → 1st delivery

22/07/2025 → 24/07/2025 (Jonathan)

Garantia Billor (30d pós-entrega)Billor warranty (30d post-delivery)

Janela 1: 24/07–23/08/2025 (Jonathan) · Janela 2: 12/03–11/04/2026 (James)Window 1: Jul 24–Aug 23/25 (Jonathan) · Window 2: Mar 12–Apr 11/26 (James)

Garantia fábrica / estendidaFactory / extended warranty

sem registro (cf warranty_end vazio)not on record (warranty_end blank) — conferir histórico de compra (Douglas)— check purchase records (Douglas)

ContratosContracts

Jonathan A. Johnson · Premium · 24/07/25→31/10/25 (voluntário: "leaving the country") → James F Johnson · Premium · 12/03/26→ativoactive

Fase sem driverNo-driver phase

01/11/2025 → 11/03/2026 (4,5 meses: rescue, reconditioning, shop 04/03months: rescue, reconditioning, shop Mar 4)

AnalistasAnalysts

Fleet: Gabriel Corso · Churn: Thiago

Specs

Electric APU · double bunk · GPS ETM · BestPass B6010316770

2Serviços executados (service entries = custo real) × cobertura × fintechExecuted services (service entries = real cost) × coverage × fintech

Cada linha é um serviço realmente executado. Correlação com WO é determinística (campo work_order_number). Cobertura derivada das janelas de garantia; fintech casada por texto do reason + data (forte/provável).Each row is an actually executed service. WO correlation is deterministic (work_order_number field). Coverage derived from warranty windows; fintech matched by reason text + date (strong/likely).

DataDate	OficinaShop	ServiçoService	WO	CustoCost	CoberturaCoverage	Fintech
22/07/25	Billor shop	Truck devices	#1713	$249	onboarding	—
24/07/25	Billor shop	Kit flatbed	#1814	$2,453	onboarding	parcelas "Flatbed Kit" ($1,5k pagas)"Flatbed Kit" installments ($1.5k paid)
11/08/25	Bill Errera	Towing / roadside	#2222	$3,500	GARANTIA BILLOR (dia 18/30)BILLOR WARRANTY (day 18/30) custo BillorBillor cost	sem fintech — cobertono fintech — covered
09/03/26	BR Diesel LLC	Óleo/filtros, DPF regenOil/filters, DPF regen	—	$3,851	fase asset (reconditioning)asset phase (reconditioning) custo BillorBillor cost	—
11/03/26	Flyk Truck Center	Inverter	—	$569	prep entrega JamesJames delivery prep	—
02/04/26	MHC Kenworth	Radiador + axle shaftRadiator + axle shaft	—	$4,205	GARANTIA BILLOR (dia 21/30, entrega James)BILLOR WARRANTY (day 21/30, James delivery)	provável: "Brake and axle repair" $1.509 (RA)likely: "Brake and axle repair" $1,509 (RA)
29/05/26	Stoops (2 SEs)	Diagnóstico motor/combustível + câmeras/safetyEngine/fuel diagnostics + cameras/safety	—	$7,735	fora de garantiaout of warranty	forte: "oils, abs, check engine, cruise" $4.256 (Emergency)strong: "oils, abs, check engine, cruise" $4,256 (Emergency)
04/06/26	Billor shop	Kit flatbed (reposição)Flatbed kit (replacement)	#5395	$2,410	fora de garantiaout of warranty	provável: "Accessory Purchase ZD-162520" $480likely: "Accessory Purchase ZD-162520" $480
09/06/26	TA Truck Service	Crankcase oil separator	—	$1,297	fora de garantiaout of warranty	forte: "Engine oil leak" $5.637 (Emergency) — reparo maior sem SEstrong: "Engine oil leak" $5,637 (Emergency) — larger repair w/o SE
11/06/26	—	Entry $0 (fechamento adm.)$0 entry (admin closure)	—	$0	—	—
Total service entriesService entries total				$26,270

Serviços de estrada da era James não geram service entry — a fintech é o único registro de custo.Road services in the James era generate no service entry — the fintech is the only cost record. Tire change na Love's (18/05, $1.448), locksmith (21/05, $486), windshield (jul, $1.335), check engine (11/06, $1.828), "Fleetnet hold" (08/06, $1.054) e hotel (#456532, $210) somam $6,4k que não existem no Fleetio — só no fintech board e no Zendesk.Tire change at Love's (May 18, $1,448), locksmith (May 21, $486), windshield (Jul, $1,335), check engine (Jun 11, $1,828), "Fleetnet hold" (Jun 8, $1,054) and hotel (#456532, $210) add up to $6.4k that don't exist in Fleetio — only on the fintech board and Zendesk.

A correlação fintech↔serviço tem chave determinística parcial:Fintech↔service correlation has a partial deterministic key: os reasons citam tickets Zendesk ("ZD-162520", "#456532") e descrições de serviço. Recomendação para o sistema: campo obrigatório de ticket/SE na abertura da fintech.reasons cite Zendesk tickets ("ZD-162520", "#456532") and service descriptions. System recommendation: make ticket/SE reference a required field when opening a fintech.

3Fintech do truck — lançado × recebidoTruck fintech — issued × received

Requests aprovadas (14 — board "Done")Approved requests (14 — board "Done")

MotivoReason	TipoType	LançadoIssued	Parc.
Tire replacement (Jonathan)	Emergency	$988	9
Renegociação (Jonathan)Renegotiation (Jonathan)	Renegotiation	$0	14
Engine oil leak	Emergency	$5,637	17
Oils, ABS, check engine, cruise	Emergency	$4,256	32
Camshaft, oil, jumpstart	General Maint.	$2,599	23
Check engine light	Support	$1,828	38
Oil leaks	Road Assist.	$1,818	37
Brake and axle repair	Road Assist.	$1,509	43
Tire change (Love's 18/05)	Road Assist.	$1,448	6
Windshield replacement	General Maint.	$1,335	45
Fleetnet hold (air lines)	Emergency	$1,054	3
Locksmith (FleetNet)	Road Assist.	$486	33
Accessory purchase ZD-162520	Support	$480	4
Hotel #456532	Advance	$210	1
Total lançadoTotal issued		$23,648

Parcelas de fintech por status (unit 1361)Fintech installments by status (unit 1361)

Status	ParcelasInstallments	ValorAmount
Recebido (Paid)Received (Paid)	27	$8,942
Em aberto (Pending)Open (Pending)	54	$32,656
CanceladoCanceled	52	$24,276
Rolado em renegociaçãoRolled by renegotiation	298	$142,906

⚠ Valores por parcela incluem juros/spread e as renegociações encadeiam saldos (o mesmo dólar aparece em mais de um ciclo). "Lançado" usa requested_amount (principal do serviço). O cancelado do ciclo Jonathan (churn out/2025) é candidato a perda.⚠ Installment amounts include interest/spread and renegotiations chain balances (the same dollar shows up across cycles). "Issued" uses requested_amount (service principal). Canceled installments from the Jonathan cycle (churn Oct/2025) are loss candidates.

4Timeline — a vida em capítulosTimeline — the life in chapters

PeríodoPeriod	CapítuloChapter	DriverDriver
06–25/06/2025	Compra (Arrow, investor Leste)Purchase (Arrow, investor Leste)	—
22–24/07/2025	Chegada, devices, kit flatbed, entregaArrival, devices, flatbed kit, delivery	Jonathan
11/08/2025	Towing $3.500 — dentro da garantia Billor (dia 18)Towing $3,500 — within Billor warranty (day 18)	Jonathan
31/10/2025	Churn voluntário ("leaving the country") · issue RESCUE abertoVoluntary churn ("leaving the country") · RESCUE issue opened	Jonathan →
nov/25–mar/26	Fase asset: 4,5 meses sem driver · shop 04/03 (BR Diesel $3.851 + Flyk $569)Asset phase: 4.5 months w/o driver · shop Mar 4 (BR Diesel $3,851 + Flyk $569)	—
12/03/2026	Nova entrega (contrato Premium) — 1º ticket Zendesk em 11/03Re-delivery (Premium contract) — 1st Zendesk ticket Mar 11	→ James
01–13/04/2026	Brokedown + MHC $4.205 (garantia Billor, dia 21) + inspeção FMCSA (2 tickets)Brokedown + MHC $4,205 (Billor warranty, day 21) + FMCSA inspection (2 tickets)	James
mai–jun/2026	Roadsides recorrentes, NEW TRUCK request no dia dos $7.735 na Stoops, oil leak (TA $1.297 + fintech $5.637)Recurring roadsides, NEW TRUCK request same day as $7,735 at Stoops, oil leak (TA $1,297 + fintech $5,637)	James
jul/2026	Saga windshield (4 tickets, fintech $1.335, sem SE) · PM em holdWindshield saga (4 tickets, $1,335 fintech, no SE) · PM on hold	James

5O que este caso ensina para o sistemaWhat this case teaches the system

1. Service entry é o custo canônico; WO é a ordem.Service entry is the canonical cost; WO is the order. Correlação determinística por work_order_number cobre 58% da frota (99,9% íntegra); os 42% restantes são reparo externo genuíno.Deterministic correlation via work_order_number covers 58% of the fleet (99.9% integrity); the remaining 42% are genuine external repairs.

2. Cobertura é derivável de datas de contrato.Coverage is derivable from contract dates. Contratos (BigQuery) dão as janelas de 30d por entrega e a fase sem driver. O towing de ago/25 e o radiador de abr/26 caíram DENTRO da garantia — custo Billor correto. Falta estruturar o "porquê" das coberturas fora de garantia (ex.: Paid By Retention já existe como status de parcela).Contracts (BigQuery) give the 30-day windows per delivery and the no-driver phase. The Aug/25 towing and Apr/26 radiator fell WITHIN warranty — correctly Billor cost. What's missing is structuring the "why" for out-of-warranty coverage (e.g., Paid By Retention already exists as an installment status).

3. Garantia de fábrica/estendida é um buraco de dados.Factory/extended warranty is a data gap. Só 105/565 trucks têm warranty_end no Fleetio; o 1361 está vazio. A fonte é o histórico de compra (Douglas) — integrar ao cadastro salva reparos como radiador/DPF que podem ser warranty claim.Only 105/565 trucks have warranty_end in Fleetio; 1361 is blank. The source is purchase records (Douglas) — integrating it saves repairs like radiator/DPF that could be warranty claims.

4. Fintech precisa de chave estruturada para o serviço.Fintech needs a structured key to the service. Hoje o vínculo é texto (reason cita ZD-XXXXX / descrição). Com truck+data+referência obrigatória, o cruzamento lançado×recebido×serviço vira automático.Today the link is text (reason citing ZD-XXXXX / description). With mandatory truck+date+reference, issued×received×service reconciliation becomes automatic.