Bank Feeds In Xero

The beauty of modern cloud accounting systems is many of them link to your bank and allow you to download transactions. I found this hard to get used to with being from a background of using Sage 50 accounts ...

The reason for this is that I love the bank reconciliation tools in Sage, but I have learned to embrace the Xero and Sage Business Cloud bank reconciliation features. However, there are a few things to consider.

If you enter sales invoices and purchase invoices (bills in Xero) into your system then make sure that when you see the payment or receipt on the bank feed, remember to match the payment to the invoices you have already entered on the system. Don't accidentally 'create' a new transaction unless you mean to.

"With simple regular payments, you can set up bank rules!"

This automatically matches regularly appearing payments, saying who the contact is, the VAT code and the account code. When I started using Xero, I set up loads of bank rules and learned quickly how to enter them in a flexible way, I'll do a separate post about that. If you see a regular direct debit there may be no need to set up bank rules as Xero will remember what you did last time it saw that payment.

That works great until the bank feeds changes how it uploads your data. Go and look at your statements page and see which columns the bank feed has imported the data into; if this changes the remember feature won't work and you will have a frustrating month remembering where you normally code those transactions to. It happened to me with one of my clients this week.

The biggest problems I see with new clients getting used to using bank feeds is they accidentally create duplicate contacts using the create area on Xero, or they create new transactions rather than marking invoices as paid!

You need to take care when you are reconciling items and don't be lulled into the false sense of security of a big green tick. Xero is not that clever when matching transactions; it is looking for an amount and won't look at the contact or date on a transaction. If you have a payment going out regularly be sure you match the payments to the correct invoice so your outstanding invoices don't look wrong.

"That could lead to issues further down the line!"

If you have got into a bit of a mess with your bank feeds in Xero then why not arrange a hand-holding session with me to go through and identify what is causing the problems so you can get your bookkeeping spot on going forward.


If anything I've written here resonates with you, call me on 01604 420057 and let's see how we can help you.