CancelTraq — F&I net-value and sales-experience modeling for dealership GMs
Compare the conventional F&I box against clearer, lower-pressure, hybrid, or digital processes — using GM-supplied modeled assumptions for close rate, front-end gross, booked F&I at delivery, cancellations, chargebacks, labor, and optional future/referral effects. Not a claim that removing F&I produces guaranteed savings or lower advertised payments.
Illustrative modeled scenario only. Not financial, legal, tax, or regulatory advice. CancelTraq does not claim F&I should be eliminated, does not promise profit outcomes, and does not produce advertised price or monthly-payment examples. Defaults are sample assumptions for exploration — not measured results from your store. Do not enter customer-identifying information.
Booked F&I PVR (gross recognized at delivery) is not whole-cycle profit
High F&I production can look excellent on the month it books — and still leave the GM uncertain after product cancellations, lender/product chargebacks, compensation, labor, delays, fallout, weak reviews, and weaker return/referral behavior.
Booked F&I PVR
Gross recognized at delivery (deal recap / F&I log). Easy to pay and celebrate. Incomplete economics.
Expected F&I (modeled)
Forward scenario after assumed cancel/chargeback/reserve leakage and direct process cost. Not measured cash through N months.
Optional future / referral
Separate scenario line only — modeled, not measured, not causal. Disabled when cohort age < 12 months; capped vs direct gross.
Does high booked F&I gross remain high realized profit after cancellations, chargebacks, compensation, labor, delays, lost sales, poor reviews, and weaker return/referral behavior?
Could a faster, transparent process with more front-end gross and lower F&I pressure create more completed sales and more realized profit over the full cycle?
Which store / product / process configuration performs best under the GM’s own assumptions?
Why whole-cycle F&I economics deserve a closer look
Industry reporting highlights three practical issues for dealership leaders: retained F&I can change after delivery, revenue recognition requires reversal estimates, and the customer’s time in the process matters.
Multi-store CFOs/COOs have described early aftermarket cancellations and chargebacks as a major profitability drag and staffing burden (not a minor true-up).
Auto Finance News · Jan 2025FASB Topic 606 requires entities to estimate variable consideration and constrain amounts when a significant revenue reversal is probable. Dealership-specific chargeback and reserve treatment should be confirmed with the store’s CPA or auditor.
FASB · Topic 606CDK cited study data that 65% of consumers spend up to 45 minutes waiting to see the F&I manager — a process design issue, not only a product-mix issue.
CDK Global · Dec 2023J.D. Power Sales Satisfaction Index evaluates negotiation/F&I and related steps. Useful for experience framing; not a causal profit formula.
J.D. Power SSIEvery store is different. Close rate, product mix, credit tier, compensation design, and inventory all influence the result. CancelTraq is designed to compare scenarios using the store’s own operating assumptions rather than prescribe one process for every dealership.
Historical realized F&I gross — cohort view
Illustrative demo of how CancelTraq could combine vendor events to show how booked F&I gross changes after product cancellations, product chargebacks, lender-reserve reversals, compensation true-ups, and direct process costs. All series below are deterministic fictional sample data — not measured results from any dealership. The 0–60 month window is a configurable observation horizon for the demo, not a claim that contracts or chargebacks last 60 months.
Demo as-of date is fixed at July 2026 so cohort age is deterministic. Observed months use fictional vendor events; months after the observed cutoff are projected and shaded.
Cohort retention curve
Gross bridge — retained direct contribution
Decision comparison (sample cohorts)
| Segment | Maturity / coverage | Booked F&I | Retained direct (obs.) | Retained % | Read |
|---|
Accessible summary table — retention series
| Month | Status | Booked F&I | Expected retained | Observed / projected retained |
|---|
Direct historical arithmetic (demo): retained direct contribution = booked F&I gross − product cancellation/chargeback leakage − lender-reserve reversals − compensation reversals − direct process costs. Chargebacks are contingent events; stores must load actual contract terms and vendor rules.
GM scenario lab — side-by-side
Edit either side. Outputs recalculate instantly in your browser. No backend. No customer data storage. Primary comparison uses expected realized direct gross only. Future/referral is optional, separate, and capped. All outputs are labeled as illustrative modeled scenarios under GM-supplied assumptions — not payment quotes and not guaranteed savings.
| Metric | Current (A) | Alternative (B) | Difference |
|---|
Formulas (deterministic, simplified): delivered = opps × close%; front-end = delivered × front-end gross/unit; booked F&I = delivered × Booked F&I PVR (gross recognized at delivery); product leakage = booked F&I × product cancel%; reserve leakage = booked F&I × reserve leak% (same total booked base — use independently measured rates only); process cost = delivered × cost/unit (labor/tech field only; wait minutes are not auto-converted); expected realized direct = front-end + booked F&I − leakages − process cost; raw future/referral = delivered × referral$/unit when cohort age ≥ 12 months, else 0; future/referral contribution = clamp(raw, ±50% of |expected realized direct|); optional scenario-inclusive = expected realized direct + future/referral contribution. Primary headline and primary per-unit/opportunity deltas use expected realized direct only. This is a forward scenario without actual cohort cash — not “realized through N months.” Wait minutes are context only and do not imply conversion or CSI outcomes.
Product / workflow modules (preview)
Concept modules for a pilot build — not a promise of shipped software.
Entity matching
Deal / product / lender / customer / store / producer identity resolution so cancellations attach to the right economics.
Booked → realized roll-forward
Month and cohort views: booked production, expected reserve, realized after chargebacks, and remaining UNKNOWN aging.
Cancellation / chargeback case queue
Ownership, aging, evidence packets, multi-party sources (consumer, lender, admin, other dealer).
Compensation & GL true-up
Track pay-plan clawbacks and chargeback GL accounts so booked logs stop silently overstating net.
Process cohort / experiment compare
Compare process modes with honest UNKNOWN states — not fake certainty from incomplete attribution.
Customer experience linkage
Optional join to CSI / reviews / CRM return sales where data permits — never forced into a single causal score.
GM scenario lab
What-if modeling under store assumptions (this page is the public sketch of that lab).
Role views & audit trail
GM, controller, F&I director, and case-owner views with change history — not a shared spreadsheet free-for-all.
Automatic vendor-data workflow (concept)
CancelTraq is designed to combine authorized vendor feeds so GMs can see booked-to-retained F&I economics without re-keying every chargeback. The patterns below describe a realistic pilot path. They are not a claim that live connectors already exist for every vendor.
Source systems
DMS / deal / F&I source
- Deal and delivery identifiers
- Booked F&I gross at delivery
- Product, lender, manager, and process attributes
Product administrator source
- Activation / contract status
- Cancellation request and effective date
- Refund and product chargeback amounts
Lender / reserve source
- Funding confirmation
- Early payoff when available
- Reserve adjustment / chargeback
Accounting / GL source
- Posted chargebacks, refunds, and compensation reversals
- Direct F&I process costs
- Reconciliation status against books
Supported acquisition patterns
- 1. Documented APIs / webhooks Where the vendor and dealership authorize a supported integration path — not implied as already live for every source.
- 2. Scheduled SFTP or vendor exports Recurring files from admin or lender portals on a controlled schedule.
- 3. Controlled CSV / XLSX import Universal starting point for pilots; schema-validated, user-reviewed before load.
- 4. Optional secure statement inbox Only when dealership and vendor authorization and controls exist — never browser credential storage or portal scraping.
Pipeline
- 1Connect / import Authorized API, SFTP, or file load
- 2Normalize Canonical event fields and signs
- 3Match Deal / product / lender keys
- 4Reconcile GL vs vendor vs deal jacket
- 5Graph Cohort retention and bridges
- 6Feedback Exception and maturity alerts
Exception queues
Unmatched
Vendor chargeback or cancel with no deal/product key match — held for review, not silent drop.
Duplicate
Same source record or overlapping refund amounts detected across imports — flagged before overwrite.
Corrected
Restated amount or void from vendor/GL — supersedes prior event with provenance, no silent replace.
Late-arriving
Posting date after observation cutoff — restates mature cohorts with an audit stamp.
Sample automatic feedback
- Observed leakage above store baseline Mature cohort sample (age ≥ maturity threshold) shows product chargeback leakage above the store’s baseline range. Review product mix and cancel handling — sample demo only.
- Too little mature data Selected product/lender combination has insufficient mature months for a conclusion. Continue observing; do not treat as a winner or loser.
- Unmatched chargebacks need accounting review Repeated unmatched product chargebacks are sitting in the exception queue. Controller review required before graphs treat them as retained leakage.
- Process variant shows higher retained direct contribution Hybrid process segment shows higher retained direct contribution than traditional in this fictional sample. Correlation is not proof of causation — manager, mix, and credit tier may differ.
Likely inputs
DMS F&I log / deal file · product admin cancel files · lender reserve/chargeback reports · commission plans · GL chargeback accounts · optional CSI/review/CRM extracts · process-mode tags (often missing).
Limitation: Process mode is frequently unlogged. Cohort comparison starts incomplete until the store tags deals.
What this concept will not do
No automatic legal determination of refund rights. No claim of causal proof from correlational CSI. No silent black-box profit score. No public pricing. No replacement for your CPA or compliance counsel. No scraping of vendor portals and no browser credential storage.
Cross-system gap: Menu tools book; admin portals cancel; GL reserves; CSI surveys score — few stores roll them into one GM decision object.
Management decision workspace
A mature-product sketch of configurable F&I / chargeback decision support. Toggle which factor groups management tracks, set a new-manager comparison policy, and switch among five decision views. All figures are deterministic fictional sample data. Language stays observational — associated with, observed, needs review — not causal proof against a manager or process.
New-manager comparison basis
Factor tracking toggles
Group master toggles and item checkboxes control what appears in the sample management summary below. Disabled factors are excluded from conclusions — they do not silently remain in the readouts.
Decision views
Durable-profit scoreboard
| Metric | Value | Denominator | Read |
|---|
Chargeback attribution matrix
| Category | Count | Chargeback $ | Control | Initiating party | Read |
|---|
Exposure and reserve forecast
| Bucket | Amount | Basis | Status |
|---|
Cancellation operations queue
Coaching and process comparison
| Segment | Basis used | Cancel rate | Retained / booked | Read |
|---|
Management demo formulas (deterministic, fictional): chargeback$ / booked F&I gross; cancelled contracts / contracts sold; cancelled contracts / currently exposed contracts; retained commission / original commission. Manager maturity requires tenure months ≥ threshold and matured contracts ≥ minimum. Blend = 0.5 × manager history + 0.5 × store average when immature under blend mode; mature managers use their own history. Direct profit excludes modeled customer-lifetime / repeat / referral / service context.
Validate CancelTraq with your store’s numbers
If you want a structured conversation about booked-to-realized F&I, chargeback operations, and process-mode trade-offs — bring a month of anonymized production and cancel data. No public pricing; validation first.
Request a validation conversation →