Keeping an audit trail when an original property file is replaced by a revision
A practical guide for sponsors on preserving document version history when updating lender files, including a concrete evidence checklist to prepare before submitting revisions.
A practical guide for sponsors on preserving document version history when updating lender files, including a concrete evidence checklist to prepare before submitting revisions.
When you revise a property file for a commercial real estate financing — updating a rent roll, correcting an operating statement, or replacing an outdated appraisal — the original version can disappear. Lenders review files that are accurate, timely, and traceable. A missing audit trail may raise questions about whether you are masking deterioration or simply managing a normal update.
This guide explains how to prepare a revision history workpaper that keeps the original evidence visible, even after the file is replaced.
Why version history matters to lenders
Bank supervisory guidance discusses analyzing financial statements to verify that all expenses are accounted for and appropriate for that particular property [1]. When a file is replaced without a record of what changed, a lender cannot verify whether the revision corrected an error or obscured a developing problem.
The same guidance notes that a troubled loan can be masked when the loan's underwriting structure or the liberal use of extensions or renewals obscures a borrower's inability to meet reasonable repayment terms [1]. A clean file with no version trail may appear consistent, but the lender has no way to see whether earlier versions showed missed payments, falling occupancy, or rising expenses.
Your revision history is not a guarantee that the lender will accept the updated file. It is a suggested way to prepare information that helps the lender understand what changed and why.
What to include in a revision history workpaper
Prepare a single-page document workpaper titled "Property File Revision History" that records the following for each file version you replace:
- File name and version number or date
- Date the original was provided to the lender
- Date the revision is being provided
- A brief description of what changed (e.g., "Corrected utility expense line for January" or "Updated rent roll to reflect new lease signed March 15")
- The reason for the change (e.g., "Data entry error in original" or "New information available")
- The name of the person who prepared the revision
Keep the original file in your own records, even if the lender does not ask for it. You are preserving an audit trail for your own file, not for the lender's underwriting.
Distinguishing a correction from a material change
A correction fixes an error in data that existed at the time the original file was prepared. A material change reflects new information that did not exist when the original file was prepared.
For example, correcting a typo in a net operating income calculation is a correction. Adding a new tenant's rent after a lease is signed is a material change. Both are legitimate reasons to revise a file, but they affect the lender's analysis differently.
Lenders may treat a material change as a new data point that requires additional underwriting. A correction, if it is small and well-documented, may not require the same level of review. Your revision history workpaper should clearly label each change as either a correction or a material change.
How to compare totals across versions
When you revise a financial statement, the totals may change. The lender will want to understand whether the change is due to a correction, a new event, or a different accounting basis.
The OCC handbook discusses analyzing cash-basis financial statements that reflect only expenses that have been paid in cash instead of all expenses that have been incurred as in accrual-basis statements [1]. If your original file used cash-basis statements and your revision uses accrual-basis statements, the totals will differ even if no expense changed.
To prepare for this comparison:
- Record the reporting basis (cash or accrual) on each version of the file
- Note the period covered by each version
- If the basis changes between versions, state that explicitly in your revision history
Do not assume the lender will notice a basis change. Your revision history should make it obvious.
What to do when the original file is lost or destroyed
If you cannot produce the original file because it was lost, destroyed, or overwritten, you can still prepare a revision history. In place of the original file, document:
- When the original was created and by whom
- What it contained, to the best of your recollection
- Why it is no longer available
- When the revision was created and what it contains
This is not the same as having the original, but it gives the lender a record of the gap. The lender may ask additional questions, but you have provided an honest account of what happened.
How to present the revision history to the lender
Attach your revision history workpaper to the revised file when you submit it. Do not wait for the lender to ask. A cover note that says "Revised rent roll attached; see revision history for details" is sufficient.
If the lender's underwriting process uses a check sheet to ensure that required documents are received and on file [1], your revision history can be added as a supplementary document. It is not a required form, but it supports the lender's internal controls.
What the revision history does not do
A revision history does not guarantee that the lender will accept the revised file or that the lender will not request additional information. It is a tool for transparency, not a substitute for accurate original data.
It also does not protect against liability if the revision conceals a material fact. If you know that the original file was inaccurate and you revise it without disclosing the inaccuracy, the revision history may actually work against you by documenting the change.
Finally, the revision history is not a commitment from the lender. Submission is a preliminary request, not an engagement or lender submission.
Frequently asked questions
Should I keep the original file even if the lender says they do not need it?
Yes. The original file is your record of what was provided. If the lender later asks about a discrepancy, you have evidence of what was originally submitted. The OCC handbook discusses internal audit evaluating the reliability, adequacy, and effectiveness of accounting, operating, and administrative controls [1]. Your own file management is part of that control environment.
What if the revision is a complete replacement, not a minor update?
Treat a complete replacement the same way. Document what the original contained, why it is being replaced, and what the new version contains. A complete replacement may signal to the lender that the original was unreliable, so your revision history should explain the reason clearly.
Does the revision history need to be notarized or certified?
No. The revision history is a workpaper you prepare for your own file and share with the lender. It does not need to be notarized or certified. It should be factual and dated, but it is not a legal document.
Send us the property, the business plan, and the capital you need. We will tell you how we would approach it.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).