Bookkeeper Group

Keeping it Real

Real Estate Bookkeeping: Property-Level Clarity Without Spreadsheet Hell

Business

Real estate bookkeeping breaks when you treat a portfolio of properties like a single, monolithic business. In a standard service business, you might just want to know if the company as a whole made money. In real estate, that aggregate number can hide a disaster. You might have three properties performing well and one bleeding cash, but if you only look at the total, you’ll never know which asset to fix or sell.

Whether you manage long-term rentals, are flipping houses, developing land, or brokering deals, the "right" books do more than just tally up income and expenses. They let you answer the specific questions that investors and lenders care about:

  • Profit by Property: Which specific address is generating a return, and which is draining resources?
  • True Cash Flow: After you pay the mortgage (debt service), how much cash is actually left in your pocket?
  • Capex vs. Repairs: Are you simply patching holes (repairs) or adding long-term value to the asset (capital improvements)?
  • Liability Tracking: Are tenant security deposits sitting in a separate account, or have they been accidentally spent on operations?

Overview

This guide shows how to structure property-level tracking so you can see the performance of every single door. We will cover how to build a usable chart of accounts that separates operational costs from financing costs, and how to close the books each month without losing visibility.

Start here if investor reporting is a nightmare and lender questions feel impossible to answer.

Business Idea

Common real estate bookkeeping pitfalls

Real estate accounting has specific nuances that generic bookkeepers often miss. Here are the most common errors and why they matter.

  • Mixing properties in one set of categories (no property-level reporting) If you dump all "Repairs" into a single account without tagging the property, you can't run a Profit & Loss (P&L) for 123 Main St. You lose the ability to evaluate the asset's performance. You must use "Classes" (QuickBooks) or "Tracking Categories" (Xero) to tag every single transaction to a specific property.

  • Misclassifying Capex vs Repairs This is a critical distinction for taxes and ROI.

    • Repairs: Fixing something that broke (e.g., unclogging a drain, patching a roof leak). These are expenses that reduce your taxable income immediately.
    • Capital Expenditures (Capex): Improvements that extend the life of the property or add value (e.g., a new roof, a new HVAC system, a kitchen remodel). These are assets, not expenses. They are depreciated over time. If you expense a new roof, you understate your profit and might get in trouble with the IRS.

  • Not tracking security deposits as a liability A security deposit is not your money. It is money you are holding on behalf of the tenant. If you record it as "Income," you are inflating your revenue and potentially paying taxes on money you have to give back. It should sit on your Balance Sheet as a "Liability" (Security Deposits Payable) until the tenant moves out.

  • Losing visibility into owner draws vs property expenses If you use the business debit card to buy personal groceries, that’s an "Owner Draw" (Equity), not a business expense. Mixing these up muddies the water on how the business is actually performing.

  • Ignoring timing differences (rent collected vs expenses paid) If you receive January's rent on December 31st, does it count for December or January? In Cash Basis, it's December. In Accrual Basis, it's January. Consistently applying these rules is key to understanding your monthly cash flow.

  • Treating loan principal payments as “expenses” This is the single biggest confusion point. When you pay your mortgage, the payment is split into two parts:

    1. Interest: This is the cost of borrowing money. It is an expense.
    2. Principal: This is paying back the loan balance. It is not an expense; it is a reduction of a liability on your Balance Sheet. If you book the whole payment as an expense, you are massively understating your profit.

Plain Language Definitions:

  • Escrow: Think of escrow as a forced savings account managed by your lender. You pay into it monthly along with your mortgage. The lender then uses that money to pay your property taxes and insurance when they are due. The money in escrow is still technically yours (an asset) until the bill is paid. It is not an expense until the tax or insurance bill is actually paid.

  • Depreciation: Buildings get old and wear out. The IRS allows you to take a "paper expense" each year to account for this wear and tear. No cash actually leaves your bank account, but it lowers your taxable income. It’s like an allowance for the fact that you will eventually have to replace the building.

If you want the baseline bookkeeping foundations first: Bookkeeping Basics.

Structure: track by property (or project)

To get property-level clarity, you need to set up your accounting software correctly from day one.

Most real estate operators need:

  • A Class or Location per Property: In QuickBooks Online Plus or Advanced, turn on "Class Tracking." Create a class for each property address. Every time you enter an invoice or deposit, assign it to that class. This allows you to filter reports by property. If you have separate legal entities (LLCs) for each property, you will need a separate QuickBooks file for each entity.

  • Standard Expense Categories: Don't get creative with account names. Use standard names like "Repairs & Maintenance," "Utilities," and "Management Fees." This ensures that when you compare Property A to Property B, you are comparing apples to apples.

  • Separate Tracking for Capex vs Repairs & Maintenance: Create a specific account for "Capital Improvements" on your Balance Sheet (Asset section) and "Repairs & Maintenance" on your P&L (Expense section). Train your team to know the difference.

