Cooperative bank statement uploads missing a row

Support
1

Hi

Still having difficulty uploading csv files from Co Operative bank ,
I have worked out to upload them as "other " and then adjust the columns and that is working… just , but for some reason Quick file is not uploading a specific row in the CSV file . It is visible in the CSV file though so its there just not uploading
The bank Ref is 4228 and it is a commission charge , unless I realise its not uploading it and do it manually my running balances dont tally
It took me ages going back over 6 months worth to work out why my balances were not matching

any help would be appreciated

2

What line no was it? The first?

3

No one in the middle …it’s always the same bank referrence …4228 commission
Always the same one …so frustrating

4

This month it’s line No 5

5

There’s probably a non-standard character in the description somewhere, could be as simple as a non blank space or something you might not be able to see at first glance. Have you opened the CSV file in Notepad and checked that line for odd looking characters?

6

Not sure how to open it in notebook …can you advise

7

i have just copied and pasted it into notepad and having wrapped the text can see the amount doesnt seem to be in the column it should although in the CSV file it looks like it does

8

I have checked both against each other and in CSV file the customer ref column on that row is empty , could that be the cause ??

9

Hi everyone who has responded to me

I think you have helped me resolve it . I have deleted the recent upload , gone back to the CSV file and added a Customer ref in the row that didnt upload and uploaded file again and its worked , so thanks everyone
Such a pain though the Co-Op Bank have been working on an upgrade for months and it absolute rubbish , worked well before they messed it about

10

If you download the file, save it somewhere then right click and select Open or Open With, then select Notepad.

Copying and pasting may or may not work as if you have opened it in Excel forst that will have probably stripped/deleted/changed the possible odd characters.

Doesn’t matter what rows the figures are on, Notepad is completely line agnostic. CSV stands for comma separated values, the commas are what tell whatever is importing it that the current field is done and to move on to the next, the line breaks are ignored.

However, the fact you have sorted it by adding the customer ref might suggest the blank space was filled with something non-standard so adding the value would overwrite this.

11

This topic was automatically closed after 7 days. New replies are no longer allowed.