Audit Hardware and Software

One unexpected benefit we received by visiting so many CPA firms in 2007 was solving day to day technology problems that seem to be present in most firms. The key technologies we observed not installed properly at CPA firms this year include: surge protection and UPS, cabling, multiple monitors, backup systems, firewalls, and security systems. These technologies are all fairly well established, and the rules and understanding of how to deploy most of these technologies have been consistent for over ten years. More recent changes in how to setup firewalls and security with greater protection would be the exception to this statement. So please listen to my first point of this month’s article: check your existing technologies to make sure that they have been installed properly. Every firm we have been to in 2007 has these problems. We were so shocked by this trend of improper implementation; we have actually created a series of articles on how to do these basics properly. We suspect your firm has these issues and others as well, but in this article, we are only going to address the key issues of technologies for your auditors.

Technology tools to make audit teams more productive have become easier to use and more sophisticated at the same time. The key issues for field auditors include 1) Connection to other auditors and sharing files and equipment in the field, 2) Connectivity back to the office and to the internet, 3) Security of data and their equipment, and 4) Maintaining productivity while in the field. We will provide a cookbook of products to consider later in this article, but first let’s address these four key areas.

Connection to other auditors and sharing files and equipment in the field – Issues of easily connecting computers in the field have plagued auditors for some years. This continues to become more critical as auditors spend more time out of the office, and audit engagements occur in more months of the year. The best solution we have found in this category is Colligo Workgroup Edition. This Canadian vendor has made peer-to-peer networking simple. We refer to it as networking for CPAs as opposed to networking for techies. Colligo allows for configurations for use in the office and field, and emulates several server technologies to make connections work easier and correctly.

Connectivity back to the office and to the internet – Some firms have gone so far as to prohibit connection to client networks, use of wireless and WAN data cards. We understand this from a security risk perspective, but it is killer for auditor’s productivity. We prefer to run appropriate levels of protection in firewalls, virtual private networks (VPN), and encryption for wireless. WAN cards have become fast enough that we can create our own links without using client’s networks, and this also keeps us from dealing with belligerent IT departments that don’t want outsiders to connect to their LANs. The downside is that not all markets have the true high speed access of WAN cards available.

Security of data and their equipment – With the high profile headlines of theft of data as well as identity theft, CPA firm laptops are great targets for criminals. We prefer to use a product like PGP Universal Series 200 that encrypts the entire laptop drive, any USB used, and any email that is sent. Additionally, we prefer to have all wireless connections using 802.11i or WPA2 encryption along with a VPN encryption. If all of these encryptions are in place, hackers will have to break through several levels of security to get to any communication. The encryption used by PGP has yet to be broken, so the theft of a laptop with an encrypted hard drive should not produce any useable data for the criminal.

Maintaining productivity while in the field – The issue here is driving up realization while producing a better end product, and not giving the extra profitability away in future audit engagements. We know it is painful, or in some cases impossible for auditors to carry all equipment listed below to a remote engagement via an airplane. Consider shipping equipment when long engagements are going to be remote where the client can’t provide comparable technical facilities. For auditors who drive to clients, this equipment is easily carried in a car. The key pieces of technology that can help with productivity are: multiple monitors, scanners, and internet connectivity. If you have internet connectivity, you can also gain access to firm files, email, internet research, and possibly voice over IP (VOIP).

Remember, specific products mentioned below were among the best choice at the time the article was written, and given as examples of what works. Review for successor or superior technology when you are ready to make your purchase. What technology tools in both hardware and software can make your auditors more productive?

