Bookkeeping for real estate in QuickBooks

Real estate bookkeeping differs from ordinary small business bookkeeping in one basic way: the business is not one operation, it is a portfolio. Standard bookkeeping treats a company as a single entity selling goods or services, and that structure breaks down for rental property owners and property managers.

A real estate business operates a portfolio of distinct income-producing assets. If you combine rental revenues, mortgage drafts, and repair expenses into generic company totals, you cannot measure Net Operating Income (NOI) per building or tell which properties generate positive cash flow.

Real estate bookkeeping also involves statutory escrow rules for tenant security deposits, mortgage amortization splits, and IRS capitalization regulations.

Here is how to structure and execute monthly bookkeeping for residential and commercial real estate portfolios in QuickBooks Online. Commercial landlords who bill common area charges also run a year-end CAM reconciliation.

Control 1: Property-level tracking using Classes

The most common failure mode in real estate bookkeeping is creating separate chart of accounts entries for every rental address:

The bloated approach: Account 5010 (Repairs - 104 Oak St), Account 5011 (Repairs - 208 Maple Ave), Account 5012 (Repairs - 315 Pine Rd)…

This inflates the chart of accounts into hundreds of line items, cluttering the general ledger and making financial statements impossible to analyze.

Instead, maintain one master account for each income and expense category (e.g. Account 5010: Property Maintenance & Repairs). In QuickBooks Online Plus or Advanced:

1. Navigate to Gear Icon > Account and Settings > Advanced > Categories.
2. Enable Track classes and select One to each row in transaction.
3. Create a Class for each rental property or building unit under Settings > All Lists > Classes.

Properties held in separate LLCs with their own bank accounts, lenders, or partners are usually best kept in separate QuickBooks files. Single-member LLCs are disregarded for income tax, though, so many investors keep several of them in one file with a Class per property; confirm that structure with your CPA and attorney. For multiple rental properties held within a single entity or holding company, Class tracking allows you to run a Profit & Loss by Class report, showing individual property performance side by side.

For our full account numbering template, see the real estate chart of accounts guide and our interactive Real Estate Chart of Accounts Explorer.

Control 2: Rent collection and portal clearing accounts

When tenants pay rent through property management software (such as AppFolio, Buildium, or TenantCloud) or payment processors (like Stripe or ACH), the money deposited into your bank account is almost always net of merchant processing fees.

If a tenant pays $2,200.00 in monthly rent by card and the payment processor deducts a $35.00 transaction fee, the bank feed receives a single deposit of $2,165.00.

Matching that $2,165.00 directly to “Rental Income” creates two accounting errors:

• It understates gross rental revenue by $35.00.
• It omits the $35.00 merchant processing fee from operating expenses.

The clearing account workflow

To maintain accurate records, route rental collections through Account 1040: Rent Payment Clearing (Other Current Asset):

First, record the full tenant charge and gross rent:

Date	Account	Debit	Credit
Oct 1	1040 Rent Payment Clearing	2,200.00
Oct 1	4010 Residential Rental Income		2,200.00

Second, when the net bank deposit lands in your operating checking account, clear the transit account and record the merchant fee:

Date	Account	Debit	Credit
Oct 3	1010 Property Operating Checking	2,165.00
Oct 3	6150 Merchant Processing Fees	35.00
Oct 3	1040 Rent Payment Clearing		2,200.00

Account 1040 returns to $0.00, your P&L displays full gross rental revenue, and payment fees are properly categorized.

Control 3: Tenant security deposit escrow accounting

Tenant security deposits do not belong to the property owner or management company. They represent fiduciary funds held in trust until lease termination. In many states, commingling tenant deposits with operating funds or using deposits to cover ongoing property expenses violates state landlord-tenant statutes.

A compliant setup requires two paired balance sheet accounts:

• Account 1030: Tenant Security Deposit Escrow (Bank Asset): The segregated bank account holding the deposit funds.
• Account 2120: Tenant Security Deposits Held (Other Current Liability): The liability reflecting funds owed back to tenants upon move-out.

Where your state requires a separate deposit account, these two accounts must match to the penny at all times. The full set of entries, from receipt to refund, is in our guide to security deposit accounting.

The move-out settlement entry

When a tenant vacates a rental unit, the landlord assesses damages against the deposit. Suppose Tenant Davis vacates after providing a $2,000.00 security deposit. Unit inspection reveals $450.00 in carpet repair damages, with the remaining $1,550.00 returned to the tenant.

Step 1: Clear the liability, record the $1,550.00 refund check from escrow, and recognize the $450.00 the landlord keeps:

Date	Account	Debit	Credit
Oct 15	2120 Tenant Security Deposits Held	2,000.00
Oct 15	1030 Tenant Security Deposit Escrow		1,550.00
Oct 15	4030 Late Fees & Tenant Charges		450.00

Step 2: Transfer the $450.00 retained amount from escrow into operating checking:

Date	Account	Debit	Credit
Oct 15	1010 Property Operating Checking	450.00
Oct 15	1030 Tenant Security Deposit Escrow		450.00

Each entry now matches one line on the bank statement: the refund check and the transfer. The escrow account and the liability both drop by $2,000.00, so they stay equal. The retained $450.00 is income, while the carpet repair itself is booked to Account 5010 when the vendor is paid, so the two net out on the property’s P&L.

