Connecting to Cooperative Bank personal account

Hi MattLeach

The Co-operative connection is not supported at the moment. You can however either manually enter the transactions or download your online bank statement, in an Excel?CSV format, and upload it to the banking section, this will give you the same functionality as iff there was a connection.

We have provided you with a link to enable you to check when the connection is available.

https://quickbooks.intuit.com/learn-support/en-uk/banking/understanding-if-you-can-upgrade-your-bank...

I have to say, I'm a little miffed about this, to put it mildly. The Co-op appears to support Open Banking, and this suggests that the problem is with your connection to it. I pay for your service to make my life easier. The automatic import of transactions is pretty much the only thing stopping me from jumping ship to a free platform. Give me a timescale as to when your system will be able to cope with Co-op, and maybe I'll stay. Otherwise, this may well be my last tax year with you.

I understand the impact this has on your business, @Monkeyman.

Rest assured that we are already working with Co-op regarding the open bank connection. In the meantime, you can follow my colleague's suggestion to import banking transactions via CSV while our Product Team is doing all the necessary preparations to make this available.

Though we can't provide the time frame for the availability, I'd recommend reaching out to our QuickBooks Self-Employed Support so they can sign you up to receive email updates once the connection is ready.

Know that I'm always here if you have other questions or concerns. I want to help however I can. Take care and have a good one.

Hello, I have been connecting to the Co Op Bank via QBs Online for a couple of years but now it will not work.  I’ve tried re-installing the connection but QBs cannot even find the bank. The Banks URL is the same so I can only surmise something has changed on QBs.

I know how important it is to get your Co-op account connected to QuickBooks Online (QBO), @PaulMars. Rest assured that I can share with you the details about this issue, and how to take care of it. 

Right now, there's an ongoing investigation about the removal of the Standard Feed new connection for Co-op. Please know that our product engineers are working closely with your bank to provide Open Banking connection. It's because we want to ensure we're compliant with the new Open Banking regulations.

To complete your task, I recommend downloading transactions from your bank using a CSV file. Then, manually upload it into QBO. For more details, see the The Co-operative Bank section through this article: Understanding If You Can Upgrade Your Bank Feeds To Open Banking. 

I'd suggest contacting our Customer Care Team. They can add your account to the notification list. This way, you'll receive email updates about the investigation (INV-42813) and its status. Let me guide you how.

1. Go to the Help menu at the upper right. 
2. Select Contact Us. 
3. Enter Fixing Co-op connection with QBO in the What can we help you with? box. 
4. Click Let's talk. 
5. Choose a way to connect with a support agent. 

Once Open Banking connection is available for Co-op, you'll see a banner on the Banking menu. You'll also receive an email from us that contains the steps you'll have to perform to complete the update. For more information, visit this article: Upgrade Your Bank Feed Connection To Open Banking. 

After that, let's go to the For Review tab to check if there are duplicate transactions since you've uploaded a CSV file. If there are any, I recommend excluding them. However, if there are no duplicates, you can continue editing, assigning, and categorising your Co-op transactions. This ensures your financial records are accurate. To learn more about this process, visit this article: Categorise Bank Transactions. 

You can always tap me if you need anything else. I'll gladly help. Keep safe always, @PaulMars. 

While I'm grateful for the information, I am somewhat frustrated. Other accounting software still seems perfectly able to import transactions from Co-op. This suggests it is not a problem with the Co-op, but with QB. Although I appreciate the "workaround", if I'm going to go to the trouble of exporting and re-importing my transactions as a CSV with all the faff that entails, then I may as well be doing my accounting in Excel. As far as I'm concerned, the bank link is the main convenience that I'm paying my £9.60/month for, and now it's gone I have no reason to continue to do that. I know you say the link will be fixed at some indeterminate point "in the coming months", but for the overhead involved in the mean time and the minimal convenience I get in return, once I've sorted out the last tax year I'll be moving to Excel and some simple formula cells for calculating my tax, which is essentially all QB is offering me without a bank feed. I'll also then have the added bonus of being £115.20 better off in the 2020-2021 tax year. You seem like nice people, but at the moment I'm just not getting what I chose to pay for.

I too am pretty miffed about this.  Unless you I shall be leaving quickbooks.  I already have to manually export Stripe, which is a complicated process, but on top of that 3 Co-op accounts.  It just isn't worth it.  Looks like this hasn't been resolved for over a month, so please give a time-scale or I'm off.

Yes , totally agree. It appears that Quickbook messages imly that the problem lies with the Coop, however, it is actually QB that has FAILED. 

Dowloading and uploading comes with issues, and I'm seriously thinking of transferring to Sage

An element of truth would be useful here.

Is the Co-op Open Banking output compliant or not?

Yes, there was a two- step requirement due to the requirement to get a ten-digit code from a security device, but the process worked.

For nearly 4-months we loyal QBO customers have been given the impression that the fault lies with the Co-op's ability to be compliant. I am not a legal person, but does that not imply competence? Again, not a legal person, but does the continued questioning of a banking corporation's competence creep into libellous grounds?

Give a more meaningful statement when your customers attempt to connect to their co-op account. Let your customers choose if they will continue with a bank that is not compliant with legislation or to continue with an accounts software provider that is not giving sufficient detail of an integration problem.

QB don't seem to care. They go on and on about uploads ! really poor show - same price ! 

I wee comparison with Xero, for example, indicates they have a simpler issue with personal Co-op accounts but business accounts (current and savings) would appear okay - much nicer way of depicting what the current situation is in addition, fully up-to-date tables of different banks, in different counties:
https central dot xero dot com / s / article / Bank dash feeds dash affected dash by dash Open dash Banking

