QB bank update has imported balances but not transactions (again) is there a way to get QB to reimport? This keeps happening - very laborious to fix manually

walkabout · ‎October 21, 2019

RaymondJayO · ‎October 21, 2019

I've got some steps that can help you get the transactions updated in the program, @walkabout.

I know how you feel about going through this banking issue for several days. I want to make sure this will be taken care of right away.

Can I ask which bank are you trying to download transactions? Also, did you encounter errors? This will help me provide accurate resolution to your concern.

Here are the possible reasons why there are missing transactions when you manually update your account:

The bank is doing maintenance.
There are alerts in your bank's website that need your attention.

To start with, you can check your financial institution website if there are any messages that need your attention. You'll first need to get the URL from QuickBooks. Let me guide you how.

Go to Banking from the left menu.
Select Add account.
Search for your bank and choose it.
Copy the URL listed in the window.
Sign in using your bank username and password.
Review for any alerts, notifications, or announcements about new security requirements.
If everything looks good, go back to the Banking menu.
Select the blue tile for the bank account.
Click Update.

Then, you can update your sign-in info in the program if you make any changes on your bank’s website. Here’s how:

Go to Banking from the left menu.
Click the Blue tile for your bank.
Select the Pencil icon to edit.
Choose Edit sign-in info.
Update your info.

For detailed steps, go through this article: Fix bank upload errors in QuickBooks Online.

Once done, all you have to do is approve the way the program categorises the transactions. You can also match them if you've already recorded the entries in QuickBooks. To learn more about this process, visit this article: Categorise and match online bank transactions in QuickBooks Online.

I’m just a comment away if you need further assistance. Have a good day, @walkabout.

View solution in original post

EmmaM · ‎October 24, 2019

Hello Emma

From looking at your account it seems that you are getting a 102 error.There has been an investigation raised by our banking engineers for this issue to be resolved it has been caused by partial IP blocking by Santander. Some users are still able to update their accounts as it has been intermittently working which could by why the balance has updated however we will add your company to the investigation and as soon as it is fixed we will update you via the case.

In the mean time there is the option of uploading the transactions as a CSV into the QuickBooks which if you need help with we can advise how to do

Emma

View solution in original post

RaymondJayO · ‎October 21, 2019

I've got some steps that can help you get the transactions updated in the program, @walkabout.

I know how you feel about going through this banking issue for several days. I want to make sure this will be taken care of right away.

Can I ask which bank are you trying to download transactions? Also, did you encounter errors? This will help me provide accurate resolution to your concern.

Here are the possible reasons why there are missing transactions when you manually update your account:

The bank is doing maintenance.
There are alerts in your bank's website that need your attention.

To start with, you can check your financial institution website if there are any messages that need your attention. You'll first need to get the URL from QuickBooks. Let me guide you how.

Go to Banking from the left menu.
Select Add account.
Search for your bank and choose it.
Copy the URL listed in the window.
Sign in using your bank username and password.
Review for any alerts, notifications, or announcements about new security requirements.
If everything looks good, go back to the Banking menu.
Select the blue tile for the bank account.
Click Update.

Then, you can update your sign-in info in the program if you make any changes on your bank’s website. Here’s how:

Go to Banking from the left menu.
Click the Blue tile for your bank.
Select the Pencil icon to edit.
Choose Edit sign-in info.
Update your info.

For detailed steps, go through this article: Fix bank upload errors in QuickBooks Online.

Once done, all you have to do is approve the way the program categorises the transactions. You can also match them if you've already recorded the entries in QuickBooks. To learn more about this process, visit this article: Categorise and match online bank transactions in QuickBooks Online.

I’m just a comment away if you need further assistance. Have a good day, @walkabout.

walkabout · ‎October 22, 2019

Hi

Thanks for the reply. To answer your questions:

The bank is Barclays - I have had this set up for a long time to update automatically. The interface seems very flakey though. On a few occasions the update has successfully updated the balance, but not brought in the transactions. The update will then not look for the missing transactions when you run a further update. There is no way to tell QB to ignore the last update and rerun. There were no error messages. The bank website seemed fine with no messages etc - I was logged onto it at the time.

The functionality seems poor on several levels:

There is no way to correct and go back to re-upload from a certain point. Therefore the only way to fix is an error prone, time consuming manual update.
The interface doesn't seem to handle errors or unexpected behaviors well. If there is a message or some other event on the bank website, surely the user should be warned and no update made, rather then half an update.
Error trapping / messaging seems very poor. The fact that the balance has moved with no transactions is surely an indication of an error?

The only way to fix appears to be to manually create an upload file to fill in the missing transactions - which can be painful.

I have manually updated now to bring things in line. But would expect more robust, user and control friendly functionality from QB on this.

Thanks

EmmaD · ‎October 24, 2019

I've just started using QB and am having the same problem. My bank is Santander Business Bank. Balance has updated but transaction has not come through and no matter how often I try to reconnect to bank the transaction is not coming through. Yes I can do it manually but if this is an issue then that means I'll need to go through my bank accounts and check that every transaction has come through to QB .... kind of defeats the purpose of connecting the bank account.

GeorgiaC · ‎October 24, 2019

Hey EmmaD,

Sorry to see you are having issues with your bank feed there. Did you receive an error code or message when you initially updated the feed?

What is the date of the transaction(s) which have not pulled though?

Thanks

EmmaD · ‎October 24, 2019

Hi Georgia,

No I didn't notice any error message. I noticed that the balance had updated but that there was no transaction for me to review. Then when I tried to refresh the bank account it said there was a connection error which then worked again later.

This was for a transaction that came through yesterday but there is another one today that has done exactly the same - the balance has updated but the transaction has not come through.

Thanks,

Emma

EmmaM · ‎October 24, 2019

Hello Emma

From looking at your account it seems that you are getting a 102 error.There has been an investigation raised by our banking engineers for this issue to be resolved it has been caused by partial IP blocking by Santander. Some users are still able to update their accounts as it has been intermittently working which could by why the balance has updated however we will add your company to the investigation and as soon as it is fixed we will update you via the case.

In the mean time there is the option of uploading the transactions as a CSV into the QuickBooks which if you need help with we can advise how to do

Emma

EmmaD · ‎October 24, 2019

That's great thanks Emma. As I say I've just started using QB so wasn't sure if it was something that I was doing wrong or functionality that I didn't understand but sounds like it's hopefully just a temporary glitch so I'll add manually in the meantime until it's sorted.

Topics

Training

Community

Resources

QB bank update has imported balances but not transactions (again) is there a way to get QB to reimport? This keeps happening - very laborious to fix manually