cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

How do I identify backdated entries?

Quite new to Quickbooks.

 

Had reconciled an account for end of year 2019.   The balance has changed.    How do I identify the transactions that were backdated?

 

I was able to find them but I don't understand why the account balance changed.   

 

A debit/credit for 101,971.20 was eliminated, a debit/credit for 113,628.00 was added.   Difference is 11,656.80 which is what I'm looking for.    However, if debits/credits match why did balance change?

3 Comments
Highlighted
Moderator

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:

 

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

Highlighted
Level 1

How do I identify backdated entries?

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!

Highlighted
QuickBooks Team

How do I identify backdated entries?

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!

Need to get in touch?

Contact us