Banking

Thanks for reaching out regarding your issues with reconciling accounts in QuickBooks Desktop (QBDT), Brittny. I see how challenging it can be when balances don't align despite your efforts to match transactions correctly.

To address your question about the Verify and Rebuild Data in QBDT, the verify tool helps to identify common issues in a company file, while the rebuild tool is used to fix them. For more details, visit this article: Verify and Rebuild Data in QuickBooks Desktop.

Regarding your reconciliation concern, ending balance issues stem from the following:

• Someone entered an incorrect ending balance at the start of the reconciliation.
• Someone edited or deleted transactions that were already reconciled.
• There are missing or duplicate transactions in QB.
• Someone entered transactions into QB that hasn't cleared your bank yet.
• Someone adjusted your last reconciliation with a journal entry.

If you haven't already, ensuring your opening and beginning balances are correct is essential. Once you've confirmed this, you can look for changed, deleted, or added transactions by running these reports:

• Reconciliation Discrepancy: This report highlights any transactions that have changed since your last reconciliation.
• Missing Checks: This report shows missing checks, which can affect the ending balance of your reconciliation.
• Transaction Detail: Use this report to identify any transaction changes.

Additionally, you can look for reconciliation adjustments. Sometimes, users make a reconciliation adjustment to force an account in QB to match their bank records. However, doing this with your accountant's guidance is recommended, as this doesn't fix errors and can cause issues if mistakes are corrected later.

Here's how to review the account:

1. Navigate to the Lists menu and choose Chart of Accounts.
2. Pull up the Reconciliation Discrepancies account.
3. From the Dates field, set dates for your last few reconciliations.
4. If you discover any adjustments inaccurately affecting the account balance, reach out to the person who made them. Ensure your corrections are consistent with the modifications.

Once everything is sorted out, you can finish reconciling.

For more detailed information, refer to this article: Fix issues when you're reconciling in QuickBooks Desktop.

Moreover, closing your books is essential to prevent changes in your past entries.

Let me know if you have any other concerns or questions. It's always a pleasure to support you, Brittny. Take care.