Reconciliation Beginning Balance Incorrect

Thank you for providing the complete details of your concern, @travesty. I'll be here to walk you through every step of the way to fix your opening balance in QuickBooks Desktop for MAC.

Reconciliation Discrepancies are caused by modified transactions and adjustments from previous reconciliation. We can review reports to determine the transaction that's causing the problem.

Beginning balance issues in QuickBooks Desktop (QBDT) may be due to one of the following reasons:

• No balance or an incorrect balance was entered when the account was set up.
• The file was converted from a different version of QuickBooks.
• Previously cleared and reconciled transactions were voided, deleted, or modified.
• And possible data damage

To isolate this, let's run your Reconcile Discrepancy report and locate what causing the discrepancy. I'll show you how.
 

1. Go to the Reports menu and select Banking.
2. Click Reconciliation Discrepancy Report.
3. Choose the appropriate account, then select OK. 
4. Identify the transaction/s causing the issue.

You can also pull up a Bank Account QuickReport or Audit Trail Report to locate the discrepancy or transactions that may have been cleared or uncleared unintentionally. To be guided, check out this article: Find reconciliation discrepancies (Mac).

Once you identify a discrepancy, you need to make the necessary corrections. If you need additional assistance about this, please consult your accountant. This way, we can ensure your account is well accounted for after making these changes. If you don't have one, you can visit our ProAdvisor page and look for one from there.

Once everything is in place, feel free to read this link for reference in reconciling your accounts flawlessly: Learn the reconcile workflow in QuickBooks.

Feel free to add a post or comment below if you have any other reconciliation concerns, I'll be always here to help you. Have a great day ahead! 

Thanks for your reply. After running the report, I show one transaction for the account in question for the amount that is causing the problem. The transaction is a check that is showing deleted. It is not in the account that has the incorrect balance or the account that it was paid for. Hope that makes sense...

How can I find the transaction in question?

Hi there, @travesty.

I'm glad you found the data that causes the issue on your reconciliation. I'm here to help you locate the transaction that shows as deleted in QuickBooks Desktop for Mac.

Missing or deleted checks might be causing a discrepancy in the ending balance of your reconciliation. We can run the Missing Checks report to find the missing data. 

Let's perform these steps:

1. Click Reports, click the Banking tab, then choose Missing Checks.
2. Choose the reconciled account and then press OK.
3. Review the missing checks report and check the transactions that are not on the bank statement. If you find such transactions, they should not be on your reconciliation list.

Additionally, we can generate a Transaction Detail Report to assist you in confirming the transactions that are modified.

Here's how:

1. Choose the Reports, then Custom Transaction Detail Report.
2. Select the Custom Dates in the Date pop-up menu.
3. Set the Date of the last reconciled transaction in the Entered/Last Modified field.
4. Choose OK to run the report.
5. Check if any transactions do not match the transactions on your bank statement. If yes, reach out to the person who made the edits to find the reason. 

I'm also adding this article if you encounter data issues within your QuickBooks Desktop for Mac: Resolve Potential Data Issues in QuickBooks.

Once again, thank you for visiting us today. I'm happy to assist if you still need to achieve tasks before the year ends. Happy holiday.