Xero: Fixing Bank Feed Duplications

I have been helping a client this week with checking through his bank statements for October to December last year. Xero had some glitches which caused transactions to be duplicated and sometimes even triplicated in the bank feed ...

This has proved a nightmare to spot and sort out when they can have multiple similar transactions on one day, so let me guide you through some of the techniques I used to help.

The issue with this particular client is they match transactions on their bank feed as and when they have a few moments so they didn't spot the duplications and created duplicate bank transactions in their systems too!

Firstly, regularly use the Reconciliation Report to check your bank balance in Xero matches your statement balance; the, button is top right when you are looking at the bank account. If the Xero balance matches the statement balance matches your paper statement then you are OK and the bank feed has no glitches.

"If it doesn't then that is where the fun starts!"

You can enter whatever date you like on the reconciliation report, so I start with a date at the end of the period I have been working on - for example, the 31st of December - and if the balances do not match at this point then go back in time in jumps until you find the last time your bank balances matched. In the case of this client, I went back to the 4th of October which is where the duplications started.

Then within the bank reconciliation report, you can click on the 'BANK STATEMENT' tab and just put one date on there. I did 4th October to 4th October so I could then compare the transactions imported with my paper statement and spot the duplications. If you then go to the Bank Statement page next to the reconcile area you can delete the duplications.

I then had to go to the account transactions page and delete the duplicated bank payments which had been duplicated on these dates as the transactions I deleted as they had already been reconciled. That then corrected the bank so the balance at the end of the day was correct.

The issue I had with this particular client was I had some transactions which had been duplicated on different days! So, there were card transactions on the 4th and 6th of October for the same purchase which did take me a while to spot.

If you are struggling to get your bank account correct and you need some support then why not arrange a handholding session with me and I can help you spot the issues?

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