cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
usertinashezano
Level 1

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

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

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

 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.

usertinashezano
Level 1

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

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
Moderator

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

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.a27 2.PNG
  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!