What types of automated workpapers products are being used by your departments? What works well and what does not work well?

I am looking for a product that will enable us to write the recommendations once in the workpapers and carry these forward to reports.

Then, report comments would be carried forward to a document for tracking completed corrective actions.

Ours is a 2 person department in a $400,000,000 community bank.

I am interested to learn if anyone has experience with AutoAudit or with TeamMate, as I am looking at these products.

I am a new auditor in a $400,000,000 community bank and I am getting started with a software called Audit Leverage by IAD Solutions. Since I am just getting started with it, I can't give too much feedback on it but it is supposed to do what you are asking for and much more. The software is inexpensive and utilizes Microsoft Access. You can go to their website www.auditleverage.com and sign up for a free web demo.

This post was originally made a few months ago. Can anyone provide any feedback this time around?

We primarily use MS Office products but I am very interested in TeamMate...

We have built an audit/compliance review module entirely within Access that does exactly what you want. If you or someone you know can move around in Access, you won't have to spend a lot of hard dollars to accomplish your goal.

I am interested in your Access review module. Was it hard to set up? What functionalities does your review module perform? I have always felt Access was a great tool but will I need to be an Advanced user to set up a module for my bank?

Thanks for your time.

As for set up, you may need an advanced user to establish the mapping functions and for general maintenance. From a user's perspective (simplified explanation), there are checklists or audit programs with the attributes to test. Next to the attribute a drop down box to check - 'exception, ok, na. Next to that, a field for your comments. After that, push the reports button and all items marked 'exception' are mapped to the report module which will show the attribute, exception comments and a field for management response dates. The response dates can then be mapped to another module for aging purposes. All exception are also mapped to a matrix by exception type for trend analysis. As for report set up, say for example you are auditing loan files and one exception would be lack of a recorded mortgage. The report would show that exception, your comments, department of responsibility (originations, operations, etc., department manager, whether a response is required, date response due, etc. From that data, I write a management letter with the trends. Very effective.

I was not involved in the set-up so I don't know how difficult it would be.

I'm still looking for the "appropriate" internal audit software for my shop of 1. I just surfed the RSM McGladrey's website and requested a demo of the their audit software product - Auditor Assistant...the license price seems very reasonable ($1,000 up to 5 users) and runs on Lotus Notes.

Which is more easy to use Microsoft Access or Lotus Notes? Are there any auditors who are presently using or have used Auditor Assistant? I need some feedback. THANKS! TGIF!!!