News

Setting Up Automatic Bank Feeds In Xero

Many accountants and businesses now use Xero instead of MYOB.

In our last post we talked about the developments that have occurred over the last few years in the accounting software space; one of which was the introduction of Xero to the marketplace. Since then, a huge number of accountants and businesses have switched to Xero.

Xero has quickly gained momentum in the accounting software space, and while it’s important for bookkeepers to be skilled in MYOB, it’s becoming increasingly important that they’re also skilled in Xero as well.

Upskilling to Xero

We developed a Xero training course for bookkeepers who’d like to add another skill to their CV, or for business owners looking for an alternative to MYOB. Like MYOB, you can add bank feeds to your Xero package, something that  is very popular because it saves you time and money.

Here, Xero Certified Advisor, Jacci Quinlivan, talks us through setting up the bank feeds function in Xero:

“Automatic Bank Feeds are becoming increasingly common and if you are using Xero, it has never been so easy to automate them and make your data processing even easier.

When you are initially setting up your bank account details in Xero, the program will automatically tell you if your bank has the availability to get live data feeds (most banks are Xero partners these days). This involves pre-populating a form with your bank account information and sending it off to Xero’s bank feeds department (a scanned, emailed copy does usually suffice).  The turnaround time from when you email or post the form usually takes between 7-10 working days.

You will receive an email from Xero once this has been completed and your data feeds will automatically sync with your bank. There is now no more uploading manual bank statements and the like from the new processed date. If your accounts aren’t quite in sync there may be a variety of things to check from the accuracy of your opening balances, or maybe you had missed a few transactions when you were manually importing them.

If you need to go back with your data feeds you may need to do this manually as a once off until you reach your current live bank feed date. This will involve you obtaining your banking history in a CSV format (OFX and QIF is fine), ensuring the columns are in the correct format and uploading to your Xero AIS. This may seem daunting, especially if you have hundreds or even thousands of transactions to reconcile, but by using the “cash coding” tab within your program, this can be done much quicker than imagined.”

***

We cover setting up bank feeds along with many other aspects to get you working proficiently in Xero in our online Xero Training Course.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Congratulations! What’s next?

Is your name on this list? I want to thank the following students for choosing…

5 days ago

Do You Need a Bookkeeper or an Accountant? Or Someone Else?

There are many finance professionals — who does your business need? Does your business need a…

1 week ago

How to get employers contacting you

Employers like small business owners are looking for staff online using Google. From office admin…

2 weeks ago

Is this what you look like when you cram for studies? School Holiday CRAM Sale

Most complete courses are now discounted. If you want to learn something new now is…

2 weeks ago

Who do you trust less? Microsoft, Mailchimp, Google or Apple?

The features that each of these companies provide is invaluable for businesses. We can't do…

3 weeks ago

MYOB is better than Xero Payroll for some things

All the marketing messages I hear is how much better Xero is than MYOB but…

4 weeks ago