Solution

Invoices from PDF to Excel – line item rows, amount fields

Supplier invoices from any layout into one table: line items as rows, amounts and dates normalised – example with invoices from three countries.

By Christian Gerloff · Published August 30, 2026

In short: Tiro reads supplier invoices as PDF and returns them as a table: one row per line item with description, quantity, unit price, tax rate and amount; invoice number, date, due date, supplier, VAT ID, net/tax/gross, IBAN and payment reference as header fields. The layout does not matter – in the example 17 line items from three invoices from three countries (Germany 19 % VAT, UK 20 % with a zero-rated line, US 8.875 % sales tax) with three currencies and three date formats run into one table.

Below you see the three invoices and the values that come out of each.

How Tiro reads an invoice

Every supplier prints differently: the invoice number is called “Invoice no.”, “Rechnungs-Nr.” or just “#”, the date reads 15.07.2026, 21/07/2026 or 07/18/2026, amounts appear as 1.234,56 or $1,234.56, and the tax shows up as VAT, a VAT analysis per rate or sales tax under the subtotal. Layout tools therefore break every invoice differently – and whoever receives many invoices ends up typing after all.

Tiro works through the fields, not the layout: you define once which values you want and in what form – “date as ISO”, “line amount excluding tax”, “VAT ID empty if none is printed”. The AI reads every page as text and as image, finds the values in the given layout and returns them in exactly that form: real numbers, real dates, the same columns for every supplier.

What people typically pull out of invoices

  • Incoming invoices for bookkeeping – invoice number, amounts and due date as a table for pre-entry or the import into the accounting or ERP system.
  • Line items for matching – quantity and unit price per line checked against the purchase order and the delivery note before anything is paid.
  • Preparing payment runs – IBAN, payment reference, amount and due date per invoice as fields; the payment reconciliation afterwards is shown on the bank statements page.
  • Reporting across suppliers – spend by supplier, tax rate or line type, in the same columns across all layouts.

Why not a PDF converter or accounting OCR?

PDF-to-Excel converters copy the layout into cells: address blocks land next to the line item table, “1.680,00” becomes text, and every supplier yields different columns. Accounting OCR in turn is locked to fixed receipt fields for a posting workflow – custom columns such as an article number, a project code or the tax rate per line do not fit in. Parseur and Airparser solve invoices with fields, but return dates as text in the source format. With Tiro you define the fields yourself, and dates, amounts and tax rates arrive normalised – in the same columns for every invoice.

Example: from document to table

A fictional document, one inbox, one run in Tiro — shown unchanged. Company, people and figures are invented.

1. The documents (3 variants)

2. The extracted data

Header fields once per document, the table as one row per line item — dates as dates, numbers as numbers. The first rows are expanded, the rest follows behind.

Header fields
FieldGerman invoice (EUR)UK invoice (GBP)US invoice (USD)
Invoice numberRE-2026-1847301445501
Invoice dateJul 15, 2026Jul 21, 2026Jul 18, 2026
Due dateAug 14, 2026Aug 20, 2026Aug 17, 2026
SupplierFalkenrath Packaging GmbHBramley Roasting Supplies LtdBrightline Cafe Equipment Inc.
VAT IDDE318447129GB 493 8817 42
CurrencyEURGBPUSD
Net total3,934.12,546.710,371.5
Tax total747.48161.34907.6
Gross total4,681.582,708.0411,279.1
IBANDE44 3705 0198 0027 4411 82GB62 SGWB 4022 1971 4466 90
Payment referenceRE-2026-1847BRS 30144INV 5501
Line items (17)
SourceDescriptionQuantityUnit priceTax rateAmount
German invoice (EUR)Kraft paper coffee bag 500 g, flat bottom, valve punch, printed 2c "Lindqvist Espresso"4,0000.42191,680
German invoice (EUR)Kraft paper coffee bag 1 kg, flat bottom, valve punch, printed 2c1,5000.5819870
German invoice (EUR)One-way degassing valve V2, food grade5,5000.0919495
German invoice (EUR)Shipping carton 400 × 300 × 250 mm, double wall2501.1519287.5
German invoice (EUR)Label roll "Lindqvist Espresso" 80 × 50 mm, 1.000 labels/roll2418.919453.6
German invoice (EUR)Freight and transport packaging, DE parcel/pallet114819148
UK invoice (GBP)RB-40K Roaster drum bearing kit RS-40 (pair, incl. seals)218920378
UK invoice (GBP)AD-115 Airflow damper assembly, cast, for 15 kg drum roasters1246.520246.5
UK invoice (GBP)TC-K3 Thermocouple probe, K-type, 3 mm, bean temperature332.42097.2
UK invoice (GBP)GC-COL Green coffee — Colombia Excelso EP, 60 kg jute bag (zero-rated foodstuff)1017401,740
UK invoice (GBP)DEL-LDN Delivery, Leeds–London pallet service1852085
US invoice (USD)EM-VD2 Vela Due two-group espresso machine, volumetric, 220 V16,8508.8756,850
US invoice (USD)GR-K65 Kern 65 on-demand grinder, 65 mm flat burrs21,2408.8752,480
US invoice (USD)WF-310 Water filtration system incl. install kit and cartridge13898.875389
US invoice (USD)KB-SS Knock box, stainless steel, counter model342.58.875127.5
US invoice (USD)SV-INST Installation & calibration on site, per hour4958.875380
US invoice (USD)FR-CC Freight, common carrier (non-taxable)11450145
Show all 17 rowsShow fewer rows

