cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Highlighted
Level 3

Cooperative Bank no longer updating automatically

Since today 31/03/2020, my Coop Business Banking UK account no longer updates. QB displays a message "Your The Co-operative Bank (UK) - Bu data feed isn't ready for Open Banking yet. In the meantime, you can keep your data updated via a bank file (111). Upload Now". Does this mean QB have disabled fetching updates from this bank until they implement open banking? I really do not want to have to manually upload transactions since it is very time consuming and too easy to get duplicate transactions.
33 REPLIES 33
Highlighted
Level 2

Cooperative Bank no longer updating automatically

Looks like Cooperative bank accounts will have to be downloaded automatically. What I find frustrating is that there is no lead time as to when the open banking link will be sorted. 

Highlighted
Level 3

Cooperative Bank no longer updating automatically

So after a long and confusing discussion with QB chat, it appears that QB have removed the bank update feature from 31/3/2020 for any bank which does not support open banking. With no warning whatsoever (although they claim to have sent emails, but we have never had one). The only way to get transactions in will be manual import.

 

They say they are complying with new UK government regulations which make Open Banking compulsory from March 2020.

 

This is very bad.... 

Highlighted
Level 2

Cooperative Bank no longer updating automatically

Sage have  March date estimated. It is possible that this date may also apply to QB's, although not very hopeful. At least Sage have some info about possible dates.Screen Shot 2020-03-31 at 12.27.49.png

Highlighted
Level 3

Cooperative Bank no longer updating automatically

I can't imagine their focus will be on implementing Open Banking at this moment in time...

Highlighted
Level 3

Cooperative Bank no longer updating automatically

I just got a reply from Coop on Facebook Messenger, they say they are prioritising support for Xero but they hope to support others "through 2020."

 

As Open Banking is supposed to be a standard, you would think that if it worked for Xero it will work for QB too. But it does not sound like anything will happen anytime soon.

Highlighted
QuickBooks Team

Cooperative Bank no longer updating automatically

Hello Tim19, 

 

Our banking engineers are working closely with banks to get them on the new open banking, we understand that having to CSV  your transactions in, is not ideal but for the meantime, you will have to CSV them into your account,  until there is an available feed for the co-operative bank, the new feed should be available in the next coming months. 

 

 

Highlighted
Level 3

Cooperative Bank no longer updating automatically

Hello Ashleigh1 and thanks for the reply,

I don't really understand why this action has been taken, the March 2020 deadline was for the banks to provide open banking services. You didn't need to turn off your upload system. It is the sudden removal of this functionality without any warning which has caused us problems.

 

The CSV import is very clunky and could be vastly improved by 

(1) Recognising and ignoring duplicate transactions (this is the main problem)

(2) Remembering the configuration of the csv file so you don't have to configure it every single time

(3) Allowing more than one header row so I don't have to manually edit the CSV every time.

Highlighted
QuickBooks Team

Cooperative Bank no longer updating automatically

Hello Tim19, 

 

The standard feed that all banks were using was disconnected because of

 

As banks and Third Parties such as ourselves prepared for the new Open Banking legislation that came into effect as of March 14th, however, some banks were not ready for the co-operative being one of them. The co-operative was fully compatible with QuickBooks until the deadline came. with the new open banking legislation that came in meant that unfortunately, we've had to drop connections for banks who will not be ready to run on this new feed in time for that deadline.
It is looking like The co-operative bank will be ready for Open Banking in the near future, but as this is after the deadline, we cannot continue to run the old style feeds we had, so until then you will need to import your data via CSV files.

 

I know having to CSV them in has caused you some frustrations, we have took your feedback on board and we will pass this information on to our developers. 

Highlighted
Level 2

Cooperative Bank no longer updating automatically

Please can we have a specific date to which you are working, 

Highlighted
QuickBooks Team

Cooperative Bank no longer updating automatically

Hi Adrain, We don't have a specific date as of yet but we're are working on finding a connection with the Bank. Please see link that advised updates on connections, We do go in and update this as much as we can. Thanks 

Highlighted
Level 1

Cooperative Bank no longer updating automatically

I just removed my co-op bank from the app so I could reconnect it and all of my accounts for this year have now disappeared! Does anybody have any idea how I could get that information back without being able to connect a co-op account?

Highlighted
Level 1

Cooperative Bank no longer updating automatically

I just removed my co-op bank from the app so I could reconnect it and all of my accounts for this year have now disappeared! Does anybody have any idea how I could get that information back without being able to connect a co-op account? Please help.

Highlighted
Moderator

Cooperative Bank no longer updating automatically

Welcome to the thread, sambloor.

 

Right now, our banking engineers are still working for a fix with regards to the open banking connection for Co-operative Bank. 

 

In the meantime, you can manually import data into your account to have your information back in QuickBooks. To manually upload bank transactions, your CSV file must be formatted correctly to successfully import it. 
 

