The Appraiser’s Workfile – Part II

In Part 1, I explored the question “What should be in the appraiser’s workfile?” The take-away is that no two workfiles will look alike; rather, the minimum standard emphasizes retaining data and information that supports the appraiser’s analyses, conclusions, and opinions. Another common question from appraisers, clients, lenders, and appraisal management companies is “What do we really mean by ‘workfile’?”

Key to understanding the Record Keeping Rule is that all report copies must be retained as part of the workfile. So, for example, if the appraiser attaches a copy of the subject’s county assessor page as an exhibit page to the appraisal report, then she would not need to retain a duplicate PDF copy of that assessor page in her records — it’s already in the workfile by virtue of being a page in the report, because the report copy should already be retained.

Similarly, if the appraiser describes in the appraisal report details learned during a phone conversation with the subject’s listing agent (for example, details of feedback the agent received after showings), the appraiser would not need to duplicate that same information in a “telephone note” in her records. Expressed differently, the sum of an appraiser’s workfile includes the report copy(ies) plus any other additional material retained:

WORKFILE = REPORT COPY(IES) + OTHER ADDITIONAL MATERIAL.

In this way, if information is included in the retained appraisal report, that same information does not need to be duplicated (i.e., “re-retained”) as a separate identical record.

Nature of the workfile

A workfile is not a report. While Standard 2 contains obligations related to the communication of assignment results (ie, the appraisal report or appraisal review report), such as being understandable to and appropriate for the intended user(s) and not misleading, a workfile is not a report and does not have those same communication obligations: there is no expectation for the workfile to be “ready-to-read” for any party. Nevertheless, a workfile should at least be understandable to the appraiser, to the point where the appraiser can understand how the workfile information led to his analyses, conclusions, and opinions. It is conceivable that a regulator may not initially understand every component of a workfile.

For example, as a simple illustration, if an appraiser makes inspection and research notes using his own abbreviations and unique short-hand, then a regulator or other party reading the workfile might not fully understand exactly how the research notes support the claims made in the appraisal report.

I was recently contacted by a state regulator asking about a particular method that an appraiser had included in her workfile. I offered an explanation of how that particular method would typically be supported, applied, and connected to other components. But, in the end, the regulator should contact the appraiser to ask her to “join the dots” between the data and methods expressed in the workfile to the conclusions and summaries in the report, in order to demonstrate how A supported and led to Z.

A workfile is not necessarily a physical folder of papers. Instead, it can be a combination of paper, electronic documents, and references to other locations. All components must be accessible and retrievable.

A Warning on References to Other Locations for Workfile Content

The Record Keeping Rule allows for references to other locations, without making a copy of an entire record, such as by referring to a cost manual, a prior assignment’s workfile, websites, computer systems, or a data base of the appraiser’s prior research. However, the appraiser must still be able to access the same information during the time frame required by the Record Keeping Rule. Consider the following problematic scenarios:

Three years after completing an assignment, an appraiser realizes the local association converted the MLS system to a difference platform, which reduced the number of data fields and photographs. Now, he cannot reproduce the search he claims he made at the time of the appraisal and details of comparable sales are now not supported.

For a second assignment (Assignment B), an appraiser references a land study contained in a prior assignment’s workfile completed three months ago (Assignment A). Four years and 11 months after Assignment B, the appraiser has already destroyed Assignment A’s workfile which contained the land study (Assignment A’s five-year retention period expired), so the support for her land value in Assignment B no longer exists.

Two years after an assignment, the appraiser is faced with a state regulator asking for evidence that the subject is 1.4 acres and is zoned RSF-B, as stated in his report. The only support in the workfile is a reference to the county assessor website, which now shows the property has apparently been split and rezoned since the assignment. He asks the county assessor for any archived historical records, but has not yet heard back.

Looking back at a three-year old assignment, the appraiser notices the page numbers she referenced in the commercial cost manual do not correspond to the data she cited in her report. She realizes that her office has simply been discarding the superseded pages as the manual is updated and there is now no evidence for the cost rates she used in her report.

Keep a database of research and conclusions

One practice by some appraisers is to keep a “master workfile”, a database of prior research, analyses, and conclusions stored in a non-assignment-specific location and relied upon in multiple appraisals as applicable to each assignment.

For example, studies of market trends, adjustment rate studies, land sales, sell-to-ask analyses, and other research may be applicable to multiple assignments where appropriate, without “reinventing the wheel” each time. If using this approach, an appraiser must reference that prior research he relies upon and ensure the research is retained for the appropriate time frame.

It’s Not a Math Problem

In a recent case heard publicly by a state board, a party to the case made a statement similar to “…and further, the appraiser’s workfile didn’t show the math behind the $45 per-sq.ft. GLA adjustments.”

Barring a state’s regulation that may add additional workfile obligations, the Record Keeping Rule of USPAP does not specifically require that an appraiser’s workfile “show the math”. Rather, the Rule indicates the workfile must contain “all other data, information, and documentation necessary to support the appraiser’s opinions and conclusions…” (emphasis added).

Upon further questioning, the individual criticizing the workfile did agree that even though the math was not shown or “spelled out” in the workfile notes pages, the comparable sales used in the report and additional MLS sales sheets retained in the workfile did reasonably support the $45 per-sq.f.t GLA adjustments that were applied in the report. It was argued, then, that the workfile did in fact meet minimum USPAP requirements: even though the math was not retained, the comparable sales data retained in the workfile did support the appraiser’s adjustment rate.

A Warning on “Re-creating” a Workfile

I recently received a call from an appraiser that had received a request from a state regulator for her to send in the workfiles of several assignments. Before she forwarded her workfile, she noticed that she had not retained any of the sales searches that supported conclusions in her report, such as the ranges of and predominant prices, trend conclusions, and similar conclusions. So, she decided to reproduce the sales searches that supported the claims in her report, changed dates on the search result pages, and then presented those documents to her state regulator as part of the requested workfiles.

