Can I Afford This Property?Commercial real estate financing, worked out

Documenting payroll assumptions after a property management change

A practical guide to preparing a payroll reconciliation worksheet that helps lenders evaluate operating expense stability after a property management transition.

Source: CodexTopic: Operating expense reconciliation1358 wordsUpdated 2026-11-19

A practical guide to preparing a payroll reconciliation worksheet that helps lenders evaluate operating expense stability after a property management transition.

When a property changes management, the payroll line on the trailing twelve month (T-12) operating statement can become a source of lender questions. The old manager's staffing, pay rates and allocation methods may not reflect the new manager's plan, yet the historical T-12 is what lenders typically use to underwrite net operating income. The task is to document the transition clearly so the lender can see which part of the payroll history is relevant and which part has changed.

Why payroll assumptions matter after a management change

A T-12 is twelve calendar months of historical income and expense data. A current rent roll is a snapshot of today's leases. When management changes partway through that twelve month window, the payroll figures in the T-12 mix two different staffing and compensation systems. Lenders use the T-12 to estimate stabilized expenses, but if the old manager ran a heavier or lighter crew than the new manager intends, the blended average will not predict future payroll. The OCC Commercial Real Estate Lending handbook describes the importance of understanding changes in loan portfolio composition and external factors such as local economies and property markets [1]. A management change is exactly that kind of external factor, and documenting it helps the lender assess whether the expense trend is reliable.

Identify the management transition date and staffing differences

Record the exact date the new manager took over. Compare the old manager's payroll records for the months before the transition with the new manager's payroll for the months after. Look for differences in:

  • Number of onsite staff (full-time, part-time, contract)
  • Hourly rates or salaries
  • Allocation of shared staff between properties
  • Payroll frequency or cut-off dates

A suggested way to prepare this information is to create a simple table listing each month of the T-12, the manager in place that month, the total payroll recorded, and the number of staff. Then note any known changes in staffing levels or pay rates that occurred at the transition. This table is not a lender requirement, but it gives the underwriter a clear before-and-after picture.

Reconcile the T-12 payroll to the new manager's budget

Take the new manager's projected monthly payroll for the property and compare it month by month to the historical T-12 payroll. If the new manager's budget is lower, explain why: for example, the old manager may have used a higher-paid regional supervisor who was replaced by a local property manager. If the new budget is higher, explain the increase: perhaps the old manager understaffed and the new manager plans to add a maintenance technician.

Calculate the difference in dollars and as a percentage of the T-12 average. Then ask the actual lender whether they will accept the new manager's budget as the underwriting expense or whether they will use a blended historical figure. Different lenders have different policies, and the OCC guidance notes that management information systems and credit underwriting standards are key elements for concentration risk management [1]. The lender's underwriter will decide which expense assumption to apply.

Prepare a payroll reconciliation worksheet

The concrete workpaper for this task is a one-page reconciliation worksheet. It should contain:

  • Property name and date of management change
  • T-12 period covered (start and end month)
  • Old manager's average monthly payroll for the months they managed
  • New manager's average monthly payroll for the months they managed
  • New manager's projected monthly payroll budget going forward
  • A short narrative explaining the reason for any difference (staffing count, pay rates, allocation change)
  • The dollar and percentage variance between the T-12 blended average and the new projected budget

This worksheet is not a guarantee of lender acceptance, but it organizes the information the underwriter needs to evaluate the expense line. It also helps the sponsor prepare for follow-up questions about other operating expenses that may have changed with the management transition.

Distinguish gross rent, collected income, NOI, capex, debt service and equity cash flow

A common confusion in underwriting is mixing up line items. Gross rent is the total of all signed leases before any vacancy or collection loss. Collected income is what actually arrived in the bank account. Net operating income (NOI) is collected income minus all operating expenses, including payroll. Capital expenditures (capex) are not operating expenses; they are improvements that extend the life or value of the asset. Debt service is the loan payment, and equity cash flow is what remains after all expenses and debt service are paid.

When payroll changes, the effect flows through to NOI, which is the primary metric lenders use to calculate debt service coverage. If payroll increases by a certain amount, NOI decreases by the same amount, and the loan amount the property can support may decrease accordingly. The reconciliation worksheet makes this cause-and-effect visible.

Ask the lender about payroll normalization adjustments

Some lenders will apply a normalization adjustment to the T-12 payroll if the new manager's budget is well supported. Others will insist on using the full twelve month average regardless of the management change. The OCC handbook discusses the importance of board and management oversight and portfolio management in establishing risk management frameworks [1], which means the lender's internal policies will dictate how they treat the expense line. The sponsor's job is to present the evidence and let the lender decide.

A suggested way to prepare for this conversation is to have the reconciliation worksheet ready along with a copy of the new manager's staffing plan and payroll budget. If the new manager has managed other similar properties, include a reference or a sample of their payroll history at those properties. This gives the lender more data points to evaluate the reasonableness of the new assumptions.

What to do if the payroll variance is large

A large variance will likely trigger additional underwriting scrutiny. The lender may ask for a third-party expense comparability study or a property condition assessment to confirm that the new staffing level is appropriate for the property size and type. The sponsor should be prepared to justify the new payroll figure with market data or the new manager's track record.

The OCC guidance on concentration risk management mentions the need for portfolio stress testing and market analysis [1]. While that language is directed at banks, it reflects the kind of analytical depth lenders expect when a key expense line changes significantly. A well-prepared reconciliation worksheet demonstrates that the sponsor has thought through the risk and can support the new assumption.

Frequently asked questions

How far back should I go in the T-12 to show the old manager's payroll? Use the full twelve months available, but separate the months by manager. If the management change happened six months ago, you will have six months of old manager data and six months of new manager data. That is enough to show the difference. If the change was more recent, you may only have a few months of new data, and the lender may want to see the new manager's budget as the primary assumption.

Can I use the new manager's budget even if the T-12 shows higher payroll? Yes, but you need to document why the old manager's payroll was higher. Common reasons include different staffing levels, different pay scales, or different allocation methods for shared employees. The reconciliation worksheet should explain the variance clearly. The lender will then decide whether to accept the new budget or require a blended figure.

What if the new manager's payroll is lower but the property's occupancy has increased? This is a potential red flag for lenders because higher occupancy typically requires more staff, not less. Be prepared to explain how the new manager achieves lower payroll despite higher occupancy. Possible explanations include automation, more efficient scheduling, or consolidation of roles. If the explanation is not convincing, the lender may ask for a third-party expense study or adjust the NOI downward.

Closing invitation

We will review the payroll reconciliation worksheet and other operating expense assumptions as part of building the loan request. Submission is a preliminary request, not an engagement or lender submission.

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.

Open the loan sizing calculator

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.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt