fullstack_logo

Bank Feeds in Xero: Automating Data Entry

Bank Feeds in Xero

Bank feeds in Xero? The program can connect to a variety of different accounts including credit cards, bank accounts and PayPal. Getting data from the source cuts the data entry load. Connecting is easy and ensures your data is accurate.

    One of the things that you’ll need to do is setup bank feeds in Xero. The banks and other financial bodies will feed data directly into Xero. This is your one stop guide to getting that to happen. Currently, you can add/connect several different facilities including:

  • Bank accounts
  • Credit card
  • Loan
  • PayPal
  • Stripe – although no direct integration exists at this stage

To add an account, go to Accounting – Bank Accounts then click Add Bank Account. You need your bank account details to fill in the below (using ANZ as an example):

After the initial link is made, there may be different follow on steps depending on your bank.

1. Logging in to your online banking portal

You may be taken to the option below and be prompted to Login & Connect the accounts which will redirect you to your providers online banking portal.

Connect Accounts

2. Bank feed application form

Some providers require you to fill out an Authority to Disclose Information form before you can connect your banks feeds in Xero. This form will need to be completed then submitted back to the bank before the accounts can be connected. This is an extra security measure. Just click the Download item button to access this.

3. Connect the bank

This option requires you to enter the details you use to access your online banking. Xero will connect the feed within a few hours rather than a few days with the two previous options. Just enter your User ID and Password. This method bypasses the security of the bank feed authority and is hosted by an authorised third party called Yodlee.

Connect with Bank

You will then need to enter in the opening balance for your bank or credit card account. If for instance you had $1,000 in the bank when the feed was setup, that is what you would enter.

Once the bank feeds in Xero are setup, you may notice there is a gap between when the account was opened and when the bank feeds started. For this you will need to import the statement manually which you should be able to download from your online banking account in CSV format. In Xero you can then select the bank account, click Manage Account and under Reconcile select Import a Statement. You will then be taken to the following screen where you can select Browse and find the statement.

import bank transactions

More help with Xero

Interested in more than the bank feeds in Xero? We have a lot of articles to help you work with Xero:

If you need more, contact Fullstack for expert advice.

Was this article helpful?

illustration-Stuart-1
Stuart Reynolds is the founder of Fullstack Advisory, an award-winning accounting firm for businesses leading the future. He is a 3rd generation accountant who specialises in tech & online companies.

Share this Article

Find out more.

Need accounting
help?

Request a consultation and speak to one of our business accountants & advisors. Get clear next steps for your project.

Connect with us

Ask Us a Question?

Reach out to us about any of the topics in this article.

CONTACT US

Speak to our experts

Other ways to get in touch with us.


Your Privacy

Privacy

We will never share your details with any third-party.

This form collects your name contact number and email address so that we can contact with you and provide a quote for our services. Please check our Privacy policy to see how we protect and manage your submitted data.

HEAD OFFICE

Sydney

Suite 63, 388 George St, Sydney NSW 2000

BY APPOINTMENT

Melbourne

120 Spencer St Melbourne VIC 3000

BY APPOINTMENT

Brisbane

310 Edward St Brisbane QLD 4000