Skip to main content

QuickBooks for rental property: set up a general ledger that matches Schedule E

Archive topic 2026
A landlord working on a laptop beside property folders

The short answer

A general ledger such as QuickBooks works for rentals when each property is tracked separately, the accounts line up with Schedule E, and security deposits sit in a liability account. Reconcile every bank account each month. If the setup keeps fighting your rental workflow, a rental-specific tool may fit better.

On this page

What a ledger has to do for a rental

A general ledger records every dollar in and out of your rental business. For a landlord, it has four jobs:

  • Show income and expenses for each property on its own.
  • Group those amounts the way your tax return asks for them.
  • Keep money you may owe back, such as deposits, out of income.
  • Agree with your bank and card statements every month.

The IRS Schedule E form reports each rental in its own column, A, B or C, and the instructions tell you to attach more Schedules E if you have more than three properties. Line 2 also asks for each property's fair rental days and personal use days. A ledger that tracks every property separately makes those columns easy to fill.

Track each property separately

Most general ledgers let you tag each transaction with a second label beyond the account. In QuickBooks Online that label is a class. Intuit's help page describes classes as important parts of your company, such as departments or product lines, and lists class tracking for its Plus and Advanced plans. Check Intuit's current plan page before you buy, because plans change.

  • Create one class per property, named by street address and unit.
  • Intuit lets you assign one class to the entire transaction or one class to each row. Choose each row if a single bill, such as an insurance premium, covers several properties.
  • Turn on the warning for transactions saved without a class, so nothing lands in an untagged pile.

Whatever tool you use, pick one tagging method for property and use it the same way every time. Two methods, such as classes for some properties and separate accounts for others, make reports hard to trust.

Build the chart of accounts around Schedule E

Your chart of accounts is the list of categories in the ledger. Matching your income and expense accounts to Schedule E lines saves a translation step at tax time. The 2025 Schedule E uses these lines:

  • Income: line 3, Rents received.
  • Expenses: line 5 Advertising, 6 Auto and travel, 7 Cleaning and maintenance, 8 Commissions, 9 Insurance, 10 Legal and other professional fees, 11 Management fees, 12 Mortgage interest paid to banks, etc., 13 Other interest, 14 Repairs, 15 Supplies, 16 Taxes, 17 Utilities, 18 Depreciation expense or depletion and 19 Other.

The instructions say line 19 is for ordinary and necessary expenses not listed on lines 5 through 18, so keep a few clear sub-accounts under Other rather than one catch-all.

Your balance sheet accounts matter too. Keep separate accounts for the operating bank account, deposits held, each mortgage, and fixed assets such as the building and later improvements. Publication 527 says you cannot depreciate land, so record land and building separately. The IRS says the cost of improvements is recovered through depreciation rather than deducted at once. When you book a loan payment, split the interest to the interest account and the principal to the loan balance.

Book security deposits as a liability

Publication 527 says not to include a security deposit in income when you receive it if you plan to return it at the end of the lease. If you keep part or all of it because the renter does not meet the lease terms, the amount you keep is income for that year. A deposit used as the final rent payment is advance rent, which is income when received.

In the ledger, that means a deposit goes to a liability account, money you may owe back, not to Rents received. When you keep some of it at move-out, move that amount from the liability to income. When you refund it, the payment reduces the liability.

State law may also control where the money sits. Florida requires one of three options for deposit money, including a separate account in a Florida financial institution or a surety bond (Fla. Stat. § 83.49(1)). Massachusetts requires a separate, interest-bearing account in a bank located in Massachusetts (Mass. G.L. c. 186, § 15B(3)(a)). If the law requires a separate account, give it its own bank account in the ledger too.

Bank feeds and monthly reconciliation

A bank feed imports transactions from your bank so you categorize them instead of typing them. Intuit's help page notes that downloaded transactions still need to be categorized before you reconcile.

Reconciling is matching the transactions in your books to your bank and card statements. Intuit recommends doing it every month after you get your statement. You enter the statement's ending date and balance, check off each matching transaction, and finish when the difference is $0.00.

  • Book money moved between your own accounts as a transfer, not as income or an expense.
  • Book money you put in or take out personally as owner contributions or distributions in equity.
  • If a payment service deposits rent after taking a fee, record the full rent and the fee separately so income is not understated.
  • Investigate any difference before you finish. Forcing a reconciliation hides the error until tax time.

From ledger to tax return

At year end, run a profit and loss report for each property and compare each total with its Schedule E line. Schedule E also asks whether you made payments that would require you to file Forms 1099 and whether you filed them, so keep vendor payment totals easy to pull.

The IRS says you generally need documentary evidence, such as receipts, canceled checks or bills, to support your expenses. Attach or file a receipt for each expense as you book it. The IRS also says to keep records connected to property until the period of limitations expires for the year you dispose of the property.

This guide is general information, not tax advice. Confirm how these rules apply to your situation with a tax professional.

When a rental-specific tool fits better

A general ledger is built for many kinds of business. That flexibility is useful, but a landlord may end up building rental workflows by hand. Consider a rental-specific tool if you find yourself:

  • Keeping a separate spreadsheet of what each renter owes and has paid.
  • Tracking each lease's deposit outside the ledger.
  • Typing in rent that a payment service already recorded.
  • Copying property totals into another file for your preparer.

Either choice can work. What matters is one consistent record per property that ties to the bank.

How Rentari helps

Rentari's accounting imports bank feeds and books transactions into your chart of accounts with types such as Revenue, Expense, Transfer, Owner contribution and Owner distribution, including split transactions. Fixed assets carry depreciation entries, and reports include a balance sheet. Online rent collection records each payment with a receipt, so rent does not need retyping. Rentari keeps the record; your preparer prepares the return.

Sources and further reading

Common questions

Can I use QuickBooks classes to track each rental property?

Yes. Intuit's help page describes class tracking for QuickBooks Online Plus and Advanced, with a class assigned to the whole transaction or to each row. Create one class per property and use it on every transaction.

Is a security deposit income in my books?

Not when you receive it if you plan to return it, according to IRS Publication 527. Record it in a liability account and move only the part you keep to income.

How often should I reconcile my rental bank account?

Intuit recommends reconciling every month after you get your statement. Categorize all downloaded transactions first, and finish only when the difference is $0.00.

Which expense accounts should a rental ledger have?

Match them to Schedule E lines 5 through 19, from Advertising to Other, and keep rent in an account that maps to line 3, Rents received.

Archive years group longstanding rental topics. This Rentari guide was published on 2026-11-14.

The Rentari team writes and updates this guide. Examples illustrate decisions and do not describe customer results. This is general education. Confirm the rules and treatment for your property with a qualified local professional. Found an error or an unclear step? Send a correction with a link to this page and the wording you’d change.

Keep learning

All Accounting & taxes guides

Your next step

Choose and review a report