Hi there!
I have been trying to import some bank statements and keep getting this error message:
There was an error processing your file
The CSV file appears to be corrupt.
Error: The CSV appears to be corrupt near record ‘10’ field '5 at position ‘0’. Current raw data : ‘’.
It doesn’t seem to matter if I delete record 10 - I still get an error message about the second to last transaction: This is happening when I try and up-load any statement. Excel csv LLoyds Bank account on a Mac.
Last month they all up-loaded fine with no problems at all!
Any help greatly appreciated,
Thanks
Sophie
Are you modifying the CSV file at all before uploading? We noticed that some banks are actually issuing corrupted CSV files, I.e. not following the correct formatting conventions for CSV. As we’ve recently updated our CSV parsing sotfware this may introduce a problem.
Are you able to export in QIF or OFX instead? Both these formats are supported in Quick File.
EDIT:
Upon further investigation Lloyds are including non-ASCII characters in their CSV. We’ve written a few workarounds which should solve this problem. Unfortunately they won’t go live until later this week, in the mean time I would suggest uploading QIFs.
Thanks Guys!
I have used the QIF option for one bank account which worked! The other bank account I don’t have access too, just the statements so will wait for the workarounds. Thanks for looking into it for me, really appreciated!
Kind regards
Sophie
I just had the same problem, however when i looked at the CSV file, it had an extra comma at the end of the header line, once i removed that, it imported it ok.
We’ve implemented a fix for Lloyds CSVs. We’ve tested on a handful and it appeared to work fine. Please let me know if you have any further difficulties with Lloyds statements.