· 9 min read · AIStatements editorial
Rental Property Balance Sheet: Building a Balance Sheet for Rental Property and a Rental Property Cash Flow Statement
Free demo pack used
Your one free pack is built. Starter keeps going: every close, every statement, the AI analysis on each pack, PDF and XLSX exports, for $39 a month billed yearly.
Generate statements from your own books · sample CSV
Software, not advice · Files parse in your browser, nothing is uploaded
Try it on a sample company, or upload your own CSV
A rental property balance sheet lists what the property is worth on your books, what you owe against it, and the difference between the two. Assets are the property at cost plus improvements, less accumulated depreciation, plus the cash, escrow and receivables attached to it. Liabilities are the mortgage balance, security deposits you hold, and unpaid bills. Equity is whatever is left. It is a snapshot on one date, not a period like the income statement.
Most landlords never build one, because Schedule E does not ask for it and the landlord software they use does not print one. Then a refinance, a partner buyout or an insurance claim arrives and the balance sheet is the document everybody wants. Below: exactly what goes on each side, the four accounts landlords get wrong, how the mortgage splits, and how the balance sheet ties to a rental property cash flow statement.
What goes on a rental property balance sheet?
Three blocks, in a fixed order. Assets first, largest and longest-lived at the bottom of that block. Liabilities second, split between what is due within a year and what is not. Equity last, and it is a residual: assets minus liabilities, never a number you decide.
On the asset side, the building dominates everything else. It goes on at cost, meaning the purchase price plus closing costs you were required to capitalize, plus every capital improvement since. Land sits on its own line and is never depreciated, which is why the purchase has to be split between land and building at acquisition. Below the building sits accumulated depreciation as a negative number, and the two together give net book value. That net book value is almost never the market value of the house, and confusing the two is the single most common error on a landlord-built balance sheet.
Then the smaller assets: the operating bank account, the security deposit account if you hold deposits separately, escrow held by the lender for taxes and insurance, rent receivable if you keep accrual books, and prepaid insurance where you paid a twelve month premium up front. Appliances and equipment with their own depreciation schedules sit here too.
On the liability side: the mortgage principal balance, split into the portion due in the next twelve months and the rest; security deposits held, which are a liability because the money belongs to the tenant; accrued property taxes if the bill has not been paid yet; and anything owed to contractors. Below that, equity: what you contributed to buy the property, plus accumulated profit, minus what you have distributed to yourself.
| Line | Amount | Note |
|---|---|---|
| Operating cash | $8,400 | Property bank account |
| Security deposit cash held | $2,400 | Offset by a matching liability |
| Escrow held by lender | $3,100 | Your asset, not the bank's |
| Land | $60,000 | Never depreciated |
| Building at cost plus improvements | $240,000 | Purchase price allocation plus capitalized work |
| Accumulated depreciation | ($34,900) | Contra asset, grows every year |
| Total assets | $279,000 | |
| Security deposits held | $2,400 | Tenant's money, not income |
| Accrued property taxes | $1,900 | Billed, not yet paid |
| Mortgage payable | $196,300 | Principal only, no future interest |
| Total liabilities | $200,600 | |
| Owner's equity | $78,400 | Assets minus liabilities, a residual |
Why does a rental property need a balance sheet if Schedule E does not have one?
Because Schedule E is a tax form and the balance sheet is a financial document, and the people who ask for each are different people. The IRS wants to know what the property earned. A lender, a partner, an insurer, an estate attorney and a buyer all want to know what you own and what you owe.
The refinance case is the most common. An underwriter sizing a loan against a rental checks the income statement for net operating income, then checks the balance sheet for the existing debt, the escrow position and whether the equity story is consistent with what you told them. A borrower who can produce both in an afternoon closes faster than one who cannot produce either.
The partner case is the one that turns ugly without a balance sheet. Two people buy a duplex, one puts in more cash, both take draws at different times, and three years later nobody can say what each person's stake is. Equity accounts on a balance sheet answer that question with a number. A folder of bank statements does not.
There is also a quieter reason: the balance sheet is the only thing that checks your income statement. If the books are kept properly the two are linked, and a balance sheet that does not balance is telling you something on the income statement is wrong. Landlords who keep only a profit and loss have no error detection at all, which is how a year of misclassified mortgage payments survives until February.
Where does the mortgage go on a rental property balance sheet?
The principal balance goes on the liability side, and only the principal balance. Future interest is not a liability, because you have not incurred it yet, so the number is what you would owe if you paid the loan off today, not the sum of your remaining payments.
The monthly payment splits three ways, and getting this wrong distorts both statements at once. Interest is an expense and belongs on the income statement, below net operating income. Principal reduces the mortgage liability on the balance sheet and never touches the income statement. Escrow moves cash from your operating account to an escrow asset and is not an expense until the lender actually pays the tax or insurance bill out of it.
Landlords working from a bank register almost universally get this wrong, because the register shows one payment leaving the account and nothing in it knows that part of that payment bought equity. The fix is to take the split off the lender's year-end statement or the annual escrow analysis rather than dividing the payment by eye. If those arrive as PDFs, converting the statements into a spreadsheet first makes the year's principal, interest and escrow columns straightforward to total and to check against the loan balance you started the year with.
One test settles whether you did it right. Take the mortgage balance at the start of the year, subtract the principal you recorded during the year, and compare it to the December statement balance. If those two agree, the split is correct. If they do not, the difference is sitting in an expense account where it does not belong.
The four accounts landlords get wrong
Security deposits recorded as income. A deposit is the tenant's money held in trust. It is cash on the asset side and an equal liability on the other, netting to zero equity. Booking it as rental income overstates profit in year one and leaves you with nothing to relieve when the tenant moves out.
Market value substituted for cost. The balance sheet carries historical cost less accumulated depreciation, not what Zillow says. Writing the property up to market breaks the link to your depreciation schedule and to the basis you will use to compute gain on sale. If you want a market view, present it as a separate schedule beside the balance sheet, clearly labeled.
Capital improvements expensed. A new roof, a full window replacement or an addition is an asset, added to the building and depreciated. Expensing it understates the balance sheet and overstates this year's costs, and the IRS can disallow the deduction. The line between a repair and an improvement runs through the betterment, restoration and adaptation tests, and the treatment of each account is mapped out on the rental property income statement page.
Escrow ignored entirely. Money sitting in escrow at the lender is your asset. Landlords routinely leave it off, which understates total assets and makes the property tax expense land in a lump in whatever month the lender paid it, rather than accruing evenly.
How is a rental property cash flow statement different from the income statement?
The income statement tells you whether the property was profitable. The cash flow statement tells you where the money actually went, and for a leveraged rental those are routinely different answers. Depreciation reduces profit without touching cash. Principal repayment consumes cash without touching profit. A property can show a tax loss and still add to your bank balance, or show a profit and drain it.
The statement has three sections and the split matters. Operating activities cover rent collected and operating costs paid, and this is the number that shows whether the property funds itself. Investing activities carry capital improvements and any property purchased or sold. Financing activities carry principal repayments, new borrowing, owner contributions and owner draws. Put principal repayment in operating, as spreadsheet models often do, and the statement stops meaning anything.
The three statements interlock. Net income from the income statement feeds equity on the balance sheet. The change in cash on the balance sheet between two dates has to equal the bottom of the cash flow statement. Those cross-checks are the reason a finance professional asks for all three rather than just the profit and loss, and why a cash flow statement generator that starts from the same mapped export keeps them consistent instead of leaving you to reconcile three documents by hand.
How to build one from books you already keep
If your books are in QuickBooks with class tracking on, the balance sheet is already there, and the work is checking it rather than building it. Confirm land and building sit as separate fixed asset accounts, confirm accumulated depreciation is a contra asset rather than an expense, confirm the mortgage is set up as a liability so payments split automatically, and confirm security deposits have a liability account. The full setup is in QuickBooks for rental property.
If your books are in Stessa, Baselane or Landlord Studio, the picture is patchier, because those tools are built around a Schedule E summary and balance sheet coverage varies by tier. What each one does and does not produce is compared on rental property accounting software. In practice you will be assembling the balance sheet from the platform's data plus the loan statement plus your depreciation schedule.
If you work in a spreadsheet, keep a simple fixed asset register alongside it: purchase date, land and building allocation, each capital improvement with its date and amount, and the depreciation taken each year. That register is what makes the balance sheet possible and it is what your CPA will ask for when you sell.
Whichever the source, the export is what matters. Account names, a property identifier and balances are enough to produce a formatted balance sheet, income statement and statement of cash flows that tie to each other, either from the balance sheet generator for the single statement or as a full per-property pack. Map the accounts once and the following month is a re-import rather than a rebuild.
Common questions
Does a rental property go on a balance sheet at market value or cost? At cost, plus capitalized improvements, less accumulated depreciation. That is book value, and it is usually well below market value on a property held for years. Market value belongs on a separate schedule if you want to show it, never in place of cost.
Is a security deposit an asset or a liability? Both, in a sense. The cash you hold is an asset and your obligation to return it is a liability of the same amount, so it nets to zero in equity. It becomes income only in the period you lawfully retain it, and state rules on how deposits must be held vary.
Do I need a separate balance sheet for each rental property? Per property is far more useful, and it is required in practice whenever a lender underwrites a single building or a partner owns a stake in one property rather than the portfolio. Produce per-property balance sheets and a portfolio total on top, not one instead of the other.
Why does my rental balance sheet not balance? In order of likelihood: the mortgage payment was expensed in full instead of split, a capital improvement was expensed, depreciation was recorded as an expense with no matching accumulated depreciation entry, or an owner draw was coded to an expense account. Each of those breaks the equation in a recognizable way.
Does depreciation reduce equity? Yes, indirectly. Depreciation is an expense, so it reduces net income, and net income flows into retained earnings inside equity. It also reduces the asset side through accumulated depreciation, so both sides fall by the same amount and the balance sheet stays balanced.