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.
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....
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.
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.
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.
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.
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
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?
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.
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:
Once verified, you can now import bank transaction, here's how:
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.
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.
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?
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.
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.
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.
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!
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...
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!