How to import a bank statement CSV into Xero
Build the Xero statement columns and import them on the bank account.
- 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
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
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
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.
- If Xero reports a date problem, the source dates were ambiguous. Set the date order and download the Xero file again.
Questions
Can I import a QBO file into Xero?
Use the Xero CSV. QBO is a QuickBooks Desktop Web Connect file.