Source A — Bank Statement
Wells Fargo XXXX-XXXX
✓ 162 rows parsed · Nov 1–30, 2024
Source B — General Ledger
DMS Cash Account Export
📊
SyntheticAuto_GL_Nov24.xlsx
✓ 157 rows parsed · Nov 1–30, 2024
| Date | Description | Bank Amount | GL Amount | Variance | Status | Ref # |
|---|
| 11/01 | ACH — Parts supplier payment | ($4,210.00) | ($4,210.00) | — | Matched | CHK-10421 |
| 11/03 | Wire — Floorplan curtailment | ($38,500.00) | ($38,750.00) | $250.00 | Mismatch | WIR-8812 |
| 11/09 | Bank fee — Monthly service | ($45.00) | — | $45.00 | Bank Only | FEE-0091 |
| 11/15 | Check — Advertising vendor | — | ($1,200.00) | $1,200.00 | GL Only | CHK-10488 |
Open Exceptions
Bank shows $38,500.00 on 11/03. GL records $38,750.00. Verify against Wells Fargo floorplan statement.
$45.00 fee on 11/09 has no GL entry. Post to account 6010 — Bank Charges.