How to Record Bank Statements in Xero (2026 Guide)

Quick answer

Bank data reaches Xero two ways: a direct bank feed that delivers statement lines automatically each business day, or a manual import of an OFX, QFX, QIF, or CSV file from Accounting, then Bank accounts, then Import a Statement. Feeds are the default; imports fill history from before the feed started, cover gaps, and serve banks without feed support. Either way, the arriving statement lines are what you reconcile transactions against.

Feeds first, imports for the rest

A connected feed removes the most error-prone step in bookkeeping, so activating feeds is job one on any new Xero organisation. Imports remain necessary in four situations: history predating the feed (feeds are not retroactive), gaps where a feed paused after a bank security change, accounts at banks with no feed coverage, and one-off accounts like a term deposit you only touch quarterly. The practical discipline is the same in all four: establish the date where Xero’s record ends, import from exactly there, and verify the closing balance in Xero matches the bank statement after the import.

Doing a manual import

1. Download the transactions from online banking, choosing OFX if offered. OFX needs no editing and its transaction IDs let Xero skip lines it already has.
2. If only CSV is available, download Xero’s CSV template from the import screen and map the bank’s columns into it: date, amount, payee, description, reference. One amount column with negatives for money out, or separate debit and credit columns, both work if mapped correctly.
3. In Accounting, then Bank accounts, open the account menu and choose Import a Statement, then upload the file.
4. Check the preview: date format parsed correctly (day-month versus month-day mistakes invert half the dates), amounts signed correctly.
5. Import, then compare the statement balance in Xero to the actual bank balance on the end date. Agreement here is the whole point of the exercise.

After the lines arrive: reconciliation

Statement lines are raw material. Reconciliation is where each line gets matched to an invoice payment, a bill payment, a transfer, or coded as spend or receive money. Feed lines and imported lines reconcile identically, and the guides for the two big flows are recording customer payments and recording supplier bills. Bank rules speed up recurring codings (the monthly bank fee, the fuel card debit), but reserve them for genuinely fixed patterns; a rule that codes every deposit from a marketplace to sales revenue will eventually swallow a refund. The reconciled state feeds the month-end close: an account is only closed when every line is reconciled and the balances agree.

Foreign currency accounts

A bank account held in another currency imports and feeds in that currency, and Xero revalues its balance at each rate change. Statement lines in the account’s currency reconcile against invoices and bills in any currency, with Xero computing the gain or loss. The mechanics belong to the foreign currency guide; the statement-side rule is simply that the file you import must be denominated in the account’s own currency.

Common mistakes

• Importing CSV with the wrong date convention, scattering transactions across wrong months; always check the preview.
• Overlapping CSV date ranges creating duplicate lines that inflate both money in and money out until deleted.
• Trusting that the feed captured everything; periodic balance checks against the bank’s own statement are what catch silent feed gaps.
• Deleting statement lines to force a reconciliation to balance; a line that will not reconcile is information, not noise.
• Treating Xero’s statement lines as the archive and discarding the bank’s PDFs, which are the documents auditors accept.

Software that helps

• Direct bank feeds in Xero remove manual statement handling for supported banks and stay the single biggest time saver.
• ExpenseFlow works the other side of reconciliation: it turns receipts and supplier invoices into coded, approved transactions in Xero, so when statement lines arrive there is something accurate to match them against.
• Statement conversion tools turn PDF-only statements into importable CSV or OFX when a bank offers nothing better.

Related guides

Reconciliation flows are detailed in customer payments and supplier bills; the closing discipline is in end of month in Xero. Glossary: bank reconciliation.