How to Extract Invoice Data From Hundreds of Vendor Formats (2026)

October 12, 2026

To extract data from invoices with hundreds of different vendor formats, use a template-free AI tool like Lido. You specify the fields you need once, and Lido finds them on every vendor's invoice, in any layout, and puts them in the same spreadsheet columns.

In this tutorial, we will walk you through extracting invoice data using a sample invoice, then cover the invoice formats that break most extraction tools.

How to Extract Data From Invoices With Different Vendor Formats

Lido is the best way to extract data from invoices with different vendor formats because it reads each invoice the way a person would, so you never build or maintain a template for each vendor.

Step 1: Log Into Lido

Before you start, make sure you have your invoices saved as PDFs, images, or scanned copies.

If you don't have a Lido account yet, you can create one for free here.

Once you're logged in, create a New File.

Lido Files page with the New file button

Step 2: Click Extract Data

Select the Extract Data button at the top of the sheet.

Extract Data button in a new Lido sheet

Step 3: Upload Your Invoices

Upload your invoices by dragging and dropping them into Lido, or click to browse. You can upload up to 100 invoices at a time, even if every invoice comes from a different vendor.

For the purpose of this tutorial, we will be using a sample invoice from a design agency. It has five line items, a discount, a deposit, and both a Total and a Balance Due, which are the details that usually trip up extraction tools.

Extract Data upload window in Lido

Step 4: Specify the Invoice Fields You Need

Enter the columns you want to extract: Vendor, Invoice Number, Invoice Date, Description, Quantity, Unit Price, Amount, and Balance Due. Use specific names like "Balance Due" instead of "Amount Owed" so Lido knows exactly which value to pick.

Next, add extra instructions to handle the details that vary between vendors. For this invoice, we used: "Extract each line item as a separate row. Vendor is the company that issued the invoice, not the Bill To company. Description is the item name only. Format dates as MM/DD/YYYY and amounts as plain numbers. Balance Due is the amount still owed after any deposit."

Keep Extract Multiple Rows per Document checked so each line item gets its own row. Once done, click Process All Files.

Invoice columns and extra instructions in Lido Extract Data

Step 5: Review the Extracted Invoice Data

Review the extracted data to make sure everything looks correct. Lido returned all five line items, and the vendor, invoice number, and date repeat on every row so you can filter and sort them.

Notice that Lido returned a Balance Due of 4801, not the subtotal of 7,387 or the total of 6,801, because the instructions told it to subtract the deposit. A quick way to check any invoice is to add up the Amount column: here it comes to 7,387, which matches the subtotal on the invoice.

Invoice line items extracted into rows in Lido

Step 6: Export to Excel

Once you're done, click Export to Excel to download your invoice data as a spreadsheet file. Google Sheets users can follow a similar path when pulling invoice data into a spreadsheet.

Export to Excel button in Lido

Step 7: Use the Same Setup for Every Vendor

Upload invoices from your other vendors with the same columns and instructions. You don't need a new template or any training, because Lido reads each layout on its own and fills in the same columns.

To skip uploads, connect your AP email inbox, a Google Drive folder, or a OneDrive folder in the Extract Data window. Lido then extracts every new invoice as it arrives, and our guide to extracting invoice data from email shows the full setup.

{"headline": "Extract data from any vendor's invoice.", "subtext": "50 free pages. No credit card required. No templates to build."}

Why Templates Break With Hundreds of Invoice Formats

Most invoice extraction tools need to know what an invoice looks like before they can read it. That works for a handful of vendors, but every new vendor adds setup work, and every redesigned invoice breaks something.

There are three common ways tools handle different invoice formats:

Template or rule-based OCR: You draw boxes or write rules that tell the tool where each field sits on the page. Each vendor needs its own template, and when a vendor moves its invoice number, the template breaks. Traditional OCR data extraction tools work this way.

Trained machine learning models: You label sample invoices so a model learns each layout. This handles more variety than templates, but accuracy drops when layouts change until someone labels new samples and retrains the model.

Template-free AI: You describe the fields once, and the AI reads each invoice in context, the way a person would. New vendors and changed layouts need no setup.

Teams often move through all three. Esprigas switched from a rule-based tool to a trained model before moving to Lido, and now processes 27,000 documents a month from hundreds of suppliers without a single template.

How to Handle Invoice Formats That Break Extraction

Most of the work in multi-vendor invoice extraction comes from a few tricky formats. In Lido, each one is handled with a short instruction instead of a new template.

Several totals on one invoice: Invoices often show a subtotal, total, deposit, and balance due. Tell Lido which one you want, such as "Invoice Total is the amount after discounts and tax, before any payments."

Vendor name variations: The same supplier might appear as "Cobalt Lane" on one invoice and "Cobalt Lane Creative Studio LLC" on the next. Upload your vendor list with + Context Doc and ask Lido to match each vendor to the closest name on the list.

Different date formats: A UK vendor writes 05/10/2026 for October 5. Add an instruction like "Dates from UK and EU vendors are day first" and pick one output format for every invoice.

Line items across several pages: Long invoices continue their line item table on page two, often with a repeated header. Lido reads all pages by default, and you can tell it to skip repeated headers and page subtotals. Our guide to line item extraction from invoices covers more examples.

Nested or grouped line items: Some vendors group items under category headings. Add a Category column and tell Lido to repeat the category on each item row instead of creating a row for the heading.

Scanned, dot matrix, and handwritten invoices: Lido's AI reads skewed scans, faded dot matrix printouts, and handwriting without any extra setup. Erewhon uses Lido to process about 20,000 invoices a month from thousands of vendors, including dot matrix invoices from older suppliers. See how Lido handles scanned PDFs for more detail.

What to Test Before Choosing an Invoice Extraction Tool

Before you pick an invoice extraction tool, run a trial on your own invoices instead of the vendor's demo files. These four checks show quickly whether a tool can handle hundreds of formats:

Start with your hardest invoices. Use scans, multi-page invoices, and nested tables. Clean digital PDFs don't tell you much.

Try a layout the tool has never seen. Upload an invoice from a new vendor with no setup and check whether the results are right the first time.

Count the setup per vendor. Add up the templates, rules, or training samples your full vendor list would need. The setup count often shows which OCR tools for vendor invoices can scale to a long vendor list.

Check the cost of fixing mistakes. Find out whether you pay again to reprocess an invoice after changing an instruction. Lido lets you reprocess for free within 24 hours.

For a side by side look at the options, see our list of the best OCR software for invoice processing.

Now that you know how to extract data from invoices with different vendor formats, you can add new vendors without building a single template.

Frequently asked questions

What is the best way to extract data from invoices with different formats?

Use a template-free AI tool like Lido. You specify the fields once, and Lido extracts them from any vendor's invoice into the same columns without templates or training.

Can Lido extract line items from invoices?

Yes. Keep Extract Multiple Rows per Document checked, and Lido puts each line item in its own row with the invoice details repeated on every row.

What happens when a vendor changes its invoice layout?

Nothing breaks in Lido. Lido reads each invoice fresh instead of relying on a saved template, so a moved field or a redesigned table is found the same way.

Can Lido read scanned or handwritten invoices?

Yes. Lido extracts data from scanned, faxed, dot matrix, and handwritten invoices as well as digital PDFs.

Can Lido extract invoices automatically as they arrive?

Yes. Connect an email inbox, a Google Drive folder, or a OneDrive folder, and Lido extracts each new invoice into your spreadsheet with the same columns.

Ready to grow your business with document automation, not headcount?

Join hundreds of teams growing faster by automating the busywork with Lido.