Discussion:IRS Auditors to be trained in Quickbooks
From TaxAlmanac
Discussion Forum Index --> Business Growth Community --> IRS Auditors to be trained in Quickbooks
| 1 July 2010 | |
| NATP recently reported that the IRS purchased 1,500 to 2,000 licenses from Intuit and is training auditors in how to use quickbooks. They may now summon the taxpayer's quickbooks file. Not just the printouts, but the electronic file. | |
| 1 July 2010 | |
| I'm actually hoping that they can teach some of my clients how to use it correctly. I'm tired of the Income and Expense report that has only two figures: income and expenses | |
Actionbsns (talk|edits) said: | 1 July 2010 |
| It's not all that hard to recover a forgotten password. I would think their training would include recovering passwords. Scary thought though, some of my client's have a hard enough time using QB, how well do you think they'll be trained? I had IRS subpoena Peachtree data files several years ago, then when they tried to open the files, they found they couldn't without the program and wanted my copy. The were communicating through my lawyer, who told me what they wanted. I asked him if that wasn't a violation of my licensing agreement, he agreed. Last I ever heard from them.
What would happen if they got the data file, tried to open it, found they had to upgrade in order to get the file to open. Would that provide any defense for a client who may feel the need to be defended? Something like "Well, in my version of QB, that's not the way it was, your honor. I have no idea what happened in the conversion process to a different version." | |
| 1 July 2010 | |
| There was a lengthy discussion on this in the "working together" seminar I attended last May. The consensus of the CPAs was - they would give reports but not the file. My concern if they can get the file is, that maybe I shouldn't get it from my clients. Maybe they would claim I should have known something I didn't know or that they would use the file to apply various fraud principles beyond the scope of a "normal" exam or inquiry. | |
IDrinkYour Milkshake (talk|edits) said: | 1 July 2010 |
| "summon file". Show me a court order. Prove we have a "file". | |
| 1 July 2010 | |
| The taxman has already been ahead of you, drawing the net ever tighter. Natalie and I were discussing this one time on here. Losing the password is not an option.
Read carefully Revenue Procedure 98-25, and Rev. Proc. 97-22 (available on legalbitstream). And don't get too excited about the 10 million dollar in assets threshold trigger for the requirements. If I'm reading this right, the client technically has to give access to his computer terminal, and teach the IRS how to use the computer. Technically. No horsing around here. AND there is a huge hole the in the 10 mil. trigger, the rules also apply: to ANY business if information to support an amount of income, deduction, credit or other item on a return is not available in hard copy but is available in a computerized format. This handy tip I got from the Quickfinder Accounting & Bookkeeping 2006 Edition. | |
| 1 July 2010 | |
| Another good reason to run "Condense" at the close of each year. | |
| 1 July 2010 | |
| Also, I don't know if it has begun to dawn on people around here yet, but storage media alone is not enough, and will not be enough. You will begin to run into cases where you will possibly need to retain old hardware in working condition.
Makes those paper ledger books look a little better, don't it! I've said over and over again, books and papers are technologies, and they are great technologies that have stood the test of TIME. We are being rooked by this paperless thing folks. I'll shut up as I'm beginning to sound like a Luddite. I will say this, it will NOT turn out to be cheaper to keep records on computers (electronic records). I won't even consider what happens if there is no AC power, or battery power for some reason. The reason electronic records will not be cheaper is that as time goes along, more and more time ($$) must be spent to make sure records are transferred over properly to new, and different hardware. Clients forget things, manuals get lost, software and hardware vendors go out of business. You wait, chaos. But I can go right today, and pick up a book that was bound during Martin Luther's time, and the only hardware I need is my two hands and a strong back....... Now that IS a great technology: the book is the greatest technology ever invented because it is SIMPLE. | |
| 1 July 2010 | |
| This morning, a couple of hours before I saw the NATP statement, I received an IDR with Quickbooks language in the boilerplate alongside the usual request for books and records. The RA said that while he had not been trained in this area, there was another RA in the office who was "qualified," whatever that means. | |
Southparkcpa (talk|edits) said: | 1 July 2010 |
| Wiles....
I can see running condense and having a printout (pdf) with the detail and telling the auditor I run condense annually. BUT in reality, I would use condense and tell the auditor that that's all I have. I might also tell him (GFY) and see what legal supprt they have to subpoena the software. I am confident they would win in this case however. I have done 2 audits on QB's and have provided the auditor with printouts and in ONE case I brought my laptop to the audit and we literally walked through the audit via screen. (ONLY because client was clean). The rub came in because Wachovia did not provide cancelled checks or copies...the auditor was so pissed. He couldn't verify the payee only the amount. | |
Actionbsns (talk|edits) said: | 2 July 2010 |
| Crow, you have a point about the paper documents. During the IRS investigation where they wanted the Peachtree data, since the files couldn't be opened, they sent a bunch of people to my office to copy documents. The senior person in charge of the investigation was out for blood (this had to do with an accountant I did a lot of bookkeeping work for) and she wanted copies of pretty much anything I had printed out, including the bazillion boxes of stuff in storage. The person in charge of the copying and his team had other ideas, when I asked how many boxes a week they wanted me to bring in from the storage locker, they nearly had heart attacks, turned purple, sputtered a bunch and said they didn't want anything from the storage locker, they were happy with what was on my shelves. I don't recall bringing anything in from the storage locker. But if it had been on a computer, stored in PDF files, or some other paperless format, I think they would have gone after my hard drive, at least for those particular clients of that one individual. They wanted to take my computer originally, but were prevented from doing so because not all of my clients were clients of that one individual and my lawyer said no to that, copies will have to work. | |
| 2 July 2010 | |
| Yikes, yikes, yikes! Don't you have to understand the double entry method of accounting to understand QB? I hope they get that training, too. | |
| 2 July 2010 | |
| First shotguns, now Qbooks licenses!
In 2007 I had 2 requests for files. One was from the State of NH; and it took some time before we could agree on an acceptable media for the files, since the Dept of Revenue had to scan for viruses. Also, we could not figure out how to copy 1 year's records and not the whole ten years that were "in" Qbooks. Fortunately, in this case; the client's "books" were merely the check register (which was full of errors) with no adjusting entries or any balance sheet accounts. The State was unable to prove whether certain transactions were intended as loans or dividends. The IRS also requested Qbooks files, which they never received. The client lost about $500,000 that year and the auditor was wasting time. | |
| 2 July 2010 | |
| Actually in an audit that just ended they asked for the Quickbooks file.........fortunately everything was in Quickbooks Online which they were not and should not be provided access to. They were at a loss at first but then fine with paper reports.
They were not and should not be given access to the live system which ended the matter. Actually more and more of my clients are moving to it so I'm not overly concerned. | |
| 2 July 2010 | |
| QBOE is a good defense, but, dang it, that program is something similar to shinola. Last thing I want to do is convince my clients to move to that. | |
Anarchrist (talk|edits) said: | 2 July 2010 |
| QB online may be good but it isn't a great defense. The online file can be exported to a desktop QB file. | |
| 2 July 2010 | |
| A number of years ago, I started thinking along the same lines as CrowJD, so now I give all of my clients a printout of the Quickbooks General Ledger with the tax returns.
My theory was the "hit by a bus" one - if I get hit by a bus, I don't want to have a single document in my office that a client might ever need that they don't also have. I'm not sure many of my clients are even backing up their computers and there are many reasons they might not be able to come up with the detail backing up the entries on their tax returns, due to all the reasons CrowJD talks about. There was a case in my area of a tax preparer's not so sudden death, after which some of his clients ended up routing through his files looking for "their" documents. It was really ugly and could have been prevented had he embraced the "hit by a bus" philosophy. It's a lot of paper, but I'm now on a first name basis with my very own Staples sales representative. | |
| 2 July 2010 | |
| The discussion was also one of security. The auditors will have a flash drive for the case. Would you allow an IRS auditor to use a flash drive to access your computer? No way. It would give the auditor access to information they aren't entitled to. And prove first to me that there wouldn't be any virus or spyware installed. That may sound paranoid but it is a legitimate concern. If ever requested they will get a complete pdf of the entire year's file. If forced to have access to a computer, all prior years will be closed & archived and the only accessible information on the file will be the year of the request. In fact, it will be the only thing on the computer if necessary! | |
CathysTaxes (talk|edits) said: | 2 July 2010 |
| I have QuickBooks installed on all three of my computers (two are backups). If the IRS wants to copy my files, then I will only have that client's data on the computer that I will give the auditor access to (probably the laptop, if I want to be itchy, I'll put it on the ten year old Gateway and let the auditor have fun with that one). | |
| 2 July 2010 | |
| TRcpa, I don't know if your comments square with those two Rev. Procedures I mentioned above. Don't know if these rules have been challanged in court or not.
I don't have the actual Rev. Procds in front of me as I got a summary out of the Quickfinder Bookkeeping & Accounting book I mentioned above. Perhaps Trillium can put a link, or either you guys have better online tax research than I do. I remember this CPA came on here one time and he had an external harddrive and he was using it for storage. Well, the manu. stopped making that harddrive and stopped supporting it, and lo and behold he had to pay 4K to get that thing cracked. I can't remember the exact details, but it made an impression on me. Natalie may remember the man if she comes by. You can buy a lot of paper and file cabinets for $4,000.00, of course, the space to put them in costs money. P.S. by the way, I've been corning the market on used file cabinets for the last 5 years. I think there's going to be a run on them at some point, and the new ones are very expensive and a lot of plants are closing down. I don't know if my investment will pan out or not. If it doesn't pan out, I'll sell them to the government to make reefs for fishing. | |
| 2 July 2010 | |
| Great point Sxptax - Here in MD, anyone getting access to your all of your computer files would constitute a security breach that you would have to report to the government and your clients (plus probably find a new line of work). | |
| 2 July 2010 | |
| One man gave me 50 file cabinets for free just for taking them off his hands. Bragged that he was going paperless. He wanted to know if I was some kind of nut. These were the good old ones, really clicked when you closed the drawers. He even had the keys.
Everyone is getting rid of (the old, sturdy wellbuilt) file cabinets, so naturally, I'm buying them. | |
Actionbsns (talk|edits) said: | 2 July 2010 |
| SZ - are you suggesting that by "closing and archiving" QB, you can prevent access to prior years? I haven't been able to do that in QB. It seems that years ago there was an archiving tool, and I don' remember if it was QB or Quicken, but you could archive the data file to save space and all the current file had on it was the current year data and items that were still open at year end like invoices, purchase orders, outstanding A/P. It must have been QB because Quicken has never been that sophisticated. In any event, I haven't been able to do that for at least 10 years. It was a nice tool though. | |
Anarchrist (talk|edits) said: | 2 July 2010 |
| In QB click
File >> Utilities >> Clean Up Company Data Type in the date you want to condense everything prior and click next. | |
| July 2, 2010 | |
| I believe QB automatically (or at least prompts you to) creates another file when condensing (called 'archive' or something similar in the file name). So it would be prudent to make sure THAT file isn't anywhere an auditor might be looking....and if they were to ask where that file is? hmmmm | |
| 3 July 2010 | |
| JD thanks for the pub not aware of that. As a practical matter I wonder if its more just to give jurisdiction to access the system especially in instances where they believe things are a miss. Been through that in the private sector audits so I'm not to concerned. Still believe providing excel export files, work papers, and hard copies of information to support the tax returns would be sufficient in most situations. | |
| 5 July 2010 | |
| From July 2nd's EA Alert:
An Examination QuickBooks Directive? NAEA learned last Friday that a revenue agent (RA) referred to a national directive instructing RAs to request the electronic QuickBooks data file in every instance in which an audited taxpayer uses QuickBooks. This came as news to NAEA's Senior Director, Government Relations, Bob Kerr, who has reached out to SB/SE for further clarification. We know IRS recently put together a QuickBooks training manual for its RAs because NAEA in January commented informally on the manual (our Government Relations Committee reviewed the manual). The manual did not suggest producing QuickBooks data would be compulsory. At the time, we expressed concerns that any electronically provided data would be used as a part of a proverbial fishing expedition. In conversations late last week, Kerr learned that IRS has secured a substantial number of site licenses from Intuit (E@lert wonders how its QuickBooks clients are going to like hearing that!). We have expressed our disappointment that enrolled agents were not apprised of the implementation in advance and have asked for clarification on whether any directive exists (and if so, what it contains). We have also expressed concern that the program may be troubling for taxpayer representatives determined to protect taxpayer rights. We understand that a communiqu� should come from the agency after the holiday weekend. | |
| 5 July 2010 | |
| I always tell my clients up front that QuickBooks is a useful accounting and management tool for the money. However, in the event of an audit they will need the documentation to backup the tax return. In other words the IRS really doesn't care what their QB data says. Also, with the possibility that merchant accounts will be matched against reported amounts on the return and the like as well as the expanded 1099 reporting requirements it is wise they either learn to use the program (or any accounting program) correctly, hire someone who can or purchase the books necessary for manual recordkeeping. No matter what the law says a lengthy exercise arguing the point costs everyone time which translates to money. Since ther government can print money and clients can not this is a cost vs. benefit decision. In other words if you can't stand the heat get out of the kitchen. | |
Southparkcpa (talk|edits) said: | 5 July 2010 |
| AA
Givint the IRS access to the Quickbooks file makes it so much easier and more efficient for them to "query data". Forget for a moment the merchant accounts and 1099's. The simple ability to "ZOOM IN" on an expense area or search through journal entries consecutively gives the auditor much more ammunition than before. I am personally not that surprised or concerned but the thought of the IRS in effect" sitting at your computer" and then asking questions changes the nature of the audit. | |
| 6 July 2010 | |
| I've mentioned this before, but since I went through heck with a former client regarding his QB vs. my QB I've consistently kept a client's QB intact and created a second QB file that I use to make changes, AJE's and prepare the tax return. I also provide a Trial Balance and AJE's with the tax return for them to adjust their QB to the tax return (right!). So, I would wonder what QB file the IRS would want. If the client does his/her own QB (and I'd love the IRS to get hold of some of those files and figure them out) and the IRS gets that file, what are they trying to figure out? Would the auditor truly look at the QB file and see whether it agrees with the tax return? I can think of one client in particular who doesn't understand note payments and that there is a difference between balance sheet accounts and income statement accounts that the IRS would never, ever be able to match up to the tax returns. This is getting so scary. It makes me wonder if I'm one audit away - due to the potential cost alone - from closing my doors. | |
| 6 July 2010 | |
| I know what you mean, LJACPA, about being one audit away from closing the doors. In spite of how much you emphasize record keeping with clients, they so often just ignore you.
I haven't had any audits since the early 1990's but keep reading about how the IRS is planning on closing the $300 billion tax gap via increasing audits. Plus the commissioner has assured the public that this won't result in jack booted thugs descending on them, rather the IRS will do it by pressuring preparers to be less aggressive. Isn't that swell? At any rate, I fully expect that if there is a significant uptick in audits that I will lose the clients who have to pay adjustments. But, theoretically I would expect to gain just as many who have left other accountants for the same reason - sort of like musical chairs. | |
| 6 July 2010 | |
| If the records are accurate and supported by documentation there would then be the issue of whether the transactions were properly reported on the tax returns. If an auditor questions an item in the accounting records whether manual or automated, the supporting documentation and tax law in effect at the time would still make the ultimate determination. In other make sure the QB data is accurate before putting on the tax return. The old "garbage in garbage out". I typically point out where the client's data doesn't make sense - negative accounts payable, etc. As a general rule I follow exactly LJACPA's procedure. | |
Actionbsns (talk|edits) said: | 6 July 2010 |
| When you think about it, why is it only QB that IRS is interested in? If they want accounting records, why wouldn't they want the accounting records of any accounting system? Why are the only "picking on" people who use QB? Isn't that discriminatory? QB isn't really an accounting system anyway, much as Intuit would like us to believe it turns the ordinary guy into an accountant. Try giving that ordinary guy a real accounting program and it will drive them nuts. There are so many problems with the scenarios above and many others, it's just scary. | |
Tax Writer (talk|edits) said: | 6 July 2010 |
| Who else here thinks that this is going to be a windfall for Peachtree? | |
| 6 July 2010 | |
| I think the IRS wants the quickbooks files EXACTLY because clients aren't accountants, Actionbsns. Just like they LOVE TurboTax. Garbage In, Garbage Out as others have written. Where else are you more likely to find mistakes than self-prepared income statements? The professionals have known it for years!!!! | |
| 6 July 2010 | |
| On what platform will the IRS copy of QB be installed & run? Windows7, Vista or XP? What about a Mac? Its hard enough to make sure I am compatible with my clients, some of whom are using computers without a USB port. | |
| 6 July 2010 | |
| If they intend on implementing this in order to view the client's actual QB data, then this will eventually prove to be a time & money waster for the Service. The Service may not believe this, but the time we spend converting our client's QB into usable reports pursuant to an IDR is for the benefit of the Service. | |
Actionbsns (talk|edits) said: | 6 July 2010 |
| Tax Writer, Peachtree will have to be a lot more available than it is now. The only reason I use QB in Hawaii is because it seems to be the program of choice. You can purchase it anywhere, not so for Peachtree. That and even though it has been dumbed down to compete with QB, it's not as easy to use. Kevin, if it sounded like IRS was only going to go after files of people with self prepared returns, we wouldn't have to be terribly concerned with the issue. In fact, it would likely be a boon to our business because people would find out that software doesn't make you an accountant (where have I heard something similar to that?). I would love to get some of those crazy sets of books to repair. Fixing up screwed up QB files is one of my favorite things to do. In fact, it might be fun to be a fly on the wall of an audit where the auditor was asking questions about the data file, questions like, "But TP, how do you have a credit balance in an asset account?", or "Why is the credit card balance $10,000 positive? Does Citibank owe you $10,000? Why?" "Why is there a wages payable figure, but it's a debit?" "Do you even know the difference between a Balance Sheet and an Income Statement". Those are going to be fun interviews for someone. | |
| 6 July 2010 | |
| we have those same questions here for some of the participants and we get the same 'deer in the headlights' response. | |
| 12 July 2010 | |
| This discussion reminded me about a concern I had regarding Intuit not giving you the ability to turn-off the audit trail feature! Anyone want to bet that this feature was disabled at the request of the IRS? | |
Tampa Taxman (talk|edits) said: | 12 July 2010 |
| I don't know if it was specifically requested by the IRS, but an audit trail would be needed to meet the requirements of Revenue Procedure 97-22, wouldn't it? | |
Ksnoopytax (talk|edits) said: | 12 July 2010 |
| I have an corporate audit coming up at the end of this month. The IRS auditor asked for a copy of the general ledger including A/R and A/P aging reports. The client uses Quickbooks and I could give the auditor a backup of the file but it is daunting to do so. One of the best features in Quickbooks is all the functionality it gives you and the ability to run multiple reports easily. Unfortunately, the IRS will have that ability also to analyze and scrutinize your books. My client doesn't have anything to hide and I looked over the file and the information "seems" reasonable but yikes... | |
| 13 July 2010 | |
| I wonder whether your E&O insurance covers such acts, Ksnoopy....giving the IRS your client's database (and the audit results thereof) when all they wanted was some specific reports. | |
| 13 July 2010 | |
| I have officially begun recommending that clients consider using Peachtree when they are ready to upgrade.
I am also using this as a further notification that they really need to clean up their books as there are some serious consequences for not having great/perfect documentation. | |
| 13 July 2010 | |
| I have 'heard' that Intuit has been asked [by the practitioner community] to come up with a way of either exporting one year's data to a new usable file or to 'lock' all data not in a particular year for a file to be given to the IRS. If you are a Quickbooks Pro Advisor (or whatever the correct name is), call Intuit and STRONGLY REQUEST that this pe a priority. | |
Southparkcpa (talk|edits) said: | 13 July 2010 |
| Peachtree, in my view, is not suitable for many small businesses. It is harder to work with, is more "traditional" in it's approach. | |
| 13 July 2010 | |
| I agree with you there Matt, but, if clients were more "traditional" in that they had bookkeepers, or they themselves understood basic accounting, then it shouldn't be an issue.
I'd much prefer to teach clients about the accounting cycle than to teach them how to screw up their business using "easy" software. Plus, with Peachtree, as they grow their business, it will be easier to migrate them to MAS90/200 ;-) In some ways, the IRS is getting to regulatory, but in others, if it "encourages" clients to use better software, or to use their existing software properly, then great. | |
| 13 July 2010 | |
| There is a service at www.QBornotQB.com that can take your QB file & pull out a specific time frame so it can be given to a third party. The call it QB legal disclosure. I have not used their services but found it in a thread on a pro advisor bulletin board about this same topic. It might be handy to have as reference in the future. | |
Ksnoopytax (talk|edits) said: | 14 July 2010 |
| Actually Kevin I think you are right. It's enough that they ask for the prior year and future year tax returns for the year of audit. Granted they have access to them in their own systems, but it is too easy in Quickbooks to run a report for multiple years which could subject my client to additional inquires and possible opening of another tax year for audit.
Paper reports it is. LJACPA - In my case, the auditor also asked for any adjusting entries that were used to prepare the books and the tax return. | |
Actionbsns (talk|edits) said: | 22 July 2010 |
| Another example of why IRS should not have access to the QB data file!! I just started working on this client's 2009 stuff and find the 2008 data doesn't match my 2008 as filed on the TR. Further checking, neither does 2007. Near as I can figure, she must have done some "editing" while I was doing the 2008 work because I locked the file after doing the journal entries and whatever she did changed the balance sheet and income statements for both years. In addition, someone entered a bunch of journal entries in 2009 that are weird and used my JE codes so they look like I did them, but they are odd and they are numbered strange. I use a system for JE - 10pwje01 would mean I did the JE using my initials, it's the first JE and the year is 2010. That way it keeps the automatic numbering system working. My client is showing several for 2009 with the numbers 06pwjeXX. All would be just more stuff to explain to an auditor if the need arose and fewer hairs on my head at the end of the day. GRRRRRRRR | |
- Copying a very relevant post by TaxSense from a related discussion:
| 25 August 2010 | |
| Might I suggest that should the IRS request a QB file that you 'extract' only that year's data and provide that to the examiner? There is a very cool tool here ---> http://www.q2q.us/dtuoverview.htm that can be used to extract specific data choosing certain parameters. I have no financial interest in Karl Irvin's web site, but I have used this tool in another scenario and it really works. The trick is you have to follow his instructions EXACTLY or the data could be faulty. Just my $.02. (This developer is a Gold Level developer for Intuit.) | |
| November 3, 2010 | |
| I'm a little late on this discussion, but I wanted to respond to this comment: This discussion reminded me about a concern I had regarding Intuit not giving you the ability to turn-off the audit trail feature! Anyone want to bet that this feature was disabled at the request of the IRS?
I guess like a lot of things, the audit trail can be seen as good or bad. I usually look at it as a positive change that QBs made because it makes it harder for people to commit fraud and get away with it. I read of one executive director of a nonprofit organization that turned off the audit trail, changed a bunch of transactions to conceal what she was doing, and stole thousands of dollars. If your client is above-board, this shouldn't be an issue, and I don't think the IRS asked for this. Several people have mentioned condensing the files. This can be a good option, but remember that any "open" transactions will be retained in the new file. That means any outstanding checks, receivables that haven't been paid, bills that haven't been paid or transactions that haven't been printed. In some cases, open transactions are significant. | |
| 3 November 2010 | |
| The condensing was me, and yes, I understand the open items remain open, but that still makes it more legwork on the part of an auditor anyhow. Plus, if enough time has passed, then the open itmes would not be open anymore.
As for the audit trail, It's a great idea that it's never turned off. You still need to dig and search to make sure things aren't changed, but it's better than before. | |
Tax Writer (talk|edits) said: | 3 November 2010 |
| This chat makes me nostalgic for the old green ledger paper from my Accounting 1A/1B classes.
Tax WriterTax Writer 14:17, 3 November 2010 (CDT) | |
| November 3, 2010 | |
| then the open itmes would not be open anymore. I have one client in particular with lots and lots of open items going back several years. I told them I wouldn't even bother condensing the file because there were too many open items. | |
| 3 November 2010 | |
| I was saving that link to the extraction utility and I accidently labled it 'Qukbooks Extraction Utility'. Say 'Qukbooks' out loud and you get the true idea of the nature of many taxpayer's use of the software. | |
| 14 February 2011 | |
| If you have invnetory in QuickBooks then the condense feature does not really work. Any suggestions for giving the files to the IRS without giving them access to all the years data? | |
- An article about a feature in 2012 Quickbooks that allows you to isolate one year of data: Create a Period Copy.

