I will extract data from PDF invoices to excel with python
Python Excel PDF Automation
About this Gig
Typing invoice data from PDFs into Excel by hand? Let a script do it accurately, in seconds.
I build Python tools that read your PDF invoices and produce a clean Excel file you can filter, sum and import into your accounting.
WHAT YOU GET
- Invoice number, dates, supplier, buyer, line items, subtotal, VAT and total
- Works with different supplier layouts and multi-page invoices
- Automatic checks: line items vs subtotal, subtotal + VAT vs total
- Duplicates and missing fields listed on an Issues sheet: nothing is skipped silently
- Excel output with Summary, Invoices and Line Items sheets
GOOD TO KNOW
Works with digital PDFs (where you can select the text). Scanned paper invoices need OCR: message me first and I'll check your files.
HOW IT WORKS
1. Send 3-5 sample invoices (you can black out sensitive data)
2. I build and test the extractor on them
3. You get the Excel result and, if you want, the reusable tool
Message me before ordering. I'll check your PDFs and confirm the package.
Technology:
Excel
•
Google Sheets
•
Python
•
PowerShell
My Portfolio
FAQ
Can you handle scanned invoices?
Scanned paper invoices need OCR. Send me a few samples first and I'll tell you whether the quality is good enough and what it would cost.
My suppliers all use different templates. Is that a problem?
No. The tool finds fields by their labels, not fixed positions, and new layouts can be added. Each package states how many layouts are included.
Can the result be imported into my accounting software?
Usually yes, as an Excel/CSV file in the format your software expects. Message me with the details.
Is my data safe?
Your files are used only for your order and deleted after delivery. You can black out sensitive data in the samples.

