The IRS wants your QuickBooks Data File

Being audited by the IRS can be scary.  If the IRS finds a mistake you made, they will assess penalty and interest on the late payment of taxes. QuickBooks makes it easy to run the reports required to quickly find errors and issues of tax avoidance. They can export your data to Excel and with a few clicks create tables of relationships analyzing your margins (the difference between costs and revenue).  The more years of data you give them, the more questions they will have. Tthe more supporting documents you will need to dig up and the more likely you will have to pay more in taxes and penalties.  No business has the time to devote to compiling the paperwork needed to satisfy an IRS auditor.  However, you will have to find the time.

What are the chances you will be selected for an audit?

Very low, in fact, less than 2-4% of tax returns are audited. And some of those audits can be handled through correspondence.

However, if you are selected for an in-person audit, it is costly in terms of time and money. Starting with the year 2010, the Internal revenue service has purchased 1500 to 2000 licenses from Intuit and will have one agent trained and licensed per group to assist the other revenue agents with their audit. This type of audit will result in greater taxes which come with greater penalties and interest.  Your best defense, now, against these types of future audits is to take the time to read this article and learn what the “hot” audit areas are for your business and employ best practices when you finish your year.

How far back can the auditor go?

Auditors can include returns filed within the last THREE years in an audit.   Generally, if a substantial error is identified, the IRS will not go back more than the last SIX years.   

Auditors are fully trained in your industry.  In fact, there are HOW TO GUIDES, for the newbie auditor to learn all about where the mistakes can be found in your tax documents.  Handing over the QuickBooks files means they can find many more mistakes in the same time allotted by their supervisor for the audit.  The reporting capability in QuickBooks makes their job easy!

To learn what the IRS will look for during an audit, click on your industry below.

So, you can see why you would not want the IRS poking around looking for honest mistakes that you made. Instead, giving them all the information they request just for the year in question will be in your best interest.

Do I have to give the IRS my QuickBooks file?

YES, they can ask for your QuickBooks file, however, you should first work with your CPA. Have your CPA request permission to split the company data file and provide the file with just the tax year(s) in question.

How do I split the QuickBooks file for an IRS auditor?

For those of you who are not currently facing an audit, the following tasks should be completed each year
Upon the close of 12/31/xx, after reconciling your books and preparing all year-end adjusting entries, when you give your CPA the QuickBooks file, set the closing date (company menu), then make a copy of your QuickBooks file and keep it in a folder called Tax Audit QuickBooks.  Rename your data file and add the tax year the file applies to.  For example, ABC Company.qbw will now be ABC Company 2011.qbw.  Have your CPA give you a list of adjustments to make in your QuickBooks file, so that your QuickBooks will agree to the tax return. These entries need to be made in your everyday QuickBooks file AND in the Tax Audit QuickBooks file.

If you do get a request for an audit, you use the cleanup utility under File menu > utilities> to condense data for the years
prior to the audit year in question.   Before you use this cleanup utility, make a copy of the file and store safely in another location.

How we can help!

Starting with the 2012 edition, the condense feature has improved!  If you prefer to give the IRS only one year of information
2012 and later editions have a period copy, leaving all the transactions for a selected date range, including the audit trail, and removing the “before and after activity.”  You will need to reset opening balances for that period – we offer a service to perform this procedure. Call us for more information 800-216-0763.

Let us help with your audit!