How to Import a bank Statement into Xero.

If your bank feed is not supported by Xero, there is an option to bring in your bank feeds manually through a CSV import. You would need to log into your online banking, download your statement in comma-delimited (CSV) format. Once you have your bank statement ready, follow these steps to upload your transactions:

1) From the Dashboard, select the bank account you want to import a statement into. Click “Manage Account” button (top right), click “Import a Statement”:

2) Download the Bank statement import template file. Even though your bank statement is already in CSV format, you may need to manipulate the data to fit a pre-designed Xero template before importing.

There are two mandatory columns that need to be in the file: Date and Amount. You can also have additional columns such as Payee, Description, Reference, and Check Number.

3) Copy the data you would like to import into the downloaded template

You may be importing an entire statement or just a few lines, depending on the situation. Once you enter all the information from your bank statement, save the file, and make sure it is still in CSV format.

4) To import the file you created, click on “Browse” and select the CSV file you just saved, then click “Import”:

5) Xero will display a message saying how many lines were imported, and you can find the transactions under the “Reconcile” tab.

Knowing how to import your bank transactions manually can be very helpful when troubleshooting and correcting bank feed errors.

By | 2019-03-19T06:06:23+00:00 March 18th, 2019|Accounting & Bookkeeping|0 Comments