Bank balance vs Quickbooks balance

RitaSPL · ‎April 17, 2020

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?

EmmaM · ‎April 17, 2020

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?

View solution in original post

EmmaM · ‎April 17, 2020

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

RitaSPL · ‎April 17, 2020

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.

EmmaM · ‎April 17, 2020

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?

RitaSPL · ‎April 17, 2020

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!

EmmaM · ‎April 17, 2020

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

RitaSPL · ‎April 17, 2020

Ok, thank you Emma.

Have a nice weekend.

EmmaM · ‎April 17, 2020

@RitaSPL Thank you, you too.

Topics

Training

Community

Resources

Bank balance vs Quickbooks balance