Bookkeeping for real estate investors works differently from standard business bookkeeping, and the difference matters more than most investors realise. A generic setup tells you how the portfolio is doing overall but gives you no visibility into which properties are actually making money and which are quietly draining it.
This guide shows you exactly how to set up QuickBooks Online for your rental portfolio, what to track at the property level, how to manage rental contracts without a separate spreadsheet, and the one categorisation mistake that costs investors money every tax season.
Key Takeaways
- Real estate investors need per-property income and expense tracking. A single business-level P&L is not enough.
- QuickBooks Online Plus is the only plan that includes class tracking, which is how you separate financials by property.
- The most expensive bookkeeping mistake investors make is recording capital improvements as repairs. The two are treated completely differently at tax time.
- Each property should have its own fixed asset account in QuickBooks, with capital improvements recorded as sub-accounts under that property.
- You can manage rental contracts, recurring invoices, and lease expiry tracking entirely inside QuickBooks without a separate spreadsheet.
- If monthly reconciliation is not happening consistently, you are likely missing deductions. Outsourcing to a QuickBooks specialist firm fixes this without adding headcount.
Why Per-Property Tracking Matters More Than a Business P&L
If you own three rental properties and run a standard profit and loss report, you will see one number: total rental income minus total expenses. That number tells you whether the portfolio is profitable. It does not tell you that Property 1 is generating a 9% cash-on-cash return, Property 2 is breaking even, and Property 3 has been losing money for six months because of a maintenance cost spike you never noticed.
Per-property tracking changes what you can see and therefore what decisions you can make. When your books are set up correctly, you can pull a profit and loss report for each individual property in under two minutes. You can see which properties justify a rent increase, which ones have expense ratios creeping up, and which ones you should consider selling before the numbers get worse.
The tool that makes this possible inside QuickBooks Online is class tracking. Every income and expense transaction gets tagged to a property. Your reporting then becomes genuinely useful, not just a compliance exercise.
How to Set Up QuickBooks for Real Estate Investor Portfolio
Choose the Right QuickBooks Online Plan First
QuickBooks Online Plus is the minimum plan for US real estate investors managing rental properties. It is the only plan that includes class tracking, the feature that separates your financials by property.
Simple Start and Essentials do not have class tracking. This is the most common setup mistake investors make. They start on a lower plan, enter months of transactions, and then have to rebuild the entire setup when they realise they cannot run per-property reports. Start on Plus from day one.
If you are working with an outsourced bookkeeping firm, they will typically access your file through a QuickBooks Online Accountant subscription, which can reduce your direct cost.
Turn On Class Tracking and Assign One Class Per Property
Once you are on QuickBooks Online Plus, here is how to turn on class tracking:
- Click the Gear icon (top right) and go to Account and Settings
- Select the Advanced tab
- Under Categories, turn on Track classes
- Set “Warn me when a transaction isn’t assigned a class” to On. This prevents untagged transactions from slipping through.
- Click Save
Now create one class for each property. Go to Settings, then All Lists, then Classes, then New and add each property by address or a short label you will recognise. “123 Main St,” “Maple Ave Unit 2,” or simply “Property 1” all work fine.
Every time you record income or an expense, tag it to the relevant property class. When you run a Profit and Loss by Class report, QuickBooks generates a side-by-side P&L for each property automatically.
Set up a Real Estate Chart of Accounts
The default QuickBooks chart of accounts is built for a service business. It has no rental income category, no repairs and maintenance split, and no asset accounts for property or capital improvements. You need to replace it with a real estate-specific structure before you enter a single transaction.
Here are the core accounts to set up:
| Account Type | Account Name | Maps to Schedule E |
|---|---|---|
| Income | Rental Income | Rents received |
| Income | Late Fees Received | Rents received |
| Income | Other Property Income | Rents received |
| Expense | Advertising | Advertising |
| Expense | Insurance | Insurance |
| Expense | Professional Fees | Legal and professional fees |
| Expense | Property Management Fees | Management fees |
| Expense | Mortgage Interest | Mortgage interest paid |
| Expense | Repairs and Maintenance | Repairs |
| Expense | Property Taxes | Taxes |
| Expense | Utilities | Utilities |
| Fixed Asset | 123 Main St (parent account) | Balance sheet |
| Fixed Asset | 123 Main St: Purchase Cost (sub-account) | Balance sheet |
| Fixed Asset | 123 Main St: Capital Improvements (sub-account) | Balance sheet |
| Fixed Asset | 123 Main St: Accumulated Depreciation (sub-account) | Depreciation expense |
Practical Tip : Bookkeeping for Real Estate Investors
Create a separate parent fixed asset account for each property you own, not one generic account for everything. Under each property’s parent account, create three sub-accounts: Purchase Cost, Capital Improvements, and Accumulated Depreciation.
This means that when you make an improvement to a specific property, it gets booked directly under that property’s Capital Improvements sub-account. When you refinance, sell, or calculate depreciation, every number ties back cleanly to the right property without any manual sorting. If you own five properties, you will have five parent fixed asset accounts. It looks like more accounts than you need at the start. In practice it saves hours of work every time your CPA needs a depreciation schedule or a lender asks for a property-level balance sheet.
The Categorisation Mistake That Costs Investors the Most Money
The single most common and most expensive bookkeeping error real estate investors make is recording capital improvements as repairs.
A repair fixes something that is broken and brings it back to its previous condition. Fixing a leaking pipe, replacing a broken window, repainting a room after a tenant moves out. These are repairs. In QuickBooks, they go to your Repairs and Maintenance expense account and reduce your taxable income in the year you pay them.
A capital improvement upgrades, extends the life of, or adds value to the property. A new roof, a full HVAC replacement, a kitchen renovation, adding a bathroom. These do not go to an expense account. They go to the Capital Improvements sub-account under the relevant property’s fixed asset account and are depreciated over time.
The practical consequence of getting this wrong: you overstate your deductions this year, understate your property’s cost basis, and create problems at an IRS audit or when you sell the property and your capital gains calculation is off.
A useful rule of thumb: if the work makes the property better than it was, it is likely an improvement. If it simply restores it to working condition, it is likely a repair. When you are genuinely unsure, that is the conversation to have with your CPA before the invoice is paid, not after.
One brief US tax note: the IRS de minimis safe harbour allows items under $2,500 per invoice to be expensed immediately rather than capitalised. Ask your CPA whether this applies to your situation.
How to Track Rental Contracts and Recurring Invoices in QuickBooks
Most investors manage lease expiry dates and rent escalations in a separate spreadsheet. QuickBooks Online handles all of this natively once it is set up correctly.
Here is the workflow:
Step 1: Create a service item for each property’s rent.
Go to Products and Services and create a new service item for each rental unit. Name it clearly, for example “Rent: 123 Main St.” Set the income account to your Rental Income account. This item becomes the billing line on every invoice for that property.
Step 2: Create a sales order for each tenant and attach the lease.
In QuickBooks, raise a sales order for each rental customer. Set the expiry date on the sales order to match the lease end date. Attach the signed lease agreement directly to the sales order as a document. This gives you one place where the contract, the tenant, the rent amount, and the lease end date all sit together. No spreadsheet needed.
Step 3: Set up recurring invoicing linked to the contract.
Go to the invoice for that tenant and select Make Recurring. Set the frequency to monthly, the start date to the lease commencement date, and the end date to match the lease expiry. If the lease includes a scheduled rent increase, update the recurring invoice amount at the point the increase takes effect. QuickBooks will generate and send invoices automatically each month based on this schedule.
Step 4: Track contract expiry from your sales order list.
Run a sales order report filtered by expiry date each month. Any lease ending in the next 60 to 90 days shows up immediately. You know which tenants need a renewal conversation, which units may be coming vacant, and which recurring invoices need to be updated before the next cycle runs.
This setup replaces the lease tracking spreadsheet entirely. Every contract is in QuickBooks, every invoice runs automatically, and your rent roll is always current.
What Bookkeeping for Real Estate Investors Should Actually Look Like
Most investors do not do their books monthly. They leave transactions uncategorised for months, then spend a frantic week in January trying to reconstruct what happened across every property for the entire year.
The cost of that approach is not just stress. It is missed deductions because the receipt is gone or the transaction cannot be identified. It is wrong categorisation because nobody remembers the details six months later. And it is a larger CPA bill because the accountant is cleaning up rather than just filing.
Here is what monthly real estate bookkeeping should actually involve:
- Bank reconciliation. Every account, every property, every month. If your bank balance and QuickBooks balance do not match, something is wrong and you need to find it now, not in December.
- Transaction categorisation. Every income and expense tagged to the correct account and the correct property class before the month closes.
- Capital improvement review. Any large expense from the month reviewed and correctly classified before it sits in the wrong account for a year.
- Three reports pulled and reviewed. Profit and Loss by Class for per-property performance, Balance Sheet for overall financial position, and your sales order expiry list for upcoming lease renewals.
When this happens every month, your books are always current, your per-property numbers are always visible, and your year-end tax preparation is a data export rather than a reconstruction project.
Need Clean Books Without Doing Them Yourself
If the monthly process above is not happening in your business, outsourcing to a QuickBooks specialist is usually the most cost-effective fix.
At Karnani and Co., we manage real estate investor books remotely using QuickBooks Online for clients across the US. Our work includes the full setup described in this article: real estate chart of accounts, per-property class tracking, fixed asset structure by property, recurring invoice configuration, and monthly reconciliation. Your CPA gets a clean, Schedule E-ready file at year end.
At Karnani and Co., we manage real estate investor books remotely using QuickBooks Online for clients across the US. You can review our engagement history and client feedback directly on Upwork.
Amit Mundhra CA holds a Top Rated Plus status with a 100% Job Success Score on his Personal Upwork Profile,
Karnani & Co also carries the same 100% score with a Rising Talent badge. You can view our Agency Upwork Profile here.
If your books are behind, your chart of accounts needs rebuilding, or you simply want clean monthly financials without doing them yourself, our Remote real estate bookkeeping services is where to start.
Frequently Asked Questions in Bookkeeping for Real Estate Investors
Q1. What is the best QuickBooks plan for real estate investors?
QuickBooks Online Plus is the right plan for most US real estate investors. It is the only plan in the QuickBooks Online range that includes class tracking, which allows you to separate income and expenses by individual property. Simple Start and Essentials do not include this feature. If you manage a large portfolio and need more advanced reporting, QuickBooks Online Advanced is worth considering, but Plus is the right starting point for most investors.
Q2. How do I track multiple rental properties separately in QuickBooks?
Use class tracking in QuickBooks Online Plus. Once you turn it on in Account and Settings under the Advanced tab, you create one class per property. Every transaction gets assigned to a property class when you record it. You can then run a Profit and Loss by Class report to see a side-by-side P&L for each property in your portfolio.
Q3. What is the difference between a repair and a capital improvement for tax purposes?
A repair restores a property to its previous working condition and is deductible in the year it is paid. A capital improvement upgrades, extends the life of, or adds value to the property. It must be capitalised on the balance sheet and depreciated over time rather than expensed immediately. In QuickBooks, repairs go to the Repairs and Maintenance expense account. Capital improvements go to the Capital Improvements sub-account under the relevant property’s fixed asset account. Getting this wrong affects both your current year deductions and your cost basis when you sell.
Q4. How do I track lease expiry dates in QuickBooks without a spreadsheet?
Create a sales order for each tenant with the lease end date set as the expiry date on the sales order. Attach the signed lease to the sales order directly. Run a sales order report filtered by expiry date each month to see which leases are coming up for renewal in the next 60 to 90 days. Pair this with recurring invoicing set to the lease term and you have a complete contract management system inside QuickBooks with no external spreadsheet required.
Q5. Which expense categories should a US real estate investor set up in QuickBooks?
The core expense categories are Advertising, Insurance, Professional Fees, Property Management Fees, Mortgage Interest, Repairs and Maintenance, Property Taxes, and Utilities. On the asset side, create a separate parent fixed asset account for each property with sub-accounts for Purchase Cost, Capital Improvements, and Accumulated Depreciation. These categories align to IRS Schedule E, which is how rental income and expenses are reported on a US federal tax return.
Q6. Should real estate investors use cash basis or accrual accounting in QuickBooks?
Most US real estate investors use cash basis accounting. Income is recorded when rent is received and expenses when they are paid. This is simpler to maintain and matches how most investors think about their cash flow. For most individual investors and smaller portfolios, cash basis is the practical choice. Discuss this with your CPA before setting up QuickBooks, as switching methods later is disruptive.
Q7. Can I outsource my US real estate bookkeeping to a firm outside the United States?
Yes. Many US real estate investors work with remote bookkeeping firms internationally. What matters is that the firm uses QuickBooks Online, understands US rental property accounting including Schedule E reporting and the repairs versus capital improvements distinction, and delivers monthly reconciled financials. Karnani and Co. manages real estate investor books remotely for US clients using QuickBooks Online.
