Xero bank rec

Xero bank rec

Didn't find your answer?

Hi - does anybody know if it is possible to import the same bank transactions twice into Xero. I am trying to sort a (an?) historical bank fudge and have come across a couple of duplicate items on the imported statement. Without access to the original / online version I don't know whether these are genuine dupicate payments or double imported? 16.15 on a friday arvo and kissing goodbye to my weekend - any help appreciated.

Replies (5)

Please login or register to join the discussion.

avatar
By WhichTyler
09th Dec 2016 16:23

It is certainly possible to import duplicate bank statement items into xero (I speak from experience). It is quite easy to delete them too, if you are sure that is what you have done...

Thanks (1)
avatar
By Cloudcounter
09th Dec 2016 16:47

As said it's not difficult to import things twice. Xero is generally very good at recognising duplicates when you import the same statement exactly, less good when you overlap ranges so only part of an import is a duplicate. It will recognise some, but not all.

That's why there is a recommendation to regularly check the Xero record agaisnt statements .

The quickest way to sort these out is to use their reconciliation report at different dates, and compare those with the actual bank balance. By starting before and after the known problem it's generally quite quick to zoom on on the problem date and find out what's been duplicated ( or of course omitted)

Thanks (2)
avatar
By stacksbookkeeping
09th Dec 2016 17:03

Damn it. Partial duplicate i think. Bank stats imported by previous bk and only access I have to stats now is via imports from owner who is away for 2 weeks so no idea what actual balance is...don't have this problem with pen paper and ruler!! Many thanks tho.

Thanks (0)
Man of Kent
By Kent accountant
10th Dec 2016 10:53

How were you ever going to be able to reconcile the bank account without access to the bank statements?

Thanks (2)
avatar
By stacksbookkeeping
10th Dec 2016 21:42

I have imported copies to date. What I don't have access to is hard copies which are only accessible by absent owner.

Thanks (0)