Xero does not let you import a PDF. Your bank sends statements as PDFs, Xero wants a bank feed or a structured file, and in between sits the job nobody enjoys: getting the transactions out of the PDF and into a format Xero will actually read. That format is CSV. This guide walks through converting a PDF statement to a clean CSV, laying out the columns Xero expects, and importing it without the errors that send most people back to retyping.
The converter at the top of this page outputs CSV directly, so once you know what Xero needs you can produce it in one step. Everything below is about getting that file right the first time.
Can you import a PDF into Xero?
No, Xero cannot import a PDF bank statement directly. Xero imports transactions through a live bank feed or from a structured file, and it accepts CSV, OFX, QIF, and a few bank-specific formats, but not PDF. A PDF is a fixed page layout, not a table of data, so there are no columns for Xero to map. To get a PDF statement into Xero you first have to convert it to one of those structured files, and CSV is the most universal and the easiest to fix if a column is off.
How do I convert a PDF bank statement to CSV for Xero?
Upload the statement PDF to a converter, let it pull the transaction table, check that the date, description, and amount columns are right in the preview, then download the CSV. The key is that the converter reads the real table rather than dumping the page into one column, because Xero needs separate fields it can map. Open the resulting PDF to CSV file, confirm the columns line up, and you are ready to map it in Xero's import screen. If the statement is a scan rather than a digital export, you need a converter with OCR, since a scanned page is an image with no text to read.
What format does Xero need for a CSV import?
Xero needs a CSV with, at minimum, a date column and an amount column, plus optional columns for payee, description, reference, and check number. The amount can be one signed column where money out is negative, or two separate columns for spent and received. The most common failure point is the date: Xero asks you to tell it which date format the file uses during import, so the dates in your CSV must all follow one consistent pattern. Keep the header row simple, one row per transaction, and no blank rows or running balances mixed in.
A clean export looks like this: a Date column, a Description or Payee column, and an Amount column with negatives for debits. That is exactly the shape a good converter produces, so you spend your time mapping fields rather than rebuilding them.
Why is my CSV not importing into Xero?
The usual culprits are the date format, stray characters in the amount, or extra rows. If Xero rejects the file or posts the wrong figures, check three things first: that every date matches the format you selected at import, that amounts have no currency symbols or thousands commas wedged inside the value, and that there are no summary or balance rows breaking up the transaction list. A dollar amount written as 1,250.00 can split across two columns because the comma is read as a field separator, which is why a converter that writes numbers plain saves you the cleanup.
If the columns themselves are misaligned, the problem started in the conversion, not in Xero. That is the sign the PDF text was pasted into one column instead of read as a table. Re-converting with a tool that detects the table structure fixes it at the source.
How do I import transactions into Xero from a CSV?
In Xero, go to the bank account, choose to import a statement, upload your CSV, then map your columns to Xero's fields and pick the date format. Xero shows a preview of how it read the file so you can catch a mismapped column before anything posts. Confirm the date, amount, and payee land in the right place, then complete the import and reconcile as usual. Because you checked the CSV before uploading, this step is mostly clicking through, not troubleshooting.
Map carefully on the first statement from a given bank. Once you know that bank's layout converts cleanly, every later statement from the same account follows the same mapping, so the routine gets faster each month.
Does Xero accept PDF bank statements at all?
Only as a manual reference, not as importable data. You can attach a PDF statement to a Xero record for your files, but Xero will not read transactions out of it. For actual data entry you need a bank feed where the bank supports one, or a structured file you import yourself. When a feed is not available, or it stops part way through and leaves a gap, converting the PDF to CSV is the reliable fallback that gets the missing transactions in.
Can I convert a PDF to CSV for Xero for free?
You can convert your first file at no cost to see whether the output is clean enough for your statements, which is the honest way to test any converter before you rely on it. Beyond that, regular monthly closes and higher volumes are where a paid plan earns its keep, because the time saved on a stack of statements dwarfs the cost. The thing to judge is accuracy, not price: a CSV that imports without manual fixes is worth far more than a free one that lands everything in a single column.
The short version
Xero reads a clean CSV, not a PDF, so the whole task is producing a CSV with a consistent date column, plain amounts, and one row per transaction. Convert the statement with a tool that reads the real table and runs OCR on scans, check the columns in the preview, then map and import in Xero. If your books are in QuickBooks instead, the same clean export drops into a CSV to QBO converter to build a bank-feed file, and for statement-specific tips see converting bank statements to spreadsheets. To start, upload your statement to the PDF to CSV converter at the top of this page, or if a person rather than Xero will work in the file, convert to Excel instead.