Import PDF Bank Statements into Xero with pdftoxlsx (2026)

1. Your bank doesn't support Xero bank feeds. Xero uses Yodlee and Plaid for automatic bank feeds, but many regional banks, credit unions, and international institutions are not supported. PDF statements may be the only export your bank provides.

2. Historical reconciliation. You need to import 6–24 months of old statements for tax preparation, audit response, or catching up on bookkeeping. Xero bank feeds typically cover only the last 90 days — older data must come from PDF statements.

3. Closed accounts. When a bank account is closed, the automatic feed is disconnected. If you still need to reconcile those transactions, PDF statements are your only source.

4. Client bookkeeping. Accountants and bookkeepers frequently receive PDF bank statements from clients who cannot or will not set up bank feeds. Converting those PDFs to importable CSV files is a daily task for many accounting practices.

5. Bank feed interruptions. Xero bank feeds occasionally disconnect due to bank security changes, API updates, or Yodlee/Plaid outages. During downtime, importing CSV statements from pdftoxlsx keeps your reconciliation on track without waiting for the feed to reconnect.

6. Audit trail requirements. Some firms prefer to import from downloaded statements rather than live feeds for compliance and audit trail purposes — the PDF serves as the source document that ties to the imported transactions.

Step 1: Upload your PDF to pdftoxlsx. Go to pdftoxlsx.com, drag-and-drop your PDF bank statement. pdftoxlsx auto-detects your bank from 100+ supported templates and extracts transactions with 99% accuracy. No configuration needed.

Step 2: Download the CSV file. pdftoxlsx outputs a clean CSV with columns: Date, Amount, Payee, Description, and Reference. For Xero import, use CSV format — Xero does not accept Excel (.xlsx) directly for statement imports. You can also batch-convert up to 12 statements at once.

Step 3: Check the date format. Xero requires dates in DD/MM/YYYY format for most regions (UK, AU, NZ) or MM/DD/YYYY for US-based organisations. pdftoxlsx outputs dates in a consistent format. If needed, adjust the date column to match your Xero organisation's regional setting before import.

Step 4: Import into Xero. In Xero, go to Dashboard > Bank accounts > click the bank account > Manage Account > Import a Statement. Select your CSV file, confirm the column mapping (Date, Amount, Description/Payee), and click Import.

Step 5: Review and reconcile. Xero shows imported transactions in the bank account's reconciliation screen. Match each transaction to an existing invoice, bill, or create a new transaction. Xero's bank rules will auto-suggest categories for recurring transactions.

Step 6: Complete reconciliation. Once all transactions are matched or categorized, verify the closing balance on your Xero bank account matches the closing balance on your PDF statement. Xero highlights any discrepancies automatically.

Xero Starter (formerly Early) — supports CSV import, but limited to 20 invoices and 5 bills per month. Bank reconciliation and statement import are fully available. Suitable for freelancers and sole traders with simple banking needs.

Xero Standard (formerly Growing) — unlimited invoices and bills. Full bank reconciliation with CSV import. Supports bulk reconciliation. This is the most popular plan for small businesses.

Xero Premium (formerly Established) — includes multi-currency support, which is critical if you're importing statements with foreign currency transactions. Also includes expense claims and project tracking.

Xero Ultimate — all Premium features plus Xero Analytics Plus for cash flow forecasting and business snapshots. CSV import works identically to other plans.

Key note on multi-currency: If your bank statements include transactions in multiple currencies, you need Xero Premium or Ultimate. Multi-currency is not available on Starter or Standard plans. pdftoxlsx automatically separates transactions by currency, so you can import each currency's transactions into the matching Xero bank account.

Date — maps to Xero's "Date" field. Xero expects DD/MM/YYYY for UK, AU, NZ organisations or MM/DD/YYYY for US organisations. pdftoxlsx outputs consistent date formats; adjust to match your Xero region setting if needed.

Amount — maps to Xero's "Amount" field. Xero accepts a single Amount column (negative for money out, positive for money in) or separate "Debit" and "Credit" columns. pdftoxlsx supports both formats.

Payee — maps to Xero's "Payee" field. This is the merchant or counterparty name. pdftoxlsx extracts payee names from bank statement descriptions where available.

Description — maps to Xero's "Description" or "Particulars" field. pdftoxlsx preserves full transaction descriptions including multi-line details as a single cell.

Reference — maps to Xero's "Reference" or "Cheque Number" field. Useful for matching transactions to specific invoices or bills in Xero. pdftoxlsx extracts reference numbers when present in the bank statement.

For Xero CSV import, the minimum required columns are Date and Amount. Adding Payee and Description significantly improves reconciliation speed because Xero can suggest matches and apply bank rules based on these fields.

Tip: Xero's import wizard lets you preview the data before confirming. Always check the first few rows to ensure dates are parsed correctly and amounts have the right sign (positive = money in, negative = money out).

