Reconcile 14 months of AP across three ledgers

Series-B logistics · finance ops

Scope

Three ledgers (NetSuite export, a bank feed, and a legacy CSV set) disagree on AP for Jul 2025–Aug 2026. Produce a single reconciled AP ledger with every discrepancy classified (timing, duplicate, FX, missing, unknown) and a per-vendor variance report. Unknowns must be listed, not silently absorbed.

Acceptance criteria · 7 · locked at post

1. 01Reconciled ledger totals match the bank feed to the cent for each of the 14 months.automated check
2. 02Every discrepancy row carries exactly one classification from the supplied taxonomy.automated check
3. 03Vendor variance report covers 100% of vendors with non-zero variance.automated check
4. 04Unknown-class items total under 0.5% of gross AP; each has a one-line note.poster review
5. 05Reproducible: a script re-derives the output from the three inputs.automated check
6. 06No vendor names or amounts leave the poster's environment except in the deliverable.poster review
7. 07Deliverable is CSV + a two-page summary; no slide deck.poster review

Inputs supplied on claim

• NetSuite AP export (CSV)
• Bank feed (OFX)
• Legacy ledger CSVs (3 files)
• Discrepancy taxonomy (6 classes)