Skip to the converter
StatementZap

Guides

How to import a bank statement CSV into Xero

Build the Xero statement columns and import them on the bank account.

  1. 1

    Use Xero's columns

    Xero wants Date, Amount, Payee, Description, Reference, and Cheque Number. Amount is signed. Dates in the download are YYYY-MM-DD. Do not add a balance column to this file.

  2. 2

    Convert the statement

    Upload the bank or card export and choose the Xero download. A checking file keeps money in positive. A card file whose charges are positive needs the signs flipped first, or the matching bank preset.

  3. 3

    Import it in Xero

    Open the bank account, choose Manage account, then Import a Statement. Upload the CSV, confirm the column mapping Xero shows, and complete the import.

  4. 4

    Reconcile in Xero

    The import adds statement lines. Matching them to bills and invoices still happens in Xero. The file does not code the register for you.

Questions

Can I import a QBO file into Xero?

Use the Xero CSV. QBO is a QuickBooks Desktop Web Connect file.