← Back to BookTraq
Live Product Demo

See FloorTraq in action

Drag the two sample files into the drop zones below to walk through a real floorplan reconciliation — from raw documents to a completed exception report.

1
Drop Files
2
Preview Data
3
Map Columns
4
Reconcile
5
Report
📄
Flooring Statement
Wells Fargo — Floorplan PDF
Click to select WF_Floorplan_Nov2024.pdf
✓ WF_Floorplan_Nov2024.pdf loaded
📊
DMS Inventory Schedule
Subaru of Metro — New Vehicles
Click to select MetroSubaru_Inventory_Nov24.xlsx
✓ MetroSubaru_Inventory_Nov24.xlsx loaded
This is a guided demo — click either drop zone to select the sample file
Select File
Select a file to load into the demo
Flooring Statement — Wells Fargo  ·  12 units parsed  ·  $421,850.00 total
VINYear / Make / ModelInvoice DatePrincipal BalanceCurtailment DueDays Floored
5YJSA1E26MF4378122024 Subaru Outback Premium10/14/24$32,100.00—47
4S3BWAE89N30225472024 Subaru Outback Onyx XT09/22/24$36,450.00$3,645.0069
4S3GKAD69N11000422024 Subaru Solterra Limited07/08/24$51,200.00$10,240.00129
4S3BWAD63N30198822024 Subaru Legacy Limited10/30/24$28,950.00—31
JF1ZNAA14N87123402024 Subaru BRZ tS09/01/24$38,400.00—60
JF2SHEDCXNH1087242024 Subaru Crosstrek Sport10/04/24$27,300.00—57
4S3BWAE84N30311042024 Subaru Outback Touring08/19/24$41,200.00$4,120.0083
KL3X44212NB0044712024 Subaru Ascent Premium11/01/24$44,100.00—29
JF2GTAFCXNH2210932024 Subaru Forester Limited09/14/24$37,650.00—57
JF2GTAFC5NH0099172024 Subaru Forester Sport06/15/24$34,200.00$6,840.00147
JF2GTAEC4NH2388012024 Subaru Forester Sport07/30/24$34,800.00$5,220.00123
4S3GKAB63N35002172024 Subaru Solterra Premium10/22/24$48,700.00—39
DMS Inventory Schedule — 10 units  ·  $379,650.00 book value
VINStock NoYear / Make / ModelDate FlooredFloor BalanceStatus
5YJSA1E26MF437812S24-08412024 Subaru Outback Premium10/14/24$32,100.00In Stock
4S3BWAE89N3022547S24-08292024 Subaru Outback Onyx XT09/22/24$38,150.00In Stock
4S3BWAD63N3019882S24-08122024 Subaru Legacy Limited10/30/24$28,950.00In Stock
JF1ZNAA14N8712340S24-08552024 Subaru BRZ tS09/01/24$38,400.00In Stock
JF2SHEDCXNH108724S24-08612024 Subaru Crosstrek Sport10/04/24$27,300.00In Stock
4S3BWAE84N3031104S24-08342024 Subaru Outback Touring08/19/24$41,200.00In Stock
KL3X44212NB004471S24-08722024 Subaru Ascent Premium11/01/24$44,100.00In Stock
JF2GTAFCXNH221093S24-08472024 Subaru Forester Limited09/14/24$37,650.00In Stock
4S3GKAB63N3500217S24-08632024 Subaru Solterra Premium10/22/24$48,700.00In Stock
JF2GTAEC4NH238801S24-08212024 Subaru Forester Sport07/30/24$34,800.00Sold-Unreported
✓ FloorTraq auto-mapped 8 of 8 columns with high confidence
Flooring Statement Columns
DMS Inventory Schedule Columns
Matching VINs across sources...
0%
Floorplan Reconciliation Report
Subaru of Metro
Lender: Wells Fargo Dealer Services
Statement Period: November 2024
Generated: Nov 30, 2024 · 11:58 PM
8
Matched
2
Phantom Units
1
Sold Unreported
$1,700
Balance Variance
$421,850
Total Floored
2 phantom units detected — these VINs appear on the Wells Fargo billing statement but cannot be found anywhere in your DMS inventory. Immediate follow-up required to avoid paying flooring interest on vehicles no longer on your lot.
Full Reconciliation Detail
VIN (Last 8)Year / ModelStk #Statement Bal.DMS Bal.VarianceDays / SoldStatus
...F4378122024 Outback PremiumS24-0841$32,100$32,100—47 daysMatched
...30225472024 Outback Onyx XTS24-0829$36,450$38,150($1,700)69 daysBal. Var.
...N11000422024 Solterra LimitedNot Found$51,200—$51,200129 daysPhantom
...30198822024 Legacy LimitedS24-0812$28,950$28,950—31 daysMatched
...87123402024 BRZ tSS24-0855$38,400$38,400—60 daysMatched
...H1087242024 Crosstrek SportS24-0861$27,300$27,300—57 daysMatched
...30311042024 Outback TouringS24-0834$41,200$41,200—83 daysMatched
...B0044712024 Ascent PremiumS24-0872$44,100$44,100—29 daysMatched
...H2210932024 Forester LimitedS24-0847$37,650$37,650—57 daysMatched
...H0099172024 Forester SportNot Found$34,200—$34,200147 daysPhantom
...H2388012024 Forester SportS24-0821$34,800Sold 11/12—Sold 11/12Sold-Unreported
...35002172024 Solterra PremiumS24-0863$48,700$48,700—39 daysMatched
Exception Summary — Action Required
Phantom unit — 4S3GKAD69N1100042 (Solterra Limited)
$51,200.00
VIN present on Wells Fargo statement (floored 07/08/24, 129 days) but not found anywhere in DMS inventory. Vehicle may have been sold without payoff, wholesaled without proper curtailment, or the VIN may have been reported in error. Contact Wells Fargo to initiate payoff or dispute. Curtailment of $10,240 also outstanding.
Phantom unit — JF2GTAFC5NH009917 (Forester Sport)
$34,200.00
VIN on statement (floored 06/15/24, 147 days) with $6,840 curtailment past due. Not found in DMS. At 147 days this unit is significantly past the standard curtailment schedule. Immediate action required to avoid further charges or lender audit.
Sold-unreported — JF2GTAEC4NH238801 (Forester Sport, S24-0821)
$34,800.00
DMS shows unit sold 11/12/24 but Wells Fargo statement still shows an active floor balance. Payoff must be remitted to lender within your contractual window to stop accruing interest.
Balance variance — Outback Onyx XT (S24-0829)
$1,700.00
Statement shows $36,450 principal; DMS floor schedule shows $38,150. Difference likely reflects a curtailment payment posted to lender but not yet updated in CDK. Verify with curtailment remittance records.
Live app exports as Excel or PDF