• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Special analysis: What to do with electronic records

by on
in Office Management,Payroll Management,Records Retention

Hardly anyone keeps paper records anymore. Naturally, the IRS knows this, so auditors ask for your electronic accounting records.

Problem #1: Software files often contain data beyond the audit years.

Problem #2: Software programs routinely create metadata for every data file created.

So how do you keep the IRS from snooping around the personal and confidential business information that’s contained in those files?

Data and metadata

Regardless of how your accounting records are kept—on paper or electronically—the rule is the same: You only need to produce the documents auditors ask for in their Information Document Request (IDR).

An IDR will most likely ask you to provide a copy of your original accounting software backup files. Backup files may be provided on CDs, DVDs, or flash/jump drives, but the files must be exact replicas of your backup files. You can’t, for example, ­create new files by re-inputting the data or converting the data into Excel spreadsheets.

Metadata—data about data—describes how, when and by whom a particular item or set of electronic information was collected, created, accessed, modified and formatted. The IRS can request this data, too, provided it’s relevant to the audit.

Hitch: The IRS broadly defines relevancy. It considers metadata relevant because it speeds audits by identifying a transaction’s original date, the dates entries were changed, your internal controls and the username of the person who made the entries. Same warning: Don’t re-create files that remove metadata.

Best electronic file practices

Sticking to the conventional advice of only providing auditors with the electronic files they requested in the IDR might not be so easy to do, owing to limitations placed on backup procedures by software manufacturers.

What are your options if you can’t create computer files specifically for auditors, and free access to your backup files can tempt auditors into expanding the audit based on what they see?

Until software manufacturers improve their file backup processes, you can take these steps to ensure that auditors have access to the requested information, and nothing more.

  • Cooperate with the auditors by voluntarily disclosing electronic files. Why: Auditors must return the original electronic (or paper) files to you. They don’t have to return anything they receive in response to a subpoena.
  • So they can read your electronic files, auditors will request the accounting software administrator’s username and password. To address concerns about sharing this information, preserve the existing password and then change the password to a temporary one—IRS audit, for example. Then create your backup file for the auditors and change the password back.
  • Don’t wash personal or confidential company data from your files. The IRS may access personal and confidential data during an audit, but must keep that information confidential.
  • Close out electronic files at the end of a year and open new files at the beginning of the next year, but back up the old year’s files. That allows you to provide auditors with a backup file created immediately at the close of the audit years. This isn’t a perfect solution, since the closed-out year may still contain confidential data (e.g., customer lists), but it will lessen the amount of extraneous data provided to auditors. However, auditors may request transactions for the months prior to and after the tax periods under audit, if transactions in those months are relevant to the data they seek.
  • Condense files for years prior to the audit year. The IRS will accept this, provided the condensed data don’t include transactions created or changed for the audit year or transactions from prior years that have an impact on the audit year.

GOING BACK EVEN FURTHER: If the scope of an audit expands, auditors may request a backup file that was created before the date the files were condensed. They may also request a copy of an archived file that was created during the condensing process. If you don’t have a complete understanding of the condensing process, contact the software provider before you condense any files.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/31446/special-analysis-what-to-do-with-electronic-records "

Leave a Comment