If you only have a small number of incoming certificates, a spreadsheet or database solution will work, but it you get more than 30 or so, it gets tiresome. The more data you copy from certificates, the better tracking you get, but it also takes longer to copy and increases the risk of mistakes.
There are a number of software programs that make it easier to enter data from paper certificates, and some allow you to enter your insurance requirements so the system can check for compliance.
There is a better solution - let your vendors' insurance agents enter the data for you, directly over the internet, and let the system verify compliance with over 100 insurance requirements. Go to http://www.Ins-Cert.com
and press "Click here to learn more" under the "Certificate Holder" paragraph, or call 303/346-3889 for a demonstration.
William R. Hartigan, CIC, ARM, AAI
Ins-Cert Cororation - Denver
(303) 877-3863 cell