Excel workbook previewBank supervision (OCC, FFIEC, FDIC)
Loan Review Worksheet
3 free downloads per account. Just your email and a 6-digit code.
About this template
A loan review worksheet records what an independent reviewer found in each credit file: the grade the loan officer gave, the grade the reviewer would give, the classification, documentation and policy exceptions, and the follow-up agreed. Banks of every size need an effective loan review system, and the board expects a summary of the results at least each quarter.
This workbook follows the loan review elements in section 3.2 of the FDIC RMS Manual of Examination Policies, including the factors a review analyses and the uniform definitions of Special Mention, Substandard, Doubtful and Loss. A register, a credit file checklist, a grade scale and a formula-driven summary are filled in for ten fictional loans at a community bank.
Who it is for
The loan review officer or outside loan reviewer at a community bank who must document each credit reviewed and report the results to the board.
What is inside
- Loan Review register with 10 worked commercial loans and 20 blank rows, 18 columns per loan
- Live grade change, regulatory class (Pass, Special Mention, Substandard, Doubtful, Loss) and days to follow-up per loan
- Credit File Checklist with 32 items in 7 groups, taken from the depth-of-review factors in the FDIC examination manual
- Checklist completion and exception counts by formula
- Grade Scale sheet with a 9-grade scale mapped to the regulatory classification definitions
- Summary sheet with count and balance by class, classified total, upgrades, downgrades, grade agreement rate and overdue follow-ups
- Dropdowns, color on classified loans, nonaccruals and overdue follow-ups, frozen headers, filters and print fit
How to use it
Enter each loan reviewed on the Loan Review sheet, then complete one Credit File Checklist per loan file.
Files
- XLSXloan-review-worksheet.xlsx18 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What should a loan review cover?
The FDIC examination manual lists credit quality, sufficiency of credit and collateral documentation, proper lien perfection, proper loan approval, adherence to loan covenants, compliance with internal policies and laws, and the accuracy and timeliness of the grades assigned by loan officers. The credit file checklist in this workbook is organized around those factors.
What is the difference between Special Mention and Substandard?
A Special Mention asset has potential weaknesses that deserve close attention but is not adversely classified. A Substandard loan is inadequately protected by the paying capacity of the borrower or the collateral and has a well-defined weakness that puts repayment at risk, with a distinct possibility of some loss if the weaknesses are not corrected.
How often should significant loans be reviewed?
The FDIC manual says reviews of significant credits are generally performed annually, upon renewal, or more often when there are signs of deteriorating credit quality. Reviews usually cover loans above a set size plus smaller loans with higher risk, such as delinquent, nonaccrual, modified, previously classified or Special Mention credits.




