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?
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?
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.
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?
I need to check, but yes, I think in the past we were able to connect this account.
I will try to connect again.
Thanks for letting us know. If you need any help with connecting the bank, just reach out back to us here in the Community
Ok, thank you Emma.
Have a nice weekend.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.