Is there a way to sort the audit trail by user?

Precision Lawn Irrigation · ‎February 05, 2020

I was wondering if it's possible to sort out the audit trail by user's?

JasroV · ‎February 05, 2020

Currently, we're unable to run the Audit Trail report for a specific user. As a way around, you'll want to export the report to an Excel file and customize the report from there. Let me guide you how

In your QuickBooks Desktop (QBDT):

Go to the Reports menu.
Select Accountant & Taxes and choose Audit Trail.
Click the Excel drop-down menu and select Create New Worksheet.

For more details, feel free to read this article: Export reports as Excel workbooks in QuickBooks Desktop.

You can also check this article that can help guide you generate reports in your QBDT to show the information you need: Customize reports in QuickBooks Desktop.

Should you have other questions or concerns, you can always get back to us anytime. I'd be glad to help you and resolve it right away. Have a great day and take care!

View solution in original post

JasroV · ‎February 05, 2020

Hi there, @Precision Lawn Irrigation.

Currently, we're unable to run the Audit Trail report for a specific user. As a way around, you'll want to export the report to an Excel file and customize the report from there. Let me guide you how

In your QuickBooks Desktop (QBDT):

Go to the Reports menu.
Select Accountant & Taxes and choose Audit Trail.
Click the Excel drop-down menu and select Create New Worksheet.

For more details, feel free to read this article: Export reports as Excel workbooks in QuickBooks Desktop.

You can also check this article that can help guide you generate reports in your QBDT to show the information you need: Customize reports in QuickBooks Desktop.

Should you have other questions or concerns, you can always get back to us anytime. I'd be glad to help you and resolve it right away. Have a great day and take care!

Cynthia NTPHP · ‎June 07, 2021

Creating a worksheet doesn't really help? You can't sort by user because the user name doesn't appear on every line. Am I missing more instructions? Thank you.

JoesemM · ‎June 07, 2021

It's good to see you here, @Cynthia NTPHP. I appreciate you for following the steps shared by my colleague and their results.

I can see how it would be useful to have the ability to run the Audit Trail report for a specific user and appear on every line, I'd suggest sending feedback straight to our product developers/engineers to be considered in the future. They are constantly finding ways to improve our product and service to make QuickBooks work the way your business needs.

To send product feedback in QBDT:

Open your QBDT, then go to the Help menu.
Tap on Send Feedback Online, then Product Suggestion.
Choose a feedback type and product area on the QuickBooks Feedback window.
Enter your suggestion or feedback, name, and email address (optional), then click on the Send Feedback button.

I also encourage you to visit our Firm of the Future site to be updated with our latest news including product enhancements: Firm of the Future.

Additionally, I've added these resources to help you manage reports in QuickBooks Desktop:

If there's anything else that you need help with, please don't hesitate to post them here. Take care and keep safe!

Topics

Training

Community

Resources

Is there a way to sort the audit trail by user?