How to Add an Account and Import Its Data into Xero

Written By

In this Xero tutorial, I’ll show you how to add a bank account to Xero. And then, how to import your data into that account using a CSV file.

Quick Instructions:

  1. Click Accounting -> Bank Accounts in the main menu
  2. Click the + Add Bank Account button.
  3. Select your bank from the list
  4. Click the Skip button on the page Connect Accounts page
  5. Enter account details then click the Continue button
    1. Account Name
    2. Account Type
    3. Account Number
  6. From the Bank accounts list click the “Import a bank statement to get started” link in your new account
  7. Browse to your downloaded bank account data file then click the green Import button
  8. Assign categories to imported fields then click the green Save button
  9. Click the OK button in the Import Results pop-up

Keep reading for full instructions with screenshots.

Add a Bank Account

To add a bank account to Xero click on Accounting in the main menu. Then select Bank Accounts. 

Navigating to the Bank Accounts option in the main menu of Xero

On the next screen click the Add Bank Account button.

Add Bank Account button in Xero

Select the name of your bank from the list. For this example, I’ll be adding a Chase bank account.

Select your bank when adding a bank account to Xero.

You’ll have the option to connect your bank account. In this example, I’m going to skip this step so I can show you how to import your data using a CSV file.

Skip connect your bank account in Xero

Enter a name for your bank account, the account type, and account number. Then click the blue Save button.

Enter your bank account details when adding a new bank account to Xero

Import a CSV File

You’ll now see your newly added bank account in your list of accounts.

New bank account in accounts list in Xero

The account shows “No transactions imported.” To import your data click on the “Import bank statement to get started” link.

On the Import Bank Transactions screen you have the option to import an OFX, QIF, or CSV file. You’ll need to have this file already downloaded from your bank account. Browse to the file on your computer and then click the green Import button.

Importing bank transactions into Xero

At the top of the screen in the green box, it shows you an example of how the data will look once imported into Xero.

Below that, on the left, it shows the lines it imported from your file and suggests what categories to map them to. You can make changes to these by clicking the drop-down menus. Then selecting a different category. 

Mapping imported data to categories in Xero

In my example below it did a good job assigning the correct categories.

On the right, the green checkmarks show data that will import. The red warning symbols are showing me categories that won’t import because I don’t have them in my file.

If you’d like, you can click on the Previous and Next arrows where it says “Statement line 1 of X.”

This will move through each line you’ve imported. So you can double-check everything will import correctly.

Reviewing statement lines when importing data into a bank account in Xero.

When your finished click the green Save button. A pop-up will appear letting you know everything imported. Click the blue OK button.

You can now view your imported bank account data. 

Bank account data imported into Xero

The imported transactions will be ready to reconcile. Click here for instructions on reconciling your Xero bank account.

If you try importing a CSV file and it doesn’t import correctly you may need to use Xero’s CSV template. 

You can find a link for this template on the Import Bank Transactions page.

Xero's CSV template download link.

You now know how to add a bank account to Xero and import its data using a CSV file. If you have any questions about adding bank accounts in Xero please ask them in the comments.

If you’d like to watch me walk through this process check out the video below:

Need some one on one Xero assistance?
Share Now
Share on facebook
Share on twitter
Share on linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

How to Reconcile Your Account in Xero – Part 2, Cash Coding

This is the second part of a Xero training on reconciling your account. In this part, you'll learn how to use the Cash Coding method.