Invoice PDFs to Excel: line items, tax and totals that actually add up

 To get invoice PDFs into Excel in a form you can check, split each invoice into two kinds of rows: one row per invoice for the header and totals, and one row per line item for what was bought. Then run four checks on every invoice: quantity times unit price equals each line's amount, the lines add up to the subtotal, the subtotal plus tax and shipping equals the total, and the total less payments equals the amount due. Add a fifth for the tax rate, by hand.

Here are all of those checks on a fictional café's batch of invoices.

The batch

Linden Street Café is made up, and so are its suppliers. One week in September 2026 it receives a coffee invoice, a paper goods invoice and a repair invoice, scanned into one PDF.

Sheet 1: one row per line

Invoice Number	Vendor	Description	Quantity	Unit Price	Amount
3021	Harbor Roasting Co.	House blend, 5 lb	10	42.00	420.00
3021	Harbor Roasting Co.	Decaf, 5 lb	2	46.50	93.00
0458	Greenleaf Paper Goods	12 oz cups, case	8	38.90	311.20
0458	Greenleaf Paper Goods	Lids, case	4	21.40	85.60
0458	Greenleaf Paper Goods	Napkins, case	3	17.25	51.75
R-112	Cascade Refrigeration	Technician labor, hours	3.5	88.00	308.00
R-112	Cascade Refrigeration	Compressor relay	1	64.00	64.00

Every row carries its invoice number and vendor, so you can sum, filter or pivot without looking anything up.

Sheet 2: one row per invoice

Invoice	Vendor	Subtotal	Tax	Shipping	Total	Payments	Amount due
3021	Harbor Roasting Co.	513.00	0.00	22.00	535.00	0.00	535.00
0458	Greenleaf Paper Goods	448.55	29.16	0.00	477.71	0.00	477.71
R-112	Cascade Refrigeration	372.00	24.18	0.00	396.18	100.00	296.18
Batch		1,333.55	53.34	22.00	1,408.89	100.00	1,308.89

Check 1: does each line multiply out?

Quantity × unit price should equal the printed amount. 10 × 42.00 = 420.00, 8 × 38.90 = 311.20, 3.5 × 88.00 = 308.00, and so on down the sheet. In Excel, add a column with =D2*E2-F2 (D quantity, E unit price, F amount) and every row should show 0.00.

This is the check that catches a misread quantity. If the repair invoice's 3.5 hours came through as 3, the row would say 3 × 88.00 = 264.00 against a printed 308.00, and the 44.00 gap is exactly half an hour of labor.

Check 2: do the lines add up to the subtotal?

=SUMIF(A:A,"0458",F:F) on the line sheet should return 448.55, Greenleaf's printed subtotal: 311.20 + 85.60 + 51.75. Harbor's lines come to 513.00 and Cascade's to 372.00. A short line sheet, say a second page of an invoice that never got read, shows up here as a gap equal to the missing lines.

Check 3: does the subtotal reach the total?

Subtotal less any discount, plus tax and shipping, equals the total:

• Harbor: 513.00 + 0.00 + 22.00 = 535.00
• Greenleaf: 448.55 + 29.16 = 477.71
• Cascade: 372.00 + 24.18 = 396.18

For the batch, 1,333.55 + 53.34 + 22.00 = 1,408.89, which matches the three totals added together.

Check 4: does the amount due follow?

Cascade took a $100.00 deposit when it booked the repair, so its amount due is 396.18 - 100.00 = 296.18. The other two have no payments, so total and amount due match. Across the batch: 1,408.89 of invoices, 1,308.89 still to pay. If you only recorded totals, you'd pay Cascade the deposit twice.

Check 5: is the tax rate right?

Greenleaf charges 6.5%: 448.55 × 0.065 = 29.15575, which rounds to 29.16. Cascade's 372.00 × 0.065 = 24.18. Harbor prints no tax at all. Whether each of those is right for your state and your purchase is a question for your sales tax adviser, but the arithmetic is yours to check, and it's the check most people skip.

Two Excel traps

Leading zeros. Open a CSV and Excel turns invoice "0458" into 458, which then won't match anything. Format that column as text before you paste, or set it to text when you import the CSV.

Dates. Check whether the dates are month first or day first before you sort. 09/03/2026 is September 3 in one and 9 March in the other.

Our guide to invoice PDF to Excel has a second worked example, the full column list for both sheets and the Bills import layout.

Disclosure: I'm Damin and I run ZeraBooks, so weigh this part accordingly. ZeraBooks Convert reads invoice PDFs, scanned ones included, and downloads both sheets above, Invoices and Line Items, as its All details format, with the source file named on every invoice row. It runs checks 1 to 4 on every invoice before you download and marks any figure that doesn't add up. It doesn't check the tax rate, so check 5 stays with you, and invoices can't be edited in Convert: a misread means comparing with the PDF and uploading a clearer copy. In CSV, the two sheets arrive as two files in a ZIP. ZeraBooks doesn't post bills into accounting software or categorize them. It's part of the ZeraBooks subscription, 1,000 pages a month for $79 a month billed annually, with a 7-day trial. More on the bank statement converter page.

Run check 2 on your next batch, even by hand. It's where missing pages show up.