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 restricted vs unrestricted donations?
Use classes or funds in your accounting software to separate donations by restriction type. Track donor intent at the time of the gift, monitor spending against restricted funds, and release restrictions when the purpose is fulfilled.
Read answerWhat payroll taxes do I need to pay in California?
California employers pay four state-specific payroll taxes on top of federal requirements. Unemployment Insurance and Employment Training Tax come from your pocket, while SDI and Personal Income Tax get withheld from employees.
Read answerWhat is nexus and how does it affect sales tax?
Nexus is the connection between your business and a state that triggers an obligation to collect sales tax there. You can establish nexus through physical presence or by exceeding economic thresholds based on sales volume.
Read answerWhat is use tax and do I owe it?
Use tax is the sales tax you owe when a seller doesn't collect it from you. Most businesses owe it on out-of-state and online purchases where no California sales tax was charged. The rate matches your local sales tax rate.
Read answerWhat is three-way trust reconciliation?
Three-way trust reconciliation matches your bank statement balance against your general ledger balance and the sum of all individual client ledger balances. When all three match, you know client funds are properly accounted for.
Read answerWhat qualifications should a bookkeeper have?
Formal certification isn't required for bookkeepers, but software proficiency, attention to detail, and industry experience matter most. The right qualifications depend on your business needs and how well the bookkeeper understands your specific situation.
Read answer