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.

Having the same issue.  What is the solution?

There is no issue - as far as I can tell.

What are you seeing that appears to be an issue?

I cannot get my balance sheet to reflect my reconciled balance although the reconciled amount matches my bank statement.

My end of year checking account is reconciled correctly and matches my bank statements, but it is not correct as of end of year on balance sheet.

There isn't a way to get your balance sheet to match a reconciled balance when it doesn't.

An account balance on a standard accrual balance sheet is the sum of all transactions in the account up to and including the date of the balance sheet. If you open most all account registers the balance as of the date of the balance sheet will be the same as the balance sheet. (AR and AP type accounts will be different for a cash balance sheet.)

At the same time, the reconciled balance is the sum of all cleared transactions in the account, regardless of date, which is a completely different concept.

I also don't understand why the Reports are run uncleared data that is often erroneous, duplicated, or invalid.

@DMTRI  If your reports are including data that is erroneous, duplicated, or invalid, it is generally because someone has entered data into QuickBooks that is erroneous, duplicated, or invalid.

Garbage in, garbage out, as they say.

That said, you'd probably be better off starting a different topic for that question. This topic revolves around user confusion regarding basic accounting concepts, not an actual error in QuickBooks.