Rental Property Bookkeeping: A Setup Guide for Investors

Rental property bookkeeping means recording every dollar of rent, deposit, repair, loan payment and improvement against the specific property and legal entity it belongs to, then closing the books monthly so the numbers are reliable. Done well, you can see which property earns money, your CPA gets clean records at tax time, and a lender or partner can read your statements without questions. If you own several properties or run them through several LLCs, multi-entity bookkeeping with consolidated reporting is the version of this work we do every month for investors.
TL;DR
-
Keep one set of books per entity and tag every transaction to a property, so you can see results property by property and in total.
-
Open a dedicated bank account and card for each entity. Mixed money is the most common reason rental books fall apart.
-
Know the difference between income, refundable deposits, loan proceeds, repairs and improvements before you record them.
-
Reconcile every account and close the month on a schedule. Quarterly or annual catch-up is where errors compound.
-
Talk to your CPA about tax treatment. Your bookkeeping job is to give them accurate, supported records.
Table of Contents
What rental property bookkeeping actually involves
Ordinary bookkeeping answers one question: what did this business earn and spend? Rental bookkeeping has to answer it for each building, and often for each unit, while also tracking things a typical small business never touches: tenant deposits, mortgage principal versus interest, capital improvements, and assets that are depreciated over years.

That is why a single bank feed dumped into one category list does not work for long. By the third property you cannot tell whether the duplex is carrying the single-family house, and by the fifth you cannot answer a lender’s question without an afternoon of digging.
Good rental books do five jobs:
-
Record income when and how it was received.
-
Match expenses to the right property.
-
Separate repairs from improvements.
-
Keep balance sheet items (loans, deposits, escrow) out of the income statement.
-
Preserve the documents that support each entry.
Tax guidance lists the same purposes for good records: monitoring the property, preparing financial statements, identifying the source of receipts, tracking deductible expenses, preparing returns and supporting items reported on them.
Step 1: Decide your structure before you record anything
Start with a list of what you own and who owns it: each property, the entity or person holding title, the lender, and the bank account that rent flows into. Many investors hold properties in separate LLCs for liability reasons. Your attorney and CPA decide that structure. Your books need to mirror it.
Tax guidance says that if you are in more than one business, you should keep a complete and separate set of records for each, and that any recordkeeping system works if it clearly shows income and expenses. In practice that gives you three layers:
| Layer | What it answers | How to handle it |
|---|---|---|
| Entity | Does each LLC or person have complete, separate books? | One set of books per entity, with its own bank accounts |
| Property | Which building earns or loses money? | Tag every transaction to a property (by class, location or account naming) |
| Consolidated | How is the whole portfolio doing? | A combined report built from the entity books, with transfers between entities eliminated |
If you hold several LLCs, our guide to bookkeeping for real estate investors with multiple LLCs goes deeper on intercompany loans and shared expenses, and the general principles in bookkeeping for multiple businesses apply to any owner running more than one entity.
Step 2: Separate the money
Give every entity its own checking account, and ideally its own credit card. Run rent in and property expenses out through that account only. Put security deposits in a separate account where your state or lease requires it (ask your attorney about your state’s rules).
Commingling creates three problems: you cannot reconcile cleanly, you cannot tell whether a transfer was a loan, a distribution or a reimbursement, and you weaken the separation you set up the LLC to create. When an owner pays a repair from a personal card by mistake, record it as a reimbursable owner contribution or loan, with a note, rather than burying it in expenses.
Step 3: Build a chart of accounts that fits rentals
Keep the chart simple and consistent across entities so reports can be combined. A workable core:
-
Income: rental income, late fees, pet or parking fees, other income
-
Operating expenses: repairs and maintenance, property management fees, insurance, utilities, property taxes, advertising, legal and professional fees, supplies
-
Mortgage interest as an expense, and loan principal as a liability
-
Fixed assets: building, improvements, and accumulated depreciation, tracked per property
-
Liabilities: mortgages, tenant security deposits held, prepaid rent received
To see results by property without building a separate chart for each one, most accounting platforms let you tag transactions. In QuickBooks Online you can switch on class tracking or location tracking in the account settings and create one class or location per property, so a single income statement can be filtered or split by building. Choose one method and use it on every transaction, because a half-tagged ledger is worse than an untagged one.
Step 4: Record income the right way
Not every dollar that lands in your account is rental income. Rental income is any payment received for the use or occupation of property, and cash-basis taxpayers report it in the year it is actually or constructively received. Tax guidance explains several cases that trip up bookkeepers:
-
Advance rent is included in income in the year received, whatever period it covers.
-
A security deposit you will return is not income when received. It becomes income in the year you keep any part of it.
-
A deposit meant as final month’s rent is income when received.
-
Tenant-paid expenses and lease-cancellation payments count as rental income. So does the fair market value of property or services received instead of rent.
Tax guidance on rental recordkeeping covers the same points. For your books, that means refundable deposits go to a liability account, not income, until the lease ends and you know what you are keeping. Money from a cash-out refinance or a bridge loan is also not income. It is debt, and it belongs on the balance sheet, which matters when you compare rental investor financing options and need your records to show what was borrowed against which property.
Whether you report on the cash or accrual basis is a decision for your CPA. Your bookkeeper should know which one each entity uses.
Step 5: Track expenses and support them
Deductible rental expenses may include mortgage interest, property tax, operating expenses, depreciation and repairs, and receipts, canceled checks or bills generally substantiate them. Build a habit around three things:
-
Attach the document. Every bill or receipt gets stored with the transaction, not in a shoebox or an inbox.
-
Code to a property. A roof repair on Oak Street is not a general expense.
-
Describe the work. A vendor line that says “labor” tells your CPA nothing. “Replaced water heater, unit 2” does.
Repairs versus improvements
This is the call that most affects rental books. Tax guidance tells owners to separate the costs of repairs and improvements and keep accurate records, because you will need the cost of improvements when you sell or depreciate the property. Capitalized improvements are generally depreciated as if they were separate property. Record anything that looks like a major improvement as a fixed asset first, then let your CPA decide the treatment.
Personal use and mixed-use properties
If a dwelling is used for both rental and personal purposes, expenses must be divided between rental and personal use based on days used for each. Deductions are limited to gross rental income, with excess expenses carried to the next year. Keep a simple day log for any vacation home or short-term rental you also use yourself.
Travel
Travel to inspect or repair a rental needs its own records. Tax guidance has specific record rules for those expenses. Log the date, destination and purpose each time.
Step 6: Reconcile and close every month
A monthly close is what turns a ledger into financial statements you can use. The routine:
-
Reconcile every bank, card and loan account to its statement.
-
Review uncategorized and flagged transactions, and assign each to an entity and property.
-
Confirm rent received against each lease, and chase gaps.
-
Record depreciation entries or confirm your CPA’s schedule is current.
-
Review the income statement and balance sheet per entity for anything odd, such as a negative expense or a deposit sitting in income.
-
Produce the property-level and consolidated reports.
Once a quarter, compare rent roll, debt balances and escrow accounts to your records. Our real estate bookkeeping checklist lays out these checks in a form you can reuse.
If you are months behind, do not try to fix it in the middle of tax season. Catch up in order: oldest unreconciled month first, then forward. Our QuickBooks cleanup and catch-up service is built for that situation.
Reports a rental investor should be reading
Bookkeeping only pays off if someone reads the output. At minimum, review each month:
-
Income statement by property, to compare rent against operating costs.
-
Balance sheet by entity, to confirm debt, deposits and cash look right.
-
Cash flow summary, so a large repair or tax bill does not surprise you.
-
Rent roll and vacancy, kept alongside the books.
-
Consolidated portfolio view, once you have more than one entity.
Owners with larger portfolios or family offices often add budget-versus-actual comparisons, debt schedules and cash forecasts. That is where controller-level oversight and part-time CFO work come in: someone who turns the ledger into decisions about refinancing, reserves and when to buy the next property.
What your CPA needs from your books
Rental income and expenses are normally reported on Schedule E of Form 1040, with income, expenses and depreciation listed for each property. If you have more than three properties, you attach as many Schedules E as needed. If you own a part interest in a rental property, you report only your share, and you must keep records supporting every item in case the return is examined.
So property-level books are not a nice extra. They are the shape the return takes. Rental losses can also be limited by the passive activity loss and at-risk rules. Whether any limit applies to you depends on your whole situation, so ask your CPA before you make decisions based on a rental loss.
Our guide to CPA-ready bookkeeping records shows what to hand over and when.
Records: how long to keep them
Asset records must be kept until the period of limitations expires for the year you dispose of the property. For a building you hold for twenty years, that means the purchase closing statement, improvement invoices and depreciation history all need to survive long after the year they were created. Store them digitally, named by entity and property, and confirm retention periods for your situation with your CPA.
Common mistakes we see in rental books
-
One bank account for several properties or entities, with transfers left unexplained.
-
Mortgage payments coded entirely to expense, which overstates costs and hides the debt balance.
-
Security deposits recorded as income on day one.
-
Improvements expensed as repairs, or repairs capitalized.
-
Owner draws and contributions mixed with operating costs.
-
Books that are updated once a year for the tax preparer.
Every one of these is fixable, and every one is cheaper to prevent with a monthly routine than to unwind after a year or more.
Our perspective
Most rental investors do not have a bookkeeping problem. They have a visibility problem. The transactions are there, but nobody has turned them into a clear monthly picture of each property and each entity.
We built The Aligned Method around that gap: reliable bookkeeping first, then the insight that comes from clean, timely statements. For an investor with several LLCs, that means books that reconcile every month, consolidated reporting that eliminates the transfers between entities, and statements your CPA and lender can both rely on.
We work alongside your existing CPA and advisors rather than replacing them. You get controller-level quality without the cost of a full-time hire, and when you need forecasting, cash planning or scenario work for the next acquisition, the same team can step in as your fractional CFO.
Aligned Ledger Team
How we help rental investors
If you would rather not run the monthly close yourself, our monthly bookkeeping services cover reconciliations, month-end close and financial statements, and our multi-entity bookkeeping and consolidated reporting keeps each LLC clean while giving you one portfolio view. Families with several entities can also look at our family office bookkeeping and reporting.

