I will extract data from pdf invoices and receipts into excel

Alcune informazioni sono riportate in lingua inglese.

Kazakistan

Parlo Russo, Inglese

Web Scraping, Spreadsheet Automation

QA engineer by day, five years of it — checking data against its source is literally my job. I build small automations that take repetitive work off your hands: • Web scraping — catalogs, listings, ...
Informazioni su questo servizio

Anyone can copy numbers out of a PDF. The question is whether they're right.


I extract your invoices, receipts or statements into one Excel workbook and then I check the arithmetic:


Every line recomputed from quantity x unit price and compared to the printed amount

All lines summed against the stated subtotal

Subtotal plus tax re-derived and compared to the total due

Ambiguous dates reported, not guessed 10/04 is flagged, not silently assumed


What you get back:

Summary how many documents, how many passed, totals by currency

One row per document: vendor, number, date, currency, subtotal, tax, total

Every line item, with a recalculated amount next to the printed one

A review sheet listing anything that didn't add up, and which file it came from


On my last batch of 8 invoices this caught two where the line items didn't match the stated total, by 118.40 and 246.90. Retyped by hand, those go straight into the accounts.


I'm a QA engineer by day verifying numbers against their source is my actual job.


FREE sample: send one PDF and I'll extract it for you before you order, so you see the result first.

Tecnologia:

Excel

Fogli Google

Python

Expertise:

Acquisizione dati

Estrazione dati

Manipolazione dati

Il mio portfolio