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

audit trail overwrite errors

How is it that the audit trail overwrites the 'Entered/Last Modified'(date) and 'Last Modified by' (user) of the last PRIOR transaction with the LATEST 'Entered/Last Modified'(date) and 'Last Modified by' (user)??


audit trail overwrite errors

Thanks for dropping by in the Community, @cindella.


Let me share a few things about the Audit Trail report in QuickBooks Desktop. When a user, makes changes or deletes a transaction, this won't overwrite the last modified date. It'll just create a new line on the report.


Since you're getting this unusual behavior, I'd recommend attempting to verify/rebuild your company file. This way, you can check if there are any data issues and fix this using the tool. You can refer to this article for the detailed steps: Verify and Rebuild Data in QuickBooks Desktop.


Correcting any data issues will surely get you back to business again.


If you have follow-up questions, do let me know. I'm always around to help.

Level 1

audit trail overwrite errors

I did a test run of the 'Verify & Rebuild' processes on a copy of my file - it did not fix the problem of the latest user and date overwriting the most recent user and date in the audit trail. Please see the redacted screen shots from the audit trails we ran before and after the process.

Level 1

audit trail overwrite errors

Verify and Rebuild Data did not fix the problem. Not only did it not correct the prior overwrites that happened on or before 4/4/2020 and continued to be seen after that; it is still occurring to the file after running the rebuild as recommended.  Please see the attached file with redacted samples of the audit trail reports I have saved that show the issue still exists.

QuickBooks Team

audit trail overwrite errors

Thank you for following the troubleshooting steps given above, @cindella.


Since Verify and Rebuild was not able to correct the data issue, I recommend contacting our Phone Support Team so they can pull up and check your data file regarding this unusual behavior. They have the proper tools to check the issue on your data and give you an accurate resolution.  


To reach them, here’s how.


  1. Open QuickBooks.
  2. Go to Help, then select QuickBooks Desktop Help.
  3. Select Contact Us.
  4. Give a brief description of your issue, then select Continue.
  5. We’ll provide you a few support options. Select which one is best for you.


Please check out this article so you’ll be guided on the Support hours. Support hours and types


Please don’t hesitate to leave a comment below if you have any other questions. Take care and keep safe.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up