# Rental Property Bookkeeping for Landlord Clients

- Author: AutoBankConvert (https://www.autobankconvert.com)
- Published: 2024-11-18
- Updated: 2024-11-18
- Category: Industry bookkeeping
- Canonical: https://www.autobankconvert.com/blog/rental-property-bookkeeping

> Rental property bookkeeping for landlord clients: rent deposits per unit, security deposits, repairs versus improvements and statements for each property.
Rental property bookkeeping for a landlord client means tracking income and costs per building, and often per unit. Code each rent deposit to the unit that paid it. Hold security deposits as money owed back to tenants. Split repairs from improvements. Collect a statement for every account the properties touch, every month, so each building's result is real.

## How should rental property bookkeeping separate each property?

Rental property bookkeeping should give every building its own line of results, because landlords decide per building whether to raise rent, refinance or sell. Pick one method and use it the same way for every transaction: a class or tracking category per property, a separate set of accounts per property, or a separate legal entity with its own books.

### Three ways to split a portfolio

Each method fits a different kind of landlord:

- **Class or tracking category per property.** One chart of accounts, and every line carries a property tag. This suits a landlord with two to ten buildings owned in one name. Reports by class show income and expense per building without a bloated chart.
- **Sub-accounts per property.** "Repairs - Elm St" and "Repairs - Oak Ave" as separate accounts. It works for two buildings and becomes unreadable at six.
- **One entity per property.** Many landlords hold each building in its own LLC. Then each LLC usually has its own bank account and its own books, and the split comes from the entity, not from tags.

### Shared accounts are the hard part

The method matters less than what happens when one bank account serves several buildings. A single operating account that collects rent for three properties and pays one insurance premium covering all of them forces an allocation decision every month. Write the allocation down once, for example by unit count or by the premium schedule on the policy, and apply it the same way each month. A landlord who later asks why Oak Ave looks worse than last year deserves an answer that does not depend on who coded the month.

## Coding rent deposits to the right unit and tenant

A rent deposit is coded to a unit by reading who paid it, how they paid and how much arrived, then matching that to the rent roll, the landlord's list of units, tenants and monthly rents. The bank statement rarely names the unit, so the rent roll is the key that turns deposit lines into per-unit income.

### What the statement actually shows

Rent arrives in several shapes, and each needs a different match:

- **ACH or online portal deposits** often carry the tenant's name or a portal batch name. A portal batch may hold several tenants' rent in one deposit, so it needs the portal's payout report to split it.
- **Mobile check deposits** show only "DEPOSIT" and an amount. The amount against the rent roll is the main clue.
- **Payment app transfers** carry a first name or a handle that may not match the lease name at all.
- **Cash or money orders** arrive as a branch deposit, sometimes combined across tenants.

Payment app rent is a growing share for small landlords, and the coding questions are the same ones a seller faces when platform payouts land in a bank account. The guide to [ecommerce bookkeeping from payout deposits](/blog/ecommerce-bookkeeping) covers splitting one platform deposit into the sales behind it, which is the same job as splitting a portal batch into tenants.

### Partial rent and late fees

Partial payments are where per-unit tracking pays off. If unit 2B owes 1,450 and pays 1,000, the deposit is still rent for 2B, and the 450 is a receivable the landlord should see on a tenant ledger. A late fee paid in the same deposit belongs in its own income account, not in rent, because landlords and their tax preparers often want to see fees on their own line.

## Security deposits held for tenants as a liability

A security deposit is money the landlord holds for the tenant and will return at move-out, minus any lawful deductions. It is a liability, not rent income, when it lands in the bank.

[IRS Publication 527, Residential Rental Property](https://www.irs.gov/publications/p527) says so plainly: do not include a security deposit in income when you receive it if you plan to return it.

### Booking the three security deposit events

Each security deposit has up to three bookings over its life:

1. **Receipt.** Debit the bank, credit a liability such as "Tenant security deposits held". If the landlord's state requires a separate deposit account, the money also moves there, and that account needs its own statement every month.
2. **Return.** Debit the liability, credit the bank, for the amount refunded.
3. **Retention.** When the landlord keeps part of a deposit for damage or unpaid rent, that kept part moves from the liability to income in the year it is kept. Publication 527 also treats a deposit applied as the final month's rent as advance rent, which is income when received rather than a deposit.

### Why the liability balance must tie to a list

The balance in the security deposit liability account should equal the sum of deposits on the current tenant list. When it does not, something was coded as rent that should not have been, or a refund went to a repair account. Checking that one number each quarter catches most deposit errors before a move-out exposes them. Nonprofits face a similar discipline with money they hold for a set purpose; the guide to [nonprofit bookkeeping and restricted funds](/blog/nonprofit-bookkeeping) shows another version of tracking money that is in the bank but not free to spend.

## Repair or improvement: sorting rental property spending

A repair keeps a property in its current working condition and is generally deducted in the year paid. An improvement makes the property better, restores it or adapts it to a new use, and is capitalized and depreciated instead. Publication 527 states that you must capitalize any expense you pay to improve your rental property.

### Examples that sort easily and examples that do not

Some lines sort themselves:

- Patching a leaking pipe, replacing a broken window pane and repainting between tenants are repairs.
- A new roof, an added bathroom or a full kitchen remodel are improvements.

The hard cases are the middle ground. A furnace replacement, a set of new appliances for one unit or a large flooring job can go either way depending on scope. The bookkeeper's job is not to make the final tax call alone. It is to keep enough detail that the landlord's tax preparer can make it: the invoice, the unit, what was replaced and the total cost. Publication 527 also asks landlords to keep separate records of repair and improvement costs, so put uncertain items in a holding account such as "Repairs and improvements - to review" rather than burying them in repairs.

### Contractor payments on the statement

Contractor costs show up as checks, card charges at supply stores and transfers to the contractor. A single supply store run might buy repair parts for one unit and lumber for a deck addition at another. Split the receipt, not just the statement line, when the landlord has one.

## What should a landlord's monthly statement collection include?

A landlord's monthly statement collection should cover every account that touches the properties: each operating account, any separate security deposit account, the credit cards used for supplies and contractors, the mortgage statements and the rent portal's payout report. Missing any one of these leaves a building's result incomplete for that month.

### A collection list for one landlord

| Document | Why it is needed |
| --- | --- |
| Operating account statement for each bank account | Rent deposits, repairs, utilities, insurance |
| Security deposit account statement, where one is kept | Ties to the deposit liability |
| Credit card statements | Supply store runs and online orders for units |
| Mortgage statement per property | Splits each payment into interest, principal and escrow |
| Rent portal payout report | Splits batch deposits by tenant and unit |
| Rent roll, updated for move-ins and move-outs | The key for coding every deposit |

Mortgage statements deserve a special note. The bank statement shows one payment, but the lender's statement breaks it into interest, principal and often escrow for taxes and insurance. Only the interest and the escrowed costs are expenses; principal reduces the loan.

Getting these documents every month is a routine, not a favour the landlord does you. The steps in [how to collect bank statements from clients every month](/blog/how-to-collect-bank-statements-from-clients) work well for landlords too, especially the habit of a fixed request date. Once statements arrive, [AutoBankConvert](/) can convert each one as it comes in on a client's monthly schedule and keep the landlord's coding rules separate from every other client's books.

## Rental property bookkeeping mistakes that distort each building's results

The mistakes that distort a building's results are the ones that move money between properties or between the income statement and the balance sheet. None of them stops the books from balancing, which is why they survive for months.

### A worked month for a three-property landlord

The table below is an example month for a landlord with three properties sharing one operating account. Names and amounts are made up for illustration.

| Statement line | Amount | Property and unit | Coded to |
| --- | --- | --- | --- |
| ZELLE FROM J MORALES | 1,450.00 | Elm St, unit 2B | Rent income |
| RENTPORTAL PAYOUT | 3,900.00 | Oak Ave, units 1 and 3 (split by payout report) | Rent income |
| MOBILE DEPOSIT | 1,600.00 | Pine Rd, new tenant | Security deposits held |
| MOBILE DEPOSIT | 1,600.00 | Pine Rd, new tenant | Rent income |
| HOME SUPPLY STORE | 186.40 | Elm St, unit 2B | Repairs |
| CHECK 1042 ROOFING CO | 9,800.00 | Oak Ave | Improvements - to review |
| FIRST MORTGAGE PMT | 2,210.00 | Pine Rd | Interest, principal and escrow per lender statement |
| INSURANCE PREMIUM | 1,140.00 | All three, by policy schedule | Insurance |

### Errors that this example could have hidden

- **The two identical Pine Rd deposits.** Coding both as rent overstates Pine Rd income by 1,600 and leaves no liability for the deposit the landlord must return.
- **The roofing check in repairs.** A full roof is almost always an improvement. In repairs, it makes Oak Ave look like a loss this year and understates the asset.
- **The whole mortgage payment as an expense.** Principal is not an expense. Booking it as one makes every mortgaged building look worse than it is.
- **The insurance premium on one building.** Charging the whole premium to Elm St because it was the first property flatters the other two.
- **Owner draws coded as repairs.** A landlord who moves money to a personal account is taking a draw, not paying for upkeep.

A quarterly look at three numbers catches most of these: the security deposit liability against the tenant list, the improvement account against the year's major projects, and each property's net result against the prior year. When one of those moves sharply without a reason the landlord recognises, the coding is the first place to look.