TROUBLE RECONCILING

A beginning balance discrepancy in QuickBooks is generally caused by a previously reconciled transaction that was edited, deleted, or unreconciled, and can be fixed by opening the Reconciliation Discrepancy Report by clicking the We can help you fix it alert and correcting the flagged transactions until the difference reaches CAD $0.00.

Here's how:
 

1. On the Reconcile page, select the We can help you fix it from the alert. This opens the Reconciliation Discrepancy Report.
2. For each transaction listed, select View to see its change history, then check the Change Type column to understand what happened.
3. Apply the correct fix based on what the Change Type column shows:

• If the amount or account was changed, select the transaction, click Edit, correct the details to match your original bank statement, then click Save and close.
• If it was unreconciled in the register, reconcile it through the normal reconciliation flow, or manually mark it with an R in the checkmark column via Account history. 
• If it was reconciled in error, select the transaction and clear the checkmark column (blank or C) to remove it from the reconciliation, then Save.
• If it was deleted, recreate the transaction exactly as shown on the report, then manually mark it R and Save.
  ​​​​4. Once all corrections are made, confirm the difference on the report shows CAD $0.00, then select Resume reconciling to continue.

For a full walkthrough, visit this article: Fix issues with your beginning balance for accounts you've reconciled before.

If you're also looking to strengthen your reconciliation foundation, Learn the reconcile workflow is a great resource. And if things still feel off after working through these steps, an accountant can help review your books to make sure everything is balanced correctly.

Feel free to reply below if you have any further questions.