Tell us
what you think
Our Sponsors
 |
Our Sponsors
|
More Automation Tips From Andy
by Andy Zavoina
Question: How can I make special audit sheets on my PC?
Answer: You no longer need special desktop publishing software or a forms program to help you here. In your spreadsheet you can easily design forms that require more of a table structure than formatted text. And if you need more text attributes, use your word processor.
With tables and user-defined styles in your word processor you can define text styles and check boxes or explanation areas where you can mark the audit item as compliant, not compliant, questionable, not applicable or answers the question in a narrative.
Here is a sample of the first question under the Credit Practices audit for the OCC workpapers. Using your examiner's questionnaires in this manner allows customization. You won't need to retype their entire questionnaires. It may be available electronically from their web site, on a CD of regulatory information or even directly from your examiner.
Credit Practices Rule
This worksheet can be used to test the adequacy of the work completed by the compliance officer and/or to conduct an independent test using a sample chosen by the examiner. Answer the following questions with a "Yes" or a "No." Every "Yes" answer indicates a violation of law or an internal deficiency and must be explained fully in the work papers.
| |
Yes |
No |
| 1. Do consumer credit contracts originated
by the bank contain any of the following
prohibited provisions or has the bank attempted
to enforce: |
|
|
1) a confession of judgment; ___ ___
2) a waiver of statutory property exemption; ___ ___
3) an assignment of wages or other earnings
(except where permitted); or ___ ___
4) a blanket security interest in household goods
12 CFR 227.13(a),(b),(c),(d)? ___ ___
Copyright © 1998 Compliance Action. Originally appeared in Compliance Action, Vol. 3, No. 11, 8/98
Rate This Article
Current Rating For the Feature:
| More Automation Tips From Andy |
| Total Ratings for this Feature: 0 |
|