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 (5)
Please login or register to join the discussion.
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
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.
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