Skip to main content
R
RitaSPL
April 17, 2020
Solved

Bank balance vs Quickbooks balance

  • April 17, 2020
  • 1 reply
  • 0 views

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?

 

Best answer by EmmaM

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?

 

 

1 reply

E
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

 

 

R
RitaSPLAuthor
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.

E
EmmaMAnswer
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?

 

 

    Terms & ConditionsAccessibility statement