Balance Sheet report differs from Reconciliation

Let's perform some troubleshooting steps to get this sorted out, FMtgSA.

The reconciliation has two balances. The Ending Balance is from your bank statement, whereas the Beginning Balance is from your register. If you delete, un-reconcile, add and reconcile a transaction, or edit a reconciled transaction, the beginning balance will change. This will cause a difference when reconciling your account. The account balance in the Balance Sheet will change as well, except if you just un-reconcile a transaction.

To resolve this, you'll want to correct the Beginning Balance:

• Compare the transactions in your bank statement and your register, and make sure they are the same. If there are duplicates or missing ones, delete or recreate them. Then, mark them as reconciled.
• Check your Reconciliation Discrepancy Reports to see if there are reported changes. You can click on the transactions to correct them.
• Re-reconcile any unreconciled past transactions that show on the report by placing a checkmark in the field indicated. Please refer to the screenshots.

Though, there are different ways to fix this depending on what's causing the issue. We can try reviewing the Audit Trail to see if there are reconciled transactions that were deleted or edited. Here's how:

1. Click the Reports at the top menu and select Accountant & Taxes.
2. Select Audit Trail and click the Customize Report button.
3. Go to the Filters tab and set a date range.
4. Click OK and look for the transaction.
5. Take note of the details of the transaction, and recreate it.

If the same thing happens, there may be damaged data on the company file you've been working with. We can run the Rebuild Data tool is built-in to fix any company file data issues. Just follow the steps and detail in the Fix data damage on your QuickBooks Desktop company file article. We can also repair your QuickBooks Desktop to fix any damaged components in the software. 

To learn more about how reconciliation work in QuickBooks, check out these articles for reference:

• View Previous Bank Reconciliation Reports
• Resolve Common Issues on Previous Reconciliation Report
• Zero or Incorrect Beginning Balance in the Begin Reconciliation Window

I want to make sure everything is taken care of for you, please let me know how it goes or if you have any other issues or concerns. Just leave a comment below and I'll get back to you. Take care always.