I will extract invoice and PDF data to excel with validation and an audit report
Python Data Automation, PDF and Invoice Extraction, APIs, Excel
About this Gig
Stop retyping supplier bills. Send me your PDFs and I return clean, checked data you can import straight into your accounting system.
What you get:
- Excel workbook: documents, line items, exceptions and a field-by-field audit trail
- CSV ready for import (QuickBooks, Xero, SAP or your own layout)
- A short PDF report: what is ready to post, what needs a look, and why
Every document is checked, not just copied:
- net + tax = total
- line items add up
- due date after issue date
- duplicate documents and duplicate files
- e-invoice XML (Factur-X, ZUGFeRD, XRechnung) compared with the printed page
Works with English, German, French, Dutch, Spanish and Italian layouts. Mixed vendors in one batch are fine.
Tested on 98 real public documents: 93.5% of fields correct on a hold-out set the extractor never saw during development. Anything uncertain is flagged for you, not guessed.
Scanned PDFs or photos: send a sample first, they are quoted separately.
Send me 2 or 3 sample files before you order and I will confirm what can be extracted.
Technology:
Excel
•
Google Sheets
•
Python
My Portfolio
FAQ
Which files do you accept?
PDF invoices with selectable text work best. Scans and photos are possible; send a sample first so I can check the quality.
Can one batch have different vendors and layouts?
Yes. Fields are found by their labels and position on the page, so a new vendor does not need a new template.
How do I know the numbers are right?
Each invoice goes through the checks listed above. Anything that fails lands on an Exceptions sheet with the reason, so you only review those.
Can you match my accounting import format?
Yes. Send your import template (QuickBooks, Xero, SAP or a CSV layout) and I map the columns to it. Included in Premium.
Do I get the source code?
Standard and Premium include the script used for your batch, so you can rerun it on new invoices of the same kind. Basic delivers the data and files only.
What happens to my files?
They are processed on my own machine, not shared with anyone, and deleted after delivery if you ask.

