Rental Property Bookkeeping: A Property-to-Portfolio System

What makes rental bookkeeping different?

A rental is kept for years, not sold in months, so its books follow the same property, loan and tenant every month. Each property needs its own record, and the portfolio is the sum of those records.

• The property is the unit. Every rent payment, bill and loan payment belongs to one property.
• Some money is not yours: a tenant’s deposit, escrow held by the lender, the loan itself. It moves through the bank without being income or cost.
• The records last. What a property cost and what was added to it matter until the day it is sold.
• The rhythm is monthly: rent, the mortgage, the manager’s statement, then the close.

How do you set up the books by property?

Give every property its own tag, and post every transaction to one. Use one chart of accounts for all of them, so every property’s statement has the same lines and the totals add up.

Each line of the property's statement is an account in the chart of accounts. The real estate chart of accounts has a rental module with each of them, from security deposits held to escrow held by the lender.

If the rental is reported on Schedule E, the cost categories line up with the expense lines of the 2025 Schedule E form. Which form the LLC files is your CPA's call.

How do you record rent, late fees, credits and unpaid rent?

Charge rent on a tenant ledger, record each payment against it, and keep late fees and credits as their own lines. Rent that has not arrived stays open on the ledger until it is paid or settled.

1. 1Charge each month’s rent to the tenant ledger on the day it is due.
2. 2Record each payment when it arrives, against that charge, tagged to the property.
3. 3Add a late fee as its own charge under the lease, and record it as income when it is paid.
4. 4Record a credit, such as a rent reduction agreed with the tenant, as its own line. Never just charge less.
5. 5Prorate a partial month by days, and note the days on the ledger.
6. 6At month end, compare the ledger with the bank or the manager’s statement, and list anything still unpaid.

Property 1's March 2026 rent arrived late, on Mar 8, with the $75 late fee from the lease. Here is the tenant ledger for that month.

On the manager's March statement, sent Mar 10, 2026, the $2,975.00 came in less a $238.00 fee: $2,737.00 reached checking.

A partial month is prorated by days. Property 2's lease started on Oct 15, 2026, so October rent was $2,450 times 17 of 31 days: $1,343.55.

On cash-basis books, rent counts as income when it arrives. Rent that has not arrived stays on the tenant ledger as owed, and that ledger is the list to follow up. A credit stays visible as its own line, and how it is reported is your CPA's call. A month with no tenant still gets a statement, showing $0 of rent, so the empty month stays visible.

Where does a security deposit go?

Into a liability account, not income. The deposit is owed back to the tenant. It becomes income only if you keep part of it under the lease.

Property 1's $2,900.00 deposit sits in Sample Property Management's trust account. Property 2's $2,450.00 arrived on Oct 12, 2026 and sits in Demo Rentals LLC's checking. Both are owed to tenants. We show receiving, returning and keeping a deposit as entries in security deposit accounting.

How do you record a mortgage payment?

Split it 3 ways from the lender’s statement. Principal lowers the loan, interest is a cost, and escrow is money held for property tax and insurance. Only the interest is a cost that month.

Property 1's October 2026 payment was $2,074.00: $236.40 of principal, $1,214.60 of interest and $623.00 of escrow. Only the $1,214.60 is a cost of October. The tax and insurance become costs when the lender pays them from escrow. The month by month view, and the escrow side, are in how to record a rental property mortgage payment.

What if a property manager collects the rent?

Record the owner statement in gross, not the net deposit. Rent and late fees go to income, the manager’s fee and the bills it paid go to costs, and the lines add up to what reached your bank.

Sample Property Management sent $2,483.00 for October 2026: $2,900.00 of rent, less its $232.00 fee and a $185.00 faucet repair. The books record all 3 lines, not the single deposit. The full walkthrough, with a year of statements tied to the bank, is in reconciling a property management owner statement.

Is a rental cost a repair or an improvement?

That is your CPA’s decision, and the books keep the records it needs: the invoice, what was done and to which part of the property. Repairs go on the P&L. Improvements go on the property record.

On Property 1 in 2026, the manager paid a $185.00 invoice to fix a leaking kitchen faucet, and Demo Rentals LLC paid Example Roofing Co $14,800.00 to replace the roof on May 14, 2026. The books carry the faucet as a repair and the roof on the property record. We set out what each invoice has to show for your CPA in repairs vs improvements on a rental property.

Which records follow a property for its whole life?

The purchase closing statement, the land and building split, every improvement, and the depreciation your CPA sets each year. They stay with the property until it is sold, and then they close it out.

Property 1 cost $380,000 plus $4,200 of settlement costs, $384,200 in all. The CPA for Demo Rentals LLC split that into $134,470 of land and $249,730 of building. The $14,800 roof is recorded on the same property record. We cover how the record is built and kept in rental property cost basis and depreciation records.

The same record is what the books use when a property is sold. We walk through the final entries in how to record the sale of a rental property.

How does a BRRRR property fit in?

It is one address with 2 records: a rehab, where costs build the property record, then a rental with its own P&L. The refinance swaps the rehab loan for a long-term loan, and its cash is not income.

• Buy: Property 2 was bought on Jun 2, 2026 for $250,000, with a $180,000 loan from Sample Hard Money Lending.
• Rehab: Jun 10, 2026 to Oct 9, 2026, $46,380 of work on the property record.
• Rent: the deposit arrived on Oct 12, 2026 and the lease began on Oct 15, 2026.
• Refinance: on Oct 22, 2026, a $240,000 loan paid off the $180,000 rehab loan and $4,800 of loan costs, leaving $55,200 of cash.
• Repeat: on Oct 23, 2026, $41,380 of that cash repaid what Demo Rentals LLC owed Demo Flips LLC.

Each phase has its own entries, set out in BRRRR bookkeeping, phase by phase. We explain the refinance alone, and why the $55,200 is borrowed money, in cash-out refinance bookkeeping.

How do property P&Ls roll up to the portfolio?

Put each property’s P&L in its own column, with the same lines in the same order, and add a total column. The portfolio is that total, and each column still shows one property’s result.

Here is Demo Rentals LLC for January to October 2026, one column per property.

Property 2 was in rehab until Oct 9, 2026 and has 17 days as a rental.

The Portfolio column alone looks flat. The property columns show one rental earning and one just out of rehab. Our guide to the rental property P&L reads each property's statement, then the total.

For a few doors, the same layout works in a spreadsheet. Start from our rental property income and expense spreadsheet with the sample properties already in it.