I have a negative cleared balance at year end in the bank reconciliation, however the bank statement actually agrees to the bank account in the chart of accounts

Hello Elitemiddx, Thanks for reaching out to the Community! If the bank chart of account is correct but the reconciliation is not it would suggest that there are transactions that have not been added to the reconciliation(by a banking match for example) or that transactions that were in the reconciliation have been removed and then re-added as a transaction but not re reconciled. If you go to the banking chart of account and in the top left select the funnel symbol and then filter by the dates of the reconcile and in the reconcile status filter dropdown select the not reconciled. Do transactions show that should be part of the reconciliation for that period? Thanks

Hi Emma.

Thanks for you reply. I had already tried that and nothing shows.

Is there anyway to edit the cleared balance statement?

Thanks

Hello Elitemiddx-gmail so there is no way to be able to edit the cleared balance statement in Quickbooks. 

Hello Community Users, In the case the reconciliation balance is not correct but the bank chart of account is and there's nothing you can see that has not been reconciled in the chart of accounts when searching the filter for not reconciled and there is no deletions/edits of amounts from a previous reconcile. The best solution is to go to the reconciliation history and find the reconciliation where the balance was correct. Then ask the accountant user to undo the reconciles up to that date and go back through those ones. 

If this is the only reconcile you have done and the start balance is correct we'd suggest undoing it and then running the reconcile in shorter periods say for example monthly . Then it will be clear at what point it has deviated from the bank balance