Here are the things that you need to check:

  1. QuickBooks has 3 fields: Date, Description and Amount to import bank transactions. Some UK banks provide .CSV transactions in 3 columns, and others in 4 columns (separating Amount into Debit and Credit fields). Both formats work for QuickBooks, if fields are mapped correctly.
  2. Mandatory fields should be filled in. For Amount fields with no value (normally happens to 4-column .CSV files), enter 0 (zero).
  3. Remove all symbols in the Amount field. For example, currency sign or comma.
  4. If your Amount field is in one column, use the minus - sign  to depict money out rather than brackets ( ).
  5. Remove non-transactional info in the file (ex. account numbers, opening, closing balance).
  6. Save your changes.

Once verified, you can now import bank transaction, here's how:

  1. In the left menu, click Banking and go to the Banking menu.
  2. Choose File upload. If you’ve never connected an account, you can select Upload transactions manually. You can also begin your upload from the Import Data page (select Settings ⚙, under Tools select Import Data, and select Bank Data).
  3. Pick Browse and choose the file you downloaded from your bank. If you haven't downloaded your CSV file yet, follow the onscreen instructions in the Upload file window to download your transactions and then select the file you downloaded.
  4. Select Open, then select Next.
  5. From the QuickBooks Account drop-down list, select the bank or credit card account then select Next.
  6. Choose a Datedate formatDescription, and AccountNote: You can choose 1 column or 2 columns.
  7. Hit Next.
  8. Select the checkboxes of the transactions to import and select Next then Yes.
  9. Select Let's go! when the Import completed notification appears.

For more information about the process above, check these articles:

You can get back to me anytime you have additional questions in QuickBooks by posting your response below. I'll do whatever it takes to ensure your concerns are addressed. Enjoy the rest of your day.

 

Highlighted
Level 3

Cooperative Bank no longer updating automatically

Unfortunately Coop bank CSV does not import into QB without a lot of editing. It has 8 columns with the description split across 3 separate columns which have to be edited back together for the auto recognition to work. There are 7 header rows at the top, then every 10 transactions they put in a page number row and another 2 header rows.

 

I have ended up writing a small .net program to modify the coop export into a format which QB will import successfully, it also keeps a log of which transactions have already been imported to avoid duplicates. I am happy to share this if it would be useful to anyone.

Highlighted
Level 3

Cooperative Bank no longer updating automatically

Also, when importing CSV rather than using the automatic bank feed, the bank balance shown in QB no longer updates to show the actual balance. Is there a way of making that work again?

Highlighted
QuickBooks Team

Cooperative Bank no longer updating automatically

Hi tim19

 

The actual bank balance was updated by the connection when you selected update, as the connection currently not supported this will not update.

Highlighted
Level 3

Cooperative Bank no longer updating automatically

Sigh... this just gets worse. Is there a way to hide or remove or manually update the figure then since it's prominently displayed on a lot of screens.

Highlighted
QuickBooks Team

Cooperative Bank no longer updating automatically

Hi Tim19, 

 

There is no way of manually editing the bank balance displayed in quickbooks, when you are csv the transactions in as live feed is not available. Only the live bank feed connection is able to update the balance shown. 

Highlighted
Level 3

Cooperative Bank no longer updating automatically

If I disconnect the account, since the connection is now non-functional, will that make the incorrect balance disappear (without also disappearing any transactions) ?

Highlighted
QuickBooks Team

Cooperative Bank no longer updating automatically

Hello Tim19 

 

If you have Quickbooks self-employed We advise you do not disocnenct the account as you will loss all your trasnactions. 

 

If you ahve Quickbooks small businees then if you have any transactions that are in your for review this will be lost when you disconnect the account. Anything in the reviewed section will stay. So you will need to sort through them in the for review transactions first and making sure they are in the reviewed before disconnected your bank account in the system. 

 

When the account is disconnect you wil still eb able to upload your transactions into the banking page via csv. 

 

 

Highlighted
Level 1

Cooperative Bank no longer updating automatically

Hi Tim . This is something I'm struggling with as we have the added layer of using G Suite and not Windows. Please excuse my ignorance, but would your program work for me?

Thanks for your help. 

Highlighted
Moderator

Cooperative Bank no longer updating automatically

Hello there, Aitchvee. I'm glad to have you here.

 

Currently, there's no accurate process for the G Suite to QuickBooks. If you want to download transactions from your bank, we can use the CSV file instead so that we successfully bring transactions from your bank to QuickBooks. I would like to include articles that will guide us through the process:

 

 

Let me know if you need anything else. Stay safe and healthy!

Highlighted
Level 3

Cooperative Bank no longer updating automatically

Aitchvee, I don't know, my program is just a little Windows application so you would need to be able to run Windows applications. It's here if you want to try...  

https://github.com/congoblue/coopbankconverter

Highlighted
Level 1

Cooperative Bank no longer updating automatically

This is completely ridiculous. Businesses don't have time for this nonsense right now, I certainly don't. Last time I tried to do a manual import I ended up spending 20 HOURS removing duplicate transactions. This is rubbish service at an incredibly bad time for SME's. Find a solution please!