How do I identify backdated entries?

I'm here to help you sort things out, Merc1976.

In QuickBooks Desktop, eliminating or adding a reconciled transaction will affect your beginning balance for the next reconciliation. You can pull up and run any of these reports to locate the difference.

Reconcile Discrepancy report:

1. Go to the Reports menu, then select Banking, then Reconciliation Discrepancy.
2. Choose the appropriate Account, then select OK. You now have a list of transactions that were changed since the last reconciliation. Use this report to identify the transaction/s causing the issue.
3. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

Audit Trail report:

1. Go to the Reports menu, then select Banking, then Previous Reconciliation.
2. Select the appropriate account being reconciled.
3. Select the most recent statement date. Choose Transactions cleared at the time of reconciliation. (Report is displayed as a PDF file) then Display.
4. Note the statement and the reconciliation creation date.
5. Go to the Reports menu, then select Accountant & Taxes, then Audit Trail.
6. Set the Account filter to the account being reconciled.
   1. Select Customize Report.
   2. Go to the Filters tab, then choose Account from the filters.
   3. From the Account drop-down, select the appropriate account.
7. Go to the Display tab. Set the Date filter with the From field blank and the To date set to the statement date. Select OK.
8. Set the Entered/Modified filter with the From date set to the previous reconciliation creation date from the PDF, and the To field as today's date.
9. See if any of the transactions in the report can account for the discrepancy.

For further troubleshooting steps, see this article: Fix beginning balance issues in QuickBooks Desktop.

I'm including these resources to learn more about the reconciliation process in QuickBooks:

• Fix issues when you're reconciling in QuickBooks Desktop
• Get reports for previous reconciliations in QuickBooks Desktop

Let me know how it goes by leaving a reply below. I'll zip right back to help you out.

Hi, thanks for the comprehensive reply!

There were no reconciliation discrepancies and when I went to the audit trail there were no prior statements and buttons were grayed out.

Was able to find the difference in "Closing Date Exception Report" which shows when it was posted and what was the effective date of the posting.   So, all good!

Thanks!

Good to hear from you again, @Merc1976.
 
You're most welcome. I also appreciate your taking the time to post this and letting me know that the issue got resolved.
 
As always, Community is full of experts possessing knowledge in all facets of QuickBooks, so please reach out to us here if there's anything you need. We're always happy to help you along your road to victory. Wishing you and your business continued success!