Concept demo · fictional bookkeeping firm

142 vendor invoices → one clean spreadsheet and a spend dashboard

A bookkeeping client had a year of supplier PDFs in 9 different layouts. The Python pipeline extracts every line, normalizes dates, amounts and vendor names, removes duplicates and checks totals against each invoice, then outputs a CSV for QuickBooks and the dashboard below.

1. Extractpdfplumber, 9 layouts—
2. Normalizedates, $, vendor names—
3. Validateline sums vs totals, dupes—
4. OutputCSV + dashboard—

Three of the nine layouts plus a re-sent copy: dates as "03/07/25", "7 Mar 2025" and "2025-03-07"; amounts with and without currency signs; one vendor spelled four ways; a re-sent invoice that would double-count.

Monthly spend all vendors

Spend by vendor click to filter

Spend by category share of total

Invoice #DateVendorCategorySubtotalTaxTotalSource