How to get line items from supplier PDF invoices into Excel without retyping them
Pull SKU, quantity, price and line totals out of text-based supplier PDFs, check the math, and export a spreadsheet — instead of typing every invoice in.
· 6 min read
This post answers
How do I get line items from supplier PDF invoices into Excel without typing them in by hand?
To get line items from supplier PDF invoices into Excel without typing them in, use a tool that reads the text inside the PDF and turns each invoice’s table into rows: one row per line item, with SKU, description, quantity, unit price and line total, plus the supplier, invoice number and date. Check the numbers before you export — quantity × unit price for each line, and that the lines add up to the invoice total. This only works directly on text-based PDFs, the kind your supplier’s system generates. Scanned paper invoices are images and need OCR first. InvoTumbra does the extraction and the checks for you, and exports a CSV that opens cleanly in Excel.
The problem: four hours of typing every week
A logistics business owner on r/smallbusiness described the problem plainly. They received around 50 supplier invoices a week as PDFs, and someone typed each one into Excel by hand — roughly four hours of work every week. They had looked at existing tools, but found them either too expensive or too complicated for what they needed.
If that sounds familiar, the goal is narrow: get the line items from a stack of PDFs into a spreadsheet, correctly, without retyping them.
Method 1: copy and paste (and why typos slip in)
The manual method most teams start with looks like this:
- Open the PDF next to your spreadsheet.
- Type or copy the header: supplier, invoice number, invoice date.
- Copy each line item. Selecting a table in a PDF and pasting it into Excel often lands the whole row in a single cell, or splits columns in the wrong places, so many people end up typing the numbers instead.
- Enter the totals and move on to the next invoice.
It works, but every number goes through a person’s hands, and that’s where the errors come from:
- Transposed digits — 169.20 typed as 196.20.
- A misplaced decimal — a $0.125 unit price entered as $1.25.
- A skipped or duplicated line when a description wraps onto two lines in the PDF.
- Mistakes in the supplier’s own invoice, which get copied faithfully into your spreadsheet.
You can catch a lot of this with a few Excel checks. Add a column with =C2*D2 (quantity × unit price) next to each line total and look for differences. Add =SUM(E2:E5) at the bottom and compare it with the invoice’s subtotal. That’s worth doing even if you keep typing by hand. But the typing still takes the time.
The example: three supplier invoices
To show the alternative, here are the three sample invoices InvoTumbra loads when you try it. They’re text-based PDFs, laid out the way real supplier systems produce them.
Northstar Industrial Supply — invoice NS-24817
| SKU | Description | Qty | Unit price | Amount |
|---|---|---|---|---|
| PAL-4840 | Wood pallet 48x40 heat treated | 40 | 12.50 | 500.00 |
| STR-1610 | Poly strapping 1/2in x 9000ft | 6 | 38.75 | 232.50 |
| WRP-80G | Stretch wrap 80 gauge 18in | 24 | 19.95 | 478.80 |
| LBL-4X6 | Thermal labels 4x6 roll of 500 | 10 | 8.40 | 84.00 |
Subtotal $1,295.30, sales tax $106.86, total due $1,402.16.
Ridgeway Fleet Parts — invoice RFP-7781
| Part No. | Description | Qty | UOM | Price | Total |
|---|---|---|---|---|---|
| BRK-2231 | Brake pad set, heavy duty | 4 | EA | $86.25 | $345.00 |
| FLT-0098 | Oil filter, diesel | 12 | EA | $14.10 | $169.20 |
| WPR-22 | Wiper blade 22in | 6 | EA | $9.75 | $60.50 |
| DEF-25 | Diesel exhaust fluid 2.5gal | 10 | EA | $11.40 | $114.00 |
Subtotal $688.70, tax $57.07, balance due $745.77.
Bayside Printing Co. — invoice BPC-1042. A quantity-first table with a sub-cent unit price ($0.125 per label), a description that wraps onto a second line, and no tax, for a total of $245.50.
Look closely at Ridgeway’s wiper blades: 6 × $9.75 is $58.50, not $60.50. The error is on the supplier’s invoice, and it’s carried into their subtotal and balance due. If you typed this invoice in by hand, you’d almost certainly copy the $60.50 faithfully.
Method 2: InvoTumbra
1. Upload the PDFs. Drop up to 20 PDFs at a time (20 MB each) onto the upload area. A file you’ve already uploaded is recognised and skipped, and anything that isn’t a PDF is rejected. Each invoice is read in the background, and the list updates as each one finishes.
2. Let it read each invoice. InvoTumbra reads the text in the PDF, keeping the table’s columns lined up, and picks out:
- The header: supplier name, invoice number, invoice date (never the due date), subtotal, tax and total.
- Every line item: SKU, description, quantity, unit price and line total.
It copes with the layouts in the samples: SKU or part-number columns, a unit-of-measure column like “EA”, a table with the quantity first, unit prices with more than two decimals, and descriptions that wrap onto a second line (Bayside’s banner line is joined back into one description). There’s no per-supplier template to set up. If it can’t find something, such as the invoice number or the line-item table, it says so on the invoice instead of leaving a blank you might not notice.
3. Review it next to the PDF. Open an invoice and you see the PDF on the left and the extracted header and line items on the right, all editable. You can fix a value, add a line or remove one. As you type, InvoTumbra checks three things:
- each line’s quantity × unit price equals its line total;
- the line totals add up to the subtotal (or to the total, less tax, when there’s no subtotal);
- subtotal + tax equals the total.
Northstar and Bayside pass every check and show as Ready to approve. Ridgeway is flagged with one issue, and its line is highlighted:
Line 3: 6 × $9.75 = $58.50, but the line total is $60.50.
The Approve button stays disabled until the numbers agree. What you do next is your call — it’s the supplier’s mistake, not a reading error. If you correct the line to $58.50, the next check appears straight away:
Line totals add up to $686.70, but the subtotal is $688.70.
Correct the subtotal to $686.70 and the total to $743.77, and every check passes. Or leave the invoice unapproved and query the overcharge with the supplier first. Either way, the error is caught before it reaches your spreadsheet.
4. Approve and export. Approved invoices are included in exports. You get one row per line item, with the supplier, invoice number, date and invoice totals repeated on each row, so you can filter and pivot in Excel straight away. Export for Excel writes a CSV that keeps part numbers like 00042 as text (Excel otherwise drops the leading zeros) and displays accented characters correctly. A plain CSV is also there for other tools, and you can export a single invoice or all approved ones.
Limits worth knowing
- Text-based PDFs only. Scanned or photographed invoices are images. Reading them needs OCR, which isn’t built yet, so InvoTumbra says “No text found” rather than guessing.
- Common layouts, not every layout. It’s built for the usual supplier invoice: a labelled header and a table with quantity and amount columns. Unusual layouts may need more corrections on the review screen.
- It checks the math, not the prices. InvoTumbra can tell you a line doesn’t add up. It can’t tell you whether $9.75 was the price you agreed.
- No accounting integration. The output is a CSV you open in Excel or import elsewhere.
How this compares with other tools
This is a crowded space, and the established tools are good at what they do. Document-parsing services such as Parseur and Docparser handle many kinds of documents beyond invoices, offer parsing rules or AI extraction, and connect to other apps for automation. If you process lots of different document types or need hands-off automation, they’re worth a look. Compare their current plans on their own sites. Open-source tools are another route if you’re comfortable with code: for example, invoice2data works from per-supplier templates, and Tabula extracts tables from PDFs. Some versions of Excel can also import a table straight from a PDF.
InvoTumbra doesn’t try to beat those tools at everything. It does one job — supplier invoice line items into a spreadsheet — with no templates to build, a review screen that puts the PDF and the numbers side by side, and math checks that stop an error like Ridgeway’s from slipping through.
Try it on your own invoices
You can load the three sample invoices with one click, find the Ridgeway error yourself, and then upload a week of real supplier PDFs. Start a 14-day free trial of InvoTumbra; after the trial it’s $39 a month.
Frequently asked questions
- Does InvoTumbra work with scanned paper invoices?
- Not yet. It reads PDFs that contain real text — the kind exported from a supplier's accounting or ERP system. A scanned or photographed invoice is just an image, and reading it needs OCR, which isn't built yet. InvoTumbra tells you when a PDF has no text instead of guessing.
- What happens if the supplier's invoice itself has a math error?
- The review screen flags it. Each line's quantity × unit price is compared with its line total, the line totals with the subtotal, and subtotal plus tax with the total. You decide what to do — fix the line, or query the supplier — and the invoice can't be approved until the numbers agree.
- Will Excel mangle part numbers like 00042?
- The "Export for Excel" option writes codes with leading zeros and long digit strings so Excel keeps them as text, and adds a byte-order mark so accented characters display correctly. There's also a plain CSV export for other tools.
- Do I need to set up a template for each supplier?
- No. InvoTumbra reads common invoice layouts — a table with quantity, price and amount columns, and labelled invoice number, date and totals — without per-supplier setup. If a field is missed or misread, you correct it on the review screen.