Twelve thousand loan files that cannot be found
The loan section of a co-operative bank in Madurai holds about 12,000 live and closed housing and jewel loan files. Files are arranged alphabetically by borrower name in open steel racks, and closed loan files are kept in the same sequence as live ones. About 140 borrowers share common names such as S. Lakshmi or M. Murugan, and clerks distinguish them only by a coloured tag. Retrieval now takes 20 to 25 minutes, eight files could not be traced last month, and the auditor has recorded that two sanction letters were placed in the wrong file. The section has no out-guide and no cross-reference slip, and one clerk keeps three files in her drawer 'for current work'. The manager has read about numeric filing with a card index and about vertical filing with folders, and wants a proposal before the next inspection.
1. Evaluate the existing alphabetical arrangement against a numeric system for this section. Give a reasoned recommendation rather than a definition of both methods.
Read the worked answer
Alphabetical filing works when names are few, distinct and stable. Here all three conditions fail. Fourteen names account for repeated entries, and Indian names are also spelled inconsistently in records (Lakshmi/Laxmi, Murugan/Murugun), so the searcher must guess the spelling used at the time of filing. Every new borrower also forces insertion in the middle of the sequence, which is exactly when mis-filing occurs - the two sanction letters in the wrong file are the predictable outcome.
Numeric filing gives each loan account a unique number, usually the account number, which never varies in spelling and is printed on every document. Files are added at the end of the sequence, so existing files never move and shelves never have to be re-labelled. The predictable weakness is that a searcher usually knows the name, not the number - which is why numeric filing is only safe when paired with a name-to-number index and cross-reference slips for joint borrowers and guarantors.
Recommendation: adopt numeric filing for the loan section, retaining the account number already in use, with a card index by borrower name, and separate the closed loan files into a distinct numeric series so that dead files stop consuming prime shelf space.
2. Explain how out-guides, cross-reference slips and a charge system would have prevented last month's eight untraced files.
Read the worked answer
The eight missing files are not evidence of theft; they are evidence of an invisible file. A file that leaves a rack without a trace is functionally lost even if it is sitting 20 feet away.
Out-guide: a stiff card, the same size as the file, placed in the vacant position, showing the file number, the name of the person who removed it and the date. Anyone searching the rack immediately knows the file exists, where it went and whom to ask. Without it, the searcher concludes the file was never filed and starts a wasteful search from the beginning.
Cross-reference slip: a card in the index or a sheet in a related file saying 'For S. Lakshmi, jewel loan, see file JL 4471'. This prevents a second file from being opened for the same borrower under a variant spelling, and it links guarantors and joint borrowers to the main file.
Charge system: a register or card on which the clerk records the file number, the date and time of removal, and the borrower's name, with a return entry. The three files in the clerk's drawer are the direct product of having no charge system - the clerk has no way to signal possession.
Together these convert an invisible movement into a recorded one, which is what the auditor will expect to see.
3. Which indexing method would you provide for 12,000 files, and what should the manager do about the closed files? Justify both choices.
Read the worked answer
Index: a card index by borrower name, with one card per borrower, arranged alphabetically and held in trays, carrying the borrower's name, address, loan account number, file number and status. It suits this volume because cards can be inserted, withdrawn or amended without disturbing other entries, and several clerks can search at the same time by splitting trays. A visible or strip index would be faster for fewer entries but becomes unwieldy at 12,000 and cannot carry enough detail. The card also gives a place to record cross-references for common names, which is the section's central problem.
Closed files: remove them from the active sequence into a separate numeric series, listed in a closed-file register or transfer list, retained according to the bank's retention schedule and the statutory requirement for loan documents, and kept in cheaper secondary storage. Two reasons: retrieval of live files falls sharply once dead files occupy the same racks, and the live series then grows only with new business. Closed files must never be destroyed casually - a housing loan may surface years later in a legal case - so the retention period should be fixed in writing and approved by the manager before anything is discarded.