Real Estate Bookkeeping

Real Estate Bookkeeping

Rental property bookkeeping with every property on its own page

If you own more than one property, a single total tells you very little. I keep your QuickBooks file so each property shows its own rent, repairs, taxes and mortgage interest, and the year closes with the figures your tax preparer needs per property.

  • One report per property
  • Mortgage payments split
  • Deposits held as liabilities
House keys in front of a home
Per propertyrent, costs and loan balance

Where rental books lose their usefulness

The most common problem is a mortgage payment recorded as one expense. Part of every payment reduces the loan and is not an expense at all. Part is interest. Often part is property tax and insurance held in escrow. Booked as a single line, your costs are overstated and the loan on your Balance Sheet never moves.

The second problem is mixing properties together. One good year on one house can hide a poor year on another, and you only find out when you try to answer a simple question such as which property to sell.

What I track in your books

Class or location per property

Each property tagged in QuickBooks so its income and costs can be reported alone.

Mortgage split

Every payment divided into principal, interest and escrow from the lender’s statement.

Security deposits

Tenant deposits held as a liability, because they are owed back.

Repairs and improvements

Routine repairs expensed, larger improvements added to the cost of the property.

Owner contributions and draws

Money you put in or take out, kept out of income and expenses.

Property management statements

The manager’s monthly statement broken back into rent collected, fees and repairs paid.

How the work runs

  1. Properties set up

    Each property becomes a class or location, with its mortgage and deposit accounts.

  2. Rent recorded

    Rent is recorded by property, from the bank or from the manager’s statement.

  3. Costs coded by property

    Repairs, utilities, insurance and taxes are assigned to the property they relate to.

  4. Mortgages split

    Loan payments are divided using the lender’s statements so the loan balance in the books agrees with the lender.

  5. Month end and year end

    Accounts are reconciled and you receive a Profit and Loss by property, plus a year end summary per property.

Short term rentals too. Payouts from booking platforms arrive net of fees. I record the full booking income and the platform’s fees separately, the same way I treat delivery platform payouts for restaurants.

Reports you receive

  • Profit and Loss by property
  • Mortgage balances and interest paid
  • Security deposits held
  • Repairs and improvements by property
  • Reconciliation reports
FAQ

Questions from owners in this industry

My personal and rental spending are in one account. Can you separate them?

Yes. I go through the statements, keep what belongs to the rentals and record the rest as personal draws.

I hold properties in more than one company. How does that work?

Each company gets its own QuickBooks file, and within each file every property is tracked on its own.

Can you work from my property manager’s statements?

Yes. Those statements are the best source for rent collected and costs they paid on your behalf.

Work with me

Own rental property?

Tell me how many properties you have, how they are owned and how rent is collected. I’ll review what you have and send a fixed price.

  • Free review of your records
  • Fixed quote before any work
  • A clear result for each property

Tell me where your books stand

A few details are enough. I’ll reply with what I see and a fixed quote.

Your details stay private. I reply within one business day.