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?
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.
<< ...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.
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.
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.