Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
May 5, 2020
Question

Audit Trail Report Quickbooks Enterprise Solutions

  • May 5, 2020
  • 2 replies
  • 42 views

Can you generate an Audit Trail report for a specific transaction in Quickbooks Enterprise Solutions?

I am looking for the audit trail of an Accounts Payable invoice.  I do not know when it was entered/last modified (which is how the main Audit Trail report is generated).  I only have the invoice information (invoice date, amount of transaction etc.)

2 replies

Rose-A
Level 10
May 5, 2020

Sending good vibes to you, CL8801.

 

Helping you run the Audit Trail report for a specific transaction in my priority. You can customize and filter the report to locate the specific invoice you're looking for.

 

Here's how:

 

  1. Click Reports at the top menu bar and choose Account & Taxes.
  2. Select Audit Trail.
  3. On the report screen, click Customize Report.
  4. Go to the Filter tab and search for Transaction type.
  5. Choose Invoice and hit OK.
  6. Filter the dates.

You can go through these articles to help guide you in customizing a report in QuickBooks as well as searching related articles for your future task:

 

Customize reports in QuickBooks Desktop

Help articles

 

If there's anything else you need, please let me know. I'd be more than willing to lend you a hand.

BigRedConsulting
Level 15
May 5, 2020

Yes, in most cases you can filter the report for one transaction by using a combination of date and Number (the document number)  filters.

 

Filter the report and set the date range to just the date of the Bill and then also filter by "Number" putting the bill's number in the filter.

November 4, 2021

What about auditing the trail of manual changes to employee vacation hours available. Is there a way to track who and when a change to this cell "Available hours" occurred and when if it was done manually.

Level 9
November 4, 2021

Hello there, rafters8.

 

I can show you how to run reports showing your employee's vacation and sick time balance, vacation/sick time used, and maximum hours in QuickBooks Desktop.

 

The Audit Trail report is transaction-based. Changes to transactions will only show on the report. While the option to manually add columns and filters to show who and when the available hours were changes is unavailable, you can consider running the Employee Contact List. Then, we can customize your report to show the vacation/sick time balance.

 

Here's how: 

 

  1. Go to the Reports menu, then select Employees & Payroll.
  2. Click Employee Contact List.
  3. Select Customize Report.
  4. Go to the Display tab, then select the following information for Columns:
    • Sick limit
    • Sick available
    • Sick used
    • Vacation limit
    • Vacation available
    • Vacation used
  5. Click OK

You can also check this article that can help guide you to 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!