Bank credit not showing in quick file when uploaded

[Joy]

I have just uploaded my current bank statement ( Co op) and there is a cheque that we paid in for £3040 that shows in the CSV file and in my bank but which doesnt come over in the upload onto the Quick flile bank account

so its not balancing and I cant tag the invoices as paid

in the bank its classified as Own account credit
Help please

[Glenn]

I just had a look at the CSV and there is no entry under the column Bank Reference for that particular transaction, this is what we import as the transaction reference and without this the system would skip over the CSV. I’m not sure if Co-op have recently started blanking this out?

You can either edit the CSV before uploading or in this case it’s probably best to just add that transaction manually.

[Joy]

ah I understand now ok thanks

[Glenn]

I know it’s a pain, but there’s so much inconsistency in the way banks format CSVs, it’s very hard to handle all scenarios gracefully. Hopefully it won’t cause too much hassle!