Skip to main content
Anna_Reznik
Anna_Reznik
April 23, 2019
Solved

Bank balances for banks with manually uploaded statements

  • April 23, 2019
  • 2 replies
  • 0 views

1) How to see bank balances for banks with manually uploaded statements before a reconciliation? After manual upploading and before a reconciliation there is zero bank balance.
2) How to check that there was no mistakes and no duplicates when uploading statements?

Best answer by Mark_R

So for now there is no solution for my isuue, right?


Thanks for getting back to us, @Anna_Reznik.

 

As of this time, the bank's current balance will not show after uploading the transaction manually in QuickBooks.

 

As mentioned by my colleague above, as a workaround, you can check the bank's current balance in your Chart of Accounts. I want to let you know that we're taking note of your feedback and suggestions to improve the experience we're providing.

 

Please also know that I'm going to send feedback on my end in regards to your concern about the option to show the bank balance after uploading the transaction manually. This way, our engineering team will check and work with this for possible inclusion in future updates.

 

Please let us know if you have any other questions with QuickBooks Online. We're always here to help.

2 replies

A
Anonymous
April 23, 2019

Hello, Anna_Reznik.

 

You can check the bank’s current balance in your Chart of Accounts. Here’s how:

  1. Click the Gear icon at the top. 
  2. Select Chart if Accounts under Your Company. 
  3. You’ll see the balance under the BANK BALANCE column. 

Furthermore, you’ll need to manually check your bank’s register in QuickBooks t figure out if there are duplicate or missing transactions. 


Please visit us again if you have other concerns about QuickBooks. 
 

    Anna_Reznik
    Anna_ReznikAuthor
    April 23, 2019

    Thank you, MikiD. We manually uploaded statements from 01/01/2019 till 03/31/2019 but can't see bank balance. What could be the reason?

    A
    Anonymous
    April 23, 2019

    Hi there, Anna_Reznik.

     

    Thanks for responding back and for providing additional explanation. 


    If your recent downloads are through webconnect or manual download, the BANK BALANCE column would be empty. The system will derive this information from your bank and will auto-populate the field. This process, won't take affect when you do a manual download. 

     


    Thanks again for dropping by. 


     

      G
      Gee4
      March 27, 2020

      Hi,

      I manually upload bank transactions for 3 different bank accounts. I've been successfully reconciling all 3 bank accounts all along. Somehow I noticed that 1 of them, shows an outdated "UPDATE" bank balance. It stopped updating after Dec 2 when in fact I've been uploading transactions after that date. Apparently this issue does not affect the books. The balance  in QBO is correct. Please advise. Thank you.

      Rubielyn_J
      Rubielyn_J
      March 27, 2020

      Thank you for posting here in the Community @Gee4.

       

      You don't have to worry about the outdated bank balance since it does not affect your books. 

       

      A connectivity issue may prevent you from downloading transactions into QuickBooks.

       

      If you want to learn more about manually uploading transaction in QuickBooks, you can refer to this article: Manually upload transactions into QuickBooks Online

       

      Please comment below if you have confusion. I'd be glad to help you. Have a nice day!

      G
      Gee4
      March 28, 2020

      Hi Rubielyn_J,

      Thanks for your quick reply.

      Does this mean that specific account will always show the outdated bank balance amount (12/2/19)?

      I always uploaded manually w/o using WebConnect. Simply using CSV comma delimited file to upload info.I attached snapshot of the account in question. (Highlighted in blue) All 3 accounts come from the same bank. All uploaded the week of March 20. 

      Thanks again!

      Terms & ConditionsAccessibility statement