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

Audit Trail Flaw

This post is coming from an auditor's view point when using the audit trail.

 

I came across this flaw after spending several hours searching for an invoice adjusted by the client that was tossing out retained earnings.

 

The audit trail has no way to filter for what was previous in another year and been edited into a current year.

The issue has arose when a client adjusted (edited and not deleted) an invoice that was in the 2017 Dec year end to March 2018. This tossed out retained earnings. So, after spending several hours tracking down this edit and chasing a couple of red herrings, I realized in Sage50, I would have just tossed on "Show Corrections" and the "Audit Trail" they have there is a journal entry made for every change, so I could have seen at the bottom of their General Ledger a reversing entry for this invoice and to whom. This type of function does not seem to exist in QBO.

 

In QBO if they adjust the invoice date to the new year there is no "This was the previous invoice date in the search". So in essence if they adjust the invoice we need to know which invoice it is or go through every single invoice in the new year.

 

This seems like a major flaw in an "audit trail".

 

 

Now I understand we can "lock" previous years, but this is not always a practical solution for some clients. Or these changes could have been made between the "initial data pull" and the entry of year end adjustments and subsequent lock.

 

I am new to QBO and am still learning the ropes, but this seemed like a serious issue, as this was one invoice, I have had multiple clients back date dozens of sales and invoices before and if they were on QBO I would have been spending hours on fixing this.

 

Additionally, printing the Audit Trail "Comparison" is flawed as well, it only prints essentially whats on the screen (has the scrolling bar on the right of the PDF), this comparison would be very helpful to have for supporting documents, but in its current printable form is useless.

 

And when printing the audit trail as a whole, does not take into account the sorting being applied to the audit trail and sorts it back to the original report.

 

Lastly, I am vaguely aware of the prior year locking function, but this should not be the "well just use that to prevent these issues" crutch for a flawed system.

 

Hope this helps you improve your system as I expect cloud bookkeeping to be the norm going forward in the industry and the old dogs will need to adapt.

Solved
Best answer January 30, 2019

Best Answers
Malcolm Ziman
Level 10

Audit Trail Flaw


@ahodgson wrote:

 

The audit trail has no way to filter for what was previous in another year and been edited into a current year.

The issue has arose when a client adjusted (edited and not deleted) an invoice that was in the 2017 Dec year end to March 2018. 

 


 

There is no such flaw in the QBO Audit Log

 

Every change made to a transaction is logged, including a date change. It makes no difference what year is used in the date.

 

Of course if an invoice is deleted you won't see it any reports, but you can filter the audit log for deleted/voided transactions, in whatever time period you want

 

 You can also run transaction reports where you can filter using these dates:

Create Date = Last year

Last Modified Date = This Year

 

 

View solution in original post

14 Comments 14
Rose-A
Moderator

Audit Trail Flaw

Sending good vibes to you, ahodgson.

I appreciate the details you've provided and taking the time to post here in the Community. It's my priority to get you pointed in the right direction.

 

I can definitely see how this feature would be useful, I would highly recommend submitting feedback and suggestions regarding this option to our product developer. This lets us know what enhancements you'd like to see in the program soon.

 

I can pass along all the feedback you have to the appropriate channels so you're able to reach a point of resolution as quickly as possible. We aren't able to tell when a feature will be available. We share recent happenings and future developments on our blog. Through this, you're able to get the latest news about QuickBooks and what our Product Care Team is working on.

 

You may find these articles helpful:

 

 

As always, you can also reach out to our Customer Care agents if you need additional help.
 
Here's how you can reach them:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

I'll be here if you have additional questions. You have a wonderful day.

Malcolm Ziman
Level 10

Audit Trail Flaw


@ahodgson wrote:

 

The audit trail has no way to filter for what was previous in another year and been edited into a current year.

The issue has arose when a client adjusted (edited and not deleted) an invoice that was in the 2017 Dec year end to March 2018. 

 


 

There is no such flaw in the QBO Audit Log

 

Every change made to a transaction is logged, including a date change. It makes no difference what year is used in the date.

 

Of course if an invoice is deleted you won't see it any reports, but you can filter the audit log for deleted/voided transactions, in whatever time period you want

 

 You can also run transaction reports where you can filter using these dates:

Create Date = Last year

Last Modified Date = This Year

 

 

qbteachmt
Level 15

Audit Trail Flaw

@Malcolm Ziman is correct; you have two Date Controls that matter. For instance, if you know the invoice number, set the Date to All = all transactions within this date range, and the Modified to All = any changes ever made, then filter on that one NUM as that invoice.

ahodgson
Level 1

Audit Trail Flaw


@Malcolm Ziman wrote:

@ahodgson wrote:

 

The audit trail has no way to filter for what was previous in another year and been edited into a current year.

The issue has arose when a client adjusted (edited and not deleted) an invoice that was in the 2017 Dec year end to March 2018. 

 


 

There is no such flaw in the QBO Audit Log

 

Every change made to a transaction is logged, including a date change. It makes no difference what year is used in the date.

 

Of course if an invoice is deleted you won't see it any reports, but you can filter the audit log for deleted/voided transactions, in whatever time period you want

 

 You can also run transaction reports where you can filter using these dates:

Create Date = Last year

Last Modified Date = This Year

 

 


Hello Malcolm,

 

When I said flaw, I felt it was something that makes the Audit Trail less useful and therefore less used. Not a flaw in the sense that the Audit Trail was not logging absolutely every change.

 

The last bit that you mentioned is exactly the fix I was looking for and didn't notice that there was filter for Year Created, if they simply added this filter to the audit trail it would solve the issue I was mentioning.

 

