Banking

Thanks for reaching back out, @Northsound.

I’m happy to help you fix the reconciliation discrepancy. Here’s how to find and fix issues so you can finish reconciling. 

Step 1: Review your opening and beginning balance

Once you know these are accurate, you can start looking for other issues.

Step 2: Look for changed, deleted, or added transactions

There are several reports that show you if anything has been changed, deleted, or added. You can run a Reconciliation Discrepancy Report. This report shows any transactions that were changed since your last reconciliation. 

1. Go to the Reports menu. Hover over Banking and choose Reconciliation Discrepancy.
2. Select the account you're reconciling and then click OK.
3. Review the report. Look for any discrepancies.
4. Edit the transaction as needed.

You can also run a Missing Checks Report and a Transaction Detail Report.

Let me guide you on how to run a Missing Check Report: This report shows any missing checks that may throw off the balance of your reconciliation.

1. Locate the Reports menu. Hover over Banking and select Missing Checks.
2. Go to the account you're reconciling and then pick OK.
3. Review the report. Look for any transactions on the report that aren't on your bank statement. If they aren't on your bank statement, they shouldn't be on your reconciliation.

Running a Transaction Detail report shows if any transactions have changed.

1. Find the Reports menu. Hover over Custom Reports and go to Transaction Detail.
2. Locate the Display tab.
3. In the Date From field, choose the earliest date in QuickBooks for the account
4. Choose the Date to the field, select the date of your last reconciliation.
5. Go to the Filters tab.
6. In the Account field, select the account you're reconciling
7. In the Entered/Last Modified field, set the Date from to the date of your last reconciliation. Then set the Date to the field to today's date.
8. Select OK to run the report.
9. Look for any discrepancies or transactions that don't match what's on your bank statement.

Step 3: Look for reconciliation adjustments

You’ll need to review the account and make sure no one made any inaccurate adjustments.

1. Go to the Lists menu and select Chart of Accounts.
2. Open the Reconciliation Discrepancies account.
3. From the Dates field, set dates for your last few reconciliations.

Once done, you can Finish Reconciling.

Let me know if there’s anything else I can help you with.