We had an auditor who basically said we have to maintain a register of all printed documents to ensure we know who has what and where. I foresee this as a nightmare. Is there a better way to manage this?
Hi Belicia,
Your auditor was correct - for adequate document control you should maintain a register of your controlled documents. This would include SOP's, Specifications, Logs, etc. etc. etc.. Depending on the type of certification you are trying to comply with, the word "should" becomes "shall".
BRC
3.2.1 - The company shall have a procedure to manage documents which form part of the food safety and quality system. This shall include:
- a list of all controlled document indicating the latest version number
SQF
2.2.1.1 - A register of current SQF System documents and amendments to documents shall be maintained
As Charles C. pointed out, the register is "certainly nice to have as long as you don't have to do it yourself". Unfortunately, when the QA/Food Safety Manager or SQF practitioner informs upper management that they need to have a document register, this all to often becomes the function of the QA/Food Safety Manager or SQF practitioner. What this typically boils down to is a lot of time spent on data input, rather than proactively assuring the quality and food safety at your facility.
There have been quite a few really great contributions to this discussion.
mgourley: Perhaps a watermark that says "This document, once printed out, is not controlled"
This is a great idea and one that I've used (and have seen used at many facilities) to indicate that as soon as the document is printed it is no longer "controlled" and it is up to the user of the document to maintain control of it. Should the "official" electronic version be updated, it is the requirement of each individual to ensure they have the updated version. This effectively saves the documentarian from having to spend an entire day walking around the facility updating manuals, and now the onus is put on each individual to conform to the company policy of obtaining their records from the updated, correct electronic version rather than a depleted stack of outdated records from 10 years that they found in a desk drawer.
MerleW: No you need an actual register for all of your documentation you can't just say that a copy is not controlled.
Exactly. First item of business is the document register. The watermark in conjunction with the register helps you meet the requirement to control your documents.
I might add that if you are going to utilize an excel spreadsheet to create (and maintain) what will amount to be another pain in the rear end database, make sure to include the document # (see MerleW's post for numbering suggestions), Rev. date, name of document, document version, folder path, and status at a minimum. As all food safety professionals know, Murphy's Law is in full effect when the auditor comes to visit so if you forgot to update one cell, you can be sure that it is the document they look at during the audit. 
Best of luck to you!
-Chris