Skip to main content
W
walkabout
October 21, 2019
Solved

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

  • October 21, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by RaymondJayO

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. 

  1. Go to Banking from the left menu. 
  2. Select Add account. 
  3. Search for your bank and choose it. 
  4. Copy the URL listed in the window. 
  5. Sign in using your bank username and password. 
  6. Review for any alerts, notifications, or announcements about new security requirements. 
  7. If everything looks good, go back to the Banking menu.
  8. Select the blue tile for the bank account. 
  9. 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: 

  1. Go to Banking from the left menu. 
  2. Click the Blue tile for your bank. 
  3. Select the Pencil icon to edit.
  4. Choose Edit sign-in info. 
  5. 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. 

1 reply

R
RaymondJayOAnswer
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. 

  1. Go to Banking from the left menu. 
  2. Select Add account. 
  3. Search for your bank and choose it. 
  4. Copy the URL listed in the window. 
  5. Sign in using your bank username and password. 
  6. Review for any alerts, notifications, or announcements about new security requirements. 
  7. If everything looks good, go back to the Banking menu.
  8. Select the blue tile for the bank account. 
  9. 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: 

  1. Go to Banking from the left menu. 
  2. Click the Blue tile for your bank. 
  3. Select the Pencil icon to edit.
  4. Choose Edit sign-in info. 
  5. 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. 

W
walkaboutAuthor
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:

  1.  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.
  2. 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.
  3. 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

 

E
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.

Terms & ConditionsAccessibility statement