Netmend · Guides · Import a PDF bank statement into Xero
Xero can import a bank statement as CSV, and it also documents a PDF bank-statement import. Start with those official tools. Convert the PDF yourself when Xero will not accept the file, or when you want to tick every total before the lines land in the account.
Defaults are a starting point. Change the number format to match the PDF. The file never leaves your computer.
No file at hand? (fictional data)
Check the totals against the original PDF before you use the file. If a column is in the wrong place, try “Every text row”, or send it to us.
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.
Xero Central documents two relevant articles: Import a bank statement in CSV format and Import a PDF bank statement. If your organisation offers the PDF import for that account and it accepts your file, use it — there is no reason to convert a statement Xero already reads. When the PDF import is not offered, or it rejects the layout, prepare a CSV and import that instead (Accounting → Bank accounts → the account → Import a statement, then map the columns and review the lines).
A live bank feed is still the better everyday path. Several banks in our bank guides already offer an official CSV or XLS for recent activity (for example Starling feed exports, bunq CSV, ABN AMRO XLS for 18 months, Commerzbank Umsatz CSV). Use those when they cover the dates. Convert a PDF when they do not.
On the official CSV import you map columns on screen. In practice the file that goes through cleanly has:
Treat the mapping screen and Xero’s current article as the authority if a heading has changed. The usual failures are mixed date formats, a European decimal comma in a file Xero is reading as US, or a “balance” column imported as if it were an amount — that last mistake posts the running total as a transaction.
The tool below runs in your browser. Choose a European or UK/US number format to match the statement. Then:
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.
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.
75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.
Need it done for you? From $20Your 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.
Sometimes. Xero Central has an official article “Import a PDF bank statement”. Try that first. If it is not available or the file is rejected, convert the PDF to a CSV and use the official CSV import.
For the usual single-amount CSV, money in is positive and money out is negative. Do not also import a running-balance column as an amount.
The statement is probably day-first and the import was told it is month-first, or the other way around. Pick one format for the whole file and say it on the mapping screen.
Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services