Engagements are fixed-fee and monthly. See the plans to find the fit for your portfolio.
FAQ
How do I keep track of rental property expenses?
Record each expense in the books of the entity that paid it and tag it to the property it served. Attach the receipt, bill or canceled check, since these generally substantiate deductions. Review uncategorized items monthly so nothing sits unassigned.
How do I set up rental properties in QuickBooks Online?
Create one set of books per entity. Inside each, turn on class or location tracking in the settings and create one class or location per property. Then tag every income and expense transaction, and run reports by class or location to see each property’s results.
Do I need separate bookkeeping for each LLC?
Yes. Keep a complete and separate set of records for each business you are in. Keep separate bank accounts as well, record transfers between entities as loans, contributions or distributions, and combine the results only in a consolidated report. Ask your attorney and CPA how your structure should work.
Is a security deposit rental income?
Not when you receive it, if you will return it. It becomes income in the year you keep any part of it, and a deposit meant as final month’s rent is income when received. Hold refundable deposits as a liability until the lease ends.
- Ready to get your rental books clean and current? Book a conversation through the contact form on the Aligned Ledger website.
Recommended
Keep reading
- Bookkeeping for Real Estate Investors with Multiple LLCs
- Bookkeeping for Multiple Businesses: How to Keep Every Entity Clean
- Dental Practice Bookkeeping: What to Do Daily, Monthly and at Close
- Bench vs The Aligned Ledger: Bookkeeping Comparison for DFW Businesses
- Multi-entity bookkeeping and consolidated reporting