1) Hardware
a) Laptop – a larger screen is better, extended life battery, and both wireless LAN and WAN built in is better – HP, Toshiba, Lenovo, Dell, Apple
b) Cell phone/combination PDA – better to have remote email access in these devices as well. This is needed less if the soft phone below is included – Treo 700, Blackberry, HP iPaq, Sprint PPC-6700. Add software like PDAnet if high speed connectivity is not included with your phone
c) High Speed WAN Card - to connect the audit team to high speed cellular service – Novatel Merlin S620 on Sprint
d) Wireless Firewall – better if it supports the high speed WAN card as well as hard wired connections – Kyocera KR1
e) Production quality portable scanner OR a multi-function (MFP) scanner/printer – Canon DR-2580C, Fujitsu fi-5120C, Fujitsu ScanSnap S500 or HP 4315
f) A second monitor when the engagement is going to keep people out for more than two days – ViewSonic ve710b, Planar 1500
g) Encrypted USB for backup of files on a regular basis – Lexar JumpDrive® Secure II, JumpDrive® TouchGuard™ SAFE PSD S1100 OR use of the encryption software below
h) Network Attached Storage (NAS) – larger disk device to save and share all files from a single location – Maxtor Shared Storage Drive H01P200 (or larger)
i) Surge protection – to share the limited power available. APC PNOTEPROC6 for in line protection, a PER8T to share with all.
j) Optional keyboard – in case the auditor wants to work from a large keyboard, but this is unnecessary with larger laptops
k) Optional 10-key with USB connection – Targus PAUK001U
l) Your auditors may be happier with a larger laptop with the 10 key built in
m) Locking cables – although these are only marginal defense try Targus PA400U
n) Optional mouse that always stays in the portable bag, but some find the built-in mice as productive.
o) Universal power adapters – so you can recharge your laptop, cell phone and other electronic devices – iGO everywhere 130 with the appropriate tips
p) Roller style of bag – that can hold all of the above and make them easier to move – TravelPro Platinum 4 #9422 or Wenger Patriot. Perhaps GearGrip LCD Shield Harness bags from CaseAce Products for monitors only like the GGLCD1K.
2) Software
a) Audit Engagement Management Software – CCH Engagement, CaseWare or CSI Engagement CS
b) Practice Aides – PPC eTools advisement/template software
c) Research software – CCH, RIA, BNA
d) Specific audit tools - ACL, IDEA, Monarch, AuditWatch, ActiveData, AuditMaster, ProfitCents etc.
e) Productivity software for word processing, spreadsheets and email – Microsoft Office
f) Software to create PDF files – Adobe Acrobat
g) Software to handle multiple monitors – Ultramon, MultiMon (www.realtimesoft.com), PivotPro
h) Peer to peer networking software to make field connections and sharing easier – Colligo WorkGroup
i) Encryption software to protect your hard drives, USB and email – PGP Universal Series 200
j) Backup software – to copy all files easily – Second Copy (www.centered.com), Allway Sync (www.allwaysync.com)
k) Softphone software – allowing your remote auditor to connect to your VOIP phone system directly – typically supplied by your VOIP vendor
3) In the office
a) Remote access to the server including files, document images, and email – Citrix or Terminal Server
b) Scheduling software, possibly covered in your workflow solution – XCM solutions
c) Voice Over IP phone system – Cisco, Avaya, 3Com, InterTel
d) Confirmation letter solution – Capital Confirmation
e) Audit budgeting software – Excel, CCH Practice, CCH Practice Management, CSI Practice CS
f) Time and Billing system with remote time and expense entry - CCH Practice, CCH Practice Management, CSI Practice CS
g) Docking stations for the laptop, properly surge protected, possibly with dual monitors (total of three monitors with laptop screen) - Targus ACP50US
h) Second set of mice, keyboards to minimize setup and tear down time
i) High speed production quality scanners to turn client paper documents into electronic files – Fujitsu fi-5750C or Canon DR-7080C

With this selection of hardware and software products you have a formula for success. However, as an audit manager, IT manager or firm administrator, you must help your auditors picture how this equipment will work for them. Preparation before leaving the office will be a necessity. An auditor should carry all of the necessary files to the field on their laptop or NAS, with all supporting documentation scanned in advance, and organized in the engagement management software. All of the appropriate equipment can be transported in a wheeled bag.

When the audit team arrives on the first day of the engagement, they can set up their tools either together or separately depending on the client designated workspace. Complete setup should take place in less than 15 minutes. The setup process would be:

1) Set up the surge protection
2) Connect the wireless access point with firewall to power and either:
a) Your WAN card
b) The client’s network with a cable
3) Attach the NAS to the wireless access point
4) Connect the first laptop
5) Start the peer to peer network sharing software
6) Check connectivity to the NAS
7) Check connectivity to the internet
8) Continue the setup process by setting up the scanner/MFP printer
9) Set up the second monitor for the first laptop
10) Begin connecting all other laptops to the network
11) Plug in the cell phone/combination PDA to power and/or establish a VOIP connection
12) Test all other laptop connectivity to
a) Share files
b) Share the printer
c) Share the scanner
d) Internet
e) VOIP

You are now ready to begin running the engagement management software using files on a laptop or on the NAS. Make sure that the shared resources are not connected via the audit manager’s machine since the manager will frequently move from one audit engagement to another, and could easily take key needed resources with them when they leave.

Only a few of the software and hardware tools named above are beyond what a typical auditor carries today. The new tools include: WAN card, second monitor, peer to peer networking software, encryption software and a softphone. The total cost of additional hardware and software to make field auditors more productive is roughly $300 for software and $1,200 for hardware. Ongoing costs for the WAN card are currently around $60/month. Most audit teams will gain enough billable time in the first engagement to justify these expenditures, plus your firm will be better protected with all data off-site encrypted. Using the right technology tools will increase the realization across all audits and keep your auditors in better communication with the firm.

This blog

by The K2 Team - Look here for anything that involves technology and accounting. K2 Enterprises is the largest supplier of technology CPE (Continuing Professional Education) for CPAs, CGAs and CAs in North America. The K2 team routinely reviews software and hardware products from all major publishers and teaches accountants how to use these tools effectively. The entire K2 team has 10+ years of experience, many with 30+ years of technology and accounting experience.

More from this blog

Bloggers crew

Steve Knowles has spent 25 years in business and practice in the UK, but he also worked in the states and the years haven't dulled his way of seeing an alternative view to everyone else, and every day is a new adventure.

