cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Bank balance vs Quickbooks balance

Hello, I need some help regarding the bank balance. We have an account for a long time ago now and we always import bank transactions from .CSV to QuickBooks. In the last time that i import the statement the bank balance change for 0 and the quickbooks balance is correct.

In the .CSV file appears the balance in the bank but when we import the .CVS file we just have 3/4 columns. However is the first time that this bank balance is 0.

 

How can i fix this?

 

7 REPLIES 7
Highlighted
QuickBooks Team

Bank balance vs Quickbooks balance

Hi RitaSPL

 

Do you use the reconcile tool option in the cog in the top right? Does that appear to be correct?

Usually, the bank balance section only updates if there is a live bank connection and will update them in the in Quickbooks balance if you are adding through an uploaded CSV

To confirm are you saying that 3 out of the 4 columns uploaded and one of the amount columns did not?

 

Thanks

 

 

Highlighted
Level 2

Bank balance vs Quickbooks balance

Hi Emma,

 

Thank you for your response. To update this account i use the File upload to add a .csv file. In account history if i select the reconciliation button i put the ending balance and date correct and everything is ok. I have a 0 difference - all done. But the bank balance appears at zero, which is not the same as the balance of quickbooks. Is the first time that this happen.

When I talk about the columns it is just to point out that we do not have a column for the amount that was in the bank balance.

Highlighted
QuickBooks Team

Bank balance vs Quickbooks balance

Hello RitaSPL

 

The banking section can not import a running bank balance through CSV even if that shows on the bank statement you download. It will create a balance in the chart od account>account history when a transaction is added from the banking section or from physically creating an expense in suppliers for example.

If the in QuickBooks balance is incorrect and the bank balance in the product is zero there is not a way to manipulate that figure if you are using a spreadsheet upload.

 

I apologise if we are misinterpreting your query. We would expect the balance to be zero on account that does not have a live bank connection as that is where QuickBooks would get that information from. When you had a balance in the past in bank balance did you have a bank connected?

 

 

Highlighted
Level 2

Bank balance vs Quickbooks balance

I need to check, but yes, I think in the past we were able to connect this account.

I will try to connect again.

 

Thank you!

Highlighted
QuickBooks Team

Bank balance vs Quickbooks balance

Hi RitaSPL

 

Thanks for letting us know. If you need any help with connecting the bank, just reach out back to us here in the Community

 

Emma

Highlighted
Level 2

Bank balance vs Quickbooks balance

Ok, thank you Emma.

 

Have a nice weekend.

Highlighted
QuickBooks Team

Bank balance vs Quickbooks balance

@RitaSPL Thank you, you too.