(480) 264-0131
Platinum Ledgers Contact
← Insights

Real Estate Investors

Rental Property Bookkeeping: What to Track for Each Property

How to keep rental property books that show which properties actually perform: what to record by property, how to treat loans, deposits, and repairs, and what your CPA needs at year-end.

Good rental property bookkeeping answers one question: which properties are actually making money after every cost is counted? To answer it, income and expenses must be tracked property by property, with loans, deposits, and improvements handled correctly.

Many investors start with one bank account and a spreadsheet. That works until the portfolio grows, a property manager is added, or a second LLC appears. At that point a single combined profit number hides the properties that carry the portfolio and the ones that quietly lose money.

Track every property separately

The foundation is a way to tag every transaction to a property. In QuickBooks Online Plus or higher, this is usually done with locations or classes, so one set of books can produce a profit and loss statement for each property and a combined view for the whole portfolio.

Decide the structure before the first transaction is entered. Changing how properties are tracked after a year of activity means reclassifying hundreds of entries.

Separate entities, accounts, and owners

If properties are held in separate LLCs, each entity should have its own bank account, and money moving between entities should be recorded as an intercompany transfer or capital movement, not as income or expense. Mixing personal and rental funds is one of the most common causes of unreliable books and uncomfortable conversations with lenders and tax preparers.

Handle mortgages and escrow correctly

A mortgage payment usually contains principal, interest, and often escrow for taxes and insurance. Only interest is an expense. Principal reduces the loan balance. Escrow is held by the lender and expensed when taxes and insurance are actually paid. Recording the whole payment as an expense understates profit and overstates the loan balance.

Simple example

A $2,000 monthly payment might be $900 principal, $750 interest, and $350 escrow. Only the $750 of interest reduces property profit this month. The $900 reduces what you owe, and the $350 sits in escrow until taxes and insurance are paid.

Know the difference between repairs and improvements

Fixing a leaking faucet is a repair. Replacing a roof or remodeling a kitchen is generally an improvement that is capitalized and depreciated over time. The distinction affects both property profit and taxes. The tax rules include safe harbors and thresholds, so your CPA should confirm treatment, but the books need to describe each item clearly so the question can be answered later.

Do not count security deposits as income

A tenant's security deposit is a liability, because it is generally owed back. It becomes income only to the extent the landlord keeps it for unpaid rent or damages. Recording deposits as revenue inflates income and creates a surprise when deposits are returned.

Reconcile your property manager's statements

If a manager collects rent and pays expenses, the monthly owner statement should tie to your bank deposits and to the transactions in your books. Management fees, leasing fees, maintenance billed through the manager, and reserve holdbacks all need to land in the right accounts. When the statement and the books disagree, the difference usually points to a missing expense or a timing issue worth catching early.

Record owner draws and distributions separately

Money you take out of the business is not an expense. Owner draws and distributions reduce equity, and they should be recorded that way. For partnerships and investor groups, track each partner's contributions and distributions so ownership percentages and balances can always be supported.

What to review every month

  • Profit and loss by property, with rent, vacancy, repairs, and management costs visible
  • Bank, credit card, and loan accounts reconciled to statements
  • Property manager statements tied to the books
  • Loan balances and interest recorded correctly
  • Security deposit liability matching deposits actually held
  • Cash by entity, including reserves for taxes, insurance, and major repairs

What your CPA needs at year-end

A year-end package should include profit and loss by property, a balance sheet, loan interest statements, a schedule of improvements with dates and costs, and documents for any acquisition or sale. When the books are organized this way during the year, tax preparation is faster and fewer questions come back later. Investors who grow into partnerships or syndications can build on the same structure with capital account and investor reporting.

Frequently asked questions

Should each rental property have its own bank account?

Separating accounts by entity is strongly recommended, and many investors go further and use a dedicated account per property. At a minimum, rental activity should never run through a personal account, and security deposits should be kept clearly identifiable.

Is a mortgage payment an expense?

Only the interest portion is an expense. The principal portion reduces the loan balance on the balance sheet. Escrow amounts for taxes and insurance are tracked separately, then expensed as the taxes and insurance are actually paid by the lender.

How do I tell a repair from an improvement?

Generally, a repair keeps a property in its current working condition, while an improvement adds value, extends its life, or adapts it to a new use. Improvements are capitalized and depreciated rather than expensed. The tax rules include safe harbors, so confirm treatment with your CPA, and record the item in the books with a clear description.

Do I still need bookkeeping if my property manager sends monthly statements?

Usually yes. A manager reports on the properties they manage. Someone still needs to tie those statements to your bank activity, account for loans, improvements, and distributions, and combine every property and entity into one picture.

What does my CPA need at year-end?

Profit and loss by property, a year-end balance sheet, loan statements showing interest paid, a list of improvements placed in service with dates and costs, and documentation for any acquisitions or sales during the year.

Platinum Ledgers provides bookkeeping and accounting for real estate investors, including property-level reporting, loan and manager reconciliation, and multi-entity books. This article is general information, not tax advice. Consult your CPA about your specific situation.

Want clean books for your rental portfolio?

Platinum Ledgers provides property-level bookkeeping and multi-entity accounting for real estate investors, with books organized so your lender, partners, and CPA can rely on them.

See Real Estate Investor Accounting