The Metro feed is now working. Thanks Intuit & Metro for sorting it out between you.
1. Disconnect the old feeds. You will not loose entries. Thanks.
2. If during the period the feeds have not been working (just over a month) you have manually entered bank transactions then go into the account register and make a note of the last date you did this. Check your bank account to ensure you have manually entered all bank transactions on this date.
3. Reconnect to bank account(s) to the new feeds. It will ask you what date you wish to start from. If you have made manual entries then enter the day AFTER the one you noted above.
4. All the newer transactions will now be imported. Add or exclude the transactions in the list (as you used to do). If the balances do not then reconcile then you need to check for any duplicated transactions around the date you specified (unlikely).
Thanks for joining us here on the Community.
We are unable to release dates though the connection is expected to be integrated within the coming months, we'll be updating our community article linked here as soon as this becomes available.
Hi Georgia. I was already aware of all that, I wanted to know a more detailed answer. I don't really understand why you are not able to give a better reply. Someone must have an idea on how long till it is complete? Are you seriously telling me that when you ask when it's going to be completed, the people working on it have no idea? The main reason I purchased Quickbooks was because of the bank feed. Not having this organised in time and letting it switch off, then just saying to people "it will be ready in a few months and we can't tell you anymore than that" is really, really terrible service. I don't understand how you can remove a main function from what I am paying for yet still charge me exactly the same money? For me to update banking will take me ages now downloading and importing. The company is still offering new people huge discounts to come on board with Quickbooks, but offering me no valuable information on when this will be resolved, no discount for me not being able to use the service any more. It seems like new customers are your priority and existing ones like me are worthless. I would never sign a customer up to my services for an agreed fee, remove a major part of that service and just say "might be back in a few months, can't tell you more than that, but I'll be charging you the same money".
Thank you for adding a reply, @austen2.
We currently don't receive updates or a specific time-frame to when does the Metro Bank feed becomes available in the Banking Feeds. Rest assured that our engineers are continuously doing updates about this.
However, you can always manually upload your bank transactions to bring your transactions into your QuickBooks Online account.
I think it's probably time to change to a QuickBooks rival as Quckbooks clearly don't care about UK customers. Telling us to manually import transactions - possibly for months - simply isn't viable.
I know, it's completely ridiculous. I tweeted them and again the same standard response, plus "We don't give discounts for banking feeds being down". They basically want me to pay full price for significantly reduced service. Plus stating, we do not give updates on projects. Then finally, just use Excel to do it, which means go back to the very reason you got QuickBooks in the first place. Terrible service, I won't recommend them in future as they have no interest in existing customer service and retention. Once I go back to Excel, I may as well stay their.
We appreciate your frustrations however we can assure you that our engineers our liaising with the bank to establish a connection which hopefully be implemented in the next couple of months.
So you're saying definitely by the end of May? (given that couple means 2 and it's the start of April). Great, very glad that you're finally able to give us a guarantee of when this will be done by. Still very annoying that you broke it before having a solution to keep it working though.
Could be the end of my might be soon might be more, we do not have a specific deadline, just that it will be coming out soon, We did not make the decision to move over to the new open banking it was new legislation that has come out that we have to follow. Like we have said previously our banking engineers are liaising with the banks to get this connection up and running as soon as possible for our customer. We appreciate the frustraistion on this all banks for meant to have been ready by the middle of March but some like the metro bank where unable to meet the deadline, hence the connection being lost as all standard feeds where disconnected. Soon As there is any updates we will inform our customers.
So you weren't telling the truth when you said it would be ready in "a couple of months"?
Metro bank blame you and say their open-banking feed has been ready for some time and that you just didn't prioritise their customers over others. Is this true?
We appreciate your frustrations and that you would like the connection to be established as soon as possible. We stated that 'hopefully' a connection will be implemented in the next couple of months, hopefully is not definitive.
So as vague as ever from Quickbooks.
What about the other half of my question relating to Metro bank saying that this feed has been ready for some time and that you just didn't prioritise their customers/do the work in time?
We can't comment on the statements made by the representative you contacted at Metro Bank., We can however, as previously stated, assure you that we are working with the bank to establish a connection.
Below is an official response from a developer at Metro Bank.
The key point is that smaller banks are not required to implement Open Banking APIs and that Metro are compliant with the required legislation. Intuit have decided that it is easier (development wise) to only talk to banks via the Open API rather than having to handle several methods, so they are using this as an excuse as Metro have a simple solution - which simply requires the account holder's permission.
So now you have a stand-off where one side has to compromise. For us, it is easier to change bank than accounting software. For other companies the converse may be true. I'm sure the situation will be sorted soon between them. But I would have thought that given what's going on in the world right now Intuit would have maintained the previous system....
BTW, unless you have A LOT of transactions do not even think about manually importing them. You could end up in a right mess and waste hours formatting spreadsheets and tracking down duplicated transactions. Simply look at your bank on-line and manually enter payments in and out in QB. It's a pain but not too arduous; and simply what we did before the (recent) era of bank feeds!
-- From Metro --
On March 14 2020, a new piece of PSD2 regulation came in which meant that third parties such as Quickbooks are no longer allowed to ‘screenscrape’ your account information from our online banking channels. The new regulation is designed to keep your account information more secure.
Metro Bank has launched a new solution (known as a Modified Customer Interface) for TPPs to use to access your information, with your permission. If Quickbooks choose to use this, you won’t see a disruption in your service and you’ll be able to use the service as you do today. If they choose not to use this, then unfortunately you’ll see a disruption in your service. Whilst we are in conversations with providers like Quickbooks, it’s their decision as to whether or not they use the Metro Bank solution.
To reassure you, the MCI is fully compliant with the new regulation. Metro Bank has chosen not to implement Open Banking APIs as it’s not required to be compliant.
I recommend contacting support to be added to the list of affected users to receive email updates about the investigation. Below I've included the steps to contact support.
Let us know if you have further questions or any other concerns. We're here to help
I have exactly the same issue, and I am extremely frustrated as well. I can see so many customers are complaining about it but QB is still insisting us to do "manual upload"
We are paying a monthly fee just as other Bank users who have no problem updating feed.
I cannot understand why QB keeps avoiding to deal with the issue.
They just aren't bothered about existing customers. Too busy offering 60% discount to new customers. If it continues much longer I may as well cancel and go back to using excel and sending invoices through my websites free accounting app. Bank feed was main selling point of QuickBooks. App was, but that has never updated correctly with my bank feeds and never got fixed. Shame, I used to recommend them to so many people. Like the saying goes "you only know who your friends are when the going gets bad".
At the present time the connection with Metro Bank is not supported. Our engineers are liaising with the bank to establish a connection however we are not able to provide you with a time frame for when the connection will be implemented. We appreciate that this may not be an ideal situation however in the meantime, as stated in the previous post, you are able to either enter the transactions manually or download your banks statements from your online account,in an Excel/CSV format, delete from the spreadsheet any transactions that have already been added to QuickBooks and upload it to the banking section and this will give you the same functionality as if there was a connection.
This is not a good situation to be in. I, like others, am extremely disapointed in the level of service we are getting from the QB team. Importing into QB manually is real pain. Everything just worked before. My VAT is due soon and we are seriously now looking at migrating to Xero. As said previously offering big discounts to new customers should not be QB priority, keeping customers you've already won should be. Once we go we'll not return.
I'm now doing this annoying csv import thing, and accepting my transactions after, but on the banking page the 'bank balance' and the 'in quickbooks' numbers are both way out from reality.
Is this because importing from CSV is rubbish/doesn't work properly, or am I doing something wrong?
Well at least I'm not the only one :\ But this isn't sustainable for months it is - messes up balance sheet, etc/makes Quickbooks totally unusable.
Can someone from Quickbooks chip in please?
As I recommended before:
Unless you have A LOT of transactions do not even think about manually importing them. You could end up in a right mess and waste hours formatting spreadsheets and tracking down duplicated transactions. Simply look at your bank on-line and manually enter payments in and out in QB. It's a pain but not too arduous; and simply what we did before the (recent) era of bank feeds!
So manually record payments in and out in QB. Check your bank statement and to emulate the on-line feed (optionally) mark transactions as cleared by adding a ‘C’ in the corresponding transaction in the QB bank account. Quite simple unless you have a large number of transactions.