Skip to main content
U
usertinashezano
April 22, 2023
Question

I am manually uploading bank transactions with a CSV, the BANK BALANCE is zero only IN QUICKBOOKS, balance is increasing

  • April 22, 2023
  • 1 reply
  • 0 views
I am manually uploading bank transactions with a CSV, the BANK BALANCE is zero only IN QUICKBOOKS, balance is increasing

1 reply

S
SarahannC
April 22, 2023

 Hello there, usertinashezano.

 

I'm here to share details on why the bank balance is showing zero in your QuickBooks Online account.

 

When the transactions are imported manually, it's normal to get zero for the bank balance. Also, the bank balance and QuickBooks balance might show an unequal amount if using a CSV file. This is because QuickBooks isn't having a direct connection to your bank data.

 

Connected accounts helps you get an accurate balance. The bank balance will also automatically change when receiving new transactions from your bank.

 

Also, you can keep your balances accurate by categorising and matching your transactions based on your bank statement. For guidance, you can visit this article: Categorise and match online bank transactions.

 

 Here's an article for tips about reconciling accounts: Reconcile an account in QuickBooks Online.

 

If you have more concerns about handling transactions, please know that I'm here to help you. Take care and stay safe.

U
usertinashezanoAuthor
April 22, 2023

Hi So are you saying if I am not connected to bank feeds the amount will stay as Zero. Also note this is a new client and 2nd year of trading

Angelyn_T
Angelyn_T
April 22, 2023

Thank you for your quick response, @usertinashezano. Let me give you additional insights about your Bank and QuickBooks Balances.

 

Yes. You're right. The Bank Balance will stay zero by default if you upload transactions manually through an Excel CSV file. It's because the bank is not connected, and the system doesn't have any idea of your actual bank data.

 

However, you can still compare the actual amount in your bank (statement) to the In QuickBooks balance section.

 

If you decide to link your account to our system to bring your entries automatically, you can follow these steps:

 

  1. Click on Banking at the left pane, then go to the Banking page.
  2. If this is the first bank account you’ve set up, select Connect account. Or select Link account if you already created one.
  3. Search for your bank, then follow the onscreen pop-ups to complete the process.

 

You may also review the resources from this article for more information: Connect bank and credit card accounts to QuickBooks Online. 

 

Once QuickBooks downloads your transactions, you need to review and categorize your transactions. To streamline the review process, you may create a bank rule that automatically categorizes transactions for you.

 

 Please leave a comment below if you have other questions while working with your bank entries in QBO. I'm more than happy to help you again. Have a good one!

Terms & ConditionsAccessibility statement