I went through this last year and sadly I was silly enough not to make a note of the solution. I found my post from Aug 16 but the link to the help guide no longer works, so I’m back at square one again.
Hi @AnnBD
We’ll certainly try our best to help get this working for you. What error messages are you seeing?
Hello, If I select co-op bank I get the message Incorrect File Format
You must upload a CSV/OFX/QBO/QIF file here (Statements-0892507081534800-28-Jun-2017-03-41-0006.txt)
If I upload as Santander (its a co-op account that runs via Santander) i get There was an error processing your file
There is no row at position 0.
Feel stupid for not saving the solution you guys gave me last time!
Am I right in thinking it’s the .txt file you’re using?
If so, are you able to get a .csv file from Santander Online Banking, or import that either using the ‘Co-op’ option, or the ‘Other’ option?
The online banking is a co-op account. It only gives me a txt option
Oops, I think I fell into the branding trap there 
What options are you seeing altogether? I can certainly take a look at the .txt file for you (will send you a separate private message to get this from you), but generally speaking .csv files, sometimes branded as Excel files, are more universal and easier to tweak.
Don’t get what you mean? Only option I get when i hit the save button on the online statement on my bank is a txt file? Happy to send you a copy over.
Ok think I have worked it out thanks to internet searching. I’ll post here in case anyone else needs to know. On co-op online business banking, go to accounts information/ transactions/ put in the dates you want, click reports, select CSV option and hit ‘generate report’. Seems to work so far . .
1 Like
Glad to hear you’ve managed to sort this @AnnBD!
Thanks for sharing this with our community too - hopefully it’ll help other users too.
This topic was automatically closed after 10 days. New replies are no longer allowed.