Total Vendors
1,119
unique across 3 stores
GL Accounts
2,720
chart of accounts entries
Active Stores
2
Grand Coulee + Pullman
Data Sources
3
Yooz + DealerTrack + CDK
Pipeline Architecture
Ingest
PDF invoices from email
Split
Multi-page → single invoices
Extract
Azure Doc Intelligence
Match
Vendor + GL fuzzy match
Code
Auto-code or human review
Export
DealerTrack TSV
Vendor Coverage by Store
Grand CouleeJE1548
OmakJFOarchived486
PullmanJE2353
228 vendors shared across stores1,387 total entries
GL Account Source Comparison — JE1
553
In Both
312
Yooz Only
11
DT Only
DealerTrack GLB — 564 accounts with types + balances
Yooz COA — 865 accounts with names only
Gap — No JE2 GLB on FTP. Yooz is only source (847 accts)
DealerTrack Account Classification — JE1 (564 accounts)
Expense239
COGS103
Sale/Revenue112
Asset57
Liability45
Equity4
Other Expense4
Canonical Data Source Matrix
| Data | Grand Coulee (JE1) | Pullman (JE2) | Omak (JFO) |
|---|---|---|---|
| GL Accounts | DealerTrack | Yooz | Yooz |
| Vendors | Yooz | Yooz | Yooz |
| Account Types | DealerTrack | — | — |
| Balances | DealerTrack | — | — |
Dataverse Seeding Status
jess_vendorready1,387
Yooz export parsed, CSV ready
jess_glaccountready2,720
DT (JE1) + Yooz (JE2/JFO) merged
jess_invoicepending—
Awaiting first pipeline run
jess_invoicelinepending—
Created from extraction output
jess_invoiceauditpending—
Auto-populated on status transitions
jess_vendoraliaspending—
Built during vendor matching