Thanks,

Adrian

Jain
Level 3

Audit Trail Flaw

I'm also seeing an audit trail flaw, kinda.  Or maybe its just a "QB sensitivity issue"?  Curious if anyone has seen what I'm about to describe.  Ultimately it seems to come down to a "distinction without a difference" but some of my users are bothered by it!  NOTE:  Using QB Enterprise Desktop

 

So here's the deal:

User A sets up an invoice, saves, and closes.  The next day, User B accesses the same invoice to attach a copy of the Customer's PO.  Or maybe User B corrected the spelling of something.  Minor stuff that has no material impact on the transaction --- the financial aspects of the transaction --- whatsoever.

 

When the audit trail is run, of course, it will show what User A originally set up and also it will indicate there's been a change by User B.  No problem so far. 

 

However, the link to the Income account under the original User A version shows the full Parent and Sub-Account name (e.g., 4000.00 REVENUE:  4010.00 Product Sales).  What the audit trail shows as a change made by User B is that now the full Parent and Sub-Account name are abbreviated, so the report indicates the change that occurred is that now the Item used in the original invoice by User A is linked to "4010.00 Product Sales"

 

Distinction without a difference? 

 

Ultimately the target income acc't is the same (4010.00 Product Sales) except we're not sure why QB would even register this as some sort of change when (a) there was no change to the Item at all; and (b) its not really a change!

 

I've checked the chart of accounts and drilled down to my income, COG, and inventory accounts and thankfully not seeing any duplicates or other mischief that would set off alarm bells.

 

Can anyone explain?  I think its more of a curiosity question at this point.  Thank you kindly!

MirriamM
Moderator

Audit Trail Flaw

Hello there, @Jain.

 

Thanks for providing detailed information about your concern. 

 

QuickBooks is a recording tool in which all the information is based on user input or from 3rd party apps with user permission.

 

Thus, the Audit Trail serves as a record of all the changes made on a specific transaction. It lists each accounting transaction and any additions, deletions, or modifications that affect that transaction and who made such changes. 

 

To know more on how to customize the Audit Trail report, you can use this article as a reference: Customize reports in QuickBooks Desktop

 

Let me know in the comment section if there's anything I can help you with. I'd be here for you. Have a great day!

cheeks622
Level 2

Audit Trail Flaw

If an immaterial change is made to the transaction (reconciling or clearing, updating billing info, etc.), doesn't that trigger that modified date, too?

katherinejoyceO
QuickBooks Team

Audit Trail Flaw

Thanks for joining in this conversation, @cheeks622. The Audit Trail report shows the transaction date and maintenance records were entered, edited, and deleted, including which user modified them. 

 

Hence, any changes made to the transactions will be shown in the Audit trail report. 

 

For more insights, check out this article to know more about viewing transaction changes in the audit history.

 

Add your comment again if you have additional concerns. I'd be here for you. 

ddaileycpa
Level 2

Audit Trail Flaw

I would have to agree. Audit Trail in QuickBooks online is useless. There needs to be a fuction or clumn that shows when the original transaction was created. This way it could be filtered to transactions changed from prior periods in the given range. When you run thousands of transactions monthly, it is very difficult to locate changes. 

 

It would also be beneficial to filter based on account. Like you can in QuickBooks desktop. It is very frustrating.

Candice C
QuickBooks Team

Audit Trail Flaw

Good morning, @ddaileycpa

 

Thanks for chiming in on this thread and letting us know your concern about the Audit Log feature in your QuickBooks Online account. 

 

You can always send our Product Developers feedback about the options you'd like to have within the Audit Log to help improve it. They take the time to review every request and try to add them to the next available update. 

 

Feel free to use our Blog site to keep up with what's new in the system. 

 

I'm only a post away if you have any other questions or concerns. Wishing you and your business continued success!

bjlmeerkat
Level 2

Audit Trail Flaw

Aloha, 

 

@ahodgson wrote: 

You can also run transaction reports where you can filter using these dates:

 Create Date = Last year

Last Modified Date = This Year

 

I'm in QBO. I don't find that I have these filters available. How do I locate them? 

Thank you! 

JasroV
QuickBooks Team

Audit Trail Flaw

It's great to see you participate in this thread, @bjlmeerkat.

 

I'd be delighted to point you in the right direction when it comes to modifying your reports.

 

You can go to the Reports menu and run the Transaction Detail by Account report. Hover to the Customize button, filter it to include the desired option, and then click Run report.

 

I've included a screenshot for your convenience. 2.PNG

 

You can also read this article for more details: Customize reports in QuickBooks Online.

 

Let me also recommend this excellent resource for accessing your reports outside of your QuickBooks Online (QBO) account: Export your reports to Excel from QuickBooks Online.

 

You can always rely on me for additional assistance with your reports and QBO account. Simply include them in your response, and I'll take care of them for you. Have a wonderful weekend!

PatD0
Level 1

Audit Trail Flaw

This answer is not a solution.  The problem with the audit log is it needs to show the transaction date as well as the date of change to be useful. Otherwise trying to find a change into a prior period requires each transaction be viewed to find the transaction date; that is like looking for a needle in a haystack.

PatD0
Level 1

Audit Trail Flaw

Note that Create Date is not the same as the transaction date. Therefore if on Jan 1 I enter a December transaction, reconcile the bank at Dec 31, and in Feb change that transaction this will not show on a report with a created on range of last year and last modified date of this year because the transaction was both created and modified this year. It would be useful for the audit report to show the transaction date as well as the modified date, and for the reports to allow a filter on a range of transaction dates.

Need to get in touch?

Contact us