Share this content
0
696

Barclays csv files contain duplicated transactions

Seems to be impacting QBO bank feed also

Didn't find your answer?

Search AccountingWEB

Evening all,

When I download a csv file from barclays online the file contains duplicated transactions. I noticed today for the first time on a file provided by a client but this is the first time I have had duplicates in the file. My business account is also Barclays so just to check I wasn't getting a duff csv off the client I downloaded my own transactions and I have duplicates in the csv. I happened to try a quickbooks online bank feed from my business account and the same transactions duplicated in the csv are also duplicated in QBO. Not a coincidence obviously.

I have raised with Barclays support team but just wondered if anyone here has seen this problem yet?

Replies

Please login or register to join the discussion.

avatar
By SXGuy
15th Jul 2019 21:24

Haven't seen this issue with barclays. The only thing I can think of is it must be a recent glitch as my csv files have been fine for years.

It's strange tho that QB doesn't pick this up. I don't use it but my software detects duplicates and offers me the choice to ignore or remove

Thanks (0)
avatar
By JoF
16th Jul 2019 00:07

Ive had the duplicates issue recently, but have to admit I thought it was the client who bobsed up the download from Barclays. The csv also had no balances on whatsoever as well!

Ive seen rounding errors with Barclays statements in the past so not a huge fan of their csv option.

Thanks (1)
avatar
16th Jul 2019 10:26

Thanks for the replies. Barclays support looking into it..........

Thanks (0)
avatar
By TessaW
16th Jul 2019 14:07

I spent a good 10 minutes going over & over a client's bank reconciliation to try & work out why it didn't agree to the Barclays statement. Last thing I did (in future the first) was to check the adding up of the running balance on the Barclays statement - it didn't add up. That was a couple of months ago. This was from business online banking - statement & the online account had a final balance which was incorrect.

Thanks (1)
By djn24
19th Jul 2019 14:11

I've noticed that too. Very annoying!!

Thanks (0)
avatar
01st Aug 2019 14:43

SwiftCSV.com is a facility that converts PDF bank statements to CSV files in minutes. During the conversion every line is balanced back to the previous line and this duplication causes the conversion program to create an error message. Our back office will then repair the CSV and XLSX files that we created and reload the corrected files. As Barclays local (in South Africa) is called FNB, try to convert your bank statement on our system and choose FNB as bank - lets see if we can sort your problem by creating a balanced CSV file

Thanks (0)
Share this content