Netmend

Netmend · Guides · Convert PDF invoices to Excel for Xero

Convert PDF invoices to Excel for Xero

Xero will not turn a supplier’s PDF into a bill for you. It will import a CSV of invoices or bills if you use its template, and it will import a bank statement as a different file. This page keeps those jobs apart, then shows how to get line items out of a text-based PDF.

Free tool in your browserNo accountFrom $20 if you want it done

Convert a PDF now

This converter is built for tables. Use it on a digital invoice or receipt with a real text layer. Switch to “Every text row” if the first preview looks short.

No file at hand? (fictional data)

How it stays private: the page uses the open-source pdf.js library (Mozilla) to read the file locally. There is no server and no upload. You can disconnect from the internet after the page loads and it still works.

Three different Xero files

A live bank feed remains the cleaner way to get ongoing payments into Xero. Use a file import when you are catching up, when the feed does not cover the period, or when you have a pile of PDF invoices and no bills on the system yet.

From a PDF invoice to a Xero-ready sheet

The converter below runs in your browser and never uploads the file. It is the same tool we use for bank-statement tables. It is useful when the invoice is a digital PDF with a clear line-item table. It is a poor fit for a photographed receipt or a designed invoice where the totals sit in a graphic. Use “Every text row” if a description wraps and the first preview looks short.

  1. Extract the PDF to CSV with the tool, or type the lines if the layout is too awkward.
  2. Copy the rows into Xero’s official invoice or bill template, one row per line item, with the invoice number repeated, a contact name that exists (or will be created) in Xero, and tax types and account codes your organisation already uses.
  3. Tick each invoice total against the original PDF. Then import in Xero and fix any rows the import report rejects — usually a missing contact, a tax type that does not exist, or a date format mixed between 03/04 and 04/03.

Sources (checked 13/11/2026). Official product help is linked in the text. Menus and templates change: treat the current screen in QuickBooks, Xero or your bank as the authority.

Need it done for you? From $20

The free tool is for a clean, text-based PDF. For scans, password files, a packed year of documents or a layout that has to match QuickBooks or Xero, we convert them and check the totals against each document.

Done-for-you conversion
$20 / 20 pages

75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.

Need it done for you? From $20
Privacy

Your file is processed only for the order and deleted after delivery. This page itself never uploads the file.

Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. No address, phone or national ID is asked for or published.

FAQ

Can Xero import a PDF invoice?

Xero has an official PDF import for some bank statements, documented in Central. Supplier invoices and customer invoices are imported as CSV from Xero’s own templates, not by dropping a PDF bill into the bank import.

What is the difference between a bill import and a bank import?

A bill is the supplier document you owe. A bank import is money that already left or entered the account. Raise or import the bill, then match the bank line to it. Do not import the same amount as both.

Why did Xero reject my dates?

Mixed day-first and month-first dates in the same column are the usual cause. Pick one format, say it on the import screen, and stick to it for every row.

Related guides

Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services