The hardest part of rental property bookkeeping isn't building the spreadsheet. It's keeping each transaction tagged to the right property as it happens. A rent deposit belongs to one address, a repair invoice to another, an HOA bill to a third. Once they pile into a single column untagged, you can't tell what any one property earned or spent.
Schedule E reports rental income and expenses property by property, not as a blended total. When the records arrive as one mixed paper trail, your certified public accountant (CPA) reconstructs that split at filing time, and deductions slip through. A miscategorized expense you'd have caught the day it landed instead waits for a year-end cleanup, if anyone catches it at all.
What to track for rental property bookkeeping
Rental property bookkeeping covers three categories, organized the way the Internal Revenue Service (IRS) expects to see them on your return: income per property, expenses per Schedule E category, and supporting documentation for every transaction.
Income per property
Rent received, late fees, prepaid rent, pet fees, parking revenue, laundry income, and online travel agency (OTA) payouts for short-term rental (STR) operators. Security deposits are not income until applied to damages or unpaid rent. Hold them in a dedicated security deposit account separate from operating cash.
Expenses per Schedule E line item
Operating costs include mortgage interest, property taxes, insurance, utilities (if landlord-paid), repairs, and supplies. Overhead and services include advertising, professional fees (CPA, attorney), management fees, homeowners association (HOA) dues, travel to properties, and depreciation. Capital improvements are tracked separately from repairs; the distinction determines whether you expense the cost in the current year or depreciate it over time.
Supporting documentation
Receipts, invoices, bank statements, mortgage statements (Form 1098), property tax bills, and signed leases. The IRS requires documentary evidence, such as receipts, canceled checks, or bills, to prove expenses you claim.
Keeping these three buckets complete and tagged by property gives your CPA usable records instead of a year-end cleanup project. Categorize a repair invoice as maintenance without tagging it to the correct property and you've created exactly the reconciliation work that drives up CPA bills.
A starter chart of accounts for rental properties
Mapping your accounts to Schedule E line items at setup time saves manual recategorization later. A working chart of accounts for a small rental portfolio breaks into three groups. Income accounts cover Rental Income per property and a catch-all for Late Fees and Other Income. Operating expense accounts mirror the Schedule E deduction lines: Advertising, Auto and Travel, Cleaning and Maintenance, Insurance, Mortgage Interest, Professional Fees, Repairs, Supplies, Property Taxes, and Utilities.
Capital tracking sits separately: Depreciation Expense as an expense account and Capital Improvements as a balance-sheet asset. Match each account name to a Schedule E line so year-end categorization is direct work, not a recategorization project.
Common rental property bookkeeping mistakes
Six mistakes drive most of the cleanup work CPAs do at tax time on rental property books. Each is preventable with a small process change.
Commingling personal and rental funds
Running rental income through a personal checking account undermines limited liability company (LLC) liability protection and forces your CPA to separate personal spending from deductible expenses by hand. Fix: a dedicated business checking account for rental operations, at minimum.
Misclassifying capital improvements as repairs
A new roof is a capital improvement, depreciated over its useful life. Patching a leak is a repair, expensed in the current year. Misclassifying a major roof replacement as a repair overstates current-year deductions and creates audit exposure. Fix: confirm the classification with your CPA before filing, especially for larger costs.
Missing depreciation
Land isn't depreciable, but the building on it is. You allocate the purchase price between the two and track the building's value as your depreciable basis. Under the Modified Accelerated Cost Recovery System (MACRS), residential rental property is depreciated over 27.5 years. Skipping depreciation doesn't save it for later; the IRS applies depreciation recapture on sale based on allowable depreciation, whether or not you claimed it.
For smaller items that would otherwise need to be capitalized (appliances, minor fixtures, low-cost tools), the safe harbor election lets you expense them in the current year instead of opening a depreciation schedule. Fix: track every property's depreciation schedule starting in year one, and apply the safe harbor election where the cost qualifies.
Commingling security deposits with operating cash
Multiple states require landlords to hold security deposits in segregated accounts. Even where the law doesn't require it, spending a tenant's deposit on a repair bill creates both a legal liability and a cash flow hole when the tenant moves out. Fix: a dedicated account for security deposits, separate from operating funds.
Inconsistent record-keeping
Reconstruct a year of transactions at tax time and you'll miss deductions. Cash payments, third-party transfers, and out-of-pocket expenses that never touched a bank account are the first to disappear. Fix: weekly updates, digital receipt capture for every expense, and monthly reconciliation against bank records.
Treating Schedule E and Schedule C as interchangeable
Long-term rental income is reported on Schedule E. Short-term rental operators who provide substantial guest services (daily cleaning, concierge, meals) may need to file Schedule C, which carries self-employment tax. Fix: confirm the correct filing schedule with your CPA based on the services you provide.
The rental property bookkeeping template
The template is a Google Sheets and Excel workbook with seven tabs, built around Schedule E categories so your data maps directly to IRS line items without reformatting.
View the rental property bookkeeping template. The Monthly Expense Tracker tab tags every row to a property and assigns it a Schedule E category:
Date | Property | Vendor | Amount | Schedule E category | Receipt |
|---|---|---|---|---|---|
03/14 | Property A | Smith Plumbing | $385.00 | Repairs | Linked |
03/15 | Property B | State Farm | $1,240.00 | Insurance | Linked |
03/18 | Property A | City Water Dept | $94.50 | Utilities | Linked |
The seven tabs cover the full landlord bookkeeping workflow for a small rental portfolio:
Property Setup: Address, acquisition date, purchase price, depreciable basis, and entity information for each property
Monthly Income Tracker: Property-tagged rows for rent, fees, and OTA payouts
Monthly Expense Tracker: Schedule E category column with property attribution on each row
Capital Improvements Tracker: Separate log for costs that are depreciated rather than expensed
Security Deposit Tracker: Per-tenant deposit amounts, dates received, and disposition status
Monthly Summary: Auto-calculated income and expense totals by property
Annual Schedule E Preview: Rolls monthly data into the line items your CPA needs for filing
Update the workbook weekly, reconcile against bank statements monthly, and review the Schedule E Preview quarterly to catch categorization errors before they stack up. The template fits smaller portfolios with manageable transaction volume.
How bank account structure affects rental property bookkeeping
Your bank account structure determines how much sorting your bookkeeping requires. Running multiple properties through one checking account means reconstructing per-property data from transaction descriptions after the fact. A dedicated account for each property creates property-attributed data before any spreadsheet or software touches it. Your month-end work becomes exporting clean records instead of reconciling memos.
Relay lets you open up to 20 checking accounts (10 if you hold rentals in your own name rather than an LLC), enough to give every property, tax reserve, maintenance reserve, and security deposit its own bucket. Automated transfer rules move a set percentage of each rent deposit into the reserve accounts you designate, so the split happens the moment money lands instead of at cleanup. Two-way sync with QuickBooks Online or Xero feeds per-account data straight into whatever accounting tool your CPA already uses. If you're comparing banking for investors, this per-property separation is the operational reason separate accounts matter.
Separate accounts don't replace depreciation schedules or tax-classification decisions. They do cut the cleanup that usually happens before your books are usable.
When to graduate from a spreadsheet to rental accounting software
A spreadsheet works for smaller portfolios with low transaction volume and weekly update discipline. As a portfolio grows, transactions pick up, or operations spread across multiple LLCs, software is usually worth the cost.
Signs it's time to graduate: the spreadsheet is taking too much time each month, your STR properties generate frequent OTA transactions, or your CPA has asked for reports the template can't produce.
If you're comparing accounting software options, start with the reporting your CPA actually needs and work backward from there.
Whatever software you choose, the per-property banking structure carries over. Clean account-level data feeds into any of these tools, reducing the manual categorization that eats hours every month.
Set up the system before the next rent deposit
Per-property bookkeeping works best when the system underneath already separates activity by address. If income, reserves, and security deposits all run through one account, your spreadsheet becomes a cleanup tool instead of a bookkeeping system. Recording each transaction with the right property attached from the start gives your CPA cleaner records and keeps Schedule E reporting manageable all year, not just in April.
Relay fits that setup: each property, reserve, and security deposit gets its own account with no monthly maintenance fees, and automated transfer rules move money into the right buckets before any cleanup starts. Two-way sync with QuickBooks Online or Xero carries that account structure into the system your CPA already uses. Open a Relay account and have it ready before your next rent deposit lands.
Frequently Asked Questions
Do Landlords Need Bookkeeping?
Yes. The IRS requires accurate records for every deduction claimed on Schedule E, and landlords who can't substantiate expenses lose them. Rental property bookkeeping is the system that produces the evidence.
What Is the Best Way to Track Rental Property Income and Expenses?
For smaller portfolios, a Schedule E-aligned spreadsheet updated weekly. For larger portfolios, dedicated rental accounting software. In either case, tagging each transaction to a property when you enter it keeps the records usable at tax time.
What Rental Expenses Are Tax-Deductible?
Deductible rental expenses include mortgage interest, property taxes, insurance, repairs, utilities paid by the landlord, professional fees, advertising, supplies, travel to properties, and depreciation. Capital improvements, such as a new roof or a full heating, ventilation, and air conditioning (HVAC) system, are depreciated over their useful life rather than expensed in one year. Consult your CPA for specifics on your portfolio.
How Do I Track Mileage for Rental Property Visits?
Log every drive to a rental property as it happens: date, starting and ending odometer, destination property, and purpose (showing, repair check, tenant meeting). The IRS standard mileage rate is the simpler option for most landlords, but you can also use the actual expense method if you track fuel, maintenance, and insurance allocated to rental use. A mileage app that logs trips automatically is usually the lowest-friction option.
Do I Need Separate Bank Accounts for Each Rental Property?
It's not strictly required by the IRS, but it's the cleanest way to keep Schedule E records property by property. A single commingled account forces you to reconstruct which deposit and which expense belongs to which property after the fact, which is where categorization errors and missed deductions come from. Multi-account banking platforms make per-property separation practical without opening a new bank relationship for each address.
Should I Use Cash or Accrual Accounting for Rental Properties?
Most individual landlords use cash-basis accounting, the IRS default for individuals. Accrual accounting is more common at larger portfolios filing as corporations or partnerships. Either method works; consistency from year to year matters most.
