A simple rental bookkeeping system (spreadsheet or app)

By Tom, CPA · Updated October 27, 2026

Part of: Rental Property Taxes

TL;DR: Use a separate bank account per rental business, categorize every transaction into the Schedule E expense lines, track capital improvements separately from repairs, and do a 20-minute monthly close. A spreadsheet works for one to three doors; accounting or landlord software earns its fee as unit count, tenants and 1099s grow.

Educational only, not tax, legal, or investment advice. Examples are illustrations, not predictions. Rules and limits change; verify current figures and talk to a qualified professional about your situation.

Your tenant pays the mortgage; the IRS pays for the roof (eventually, over 27.5 years). Your bookkeeping is how you prove both happened. The goal is not beautiful accounting. The goal is a Schedule E that takes an hour instead of a weekend, and records that survive a letter from the IRS.

This page walks through a system designed for small landlords: one to maybe twenty units, cash method, filing Schedule E. It is the same structure whether you use a spreadsheet or software; the software just automates the boring parts. For which receipts to keep and for how long, see rental property records.

CPA Warning Label: Commingling rent with grocery money does not change your taxes. It just guarantees you will spend a weekend in April arguing with your own bank statement.

Start with the bank account

Open a separate checking account for your rental activity (one per entity if you use LLCs). Rent goes in, expenses go out, and owner transfers are labeled as transfers. Separate accounts are not legally required for a sole owner, but they do three useful things:

• Every deposit is presumptively rental income and every withdrawal is presumptively a rental expense or an owner draw, so categorizing is fast.
• They support liability protection for an LLC by showing it is a real separate entity.
• They make the QBI rental safe harbor requirement of separate books and records for each enterprise much easier to meet (see the QBI rental safe harbor).

Add a dedicated credit card for rental purchases. Pay it from the rental account. Do not run personal charges through it, even "just this once," because once becomes a habit by spring.

Security deposits

Under IRS Publication 527, a security deposit you intend to return is not income when received. Many states also require deposits to be held separately or in a specific type of account. Track deposits in a liability column, not as rent. If you keep part of a deposit for damage or unpaid rent, that part becomes income in the year you keep it. A deposit that is really the last month's rent is advance rent and is income when received.

Use the Schedule E categories

Your chart of accounts should mirror Schedule E, Part I. Then the tax return is a copy-paste, not a translation project. The expense lines on Schedule E:

Add three non-Schedule E categories: Capital improvements (assets you depreciate), Owner contributions and draws, and Loan principal (not deductible). Principal is the most common mistake on landlord spreadsheets: your mortgage payment is interest plus principal plus escrow, and only the interest and the escrowed taxes and insurance are expenses.

Income categories

Rent, late fees, pet fees, laundry or parking income, tenant-paid expenses (also income, with an offsetting expense), and kept security deposits. Advance rent is income in the year received, regardless of the period it covers.

Spreadsheet layout

For one to three doors, a single spreadsheet tab per year works well. Columns:

• Date
• Property (address or nickname)
• Payee or payer
• Description
• Category (dropdown of the list above)
• Amount (income positive, expenses negative)
• Paid from (rental checking, rental card)
• Receipt link (cloud file path)
• Notes (repair versus improvement reasoning, tenant name for deposits)

Then a summary tab with a pivot table: properties across the top, categories down the side. That pivot is your Schedule E. Add a second tab for the fixed asset register: each improvement, cost, date placed in service, recovery period and accumulated depreciation.

Illustration: Fran owns a duplex. Assumptions: monthly rent $1,400 per unit, one unit vacant for one month, mortgage payment $1,650 a month of which $1,100 averages to interest, $350 escrow for taxes and insurance and $200 principal, and repairs of $2,300 during 2026. Annual summary: rent $1,400 times 23 unit-months = $32,200. Expenses on Schedule E: mortgage interest $13,200 ($1,100 times 12), taxes and insurance $4,200 ($350 times 12), repairs $2,300. The $2,400 of principal ($200 times 12) does not appear on Schedule E. Before depreciation, net rental income is $32,200 minus $19,700 = $12,500. If Fran had entered the full mortgage payment as an expense, she would have overstated expenses by $2,400.

When an app is worth it

Software earns its keep when any of these are true:

• You have more than a handful of units or more than one property owner entity.
• You need tenant portals for online rent payment and maintenance requests.
• You issue more than a few contractor Forms 1099 a year. The 1099-NEC reporting threshold is $2,000 for payments made in 2026 and is inflation-adjusted after that, under the 2025 law per IRS guidance. See landlord 1099 requirements.
• You want bank feeds that auto-categorize transactions by rule.
• Someone else (a spouse, a bookkeeper, a tax preparer) needs access.

Choosing between general small-business accounting software and landlord-specific software mostly comes down to whether you want tenant features. Either works for tax purposes if the chart of accounts follows Schedule E and you attach receipts. Avoid any system that you will not open monthly.

Monthly close routine

Twenty minutes a month keeps the year-end from becoming a crisis:

1. Download or sync the rental bank and card transactions.
2. Categorize everything. Split mortgage payments into interest, escrow and principal using the lender statement.
3. Attach receipts for anything over a threshold you choose (many landlords use $75). Under the de minimis safe harbor election, many small purchases up to $2,500 per invoice or item can be expensed rather than capitalized; flag them in notes. See the de minimis safe harbor.
4. Flag improvement-type spending for the fixed asset register.
5. Reconcile to the bank statement ending balance.
6. Log mileage and time if you track hours for QBI or participation.
7. Check rent received against the rent roll and note any late or unpaid rent. Cash-method landlords do not deduct unpaid rent, because it was never included in income.

The year-end package

When the year closes, export one package per property (or per entity) for your return or your preparer:

• The category summary that maps to Schedule E
• The fixed asset register with new additions, disposals and the supporting invoices
• Form 1098, property tax bills and insurance declarations
• Copies of Forms 1099 you issued and received
• Mileage and time logs
• A short note on anything unusual: a vacancy, a casualty, a refinance, a tenant who paid a year in advance

Repairs versus improvements in the books

Make the call when you enter the transaction, while you still remember what the work was. Repairs keep property in ordinary operating condition and go on the Repairs line. Betterments, restorations and adaptations are improvements and go to the asset register. When unsure, write a one-line note with the facts (what failed, what replaced it, how much of the system was replaced); that note is what lets you or a preparer apply the tangible property rules later.

At year-end, add depreciation from your schedule, total the categories, and compare to last year. A category that doubled deserves a note explaining why.