Settlement-PDF-to-ERP Converter

Every concert produces a settlement document showing what sold, the venue's cut, sales tax, card fees, and cash. To get those into the accounting system, an accountant opened each PDF, read it, and hand-keyed ~18 fields into an import spreadsheet, formatting each row for the specific deal type (who sold, who kept the tax), one PDF at a time across nightly shows. Card/fee/cash totals had to be looked up separately.

Defined the settlement workflow around the numbers accounting actually needs: deal type, taxes, cash, fees, venue share, artist payout, and ERP-ready row formatting. The resulting system turns uploaded settlement PDFs into structured import files and includes a balancing check so discrepancies are visible before the numbers are booked.

Four settlement deal types became structured conversion flows. Roughly 18 fields are extracted from each settlement, and the balance check flags shortfalls above a defined threshold before import. The workflow changes settlement processing from manual PDF reading and spreadsheet formatting into a guided review-and-import process.