cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Bank balances for banks with manually uploaded statements

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?

Solved
Best answer April 24, 2019

Best Answers
Highlighted
QuickBooks Team

Bank balances for banks with manually uploaded statements

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

View solution in original post

13 Comments
Highlighted
Anonymous
Not applicable

Bank balances for banks with manually uploaded statements

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. 
 

Highlighted
Level 2

Bank balances for banks with manually uploaded statements

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?

Highlighted
Anonymous
Not applicable

Bank balances for banks with manually uploaded statements

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. 


 

Highlighted
Level 2

Bank balances for banks with manually uploaded statements

This is bad.. Xero shows bank balance based on the loaded statements.

Highlighted
Anonymous
Not applicable

Bank balances for banks with manually uploaded statements

Hello, Anna_Reznik. 

 

You might want to exclude the transactions that are downloaded manually and let the system download your transactions through direct connect. This way you’ll be able to see information under the BANK BANLANCE field. 


Aside from that, you can also make sure that you’ve downloaded and added all the transactions from the bank. This will assure you that the QUICKBOOKS BALANCE would be the same as BANK BALANCE and will keep you from any reconciliation discrepancy. 


Don’t hesitate to visit us again if you have other questions. 
 

Highlighted
Level 2

Bank balances for banks with manually uploaded statements

Quick books hasn't got direct connect for Transferwise, Epayments, Rietumu bank and some other banks and payment providers. I can only manually upload statements and this creates a difficulties for our business connected with possible errors and lack of ability to see the bank balance.

Highlighted
QuickBooks Team

Bank balances for banks with manually uploaded statements

You can request for those banks to be added on the list of supported financial institutions, Anna_Reznik.

 

Here's how:

  1. Click Banking.
  2. Go to the Banking tab, then click Add account.
  3. Enter the name of the bank and if our system is unable to find it, you'll get a message, "Hmm, we can’t find [name of the bank you entered] in our list of supported banks".
  4. Click Request support for your bank.
  5. Enter the bank's URL in the field, then click Request.

For now, you can continue importing the bank transactions manually.

 

Let us know if you have more questions. We'd be happy to answer them. 

Highlighted
Level 2

Bank balances for banks with manually uploaded statements

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

Highlighted
QuickBooks Team

Bank balances for banks with manually uploaded statements

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

View solution in original post

Highlighted
Level 2

Bank balances for banks with manually uploaded statements

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.

Highlighted
QuickBooks Team

Bank balances for banks with manually uploaded statements

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!

Highlighted
Level 2

Bank balances for banks with manually uploaded statements

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!

Highlighted
QuickBooks Team

Bank balances for banks with manually uploaded statements

It depends on your bank, Gee4.

 

I'll share some information about how banking works in QuickBooks Online.

 

Your financial institution controls what and how information is received by QuickBooks. As what my colleague Rubielyn_J has mentioned, Rubielyn_J, it could be that there's a connectivity issue or your bank's website is experiencing technical difficulties in transmitting the data into your QuickBooks account.

 

In addition, if a certain transaction hasn't been cleared in your bank yet, the balance of your bank connected to QuickBooks will also not be updated.

 

When we connect our bank, QuickBooks Online automatically downloads the latest available transactions every night around 10 PM PT. For most banks, transactions are usually available for QuickBooks to download the day after they post to your bank's website. Some may take a little longer depending on your bank.

 

It's highly recommended that we should coordinate with your bank before you set up online banking. This way, we’ll be able to know what connection method they support, what the fees are (if there's any), and what information you need to set up and use the feature.

 

I've included an article that will guide you in handling your bank transactions: Assign, categorize, edit, and add your downloaded banking transactions.

 

Do you have other questions in mind? You can leave them below and I'll make sure to get back to you as soon I can.

 

Need to get in touch?

Contact us