Preparing a commercial tenant arrears schedule for lender review
A practical guide to assembling a tenant arrears schedule that helps a lender evaluate rent collection risk, with a concrete evidence checklist and explanations of how arrears affect underwriting.
A practical guide to assembling a tenant arrears schedule that helps a lender evaluate rent collection risk, with a concrete evidence checklist and explanations of how arrears affect underwriting.
When a lender reviews an existing income-producing property, the rent roll and the trailing twelve months (T-12) of operating statements are the two core documents. The arrears schedule sits between them: it is the detailed record of what each tenant owes and has paid over a defined period. This guide explains how to prepare that schedule, what the lender is looking for, and how the information shapes the financing discussion.
What an arrears schedule should contain
The arrears schedule is a spreadsheet or table that lists every tenant by unit. For each tenant, record the monthly base rent, any additional rent (CAM, percentage rent, utilities), the total amount due each month for the trailing twelve months, the amount actually collected each month, and the resulting arrears or prepayments. Include the lease commencement and expiration dates, the renewal options, and any rent concessions or abatements. The schedule should also note whether the tenant is current, how many months behind, and the total dollar amount of overdue rent. If the tenant has a security deposit or a guarantor, note that as well. The more complete and accurate the arrears schedule, the less follow-up the lender needs.
How arrears affect the underwriting of net operating income
The lender uses the arrears schedule to adjust the effective gross income. If a tenant is consistently late or in default, the lender may underwrite that space at a lower rent or assume a vacancy and re-leasing cost. The arrears history also influences the bad debt reserve the lender assumes. [1] The OCC handbook notes that re-leasing costs are an important consideration when analyzing cash flow, and those costs include leasing commissions and tenant improvements for new and renewing tenants. A property with high arrears may require a larger replacement reserve or a higher management fee assumption because of the additional collection effort. The lender may compare the arrears schedule to the T-12 to assess whether reported net operating income (NOI) reflects actual collections or just billed amounts.
Distinguishing the rent roll from the T-12
The rent roll is a snapshot of the current lease status: who is in place, what rent they pay, and whether they are current. The T-12 is a historical report of income and expenses for each of the past twelve months. The arrears schedule bridges the two. For example, the rent roll may show a tenant as current, but the T-12 may show that tenant paid late for six of the last twelve months. The arrears schedule captures the payment pattern, not just the current balance. When you compare the totals, the gross rent from the rent roll should match the sum of the T-12 income line items, but the collected income will be lower if there are arrears. Explain the timing difference: the rent roll is as of today, while the T-12 covers the prior twelve months. A tenant who was current at the end of the T-12 may have fallen behind since, and the arrears schedule should show that.
Identifying the reporting basis and reconciling periods
Before you prepare the arrears schedule, confirm the reporting basis of the financial statements. If the property uses cash-basis accounting, the income line shows only what was actually received. If it uses accrual-basis accounting, the income line shows what was billed, regardless of collection. The arrears schedule should be prepared on a basis that aligns with the lender's underwriting approach, which the borrower can confirm with the lender. [1] The OCC handbook says that lease agreements should always be reviewed to determine which expenses are the landlord's responsibility. Similarly, the arrears schedule should note which expenses are reimbursable and whether those reimbursements are being collected. Reconcile the periods: the T-12 covers a specific twelve-month window, and the arrears schedule should cover the same window. If the lender asks for a current rent roll and a T-12 ending last month, the arrears schedule should also end last month.
Preparing a concrete evidence checklist
Here is a suggested checklist of documents and workpapers to assemble alongside the arrears schedule:
- A current rent roll with lease expiration dates, rent amounts, and any concessions.
- The trailing twelve months of income and expense statements (T-12).
- A tenant arrears schedule covering the same twelve months, with monthly collection data.
- Copies of the lease agreements for any tenant that appears more than one month in arrears.
- A reconciliation showing how the arrears schedule totals tie to the T-12 income line.
- A summary of any collection actions taken (e.g., notice to cure, demand letters, eviction proceedings).
- A list of security deposits held and whether they have been applied to arrears.
- For tenants with percentage rent, a record of reported sales and whether percentage rent was collected.
This checklist is a suggested way to prepare information for the lender. It is not a mandatory lender process, but having it ready can reduce underwriting delays.
Distinguishing gross rent, collected income, NOI, capex, debt service and equity cash flow
The arrears schedule directly affects each of these metrics. Gross rent is the total of all base rents and additional rents billed. Collected income is what was actually received. NOI is collected income minus operating expenses (including a management fee and a replacement reserve). Capital expenditures (capex) are separate from operating expenses and are not deducted in NOI; they are funded from NOI or from a reserve. Debt service is the principal and interest due on the loan. Equity cash flow is whatever remains after debt service. If arrears are high, collected income falls, NOI falls, and the property may not generate enough cash flow to cover debt service, let alone provide a return to equity. [1] The OCC handbook notes that re-leasing costs are not always considered an operating expense in calculating NOI but are an important consideration when analyzing cash flow. That means the lender may look at the arrears schedule and decide to underwrite a vacancy and re-leasing cost for a troubled tenant, which further reduces projected NOI.
What to do with the arrears schedule after it is prepared
Identify any tenants that are more than 30 days past due and discuss the collection plan. If a tenant is in default, the lender may require a cure or a lease termination before funding. If the arrears are concentrated in one or two tenants, the lender may underwrite those spaces as vacant. If the arrears are widespread, the lender may question the property management and require a management plan. The arrears schedule is not just a historical record; it is a tool for the lender to assess the property's cash flow stability and the sponsor's ability to manage risk.
Frequently asked questions
What if the tenant has a security deposit that covers the arrears?
Record the deposit amount and whether it has been applied to the arrears. The lender will still consider the tenant's payment history because a deposit is not a substitute for consistent rent collection. If the deposit is applied, the lender may underwrite a lower effective rent going forward.
How do I handle a tenant who is paying but always late?
Record the payment pattern in the arrears schedule. The lender may underwrite that tenant at a lower rent or assume a higher bad debt reserve. If the tenant pays within a grace period, note that as well; some lenders will treat that as current, while others will count the late payments.
Does the arrears schedule need to be audited?
No, but the lender may request supporting documentation such as bank statements, rent receipts, or tenant ledgers. The schedule should be prepared by someone who can vouch for its accuracy, such as the property manager or the sponsor's accountant. If the lender finds discrepancies, it may require a third-party review.
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).