Dear @Intuit – Would You Make This Tweak to QuickBooks?

 In Post, QuickBooks Desktop, QuickBooks Enterprise, QuickBooks for Mfg + Distributors, QuickBooks for Service Businesses, QuickBooks Online (QBO), QuickBooks Reports, QuickBooks Tips and Training

Dear @Intuit:

I’m writing to you today on behalf of countless ProAdvisors, accountants, and small businesses.

The reason for writing? To request that you make a quick tweak to QuickBooks (both desktop and online versions) that will likely save significant headaches for countless businesses.

But before we discuss the requested tweak, let’s review the underlying problem…

“NEWS REPORTS SAY [INSERT NAME HERE] IS EXPECTED TO PLEAD GUILTY”

Guilty of what you ask?

Guilty of theft and embezzlement.

And a common theme in these cases?

Bookkeepers and accountants issuing checks in the name of one vendor, and then changing them in QuickBooks to another name to cover their tracks. I see this same theme over and over again in articles about small business fraud.

Some examples:

and more…

Sadly, I see one or more of these reports with similar themes just about every month.

THE TWEAK TO HELP YOUR ADVISORS, ACCOUNTANTS AND SMALL BUSINESSES OUT

QuickBooks software includes the Audit Trail report, which is a good start.

But not good enough to help us in this situation.

Why?

Because there is no way to filter this report for ONLY those transactions that were MODIFIED during a given period (if this already exists, I’d love to know about it).

It’s pretty safe to say that nobody (and I mean nobody) is going to take the time and surf through this report that contains hundreds or thousands of original and modified entries just looking for those that were changed.

Having the ability to see ONLY modified transactions? Priceless…

In fact, you already take us part of the way. The audit trail already marks those transactions with changes in bold type as shown in the example below:

Filter the QuickBooks Audit Trail Report for Modified Transactions

Can you take us the rest of the way by adding this additional filter? I can’t imagine it would take that much time to do.

Having this in addition to the “Voided/Deleted Transaction” report that already exists (and is fine as is) will provide some powerful reporting options.

Imagine the benefits to all of us:

  • The “modified transactions” report easily becomes part of the month-end closing and review routine
  • A “modified transactions” report easily becomes part of the report package given to non-profit boards every month
  • A management review of the “modified transactions” report helps stop this “vendor cover-up” problem that is likely happening RIGHT NOW in unsuspecting businesses

I completely understand that this one change won’t solve all of the unscrupulous behavior going on these days in the world of bookkeeping and accounting.

But it will certainly go a long away toward helping us help our clients identify some of these situations early on.

What do you say….you in for this request?

Best regards,
Scott Gregory

Certified QuickBooks ProAdvisor for 20+ Years

 

Recent Posts
Showing 6 comments
  • Robert Peterson
    Reply

    Can you export the report to Excel then filter on the bold type or use conditional formatting to change the color of any cells that have bold type?

    • Scott Gregory
      Reply

      Hi Robert:

      While “technically” you can export any report out of QB to Excel, the practicality of that for this particular situation is pretty minimal – at least in my opinion.

      Adding the “modified only” filter directly in the QB audit trail report strips out all this extra time and messing with Excel.

      Scott

  • Jeff
    Reply

    This is a very reasonable request and this functionality should have been in place for years now.

    • Scott Gregory
      Reply

      Totally agree with your comment Jeff…

      Scott

  • Kathy Drone
    Reply

    I have a question. In payroll, how can you add a deduction that has two levels of tax limits.
    First, up to 25,000.00 then second rate goes into effect for earning OVER 25,000.00??

    • Scott Gregory
      Reply

      Kathy:

      You’d want to check with your payroll provider to see how they handle something like this. They will know the answer on how to set it up (assuming they can handle something like this).

      I don’t do much work in payroll, so am not able to answer this question for you.

      Scott

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.