🏭
Factory Statement
Ford Motor Company — Parts Statement
Click to select FordParts_Statement_Nov2024.pdf
✓ FordParts_Statement_Nov2024.pdf loaded
📊
GL Detail Template
Synthetic Ford — Chart of Accounts
Click to select SyntheticFord_GL_Template.xlsx
✓ SyntheticFord_GL_Template.xlsx loaded
This is a guided demo — click either drop zone to select the sample file
Select a file to load into the demo
Ford Parts Statement — FordParts_Statement_Nov2024.pdf · 18 line items · $94,218.40 total
Line # Part Number Description Category Qty Unit Price Amount Type
001 FL-500S Motorcraft Oil Filter Parts 144 $4.89 $704.16 Purchase 002 FA-1999 Air Filter — 2.3L EcoBoost Parts 36 $18.40 $662.40 Purchase 003 BRF-11 Brake Fluid DOT-4 12oz Parts 48 $9.20 $441.60 Purchase 004 PDI-F150 F-150 PDI Allowance — Nov Incentive 22 $350.00 $7,700.00 Incentive 005 SW-6674 Spark Plug Set — 5.0L V8 Parts 24 $62.10 $1,490.40 Purchase 006 HB-F150-24 F-150 Holdback — Q4 2024 Holdback 22 $978.00 $21,516.00 Holdback 007 WT-1140 Wiper Blade Set — 18/22in Parts 60 $22.50 $1,350.00 Purchase 008 PDI-EXPL Explorer PDI Allowance — Nov Incentive 8 $300.00 $2,400.00 Incentive 009 TC-3505 Transmission Cooler Line Kit Parts 12 $84.30 $1,011.60 Purchase 010 CR-2022-11 Warranty Chargeback — VIN ...F422091 Chargeback 1 ($1,240.00) ($1,240.00) Chargeback 011 HB-EXPL-24 Explorer Holdback — Q4 2024 Holdback 8 $890.00 $7,120.00 Holdback 012 CV-8814 CV Axle Shaft — Front LH Parts 8 $148.60 $1,188.80 Purchase 013 DC-FORD-1124 Dealer Cash Program — Nov 2024 Incentive 1 $8,500.00 $8,500.00 Dealer Cash 014 RB-4490 Rear Brake Pad Set Parts 30 $54.20 $1,626.00 Purchase 015 CR-2022-12 Warranty Chargeback — VIN ...K118843 Chargeback 1 ($890.00) ($890.00) Chargeback 016 AC-7712 AC Compressor — 2.7L EcoBoost Parts 4 $412.80 $1,651.20 Purchase 017 PDI-MAVE Maverick PDI Allowance — Nov Incentive 11 $275.00 $3,025.00 Incentive 018 SB-9901 Serpentine Belt — 3.5L V6 Parts 18 $38.40 $691.20 Purchase
GL Detail Template — SyntheticFord_GL_Template.xlsx · 8 accounts
Account # Account Name Type Normal Bal. Department Maps To
1200 Parts Inventory Asset Debit Parts Parts Purchases 2100 Accounts Payable — Ford Motor Liability Credit Accounting Parts Purchases 1410 OEM Receivables — Ford Asset Debit Accounting Holdback / Incentive 4800 Holdback Income Revenue Credit New Vehicle Holdback 4810 PDI Allowance Income Revenue Credit New Vehicle PDI Incentive 4820 Dealer Cash Income Revenue Credit New Vehicle Dealer Cash 6200 Warranty Expense — Chargebacks Expense Debit Service Chargeback 2110 Warranty Chargeback Payable Liability Credit Service Chargeback
Continue to Column Mapping →
✓ FactoryTraq auto-mapped 8 of 8 fields with high confidence
Ford Parts Statement — Field Mapping
Line Type Field Type Category Line_Type
Part / Program # Part Number Program_ID Item_Code
Amount Field Amount Net_Amount Total
Description Description Item_Desc Detail
GL Template — Account Mapping
Account # Field Account # Acct_Num GL_Code
Account Name Account Name Acct_Name Description
Normal Balance Normal Bal. Dr_Cr Balance_Type
Maps To (Category) Maps To Category_Tag Type_Tag
Journal Entry Preview — Auto-generated routing
Parts Purchases
DR 1200 Parts Inventory $11,817.36
CR 2100 AP — Ford Motor $11,817.36
Holdback + Incentives
DR 1410 OEM Receivables $50,261.00
CR 4800/4810/4820 $50,261.00
Warranty Chargebacks
DR 6200 Warranty Expense $2,130.00
CR 2110 Chargeback Payable $2,130.00
← Back
Export Journal Entry →
Categorizing line items by type...
0%
Journal Entry JE-2024-1130-01 — Parts Inventory Purchases
Nov 30, 2024 · Auto-generated · 11 lines
Line
Account
Description
Debit
Credit
001
1200 · Parts Inventory
Motorcraft Oil Filter × 144
$704.16
002
1200 · Parts Inventory
Air Filter 2.3L EcoBoost × 36
$662.40
003
1200 · Parts Inventory
Brake Fluid DOT-4 × 48
$441.60
004
1200 · Parts Inventory
Spark Plug Set 5.0L × 24
$1,490.40
005
1200 · Parts Inventory
Wiper Blade Set × 60
$1,350.00
006
1200 · Parts Inventory
Transmission Cooler Line × 12
$1,011.60
007
1200 · Parts Inventory
CV Axle Shaft Front LH × 8
$1,188.80
008
1200 · Parts Inventory
Rear Brake Pad Set × 30
$1,626.00
009
1200 · Parts Inventory
AC Compressor 2.7L EcoBoost × 4
$1,651.20
010
1200 · Parts Inventory
Serpentine Belt 3.5L V6 × 18
$691.20
011
2100 · AP — Ford Motor
Ford Parts Statement Nov 2024
$11,817.36
Total Debits: $11,817.36
Total Credits: $11,817.36
✓ Balanced
Journal Entry JE-2024-1130-02 — Factory Holdback & Incentive Receivables
Nov 30, 2024 · Auto-generated · 8 lines
Line
Account
Description
Debit
Credit
001
1410 · OEM Receivables — Ford
F-150 Holdback Q4 2024 × 22 units
$21,516.00
002
1410 · OEM Receivables — Ford
Explorer Holdback Q4 2024 × 8 units
$7,120.00
003
1410 · OEM Receivables — Ford
F-150 PDI Allowance Nov × 22 units
$7,700.00
004
1410 · OEM Receivables — Ford
Explorer PDI Allowance Nov × 8 units
$2,400.00
005
1410 · OEM Receivables — Ford
Maverick PDI Allowance Nov × 11 units
$3,025.00
006
4800 · Holdback Income
F-150 + Explorer Holdback Q4
$28,636.00
007
4810 · PDI Allowance Income
PDI — F-150 / Explorer / Maverick
$13,125.00
008
4820 · Dealer Cash Income
Ford Dealer Cash Program Nov 2024
$8,500.00
Total Debits: $50,261.00
Total Credits: $50,261.00
✓ Balanced
Journal Entry JE-2024-1130-03 — Warranty Chargebacks
Nov 30, 2024 · Auto-generated · Requires Review
Line
Account
Description
Debit
Credit
001
6200 · Warranty Expense — Chargebacks
Chargeback — VIN ...F422091
$1,240.00
002
6200 · Warranty Expense — Chargebacks
Chargeback — VIN ...K118843
$890.00
003
2110 · Warranty Chargeback Payable
Ford chargebacks — Nov 2024
$2,130.00
★ Review required:
Two chargebacks totaling $2,130.00 require service department confirmation before posting. Verify chargeback reason codes and technician documentation for VINs ...F422091 and ...K118843.
Total Debits: $2,130.00
Total Credits: $2,130.00
✓ Balanced
Statement Reconciliation Summary
Total Statement Amount
$94,218.40
Total JE Posted (3 entries)
$64,208.36
Chargebacks Pending Review
$2,130.00
↺ Run another demo
Live app exports JE file for direct DMS import
↓ Export to CDK (demo)
↓ Export Excel (demo)
↓ Export PDF (demo)