Navigation:


DISCUSSIONS > IIA GENERAL DISCUSSION AREA [ REFRESH ]
Thread Title: Audit Finding Tracking Database
Created On Thursday March 28, 2013 2:43 PM
  Audit Finding Tracking Database
  Audit Finding Tracking Database
  Audit Finding Tracking Database
  Audit Finding Tracking Database
  Audit Finding Tracking Database
  Audit Finding Tracking Database
  Audit Finding Tracking Database
  Audit Finding Tracking Database
  Audit Finding Tracking Database


KellyB3


Posts: 2
Joined: Mar 2013

Thursday March 28, 2013 2:43 PM

User is offline View thread in raw text format

Hi eveyone-

I am looking for a software or database system with reporting capabilites in order to track audit findings. We are a small shop (3 people) and currently track audit findings in a Word chart which is very timeconsuming to manipluate the data for reports. We t
ickmark paper so we don't have any audit software (TeamWork, Auto Audit, etc). Not really looking to start doing paperless audits right now, but I am trying to get my department to move in that direction in the near future. A database for reporting would be a great first step for us. Any suggestions please? How does everyone else track findings?

KellyB

Reply
Quote
Top
Bottom



Marc LeBlanc


Posts: 14
Joined: Nov 2006

Friday April 05, 2013 3:22 PM

User is offline View thread in raw text format

Like you we track audit findings very manually. It's a very laborious and inefficient. Rather than invest in a database to simply manage audit findings, we are looking at implementing audit management software. This will give us a proper database to track findings plus we get the efficiencies from using an integrated tool to manage the entire audit process.

Frankly, the cost of audit management software is not that much (a couple grand per auditor per year) and I encourage you to explore these systems. I estimate you will pay 50% the value of full audit management software top get a database to track audit findings only but you will only receive 20% of the benefit of full audit management software. Put another way, I think it would be cost advantageous for you to spend a bit more to get a whole lot more of a system.

Marc

Reply
Quote
Top
Bottom



KellyB3


Posts: 2
Joined: Mar 2013

Friday April 26, 2013 4:18 PM

User is offline View thread in raw text format

Thanks Marc-

Do you have an audit management software you can recommend or one you have tried?

Reply
Quote
Top
Bottom



Mark R. Simmons


Posts: 133
Joined: Nov 2003

Friday April 26, 2013 5:48 PM

User is offline View users profile View thread in raw text format



<< ...We are a small shop (3 people) and currently track audit findings in a Word chart which is very time consuming to manipulate the data for reports...A database for reporting would be a great first step for us. Any suggestions please?... >>



In the departments I ran, I had a simple-to-use database creation program from IBM called LOTUS Approach. It was similar to Microsoft Access, but much more user friendly. With that software I was able, with careful thought and planning, to create a fairly sophisticated database system that captured a significant amount of information from our audits and produced some very informative reports. The advantage of going that route is you have complete control over a custom designed audit management and reporting tool, and you can make modifications as your needs change. Packages like TeamMate are very powerful, but for a small shop may be overkill, and often can be labor intensive to implement.

I suggest you try creating something simple in Microsoft Access (or LOTUS Approach if it's still on the market). You may be pleasantly surprised by what you can accomplish.

Good luck!
Mark R. Simmons, CIA CFE (retired)

Reply
Quote
Top
Bottom



Tennessee Flash


Posts: 81
Joined: Oct 2003

Monday May 06, 2013 11:28 AM

User is offline View thread in raw text format

We have an Excel based findings tracking with macros and reporting capabilities one of my auditors designed. It can be done in Access as well. Much more efficient than Word. I have 17 auditors on my team, but use an admin to enter findings and updates.

Reply
Quote
Top
Bottom



Tennessee Flash


Posts: 81
Joined: Oct 2003

Monday May 06, 2013 11:32 AM

User is offline View thread in raw text format

We have an Excel based system with Macros and reporting capabilities that is easy to use. This could be done in Access as well. I have an admin enter the findings and updates and takes minimal time. It is much more efficient than Word.

Reply
Quote
Top
Bottom



PRP


Posts: 3
Joined: Aug 2012

Monday May 13, 2013 12:52 PM

User is offline View thread in raw text format

http://office.microsoft.com/en-us/templates/results.aspx?qu=access&av=zac&queryid=ce06cd57%2Ded61%2D4a79%2Db985%2Df043df7e80f8&AxInstalled=1&c=0#ai:TC001225348|

The above template can be used for internal audit tracking and can be customized as needed.

Reply
Quote
Top
Bottom



Niki


Posts: 50
Joined: Feb 2009

Friday May 17, 2013 3:03 AM

User is offline View thread in raw text format

We also use excel, but will be moving to develop something on SharePoint soon.

Reply
Quote
Top
Bottom



Griff


Posts: 267
Joined: Oct 2002

Friday May 31, 2013 2:50 PM

User is offline View users profile View thread in raw text format

Hi Kelly

I have some examples on www.internalaudit.biz (completely free - no catches) including excel databases and an access database, which you are welcome to copy and modify.

David Griffiths

-------------------------
David Griffiths
www.internalaudit.biz

Reply
Quote
Top
Bottom

DISCUSSIONS > IIA GENERAL DISCUSSION AREA [ REFRESH ]
The Institute of Internal Auditors • 247 Maitland Avenue Altamonte Springs, FL. 32701-4201 USA
+1-407-937-1100 • FAX +1-407-937-1101 • www.theiia.org