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

Can you REALLY Trust PayPal?

When we were using our old enrolment form I was alerted about the option to…

5 days ago

Bookkeeping Basics: Chart of Accounts Explained

Just wanted to give you the heads-up on some cool stuff we've been working on.…

7 days ago

Thank you Dani!

I've received some negative feedback this week, but it's not as bad as you think.…

2 weeks ago

Stay Ahead of the Curve: Our Updated Xero Beginners Course Reflects Xero’s Constant Evolution

In today’s fast-paced business environment, staying stagnant is a recipe for falling behind. This is…

4 weeks ago

Are you 1) Angry, 2) Frustrated or 3) Exhausted trying to use Microsoft Excel?

Master Microsoft Excel one step at a time with the guidance of: Training Workbooks Excel…

1 month ago

How does $20,000 mortgage repayments equate to $47,598.02?

All eyes will be on the announcement from the Reserve Bank Governor today to see…

1 month ago