A landlord goes to refinance an eight-unit building and the lender's first question is not about the rent roll. It wants the debt service coverage ratio: operating income before debt service, divided by the total mortgage payment. The landlord opens QuickBooks and finds one "Rental Income" account, one "Repairs" account, and a mortgage payment that posts as a single lump expense every month. Nothing on the trial balance separates what the property earns from operations from what it pays a lender. The ratio gets built in a spreadsheet, and the lender asks why the books don't already show it.
The spreadsheet is not the fix. The chart of accounts is. A debt service coverage ratio is a read on five accounts, and if those accounts exist and are posted to every month, the ratio falls out of the trial balance the same way any other report does. This guide covers those accounts, the three entries that fill them, and what each one does to the income statement and balance sheet.
Why a generic chart breaks down for landlords
The default QuickBooks chart treats every dollar that lands in the bank as income. A tenant's security deposit is not income; it belongs to the tenant until they move out and the property passes inspection. Under GAAP (Generally Accepted Accounting Principles), a deposit becomes a liability the moment it is collected, and the cash backing it should be traceable on its own line, not blended into the account that also holds this month's rent.
A building is not one asset either. Land does not wear out. A roof, an HVAC system, and a refrigerator each depreciate on a different schedule, and the Internal Revenue Service sets the building's own clock: 27.5 years, straight line, for residential rental property. A single "Property" or "Fixed Assets" account depreciated at one blended rate cannot tell an owner which asset class is driving the expense, or when the equipment will be fully written off while the building still has decades left.
Mortgage debt compounds the problem. A single "Loan Payment" line, run straight through the bank feed, posts the whole check as an expense and skips the amortization schedule entirely — which overstates the interest expense in some months and understates it in others, and never separates the two halves of the payment that a coverage ratio needs kept apart: principal, which reduces a balance sheet liability, and interest, which is the financing cost the ratio measures against.
There is a tempting shortcut here too: keep one "Mortgage Expense" account and let the accountant sort principal from interest at tax time. It works until the next refinance, when the lender wants monthly numbers for the trailing twelve, not a single number reconstructed in April. The chart of accounts is the cheapest part of that request to get right, and the one a spreadsheet built after the fact cannot substitute for.
Cash and cost flow through the property accounts
Every dollar a rental property touches moves through these accounts in this order. Revenue and cost reach the income statement on the way through; the balance sheet holds whatever has not settled yet.
The accounts that do the work
These are the accounts from the real estate template that a generic chart does not give a landlord. Account numbers, names and types below are exactly as they import.
| Row | Account | Number | Type | Purpose |
|---|---|---|---|---|
| 01 | Tenant Receivables | 1210 | Accounts Receivable | Outstanding rent and fees from tenants |
| 02 | Security Deposits Held | 1300 | Other Current Assets | Tenant security deposits held in trust |
| 03 | Tenant Security Deposits | 2200 | Other Current Liabilities | Tenant security deposits liability |
| 04 | Rental Income - Residential | 4000 | Income | Rental income from residential properties |
| 05 | Buildings | 1520 | Fixed Assets | Rental buildings and structures |
| 06 | Equipment & Appliances | 1540 | Fixed Assets | HVAC systems, appliances, equipment |
| 07 | Accumulated Depreciation - Buildings | 1590 | Fixed Assets | Accumulated depreciation on buildings |
| 08 | Accumulated Depreciation - Equipment | 1591 | Fixed Assets | Accumulated depreciation on equipment |
| 09 | Mortgage Payable - Property 1 | 2500 | Long Term Liabilities | Mortgage on rental property |
| 10 | Depreciation Expense | 6700 | Expenses | Depreciation on properties and equipment |
| 11 | Mortgage Interest Expense | 7010 | Other Expense | Interest on property mortgages |
The two accumulated depreciation accounts, 1590 and 1591, are what let the building and the equipment run on separate schedules while sharing one Depreciation Expense account on the income statement. Mortgage Interest Expense sits in the 7000 range, below the accounts that make up operating income, so it never gets summed into the property's operating costs by accident.
How the accounts get booked
Take one eight-unit building renting at $1,200 a unit, a $9,600 monthly rent roll. Figures are illustrative throughout.
A new tenant signs a lease and pays first month's rent plus a $1,500 security deposit. Only the rent is revenue. The deposit is recorded where it belongs, kept apart from the cash the business can actually spend.
| Account | Debit | Credit |
|---|---|---|
| 1300Security Deposits Held | 1,500 | |
| 2200Tenant Security Deposits | 1,500 | |
| Totals | 1,500 | 1,500 |
No revenue account is touched. The deposit sits as a liability until the tenant moves out, at which point it is either returned, applied to damage, or both — never recognized as income on the way in.
At month end the building and its equipment each take their own depreciation. The $280,000 building basis, straight-lined over the IRS's 27.5-year schedule for residential rental property, works out to $848 a month. The $24,000 in HVAC systems and appliances, depreciated over a 5-year life, works out to $400 a month. Both post to the same expense account; only the credit side keeps the two schedules apart.
| Account | Debit | Credit |
|---|---|---|
| 6700Depreciation Expense | 848 | |
| 1590Accumulated Depreciation - Buildings | 848 | |
| 6700Depreciation Expense | 400 | |
| 1591Accumulated Depreciation - Equipment | 400 | |
| Totals | 1,248 | 1,248 |
The building and the equipment wear out on different schedules. Splitting the credit side is what lets an owner see, years from now, that the appliances are fully depreciated while the building still has two decades left.
The mortgage payment on the building is $1,850 a month. Pulled from the amortization schedule, $650 of it reduces the loan balance and $1,200 is interest.
| Account | Debit | Credit |
|---|---|---|
| 2500Mortgage Payable - Property 1 | 650 | |
| 7010Mortgage Interest Expense | 1,200 | |
| 1000Operating Cash | 1,850 | |
| Totals | 1,850 | 1,850 |
Only $650 of this check reduces what the property owes. Booking the whole $1,850 as an expense would overstate cost and understate the remaining loan balance — and it would bury the interest inside operating expenses instead of below them.
What this looks like on the statements
The same three entries, seen from the reports. The highlighted lines exist only because the accounts above exist.
| Rental Income - Residential | 9,600 |
| Direct property costs | |
| Property Maintenance & Repairs | 450 |
| Property Taxes | 800 |
| Property Insurance | 300 |
| Utilities - Water & Sewer | 220 |
| On-Site Maintenance Labor | 900 |
| Depreciation Expense | 1,248 |
| Total direct property costs | 3,918 |
| Operating income before debt service | 5,682 |
| Mortgage Interest Expense | 1,200 |
| Net income | 4,482 |
Example figures.
Operating income before debt service is the line the lender wants. Divide the $5,682 by the $1,850 monthly mortgage payment and the coverage ratio is about 3.1, well above the 1.2 most lenders require before approving a refinance. That ratio does not exist as a line item anywhere in QuickBooks; it exists because the accounts above it are separated correctly, and any report can compute it from there.
| Current assets | |
| Security Deposits Held | 12,000 |
| Fixed assets | |
| Buildings | 280,000 |
| Equipment & Appliances | 24,000 |
| Accumulated Depreciation - Buildings | (10,176) |
| Accumulated Depreciation - Equipment | (4,800) |
| Current liabilities | |
| Tenant Security Deposits | 12,000 |
| Long-term liabilities | |
| Mortgage Payable - Property 1 | 247,200 |
Example figures.
The $12,000 in Security Deposits Held matches the $12,000 in Tenant Security Deposits exactly, across all eight units — neither number ever touched revenue. After a year of the entries above, the building has depreciated by $10,176 and the equipment by $4,800, on the schedules each was assigned on day one. The mortgage balance is down to $247,200, a number a lender can tie directly to twelve months of Entry 3 rather than take on faith.
- 01How much of our cash can we actually spend? Without Security Deposits Held and Tenant Security Deposits kept apart from the operating account, the checking balance overstates what the business has to work with.
- 02Which asset is actually driving our depreciation expense, and when does it run out? One blended fixed asset account cannot say whether the roof or the refrigerator is the reason the number changed.
- 03Would this property qualify for a refinance today? With mortgage interest buried inside overhead, operating income before debt service has to be rebuilt from bank statements every time a lender asks for it.
What the template changes
The diff, in the grammar the product uses everywhere else.
- Fixed Assetsbuilding, land and equipment blended together
- 1520Buildingsasset
- 1540Equipment & Appliancesasset
- 1590Accumulated Depreciation - Buildingscontra-asset
- 1591Accumulated Depreciation - Equipmentcontra-asset
- Rental Incomedeposits recorded as income when received
- 1300Security Deposits Heldasset
- 2200Tenant Security Depositsliability
- Loan Paymentone expense line, no principal split
- 2500Mortgage Payable - Property 1liability
- 7010Mortgage Interest Expensebelow operating income
- 6700Depreciation Expensestays in operating expenses
- Publication 527, Residential Rental Property (Including Rental of Vacation Homes) · Internal Revenue Service
- Principles of Accounting, Volume 1: Financial Accounting · OpenStax, Rice University
Get started
The real estate chart of accounts template includes every account on this page, pre-numbered and ready to import into QuickBooks. It takes about 60 seconds to optimize and gives a landlord the statements a lender expects to see before the next refinance conversation, not after.
If you already have a chart, the optimizer reads it and shows the diff above against your own accounts, so you can see which of these are missing before you change anything. Post the deposit entry the day it clears, run depreciation by asset class every month, and split every mortgage payment at the source, and the next debt service coverage ratio comes from the trial balance instead of a spreadsheet built the night before the lender call.
The principles are easy. Applying them is the work.
This guide is the theory. The free trial helps you review a real QuickBooks Online chart with a score, structural diff, and prioritized cleanup plan.
- +Score the chart across the health dimensions
- +Compare structure against a reference pattern
- +Prioritize cleanup work before changing books
- +Review recommendations before anything is applied