Xero statement import guide

How to Import Bank Statement Transactions into Xero from PDF or CSV

Prefer a complete bank-provided OFX or CSV when it covers the required account, period, and fields. If only a PDF is available, check whether your Xero organisation is eligible for direct PDF import, or prepare a reviewed CSV from a PDF conversion. ExtractMint's CSV is a general review export, not a Xero-specific template or direct connection.

Choose the source before converting

Check your bank's export options and select the required period. A complete bank download avoids extracting transactions from PDF layout. Xero recommends OFX over PDF when available. Check a bank CSV against the statement before using it: the account, currency, period, dates, and transaction direction still matter.

If the bank export lacks the required period or fields, compare the PDF options below. Keep one account per import file and check for overlap with transactions already recorded through an earlier import or bank feed.

Can Xero import a PDF directly?

As checked on October 29, 2026, Xero documents direct PDF import only for organisations in Canada and the United States, excludes the Xero Ledger plan, and requires a PDF without password protection. Other file and access requirements apply. Eligibility may change; check Xero's PDF import instructions for your organisation before choosing this route.

If the route is available, follow Xero's instructions and review its transaction preview against the original statement. If it is unavailable or the PDF cannot be used, a reviewed CSV is another preparation route; conversion alone does not establish that Xero will accept it.

Prepare a separate CSV import copy

Review the PDF conversion in ExtractMint first. Compare every extracted transaction with the source, including rows at page breaks, wrapped descriptions, references, and amount direction. Resolve warnings and confirm the date convention before exporting. Preserve the original 16-column CSV for review and traceability, then prepare a separate copy containing the transaction fields needed for import.

ExtractMint exports a signed Amount: it uses the row amount when present, otherwise deposit minus withdrawal minus tax. Check that value against each source transaction; do not subtract Tax again or import Withdrawal and Deposit as additional transactions.

Xero requires Date and Amount; income is positive and expenses negative. Its CSV guidance accepts a leading minus or parentheses for negative amounts. See Xero's CSV import instructions, since its steps and requirements can change.

CSV fields and Xero mapping
ExtractMint fieldXero mapping or handling
DateMap to Transaction Date after confirming the date convention.
AmountMap to Transaction Amount. Check positive money in and negative money out.
DescriptionOptionally map to Description after checking the extracted text.
ReferenceOptionally map to Reference; preserve meaningful leading zeros as text.

These are preparation suggestions based on the documented fields. ExtractMint has not been verified as a Xero integration, and its CSV is not Xero's own template. Use the template and instructions available in your Xero account if needed; file acceptance and account eligibility are not guaranteed here.

Which extra columns should be left out?

Keep these fields in the full review export, but leave them out of the separate import copy: Withdrawal, Deposit, Tax, Balance, Review Status, Review Notes, Category, Confidence, Source, Source Lines, Statement Warnings, and Date Format. Read the warnings before removing those columns from the copy. The signed Amount is the transaction value for this mapping; the other amount and balance columns are review context.

Xero instructs users to remove opening/closing balance columns, bank account numbers, and empty rows. Also remove unrelated empty columns and non-transaction summary rows from the import copy. Do not turn an opening or closing balance into a transaction. Keep those figures separately for balance checks.

A synthetic import-copy example

These invented rows show a four-column preparation example, not a tested Xero import file. All amounts are in one example currency. DD/MM/YYYY has been confirmed for this fictional statement.

Invented transaction rows with DD/MM/YYYY dates
DateAmountDescriptionReference
14/05/2026-84.25Fernlight paper orderFERN-014
16/05/2026240.00Amber Desk project receiptAMBR-016
18/05/2026-12.50Account service chargeFEE-018

The invented net change is +143.25: 240.00 − 84.25 − 12.50. An invented opening balance of 700.00 would give a closing balance of 843.25. Retain those balances for review, outside the import copy. A matching total does not prove every row or date is correct.

Review dates, mapping, and duplicates in Xero

  1. Confirm the destination bank account, currency, and period. Compare with existing statement lines and bank-feed coverage before uploading.
  2. Confirm the date convention from the source. In this example, 14/05/2026 is 14 May. Check the first, last, and ambiguous dates after any spreadsheet edits; do not guess from a date such as 05/06/2026 alone.
  3. Use the relevant account's statement-import option in Xero. Inspect the field mapping, including any previously saved mapping, and confirm the chosen date format. Compare money-in and money-out signs with the source.
  4. Review Xero's import preview row by row, including warnings, errors, row count, and duplicate candidates. Xero documents detection of matching transactions already in Xero; also check repeated rows in your file and overlapping periods yourself. Do not remove a legitimate repeated payment just because its amount matches another.
  5. Correct unexpected dates, amounts, or mappings before completing the import. Compare the resulting statement lines with the source and complete your normal reconciliation review afterward.

The preview is a review step, not evidence that ExtractMint has a tested Xero connection.

Limits, related guides, and privacy

ExtractMint is in beta. Extraction and OCR can omit or misread rows, and no bank-specific format has been independently validated against real statements. Review each row and the balance trail. Neither a successful conversion nor a matching closing balance guarantees an acceptable accounting import.

Core conversion and OCR run in your browser. Optional Ask ExtractMint sends your question and selected document context to an endpoint and, when configured, an AI provider; site analytics have a separate data flow. Uploading an import file to Xero sends that file to Xero. Read the privacy and data-flow details before processing or sharing sensitive material.

Open the converter to review a statement.