Date format gotchas. Xero's date parsing depends on your organisation's country setting. A date like "03/04/2026" is March 4 in the US but April 3 in the UK/AU. Always verify that your CSV dates match your Xero region. pdftoxlsx outputs unambiguous dates, but if you're importing statements from a foreign bank into a Xero organisation with a different locale, double-check the date column.

Xero bank rules for auto-categorization. After your first import, set up bank rules in Xero to auto-categorize recurring transactions. Go to Settings > Bank Rules > Create Rule. For example, create a rule that categorizes all transactions containing "AWS" as "Cloud Hosting" expense. Bank rules save significant time on subsequent imports and reconciliation.

Multi-currency handling. If your bank statement includes transactions in multiple currencies, pdftoxlsx separates them automatically. Import each currency's transactions into the corresponding Xero bank account. You must have a bank account set up in Xero for each currency. Multi-currency requires Xero Premium or Ultimate plan.

Bank feeds vs manual import. Xero bank feeds (via Yodlee/Plaid) are convenient for ongoing reconciliation. Use them when your bank is supported. Use pdftoxlsx + CSV import when: your bank isn't supported by Yodlee/Plaid, you're importing historical data older than 90 days, the bank account is closed, or you're importing statements on behalf of a client.

Duplicate prevention. Xero detects potential duplicate transactions during import by checking dates and amounts. If you see a "possible duplicate" warning, review carefully before confirming. To avoid duplicates: import non-overlapping date ranges, and don't import a period that your bank feed has already covered.

Reconciliation strategy. Import one month at a time and reconcile before importing the next month. This makes it easier to spot errors — if the closing balance doesn't match the statement, you only have one month to review.

Use Xero bank feeds when: your bank supports direct connection via Yodlee or Plaid, you're doing ongoing month-to-month bookkeeping, you want automatic daily transaction downloads, and you don't need to import historical data older than 90 days.

Use pdftoxlsx + Xero CSV import when: your bank is not supported by Yodlee or Plaid (many regional and international banks), you need to import historical statements older than 90 days, you're catching up on months of unreconciled bookkeeping, the bank account is closed and no longer connected, you're an accountant importing client statements, you need an audit trail tied to specific PDF source documents, or the bank feed is experiencing downtime or has disconnected.

Many users combine both approaches: bank feeds for current-month transactions and pdftoxlsx for historical catch-up, closed accounts, or statements from banks without feed support. The two methods work seamlessly together in Xero — imported transactions and bank feed transactions appear in the same bank account register and can be reconciled together.

Cost comparison: Xero bank feeds are included in your Xero subscription at no extra cost. pdftoxlsx offers the first conversion free, then subscription plans for regular use. For users who only occasionally need to import PDFs (e.g., once a year for historical catch-up), pdftoxlsx's free tier may be sufficient.

1. CSV format requirements. Xero accepts CSV files encoded in UTF-8. The file must use commas as delimiters (not semicolons, which some European exports use). If your CSV uses semicolons, open it in a text editor and replace semicolons with commas, or re-export from pdftoxlsx with comma delimiter. Xero also does not accept headers with special characters — pdftoxlsx outputs clean headers by default.

2. Date format gotchas. The most common import error in Xero is date format mismatch. If your Xero organisation is set to UK/AU (DD/MM/YYYY) but your CSV has US dates (MM/DD/YYYY), transactions will be assigned wrong dates — and you may not notice until reconciliation fails. Always verify the first transaction's date against the original PDF after import.

3. Duplicate detection in Xero. Xero's duplicate detection compares dates and amounts but not descriptions. This means two different transactions with the same date and amount (e.g., two coffee purchases on the same day) may be flagged as duplicates. Review these carefully — they may be legitimate. Conversely, if you import the same file twice, Xero will create duplicate entries for transactions it doesn't flag.

4. Multi-currency edge cases. Statements from international banks (HSBC, Citi, Revolut) may mix multiple currencies on one statement. pdftoxlsx separates these automatically. In Xero, each bank account can only hold one currency. Create separate bank accounts for each currency (e.g., "HSBC USD", "HSBC EUR") and import each currency's CSV into the matching account. Multi-currency requires Xero Premium or Ultimate.

5. Xero bank rules after import. Bank rules in Xero work on imported transactions the same way they work on bank feed transactions. After your first import, create rules for recurring payees to speed up future reconciliation. Rules can set the account code, tax rate, tracking categories, and contact automatically.

6. Reconciliation workflow. After importing, go to the bank account and click "Reconcile." Xero shows each imported transaction alongside suggested matches from your invoices and bills. For transactions with no match, create a new "Spend Money" or "Receive Money" entry. Use the "Transfer" option for inter-account movements. Complete all items to achieve a matched closing balance.