Xero is one of the most widely used cloud accounting platforms for small businesses and accounting firms, serving over 4 million subscribers globally. Unlike QuickBooks, which has native bank import in the Banking section, Xero's bank statement import has a few specific requirements — particularly around date formatting — that catch many users off guard. This guide walks through the entire process, from PDF to reconciled Xero bank account.
Xero's CSV Format Requirements
Xero accepts CSV files for bank statement import with the following specifications:
| Column | Required? | Notes |
|---|---|---|
| Date | Required | Must match your Xero organization's date format setting (DD/MM/YYYY or MM/DD/YYYY). This is the #1 source of import errors. |
| Amount | Required | Single column with negative values for debits (money out) and positive for credits (money in). OR use separate Debit and Credit columns. |
| Description | Required | Transaction description / memo. Xero uses this for bank rules matching. |
| Reference | Optional | Check number or transaction reference. Maps to Xero's Reference field. |
| Payee | Optional | Merchant or payee name if separate from description. |
File constraints:
- Maximum file size: 500KB
- Maximum transactions per import: 5,000 rows
- File must be saved as .csv (not .xlsx or .ods)
- First row should be a header row (Xero uses this to identify columns)
- No blank rows between transactions
The Critical Date Format Setting
The single most common reason Xero bank imports fail — or produce wrong dates — is a mismatch between the date format in your CSV and the date format configured in your Xero organization settings.
How to Check Your Xero Date Format
- In Xero, go to Settings (top right gear icon) → General Settings.
- Look for "Date Format" in the Organisation Settings section. It will show either DD/MM/YYYY (used in Australia, UK, and many international orgs) or MM/DD/YYYY (common for US orgs).
- Note this format. Your CSV dates must match it exactly.
How to Reformat CSV Dates in Excel
If your CSV dates don't match Xero's format, use this Excel formula to reformat them:
-- Convert from MM/DD/YYYY to DD/MM/YYYY -- =TEXT(DATEVALUE(A2),"DD/MM/YYYY") -- Convert from DD/MM/YYYY to MM/DD/YYYY -- =TEXT(DATEVALUE(A2),"MM/DD/YYYY") -- If Excel stored the date as text (won't DATEVALUE correctly) -- =TEXT(DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)),"MM/DD/YYYY")
Copy the reformatted dates, paste them over the original date column (use Paste Special → Values Only), then save as CSV before importing to Xero.
Step 1: Convert Your Bank Statement PDF to CSV
- Download your bank statement PDF. Log in to your bank portal and download the monthly PDF statement. For password-protected PDFs, unlock them first.
- Go to bankstatementtocsvfile.com and upload your PDF.
- Download the CSV. The converter produces a CSV with Date, Description, Amount, and Balance columns. This is your starting point for Xero import.
Step 2: Format Your CSV for Xero
- Open the CSV in Excel.
- Check the date format and reformat if needed to match your Xero setting (see the date format section above).
- Verify the Amount column. Xero expects negative amounts for debits (money out) and positive for credits (money in). The converter from bankstatementtocsvfile.com uses this convention by default — verify a debit transaction shows a negative number.
- Remove the Balance column if present. Xero's import doesn't use a balance column — it calculates the running balance itself. Remove it to avoid confusing Xero's column mapper.
- Ensure the header row is present. The first row should be: Date,Description,Amount (or Date,Description,Debit,Credit if using separate columns).
- Save as CSV. File → Save As → CSV (Comma delimited). Not .xlsx.
Step 3: Import into Xero
- In Xero, go to Accounting → Bank Accounts. If you don't have a bank account set up in Xero yet, add it first: click "Add Bank Account" and enter your bank name and account details.
- Click on your bank account. This opens the bank account's transaction view.
- Click "Import Statement." This button is typically in the top-right area of the bank account view, next to "Get Bank Feed." If you don't see it, look under the "Manage Account" dropdown.
- Upload your formatted CSV. Click "Select file" and choose your CSV. Xero will process the file and show a column mapping screen.
- Verify column mapping. Xero auto-detects columns based on header names. Check that Date → Date, Description → Description, Amount → Amount (or Debit/Credit appropriately). Adjust if Xero misidentified any column.
- Review the transaction preview. Xero shows the first few transactions. Verify dates look correct (not swapped month/day), amounts have the right signs, and descriptions are readable.
- Click "Import." Xero imports the transactions and shows a confirmation: X statement lines imported.
Common Import Errors and Fixes
| Error | Cause | Fix |
|---|---|---|
| "Date format does not match organisation settings" | CSV dates in wrong format | Check Settings → General Settings for your org's date format. Reformat CSV dates using Excel's TEXT formula. |
| "File is too large" | CSV exceeds 500KB or 5,000 rows | Split the file into two uploads covering different date ranges. |
| All transactions show as positive (no debits) | Amount column only has absolute values | Add negative signs to withdrawal/debit amounts. In Excel: if column C shows debit amounts separately, use =IF(C2>0,C2*-1,D2) to combine into a signed column. |
| Duplicate transactions appear | Overlapping date ranges imported | Check statement lines, delete duplicates. Avoid overlapping date ranges on future imports. |
| "Could not parse the file" | File saved as .xlsx not .csv | Re-save as CSV (Comma delimited) in Excel before uploading. |
Step 4: Reconcile with Find & Match
After importing, Xero moves all imported statement lines into the Reconcile queue for that bank account. The reconciliation workflow uses two primary actions:
Find & Match
Xero searches your existing transactions (entered invoices, bills, expense claims, manual journal entries) for a match to the imported bank statement line. When Xero finds a match by amount and approximate date, it surfaces it as a suggested match. Review and click OK to confirm the match and reconcile both the statement line and the Xero transaction.
Create & Match
For bank statement lines that have no existing Xero transaction (a direct expense not previously entered, a fee not yet recorded), Create & Match creates a new Xero transaction on the spot — you specify the account code and contact, and Xero creates and reconciles in one step.
Xero Bank Feed vs CSV Import: When to Use Each
| Scenario | Bank Feed | CSV Import |
|---|---|---|
| Current month's transactions | Preferred | Works too |
| Historical transactions (3+ months ago) | Usually not available | Yes |
| Bank not supported by Xero's feed | Not available | Yes |
| New business setup (catching up 12 months) | Not available | Yes |
| Credit union or small regional bank | Often not available | Yes |
| Explicit control over what enters Xero | Always on (auto-imports) | Manual control |
Convert Your Bank Statement PDF for Xero Import
Get a clean CSV with the right format for Xero import in 30 seconds. Free, no signup, handles all major US banks.
Convert Bank Statement for Xero →Frequently Asked Questions
What CSV format does Xero require for bank statement import?
Xero requires at minimum: Date (matching your org's date format), Amount (negative for debits), and Description. Optional: Reference and Payee. Max 500KB or 5,000 transactions per file. Must be saved as .csv not .xlsx. The #1 requirement to get right is date format — check your Xero org settings first.
What is the most common Xero bank import error?
Date format mismatch. If your Xero organization is set to DD/MM/YYYY and your CSV has MM/DD/YYYY dates (or vice versa), the import will fail or post transactions with wrong dates. Fix: go to Settings → General Settings in Xero to check your date format, then reformat your CSV dates using =TEXT(DATEVALUE(A2),"DD/MM/YYYY") in Excel before saving and re-uploading.
What is the difference between Xero bank feed and CSV import?
Xero bank feed (via Plaid) automatically pulls new transactions daily — no manual import needed. CSV import is manual: you download, convert, and upload. Bank feeds are best for current transactions at supported banks. CSV import is better for historical statements (bank feeds typically go back 90 days), unsupported banks, and when you want manual control over what enters Xero.
Can I import OFX or QBO instead of CSV into Xero?
Yes. Xero accepts CSV, OFX, QIF, and QBO file formats for bank statement import. OFX and QBO often include more transaction metadata than CSV. If your bank offers an OFX download, that can give a slightly cleaner Xero import. However, bankstatementtocsvfile.com's CSV output is formatted to work reliably with Xero for all major US bank formats.
What is Xero's Find & Match vs Create & Match?
Find & Match searches Xero for an existing transaction (invoice, bill, manual entry) matching the bank statement line by amount and date — you approve the match to reconcile. Create & Match creates a new Xero transaction directly from the bank statement line (you specify the account code) and reconciles it simultaneously. Find & Match is for transactions already in Xero. Create & Match is for new expenses or income not yet recorded.
How do I handle duplicate transactions in Xero?
Xero warns about potential duplicates during import but may not catch all of them. After import, go to Accounting → Bank Accounts → your account → Statement Lines, filter for the relevant date range, and check for duplicates. To delete a statement line, click it and select Delete. Prevent duplicates by never importing overlapping date ranges — always note the exact date range of each import.