Control 4: Mortgage amortization and escrow splits

When a property mortgage draft clears checking, the total withdrawal represents three distinct financial elements:

1. Principal repayment: Reduces your balance sheet loan liability. It is not an expense.
2. Mortgage interest: The tax-deductible financing cost reported on your P&L.
3. Property tax & insurance escrow (impound): Prepaid current assets held by your lender until property taxes and insurance premiums are disbursed.

Coding an entire $2,650.00 monthly mortgage draft to a “Mortgage Expense” account overstates deductible expenses and fails to reduce your debt balance sheet note.

The monthly mortgage entry

Split each monthly bank feed mortgage payment into its 3 constituent parts:

Date	Account	Debit	Credit
Oct 5	2510 Mortgages Payable	650.00
Oct 5	6100 Mortgage Interest Expense	1,500.00
Oct 5	1450 Lender Escrow Impound	500.00
Oct 5	1010 Property Operating Checking		2,650.00

At year-end, tie Account 6100 to Box 1 of the lender’s Form 1098 (Mortgage Interest Statement), tie Account 2510 to the year-end principal balance on the lender’s annual loan statement, and tie Account 1450 to the escrow account analysis.

Control 5: CapEx vs. repairs (the IRS safe harbor framework)

Under the IRS Tangible Property Regulations (Treas. Reg. §1.263(a)-1 through §1.263(a)-3), improvements to a building must be capitalized and depreciated over 27.5 years for residential rental property or 39 years for nonresidential commercial property. Ordinary maintenance and repairs may be expensed in the year paid.

To determine whether an expenditure must be capitalized, the IRS evaluates three criteria:

• Betterment: Does it fix a pre-existing defect, enlarge the property, or materially increase its capacity or quality?
• Restoration: Does it replace a major structural component or building system (e.g. an entire roof or HVAC system)?
• Adaptation: Does it adapt the property to a new or different commercial use?

Using IRS safe harbors to expense more repairs

Three safe harbors let property owners expense qualifying costs in the year paid without working through the improvement tests item by item:

Safe harbor	Authority	Threshold and application
De minimis safe harbor	Treas. Reg. §1.263(a)-1(f)	Items costing up to $2,500 per item or per invoice can be expensed by attaching an annual election to a timely filed return ($5,000 for taxpayers with an applicable financial statement, such as audited financials).
Routine maintenance	Treas. Reg. §1.263(a)-3(i)	Recurring upkeep you reasonably expect to perform more than once in the 10-year period beginning when the building is placed in service (e.g. HVAC servicing, boiler inspections).
Small taxpayer safe harbor	Treas. Reg. §1.263(a)-3(h)	For taxpayers with average annual gross receipts of $10 million or less, each building with an unadjusted basis of $1,000,000 or less can expense repairs, maintenance, and improvements up to the lesser of $10,000 or 2% of unadjusted basis. It is all-or-nothing: if the year’s total for that building exceeds the limit, none of it qualifies. Elected annually per building.

• Deductible repairs (Account 5010): Repainting unit walls between leases ($1,200), repairing plumbing leaks ($650), replacing a garbage disposal ($250).
• Capitalized improvements (Account 1600): Installing a brand new central AC compressor ($8,500), replacing an entire roof ($16,000), building an exterior deck ($9,000).

For asset write-offs and contra-asset balance sheet mechanics, review our guide on the journal entry for depreciation.

Monthly real estate bookkeeping closing checklist

Run this 5-step checklist at month-end:

1. Reconcile rent collections: Match bank feed deposits and payment clearing accounts against your rent roll report to confirm zero unapplied tenant balances.
2. Reconcile security deposit escrow: Verify that Account 1030 (Escrow Bank) equals Account 2120 (Escrow Liability) to the penny.
3. Split mortgage drafts: Verify that principal, interest, and lender escrow accounts reflect monthly statement amortization.
4. Audit Class assignments: Run a Profit & Loss by Class report and inspect the “Not Specified” column to catch any expenses uncoded to a property.
5. Review Form 1099-NEC contractor compliance: Verify that payments to unincorporated plumbers, handymen, and landscapers totaling $2,000 or more for the year are tagged for year-end 1099-NEC reporting. The threshold rose from $600 for payments made after December 31, 2025.

For a broader financial review sequence, consult our interactive month-end close checklist.

When real estate books require a diagnostic cleanup

If your portfolio has multiple years of un-split mortgage payments, commingled tenant security deposits, or misclassified repair expenditures, attempting to patch current entries will not fix historical balance sheet distortions.

Restoring clean property ledgers and preparing audit-ready schedules for your CPA requires a specialized QuickBooks cleanup:

$99per month of backlog20% off 6+ months

We untangle property ledgers, reconstruct escrow balances, and categorize capital assets under applicable IRS safe harbors. If your real estate business needs an assessment, request a file review on our contact page. For accounting practices managing rental portfolios, our white-label services for CPAs provide back-office delivery under your firm’s brand. Once historical ledgers are resolved, our monthly bookkeeping service delivers monthly P&L by Class statements, rent reconciliations, and mortgage allocations by the 5th business day of every month.