Review and Upload Bank Statements
Review and Upload Bank Statements
Embedded Files
This section covers the essential pre-reconciliation process of importing your bank data into Xero, where you will learn to manually upload bank statements, review and correct imported transactions, and ensure data accuracy before starting reconciliation to guarantee clean and reliable data for efficient matching.
Uploading a Bank Statement
(If your bank doesn’t provide a live feed into Xero, you can upload bank statements manually)
Uploading a Bank Statement
(If your bank doesn’t provide a live feed into Xero, you can upload bank statements manually)
Step 1 of 5: Go to Accounting > Bank accounts
Step 2 of 5: Next to the relevant bank account, click the Manage Account button, then select Import a Statement.
Step 3 of 5: after you select Import a Statement, then choose the file to upload. Xero supports formats such as OFX, QIF, QBO, or CSV.
📌 For CSV files:
Ensure the file includes at least these columns: Date, Amount (use positive for deposits, negative for withdrawals), and Payee/Description.
Format dates as DD/MM/YYYY or MM/DD/YYYY based on your Xero settings.
Avoid including headings, totals, or blank rows.
Step 4 of 5: Review the imported transactions. Use the Clear any transactions you do not wish to import.
Step 5 of 5:
Navigate to the bank account to view all transactions.
[1] indicates the data source (e.g., bank feed, manual import, or reconciled transaction).
[2] shows the reconciliation status (e.g., Reconciled, Not Reconciled, or Deleted).
Click Bank Statements [3] to review the imported statement lines.
View Bank Statement lines
View Bank Statement lines
Xero displays each statement line with its reconciliation status. To manage these lines:
Select [1] a duplicate line and click Delete to remove it (this changes the statement balance in Xero).
If deleted by mistake, select it again and click Restore.
Click the current view [2] and select Statements [3] to see all imported statements.
Managing Duplicate Statements
To remove a statement imported in error, click on it [1].
Select Delete Entire Statement from the bottom of the list.
Choose to delete any transactions reconciled from that statement.
⚠️ Note: Deleted bank statements cannot be restored.
Page updated
Report abuse