46867

Joel M. Ungar, CPA is a lifelong resident of the Detroit area and a graduate of The University of Michigan. He is a principal with Silberstein Ungar, PLLC, a Top 15 auditor of SEC public reporting companies.

79724

Allan Boress, CPA, with over 25 years as a practitioner and consultant to the accounting profession. Mr. Boress is the author of 12 published books in 6 different languages, including a best-seller, The "I-Hate-Selling" Book.

51967

Larry Perry, CPA, CPA Firm Support Services, LLC, is the author of accounting and auditing manuals, author and presenter of live staff training seminars, and author of webcast and self-study CPE programs. He blogs about small audits, reviews, and compilations.

94107
Sandra Wiley, COO and Shareholder, is ranked by Accounting Today as one of the 100 Most Influential People in Accounting as a result of her prominent role as an industry expert on HR and training as well as influence as a management and planning consultant. She is also a founding member of The CPA Consultant's Alliance. Sandra is a certified Kolbe™ trainer who advises firms on building balanced teams, managing employee conflict and hiring staff.
23414

Maria Calabrese, CIR, Human Resources manager for Fazio, Mannuzza, Roche, Tankel, LaPilusa, LLC in Cranford, New Jersey, Maria's topics revolve around the world of: Mentoring, Performance management, and The "Y Generation," a.k.a. "The whY generation".

59227

William Brighenti is a CPA, Certified QuickBooks ProAdvisor, and Certified [Business] Valuation Analyst, operating an accounting, tax, and QuickBooks consulting firm in Hartford, Connecticut, Accountants CPA Hartford.

84710

Ken Garen, CPA, is the co-founder and President of Universal Business Computing Company (www.ubcc.com), a software development firm of high-volume, high-productivity accounting and payroll technology.

27382

Eva Rosenberg, MBA, EA, is the publisher of TaxMama.com, and author of the weekly syndicated Ask TaxMama column. She provides answers to tax questions from taxpayers and tax professionals worldwide.

67912

Amy Vetter, CPA, CITP is the CPA Programs Leader for Intacct Corporation responsible for leading the CPA/BPO Partners nationally.

36944
Brian Strahle is the owner of LEVERAGE SALT, LLC where he provides state and local tax technical services to accounting firms, law firms and tax research organizations across the United States. He also writes a weekly column in Tax Analysts State tax Notes entitled, "The SALT Effect." For more info, visit his website: www.leveragestateandlocaltax.com
107117
Scott H. Cytron, ABC, is president of Cytron and Company, known for helping companies and organizations improve their bottom line through a hybrid of strategic public relations, communications, marketing programs and top-notch client service. An accredited consultant, Scott works with companies, organizations and individuals in professional services (accounting, finance, medical, legal, engineering), high-tech and B2B/B2C product/service sales.
28761

Rita Keller is a nationally known CPA firm management consultant, speaker, author, mentor and blogger. She has over 30 years hands-on experience in CPA firm management, marketing, technology and administrative operations.

56180
Stacy Kildal is the mom of two fantastic kids, an Advanced Certified QuickBooks ProAdvisor, Certified Enterprise Solutions ProAdvisor, Sleeter Group Certified Consultant, a nationally recognized member of the Intuit Trainer and Writer Network, and co-host of RadioFree QuickBooks.
30740
Michael Alter's blog specializes in providing practical advice to those who seek greater profitability and practice management tactics that enhance deeper client relationships.
35179

Sally Glick, CMO, Principal, Marketer of the Year in 2003 and AAM Hall of Famer in 2007, leads a lively discussion of the constantly expanding roles of marketing and the professional marketers that drive this initiative in accounting firms of all sizes.

105400

The IMA Young Professionals Blog features the insights of IMA’s Young Professionals Committee. Committee members share advice and experiences on careers, continuing education, work/life balance, and other issues affecting young accounting and finance professionals.

36511

FEI Financial Reporting Blog provides highlights from SEC, PCAOB, FASB, IASB, and other regulatory news, including reporting under Sarbanes-Oxley Sect 404. It is written by Edith Orenstein, Director of Technical Policy Analysis at FEI.

116609

Sue Anderson has 30 years of experience in continuing education for accountants. Currently she is the program director for online CPE provider CPE Link.

64944

Jim Fahey is COO of Apple Growth Partners, a regional CPA firm in Ohio. His focus is on the effective and efficient use of technology within the firm by all team members.

42345
Caleb Newquist is the Editor-in-Chief of Sift Media US, overseeing content for both AccountingWEB and Going Concern.
69755

Leita Hart-Fanta, CPA, CGFM, and CGAP is the author of "The Yellow Book Interpreted" and owner of Yellowbook-CPE.com a website devoted to training for governmental auditors.

96093

AccountingWEB is more than just a U.S. team of journalists and financial and technology experts - we have an international side, too! Members of our British team who publish AccountingWEB.co.uk share their ideas, insights, and perspectives from across the pond.

57028