Invoice Data Extraction to Excel
Freelancer.com
- IT & Development
- Op afstand
- Remote
- Freelance
This job comes from an external source. xFreelance is not a party to it and cannot guarantee it is still current.
Description
I have a collection of text-selectable PDF invoices that need to be converted into a structured Excel workbook. Each invoice must have its own worksheet, named after the invoice number. Inside every sheet I expect the full header (number, date, supplier, total) followed by a table of every line item, complete with descriptions, quantities, unit prices, taxes, and line totals—nothing skipped.
Because the PDFs are already text-based, no OCR is necessary; copy-paste, scripted parsing, Power Query, VBA, or Python are all acceptable so long as the result opens flawlessly in Excel 2016 or later. Accuracy is critical: figures, currency symbols, and tax percentages have to match the source exactly, and any field you cannot match must be clearly highlighted.
Deliverables:
• One .xlsx file containing a separate, consistently formatted worksheet for each invoice
• Any scripts or macros used so the process can be repeated on future batches
I’ll provide the first 50 invoices once we settle on timing. Let me know your proposed turnaround and the method you plan to use.
Budget: INR 750–1250
This job is 100% remote.
Skills
- Excel
- Data Analysis
- Visual Basic
- Data Processing
- Data Management
- Python
- Data Extraction
- Automation
Interested in this job?
Create a free account to open the original job on Freelancer.com.
Create account