Guides

Rental Property Balance Sheet Template: Line Items and Structure

A rental property balance sheet template with real estate asset, liability, and equity line items, plus how it ties to the T-12 and what lenders check.

Why the standard balance sheet template doesn’t fit real estate

A generic small-business balance sheet template, the kind that ships in every accounting software package, assumes a mix of inventory, accounts receivable, equipment, and diversified payables. Apply that structure to a rental property and half the line items go empty while the two accounts that actually matter, the property basis and the mortgage, get buried under headings that don’t describe them well.

A rental property balance sheet needs its own structure because the asset side is concentrated in one illiquid holding carried at cost, the liability side is dominated by a single secured loan, and several line items (accumulated depreciation, tenant security deposits, escrow reserves) exist only because real estate ownership works differently from operating a business that sells goods or services.


The rental property balance sheet structure

SectionLine itemWhat it represents
AssetsCash and cash equivalentsOperating account balances
Restricted cash / escrow reservesTax, insurance, CapEx, TI/LC reserves held by lender
Tenant security deposits held (asset side, if segregated)Mirror of the liability, if funds are in a separate account
Accounts receivableRent and reimbursements billed but uncollected
Prepaid expensesInsurance, prepaid taxes, prepaid loan fees
LandNon-depreciable portion of acquisition basis
Building and improvements, at costDepreciable basis: purchase price allocation + capitalized CapEx
Less: accumulated depreciationContra-asset; cumulative depreciation taken
Net property and equipmentBuilding and improvements minus accumulated depreciation
Deferred financing costs, netLoan origination fees, amortized over loan term
Deferred leasing commissions, netCapitalized lease-up costs, amortized over lease term
Total assetsSum of the above
LiabilitiesAccounts payableUnpaid vendor invoices
Accrued expensesAccrued interest, accrued property tax, accrued payroll
Tenant security deposits held (liability side)Funds held on tenants’ behalf, refundable
Prepaid rentRent collected in advance of the period it applies to
Current portion of long-term debtPrincipal due within 12 months
Mortgage payable, net of current portionOutstanding loan principal, long-term portion
Total liabilitiesSum of the above
EquityMember/partner capital contributionsCumulative equity invested
DistributionsCumulative cash returned to owners (contra-equity)
Retained earnings / cumulative net incomeRolled forward from the operating statement each period
Total equityContributions minus distributions plus retained earnings
Total liabilities and equityMust equal total assets

Asset side: what’s specific to real estate

Land and building, separated. Land is never depreciated; building and improvements are. Getting this split wrong at acquisition, whether by not separating the purchase price allocation or by using an inaccurate land-to-building ratio, misstates depreciation for the life of the hold. Most acquisitions use the county assessor’s land-to-improvement ratio or a cost segregation study to set this split, and it should be documented in the closing file.

Accumulated depreciation as a running offset. Commercial property depreciates over 39 years straight-line (27.5 for residential); land does not depreciate. This creates a structural feature specific to real estate balance sheets: book value declines every year on a stabilized, cash-flowing asset that may simultaneously be appreciating in market value. A five-year-old $40M acquisition with a $32M depreciable basis has taken roughly $4.1M of accumulated depreciation by year five. No cash leaves, but book equity falls by that amount.

Restricted cash and escrow reserves, separated from operating cash. Lenders on institutional loans routinely require monthly escrow deposits for real estate taxes, insurance, and capital reserves, plus TI/LC (tenant improvement/leasing commission) reserves on office and retail assets. These funds are not available for operations and belong in a distinct line from the operating cash account. Combining them overstates liquid, spendable cash, and it’s one of the first things a lender’s underwriter checks.

Deferred financing and leasing costs. Loan origination fees and lease-up commissions are capitalized and amortized over the loan term or lease term, respectively, rather than expensed immediately. Both appear as net asset balances (gross cost less accumulated amortization), similar in structure to accumulated depreciation on the building.


Liability side: what’s specific to real estate

Tenant security deposits, as a liability. Owners without institutional-grade bookkeeping mishandle this item more than any other. A security deposit received from a tenant is a refundable liability held on the tenant’s behalf, not income, and in many states it must sit in a segregated, sometimes interest-bearing account. Booking a deposit as revenue when received (rather than as a liability, with income recognized only if and when it’s forfeited or applied) inflates reported income and creates a real problem at tenant turnover when the deposit is due back.

Prepaid rent. Rent collected before the period it covers (common with annual or upfront payments from certain tenant types) is a liability until the corresponding period passes, at which point it converts to recognized rental income. This is the mirror image of accounts receivable: money the owner holds but hasn’t yet earned.

Mortgage payable, split between current and long-term. The portion of principal due within the next 12 months is classified separately as a current liability, with the remainder as long-term. This split matters to lenders evaluating a refinance or an acquisition loan, since it’s a direct input to near-term debt service coverage and covenant testing.


Equity: why it understates real value

Balance sheet equity for a real estate holding (contributed capital, less distributions, plus retained earnings) is a book-basis number, and it systematically diverges from the owner’s real economic equity because the property sits on the balance sheet at depreciated cost rather than market value.

Consider a stabilized asset acquired five years ago for $40M with $12M of equity, now generating strong NOI and appraised at $52M. Book equity, after five years of depreciation eating into the property’s carrying value and modest retained earnings, might show $13.5M. Real economic equity (market value less outstanding debt) is closer to $22M. The two numbers measure different things. Lenders and auditors want the book figure because it’s auditable and consistent. Owners, brokers, and buyers evaluating a sale or refinance want the market figure, which requires an appraisal or a comparable-sales analysis layered on top of the balance sheet, not read directly off it.