are you using xero? would you recommend? 

Hello David_g1

The Co-operative connection is still not supported at the moment. Our banking engineers are working with the co-op to get them onto open banking. It is a case of you can either manually enter the transactions or download your online bank statement, in Excel to a CSV format, and then upload it to the banking section until there is an available connection on open banking. This link will tell you which banks are on open banking and which are not yet on open banking. 

Are you now telling us that its the COOP problem ?  

Because the Coop does have a 2 step open banking system !

Where does the problem lie ; QB or Coop ?  

Please advise 

Hi hirhydyfelin-nonpo, 

Our engineers are actively working with the banks engineers to establish an open bank connection with QuickBooks. Each open bank connection is set up individually between both the bank and the provider. We appreciate your eagerness to have a connection completed and we're working hard to ensure this is available to you ASAP. 

Thank you

Not the best diagram, but something to enable a point to be made. In all of the processes, QBO has to ensure the security of exchanges of information with the Co-op, one of the elements includes what a user would typically know as the username/password. What this integration seems to be suffering from is an inability to handle the additional security measure of managing a ten-digit code, which can only be provided after the first step. Not really the ability to handle username/password and the ten-digit code, but the ability to securely combine the two (and its two-step process).

So, when this was happening pre-mid-March it was 'safe'. After that point, it was no longer 'safe' because:

a. The Co-op changed something?

b. QBO realised that the combined interaction was actually not 'safe'?

c. There was a change in the legislation of how Open Banking information had to be handled/managed?

d. There was a change in an approved code of practice of how Open Banking information had to be handled/managed?

e. There was a response to a potential security risk, with Open Web Application Security Project (OWASP) guidance, identifying enhanced feature requirements

simple question 

Who is at fault ?  

Coop or QB ? 

Thanks for joining this thread david_gb, I appreciate you highlighting the complexity of the API connections. The new Open Banking regulations which were implemented in March under PSD2 change the way we share financial data with your bank - previously the multi-factor authentication code would be required each time when updating the account within QuickBooks, however now, permission is granted when the connection is established and remains connected for 90 days, after which you'll be invited to re-authorise for another 90 days. While we don't have any further information to share on this, our engineers are working to implement the new secure feed ASAP. You can see more on open banking here in the meantime. Thank you 

Hi rhydyfelin-nonpo, we're working closely with the bank to establish the connection, neither side is to blame. 

Its has been months and still no progress. If everything doesn't link and update automatically then I don't see what I am paying for. Do you have an idea of timescale? I think we have been more than patient and paying for a service we are not receiving. Until you fix this issue I don't think you should be charging co op Bank users to use Quickbooks.  

We need an idea of timescale. I cannot carry on like this, it has only be tolerable as my shop has been closed for 3 months. We are back open and thoroughly disappointed that this issue hasn't been resolved. 

You keep advertising on TV about how you are helping small businesses. I see absolutely no sign of this. 

We don't want you to feel this way, @Tw1nb0y5.

As of now, we don't have a specific time frame as to when this feature will be available in QuickBooks Self-Employed (QBSE). Rest assured, our engineering team are working in implementing this in the future.

For now, I recommend uploading your bank transactions to your QBSE account. Let me show you how.

1. Sign in to your bank's website.
2. Follow the steps on how to download the transactions as a CSV file.
3. Once done, go to the Gear icon in your QBSE account.
4. Click Imports.
5. Select the account you want to add the transactions into.
6. Click Browse and find the file you downloaded from your bank. 
7. Select the file and select Open to start the import.
8. Review the column headers and data then select Continue to complete the import.

You can also read this useful article for additional reference: Add older transactions to QuickBooks Self-Employed.

Once done, you can now categorise your transactions for easy tracking.

In addition to this, I also recommend checking our QuickBooks blog page regularly to stay updated on the latest news and updates. There, click the Newsletter signup and type in your email and click Subscribe.

Know that I'm always around to help you anytime you need assistance. Have a great day ahead.

There is still no cconnection between the cooperative bank and quickbooks.  I complained to the cooperative bank, thinking this was t heir fault. They have said that that the fault was quickbooks, becasue they contacted you in advance to warn that you would need to resubmit to comply with coop and said you never responded to them.  what's your side of the story?

Despite assurance that a connection between coop and quickbooks is coming soon, nothing has happened.  what exactly what does 'soon' mean?  

It is not working using the manual report upload to quickbooks - it doesn't provide all the information one requires. Currently i am paying for quickbooks (via may accountant's vendor account) but not really able to experience any of its benefits. If there is no confirmed date for the new bank connection, i will be closing my quickbooks account.

Hello Steve Rivers, Welcome to the Community! We don't want to be getting into the "lets blame" We're aware of frustrations caused by this issue and we're working on creating a new connection for The Cooperative and are liaising with the bank to make this happen. Appreciate that the latest update is still 'in the next coming months' is not a date as such but we don't want to be giving false promises/hope that it's going to be resolved sooner than what it is, We don't have a date yet. We are working on it and are conscious that quite a few of our customers use this bank so we are keen to get this working. 

We obviously don't wish for you to close your account and wish to work with you to get your transactions, What is it that's not working when uploading CSV file? 

I am in exactly the same position. Moreover, the new payroll system has failed me and somehow in the switch from paysuite to new QB system, I am unable to submit FPS. The HOURS I have spenttrying to sort it out just don't bear thinking about. Downloading bank reports manually is such a faff, I might as well just do the whole accounting myself :(