Skip to main content
February 10, 2020
Question

How can I update my bank balance to match quickbook balance ?

  • February 10, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

February 10, 2020

Hello samira-bartoulma,

 

When you have your bank account connected through the bank feed, you'll see a Bank Balance and an In QuickBooks. When you've got all the necessary transactions entered in QuickBooks Online that are coming in from your bank, the two numbers should balance. When they don't, there are a few things to consider, from both sides.

 

The first thing to do is make sure that your transaction entries match between QuickBooks and the bank. If you haven't reconciled your account in a while, this is a good place to start. Reconciling an account is quite literally comparing what's entered in your books to what's hit your bank account and is a useful way to make sure you have the correct information in both places. Learn more here: Reconcile an account in QuickBooks Online

 

If you're not ready to reconcile yet, you can simply compare the transactions in QuickBooks to what's in your bank account by pulling up the account register in QuickBooks to compare it against your banking website's information. You can get to the account register by going to Accounting > Chart of Accounts > Account history for the account in question.

 

In the event you're missing transactions in QuickBooks, add them. If you've got duplicates, delete them. Here are a couple articles that may help.

An accountant or bookkeeper can help you with figuring out what transactions should be there and which shouldn't. QuickBooks Online's My Accountant tab can help you connect with an accountant. You can add one you're already working with as an accountant user or use the Find a pro to help feature to find someone near you.

 

Best of luck and have a great week. :)

February 11, 2020

Thanks for the answer but for more info, actually am not connecting my bank account to QuickBooks, I just used to upload info from my bank by browsing the file.

But after, I stopped uploading and begin to enter all transactions manually, so the problem is that since I stopped that upload I find that difference between Bank Balance and QuickBooks balance although my QuickBooks balance is similar to my bank account, all the problem is that since I stopped uploading bank files the bank balance in QuickBooks stopped updating and it gives me that the last update was 105 days ago means the last time I uploaded bank files.

I am sure that the problem is that I stopped uploading files from bank but we should find a solution because I want to continue entering manually my transactions, in plus I tried to add  the green square (Manually added from bank feeds) to the manually added transaction to could solve the problem but I couldn't , so please I need an answer for this detailed issue.

 

Thanks You

February 11, 2020

Hello again. I appreciate the clarification of how you've been entering our bank transactions into QuickBooks. Typically the Bank Balance only displays and updates when there has been a bank feed connection like I was talking about, so you may have had a connection at one point. Otherwise, the system was behaving a bit oddly for you to be able to see it with only a manual upload of the file. All the same, a bank feed connection is needed to move forward with having the Bank Balance portion update.

 

I recommend leaving feedback for our product developers about this since it's a feature you're looking for in the program. Take a look at this article to learn how it's done: How do I submit feedback?

 

I'm here if you have further questions.