How the balance sheet ties to the T-12

The balance sheet and the T-12 are two views of the same underlying financial activity, and a diligence team should be able to reconcile them.

  • Net operating income from the T-12 flows into retained earnings. After debt service and capital expenditures, the residual period earnings roll forward into the equity section.
  • Cash balances should reconcile. The T-12’s cash flow statement (or a derived cash rollforward) should explain the change in the balance sheet’s cash line from one period to the next. A gap usually means either a timing difference between accrual and cash accounting, or an unrecorded transaction (a capital call, a distribution, a loan draw) that didn’t make it into both documents.
  • Accounts receivable on the balance sheet should match uncollected rent implied by the T-12’s billed-versus-collected detail. A balance sheet AR balance that’s grown faster than the T-12’s revenue trend is an early signal of a collections problem the income statement alone won’t surface as clearly.

A buy-side analyst pulling both documents during diligence checks this reconciliation early, because a balance sheet that doesn’t tie to the operating statement is a signal that the seller’s books aren’t being maintained with rigor, and every other number in the package then needs independent verification, including the numbers that would otherwise sit inside a multi-year operating statement consolidation or feed a NOI calculation used to underwrite the deal.


What lenders check first

Underwriters reviewing a rental property balance sheet as part of a loan package or refinance request a small, consistent set of items before they move to anything else:

  1. Loan balance versus the note. The mortgage payable figure should match the lender’s own records of outstanding principal — a mismatch triggers an immediate reconciliation request.
  2. Reserve balances versus required minimums. Escrow and CapEx reserve accounts are checked against loan covenant minimums; a reserve running below the required threshold is a covenant flag before it’s anything else.
  3. Security deposit liability versus the rent roll. Lenders (and buyers) cross-check the security deposit liability balance against the sum of deposits listed on the current rent roll. A shortfall suggests deposits were spent rather than held, which is both a red flag and, in many jurisdictions, a legal problem.
  4. Debt-to-equity and loan-to-value implied by the balance sheet, cross-checked against the appraisal, to confirm the loan still sits within covenant.
  5. Trend across periods. A single balance sheet is a snapshot; lenders and sophisticated buyers request at least two to three years to see whether reserves are being maintained, receivables are growing faster than revenue, or accrued liabilities are creeping, patterns a single period won’t reveal.

Building a clean rental property balance sheet from scratch

For an owner setting one up for the first time, or standardizing across a portfolio, the sequence that avoids the most rework:

  1. Establish the land/building split at acquisition using the assessor ratio or a cost segregation study, documented in the closing file.
  2. Set up a segregated liability account for tenant security deposits from day one, matched to a restricted cash asset if required by state law.
  3. Separate operating cash from escrow/reserve cash in the chart of accounts before the first month closes, not after a lender asks for it.
  4. Run depreciation on a fixed schedule (39-year straight-line commercial, 27.5-year residential) tied to the documented basis allocation, and don’t adjust it ad hoc.
  5. Reconcile to the T-12 every period close: cash balance, AR, and retained earnings should all tie out before the balance sheet is considered final for that month.

A balance sheet built this way holds up under lender underwriting, buyer diligence, and audit review without restatement.

FAQ

Frequently asked questions

What makes a rental property balance sheet different from a standard business balance sheet?
The asset side is dominated by a single illiquid, appreciating (or depreciating, on the books) fixed asset — the property — carried at cost basis with accumulated depreciation as a running offset, rather than a mix of inventory, receivables, and equipment. The liability side typically carries one dominant secured loan rather than diversified trade payables. Tenant security deposits also appear as a liability, since the funds are held on behalf of tenants and are not the owner's to spend.
Should the property be listed at cost or market value on the balance sheet?
At cost, under GAAP and standard real estate accounting practice — original purchase price plus capitalized improvements, minus accumulated depreciation. Market value belongs in an appraisal or broker opinion of value, not the balance sheet. Lenders and buyers who want a fair-value view build it separately from an appraisal; mixing market value into the balance sheet itself invites restatement risk and confuses the depreciation schedule.
How does accumulated depreciation affect the balance sheet?
It's a contra-asset account that reduces the property's book value each year without any cash changing hands. For a typical commercial property depreciated over 39 years (27.5 for residential), annual depreciation is roughly 2.5-3.6% of the depreciable basis. Book value falls steadily even while the property may be appreciating in market value — which is why balance sheet equity understates true owner equity in most stabilized assets, sometimes significantly.
Where do security deposits go on the balance sheet?
As a current liability, usually labeled 'tenant security deposits held' or similar, matched by a corresponding cash or restricted-cash asset if the funds are held in a segregated account (required by law in many states). The deposit is not revenue and never touches the income statement unless it's applied against unpaid rent or damages at move-out — a common structural error is booking deposits as income upon receipt.
How does a rental property balance sheet connect to the T-12?
The T-12 (trailing twelve-month operating statement) feeds retained earnings on the balance sheet — net operating income, less debt service and capital items, rolls into the equity section as period earnings. Cash balances on the balance sheet should reconcile to the T-12's cash flow rollforward; a mismatch usually signals either a timing difference (accrual vs. cash basis) or an unrecorded transaction, such as a capital call or distribution.