Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
Hello, Anna_Reznik.
You can check the bank’s current balance in your Chart of Accounts. Here’s how:
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.
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.
This is bad.. Xero shows bank balance based on the loaded 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.
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.
You can request for those banks to be added on the list of supported financial institutions, Anna_Reznik.
Here's how:
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.
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.
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.
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!
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!
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.
Do you think you could help me? I'm actually having the opposite problem. There should be a 0 bank balance because we uploaded statements for a credit card but there is a bank balance reflected and it is wrong. How can I fix this? I've deleted everything and re-uploaded twice and a balance keeps coming up. Should we ignore and go with the Quickbooks balance? How will this throw off reconciling that acct.?
Hello there, sgriffin.
The bank balance is your bank's actual balance from the last bank feed update. There can be outstanding transactions that are causing the bank balance not equal to zero. In reconciling an account, we rely on your bank statements and it should match the transactions posted in QuickBooks. You can check out the Fix issues the first time you reconcile an account on QuickBooks Online page that will help you manage your bank account balances.
Once you have your bank or credit card statement, you can start adding and matching your bank transactions and then reconcile them. Let me show you how:
For the detailed steps, you can click here.
Keep me posted if you need more help. Take care!
why at my bank balance acc show nothing but balance in quickbook show the correct amount.
how to make balance under bank balance show amount?
Thanks for joining us here today, @VENCETEO.
I'll walk you through the steps on how you can see the correct bank amount. All you have to do is update your bank account manually in QuickBooks.
Here's how:
Want more details? Check out this guide: Download the most recent bank and credit card transactions in QuickBooks Online.
In case you hit a snag, you'll want to refer to this article for the recommended solution: What to do if you get a bank error or can't download transactions in QuickBooks Online.
I'll be around if you still have questions about banking or bank transactions. Just drop them in the comment section below and I'll be happy to answer them for you. Take care and have a nice day ahead.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here