How do I track income and expenses by property?
The cleanest way to track income and expenses by property is using class tracking in your accounting software. QuickBooks Online calls this feature Classes. You create a class for each property address, then assign every transaction to the property it belongs to. Rent received from 123 Main Street gets tagged to the 123 Main Street class. Repair costs for that property get the same tag.
When you run a Profit & Loss by Class report, you see exactly how each property performed. Revenue, expenses, and net income broken out property by property. This tells you which properties are making money and which ones are dragging down your portfolio.
Set up your classes before you start entering transactions. Name them consistently using the property address or a short identifier that’s easy to recognize. If you have ten properties, you need ten classes. Don’t skip this setup step because going back to retag a year’s worth of transactions is painful.
Every transaction needs a class assignment. Make this a habit. When you pay for a roof repair, assign it to the property that got the roof. When rent hits your account, assign it to the property that generated it. Missing class assignments means incomplete property reports that you can’t trust for decision-making.
Some landlords open separate bank accounts for each property. This makes tracking easier because every transaction in that account belongs to one property by default. It also simplifies security deposits since you’re not commingling funds. The downside is managing multiple accounts gets tedious with more than a few properties.
At minimum, keep one dedicated bank account for all rental activity that’s separate from your personal accounts and any other businesses you run. This keeps rental transactions together and makes reconciliation straightforward even if you’re using classes to separate properties within that single account. A small business bookkeeper can help you decide which structure makes sense for your situation.
Your chart of accounts should include the expense categories you’ll use across all properties. Repairs and maintenance, property taxes, insurance, utilities, mortgage interest, HOA fees, property management fees. Keep these consistent so your property reports are comparable. You want to know why one property costs more to maintain than another, and that requires consistent categorization across your real estate portfolio.
For tax purposes, tracking by property is essential if you own rentals. Schedule E requires income and expenses reported separately for each property. Clean property-level books make tax prep straightforward. Messy books where property costs are lumped together create guesswork and missed deductions.
If you have more than a handful of properties, the tracking discipline required for accurate property reporting takes time you could spend finding deals or managing tenants. Getting the system set up correctly from the start and maintaining it monthly means you always know exactly how each property is performing.
San Diego's Small Business Bookkeeper
The Next Step:
A Short Conversation
A quick call to tell us about your business. We'll listen, answer your questions, and give you a clear price quote.
More Questions
How do I track inventory for a restaurant?
Weekly counts of high-value items combined with monthly full counts give you what you need. The goal is calculating your food cost percentage and catching variance before it kills your margins.
Read answerCan a bookkeeper fix years of neglected books?
Yes. Bookkeepers regularly handle catch-up work for businesses with years of neglected records. As long as bank statements and basic documentation exist, the books can almost always be reconstructed and brought current.
Read answerHow do I reconcile accounts in QuickBooks?
Reconciliation matches your QuickBooks transactions against your bank or credit card statement. In QuickBooks Online, go to Settings, select Reconcile, and check off transactions until the difference reaches zero.
Read answerWhat is workers compensation insurance?
Workers compensation insurance covers employees who get injured or sick because of their job. It pays for medical expenses and a portion of lost wages while they recover.
Read answerHow do I handle security deposits in accounting?
Security deposits are liabilities, not income. Record them to a liability account when received and reverse the entry when you return them. If a tenant forfeits the deposit, only then do you recognize income.
Read answerHow do I account for property management fees?
Property management fees are operating expenses that reduce your rental income. Record the full gross rent as income and the management fee as a separate expense, even when you receive a net deposit.
Read answer