3. What it looks like in Tiro

The result in the browser, right after the upload. From here it is one click to Excel or CSV.

The “Invoices” inbox in Tiro with the three processed invoices – Germany, UK and US – all with status “done”

How it works

  1. Create an inbox

    A name is enough, for example “Invoices”. On the first upload the AI proposes the fields – invoice number, dates, amounts and the line item table. You decide once what should apply, such as “leave the VAT ID empty if none is printed” or “line amount excluding tax”.

  2. Upload the invoices

    PDF invoices from your inbox or scanned paper invoices – one by one or as a batch, from as many suppliers as you like. You never say which supplier an invoice comes from or what its layout looks like.

  3. Download the table

    Every invoice yields the same column structure – one row per line item, header fields such as supplier, invoice number and due date repeated in every row. Excel or CSV, dates as dates, amounts as real numbers; the tables of all invoices stack directly underneath each other.

Frequently asked questions

How do I convert an invoice to Excel?

Upload the invoice PDF to an inbox, done – Tiro returns invoice number, dates, amounts and every line item as a table that you download as Excel or CSV. Unlike a converter, Tiro does not copy the layout but reads the fields; the table looks the same for every supplier.

Do I need a separate inbox for every supplier?

No. One inbox with one field definition covers all suppliers – in the example a German, a British and a US invoice run into the same table. The AI reads the fields from each layout, not from fixed positions; a new supplier needs no template and no training.

How does Tiro handle tax rates and tax-free lines?

The tax rate is a numeric column per line in the example: 19 for German VAT, 20 and 0 for the UK invoice with zero-rated green coffee, 8.875 for New York sales tax and 0 for the non-taxable freight line. Net, tax and gross also arrive as header fields – so Excel can immediately check whether lines and totals add up.

What happens if an invoice has no VAT ID or IBAN?

Then the field stays empty – as with the US invoice in the example, which prints ACH bank details instead of an IBAN and carries an EIN rather than a VAT ID. Tiro does not invent values and does not put the wrong number into the field either; the field instruction says so (“a US EIN is not a VAT ID”).

Are 1.234,56 € and $1,234.56 read correctly?

Yes. Amounts arrive as real numbers whether the invoice prints 1.234,56, 1,234.56 or $6,850.00; dates always arrive as ISO dates (2026-07-15) whether the invoice writes 15.07.2026, 21/07/2026 or 07/18/2026. In the example all 17 line items and all totals from three number and date formats are correct.

Does it work with scanned invoices and e-invoices (ZUGFeRD, XRechnung)?

Scanned or photographed invoices are read from the page image, without any OCR setting – details on the PDFs & scans page. A ZUGFeRD PDF can be uploaded; Tiro reads the visible invoice, not the embedded XML. Pure XML invoices (XRechnung without a PDF) are currently not accepted, and there is no e-mail intake either – invoices reach the inbox via upload or API.

Where are the invoices processed?

On servers in Germany; AI processing runs through AWS Bedrock in the EU region Frankfurt, with no training on your data. Retention is set per inbox – down to “delete right after export”.

What does it cost?

Getting started is free – 20 pages per month, no credit card. One page is one credit; the three one-page invoices in the example cost three credits. Paid plans differ only in the number of pages.