Needless to say, it was clear she had tried to “back-date” searches, and the response from the state was not good. By responding to a request for a workfile in this manner, the appraiser was essentially claiming the documents were created years ago (at the time of the assignment), despite truly being only days old following the state’s request.

Remember, in accordance with the Record Keeping Rule: “A workfile must be in existence prior to the issuance of any report or other communication of assignment results.” Key take-aways:

  • Workfile components must exist prior to issuing the appraisal report.
  • Even if an appraiser were to “re-create” data that was not present or retrievable (in order to, for example, show the validity of the conclusions expressed in the report), it would be crucial for the appraiser to clearly indicate that the new items were in fact new and were not part of the original workfile retained at the time of the assignment.

The actions of the appraiser in this example clearly conflict with the Record Keeping Rule and, since they were intentional, also conflict with the Ethics Rule.

For more background on the Record Keeping Rule and workfile obligations, see Part 1.

Joshua Walitt is the Principal Consultant for Walitt Solutions, and conducts webinar and classroom training for appraisal firms, associations, lenders, and appraisal management companies. To schedule a USPAP course, custom training course, or compliance or valuation consulting, email joshua@walitt.com or visit walitt.com.

The Appraiser’s Workfile

Two common questions that come up when I’m coaching appraisers, training an appraisal department at a lender or management company, or teaching a USPAP course is “What should be in the appraiser’s workfile?” and “What do we really mean by ‘workfile’?” I’ll explore the first question here, and the second question in Part 2.

At a conference of state appraiser regulators I took part in during the spring of 2019, one state regulator suggested that USPAP should contain a more-itemized list of components that are required to be retained in an appraiser’s workfile. I believe such a detailed Rule is unnecessary; USPAP already sets a reasonable standard for the minimum components that must be retained in an appraiser’s workfile for appraisal and appraisal review assignments.

Rather than setting in stone a lengthy list of items for a workfile (which inevitably means that some of those items will be inapplicable for certain types of assignments), appraisers and their regulators should instead re-familiarize themselves with USPAP’s Definitions and Record Keeping Rule. From the 2020-2021 Uniform Standards of Professional Appraisal Practice (USPAP), in part:

Definition of “workfile”:
data, information, and documentation necessary to support the appraiser’s opinions and conclusions and to show compliance with USPAP.

Record Keeping Rule:
An appraiser must prepare a workfile for each appraisal or appraisal review assignment. A workfile must be in existence prior to the issuance of any report or other communication of assignment results. …
The workfile must include:
• the name of the client and the identity, by name or type, of any other intended users;
• true copies of all written reports, documented on any type of media; …
• all other data, information, and documentation necessary to support the appraiser’s opinions and conclusions and to show compliance with USPAP, or references to the location(s) of such other data, information, and documentation.
[Edited for length. Refer to USPAP for the complete Record Keeping Rule.]

What is “all other data”?

The first two bullet points shown in the Record Keeping Rule excerpt above are straight-forward and typically easy to comply with, generally by retaining the engagement letter and all report copies. However, the third bullet point shown above is less straight-forward. What does USPAP intend by “all other data, information, and documentation necessary to support the appraiser’s opinions and conclusions and to show compliance with USPAP”?

In short, the “all other data…” workfile obligation prevents appraisers from “making up” their opinions, conclusions, data analyzed, information relied upon, and so on.

Related to the content of an appraisal report (such as data, conclusions, statements, etc.), an appraiser should ask “Do I have something in my workfile that supports what I expressed, or would it look like I pulled it out of thin air?”

Easy Workfile “Rules”

While certainly not USPAP “canon”, I share three simple “Rules” when coaching appraisers to focus on the intent of keeping a workfile and to promote questions that examine whether an appraiser’s workfile meets minimum requirements. They are:

  1. If you see it, save it.
  2. If you express it, support it.
  3. Could a peer come to similar results using your workfile?

In other words, if an appraiser’s process includes researching county records, MLS records, photographs of properties, and other sources, the Record Keeping Rule indicates such items should be retained. For example, if an appraisal report includes the subject’s legal description, site size, zoning, and shape, did the appraiser retain the county records (or applicable sources) that support those relevant characteristics?

If an appraiser is not retaining such sources, an appraiser should consider: “Why would I not print the web pages to PDF when I look up county records, MLS information, and other data?”

In my Investigations Workshop with appraisers, among other questions, we explore:

  • If a report indicates a market trend conclusion of Stable, did the appraiser retain data he relied upon to come to that conclusion? Looking at that same data, could a peer come to a reasonably similar conclusion, or is it clear that the workfile data points to an Increasing or Decreasing market?
  • If the sales comparison approach includes a $50,000 adjustment for difference in quality of construction, does the appraiser have data in the workfile that supports her adjustment?
  • For the cost approach, if an appraiser cited “Marshall and Swift Residential Handbook and local contractors”, did the appraiser retain copies of those data sources and do the data sources support the cost information used in the appraisal report?
  • While not a step an appraiser would realistically take for each assignment, if the appraiser were to ask a peer to look at the data and information in the workfile, would that peer be able to come to conclusions similar to those expressed in the appraisal report?

In Part 2, I’ll explore the question, “What do we mean by ‘workfile’?” including referencing other locations of information and a caution of recreating documentation after the assignment.

Joshua Walitt is the Principal Consultant for Walitt Solutions, and conducts webinar and classroom training for appraisal firms, associations, lenders, and appraisal management companies. To schedule a USPAP course, custom training, or consulting, email joshua@walitt.com or visit walitt.com