Skip to main content
B
biffdiff
May 5, 2021
Solved

Current cash balance doesn't show balance of all accounts?

  • May 5, 2021
  • 1 reply
  • 0 views

On my QB Dashboard under cash flow the current cash balance shown simply reflects what I have in my HSBC accounts. Both of these accounts are under 'Transactions' where they get synched feeds from my bank.
But I also have other bank accounts set up. They are categorised exactly the same as my HSBC ones but the money in them is not included in the cash balance. Can't figure out why.
On the right hand side of the dashboard where it has a list of all 'Bank Accounts' they are showing, including Paypal etc.

Best answer by EmmaM

Hi,

If you mean via the bank connection which automatically downloads data from the bank, then yes. The two bank accounts that are connected seem to represent the cash balance.
But on the right hand side of the dashboard you see a list of all 'Bank Accounts' and all of them are shown there including Paypal etc. So QB does identify them as bank accounts but just doesn't want to use their balance towards the current cash balance.
Thanks


Hello Bifdiff, On the dashboard, if you click on the figure for the current cash balance it reverts to those 2 accounts? We'd like to look at this further but we'd need to look at screenshots if you do not wish to post them in the public forum can you DM/PM FaceBook or Twitter under QuickBooks UK with a screenshot of the cash balance you are seeing and the transactions which show behind it and one of the list of accounts you have added so we can see why there is a discrepency.

1 reply

MJoy_D
MJoy_D
May 6, 2021

I can share some information about bank connections in QuickBooks Online (QBO), @biffdiff. 

 

The information that's being downloaded in the Banking or Transactions tab always depend on how a bank shared it with QuickBooks. Once these transactions are transferred, QuickBooks automatically analyze its information. 

 

If you have missing transactions from the bank, you can manually download the transactions from the bank and then upload the file to your account.

 

Download bank transactions:

 

  1. Go to your online banking account to get your file.
  2. Check or follow your bank’s instructions to get a copy of the data and then save it on your computer.
  3. Ensure that the data range is at least one day before your oldest transaction to avoid duplicates.
  4. Please take note of the supported file format and size. It should be either a Comma-Separated Values (CSV) or a QuickBooks Online (QBO) file. 
  5. Download your transactions and save the file to your desktop. 

 

To upload the file to your QuickBooks account: 

 

  1. Go to the Banking menu and select the bank where you’re uploading the transactions from the Banking tab.
  2. Click the Update drop-down and select File upload.
  3. On the window that appears, click the Browse button and choose the file that you’ll be downloading.
  4. Click on Open, then Next.
  5. Follow the onscreen instructions. Match the columns on the file with the banking fields in QuickBooks, then select Next.
  6. Click on Let's go. QuickBooks will now add the transactions to your account.

 

Check this article for more information: Manually upload transactions into QuickBooks Online. From here, you can now categorise and then reconcile the transactions.

 

Let me know if there's anything else that I can help with your bank transactions. I'm always here to assist. Take care and have a great rest of the day!

B
biffdiffAuthor
May 6, 2021

Hi Mary,

Thanks for your response. I'm not missing any transactions. All the accounts and transactions are there in quickbooks and the accounting is correct. Simply the dashboard where it shows the current cash balance only reflects the balance of two of the bank accounts. That's the issue. 
The only difference I can see in these two bank accounts from the others is that they are under 'Transactions' which get synched. That's the only reason I mentioned it.
If I transfer from one of the bank accounts, that is reflected in the current cash balance, to another bank account, then the current cash balance drops by that amount. Even though the company still has the same amount of cash and it hasn't been spent anywhere.
Thanks.

A
Ashleigh1
May 6, 2021

Hello Biffdiff, can we ask you are some of your banks connected via the banking section and others aren't? 

Terms & ConditionsAccessibility statement