If you are starting from scratch, build a chart that supports this: Chart of Accounts.

Suggested chart of accounts (rental portfolio)

Your Chart of Accounts is the map of your financial world. For real estate, it should look something like this:

Income

  • Rental Income: The gross rent collected from tenants.
  • Late Fees: Penalties charged to tenants (separate this so you can see if you have a chronic late-payment problem).
  • Other Income: Laundry machines, parking fees, pet fees, etc.

Operating expenses

These are the costs to keep the lights on and the building standing.

  • Repairs & Maintenance: Routine fixes (painting, plumbing leaks, broken locks).
  • Property Management Fees: What you pay a third party to manage the tenants.
  • Landscaping/Snow Removal: Seasonal maintenance.
  • Utilities: Water, sewer, electric, gas, trash (if landlord-paid).
  • Insurance: Property and liability insurance premiums.
  • Property Taxes: Local municipal taxes.
  • HOA/Condo Dues: If the unit is in a community association.
  • Advertising/Tenant Placement: Costs to find new tenants.

Capital expenditures (capex)

These do not show up on the Profit & Loss statement directly; they sit on the Balance Sheet as assets.

  • Capital Improvements: Major renovations, new roofs, new windows.
  • Appliances/Equipment: Refrigerators, stoves, washers/dryers (if capitalized).

Balance sheet essentials

  • Security Deposits Payable (Liability): Money owed back to tenants.
  • Loans Payable (Liability): The mortgage balance.
  • Escrow Account (Asset): Money held by the lender for taxes/insurance.
  • Accumulated Depreciation (Contra-Asset): The total depreciation taken to date.

The monthly close (real estate edition)

Closing the books means verifying that everything is accurate so you can trust the reports.

  1. Reconcile Bank and Credit Cards: Match every transaction in your bank feed to a receipt or invoice. Ensure the ending balance in your software matches the bank statement exactly. Bank Reconciliations

  2. Tie Rent Roll to Deposits: If you use property management software (like Buildium or AppFolio), run a "Rent Roll" report. The total rent collected on that report must match the total deposits in your bank account. If it doesn't, money is missing or miscategorized.

  3. Review Capex vs Repairs: Scan your "Repairs & Maintenance" account. detailed invoice notes matter here. Did you accidentally classify a $10,000 roof replacement as a repair? Move it to the Balance Sheet (Capital Improvements).

  4. Track Loan Activity: Look at your mortgage statement. It will show the breakdown of your payment.

    • Debit Interest Expense for the interest amount.
    • Debit Loan Payable for the principal amount.
    • Debit Escrow Asset for the tax/insurance portion.
    • Credit Cash for the total payment.

  5. Run Property-Level P&Ls: Run a "Profit & Loss by Class" report. Look for anomalies. Did one property have a huge spike in water bills? (Maybe a running toilet?) Did another have zero rent? (Vacancy?). Compare this month to last month. Variance Analysis

Start here: Close Checklist.

KPIs worth tracking

Goal

Key Performance Indicators (KPIs) tell you the health of your portfolio at a glance.

  • Net Operating Income (NOI):

    • Formula: Revenue - Operating Expenses (excluding mortgage payments).
    • Why it matters: This is the pure profitability of the asset, independent of how you financed it. Lenders use this to value the property.

  • Vacancy Rate and Delinquency:

    • Formula: (Days Vacant / Total Days) or (Unpaid Rent / Total Potential Rent).
    • Why it matters: An empty unit earns zero dollars. High delinquency means you have a collections problem.

  • Maintenance % of Rent:

    • Formula: Maintenance Costs / Total Rent.
    • Why it matters: If this is creeping up (e.g., over 10-15%), you might be deferring maintenance or the building is nearing the end of its useful life components.

  • Cash-on-Cash Return:

    • Formula: Annual Pre-Tax Cash Flow / Total Cash Invested.
    • Why it matters: This tells you how hard your actual cash dollars are working. Is your $100,000 down payment earning 5% or 15%?

  • Debt Service Coverage Ratio (DSCR):

    • Formula: NOI / Total Debt Service.
    • Why it matters: Lenders require this to be above 1.20 or 1.25. It means the property generates enough cash to pay the mortgage with a buffer.

For reporting basics: Financial Statements.

Practical tips

  • Keep Security Deposits Separate: Open a separate bank account for security deposits. This makes it impossible to accidentally spend them and keeps you compliant with landlord-tenant laws in many states.
  • Attach Invoices: Upload PDFs of invoices to every transaction. When you refinance or sell, the bank (or buyer) will want to see proof of those capital improvements.
  • Consistent Rules: Write down your rules for "Repairs vs Capex" (e.g., anything under $2,500 is a repair; anything over is capitalized). Give this cheat sheet to your bookkeeper so they don't have to guess.