How do I track income and expenses across multiple rental properties?
The most important principle is that every dollar of income and every dollar of expense gets assigned to a specific property. Without that discipline, you end up with a pile of numbers at year end and no idea which properties are making money and which ones are dragging down your portfolio.
In QuickBooks Online, the cleanest approach is using the “Projects” or “Location” tracking feature to tag each transaction to a property. Some investors prefer classes. Either works as long as you pick one method and apply it consistently. You can then run a profit and loss report filtered by property and see exactly where you stand on each one. If you have a small number of properties, separate bank accounts per property can simplify things further, but this gets unwieldy as you scale beyond four or five doors.
For each property, you should be tracking rent collected, late fees, security deposit activity, and any other income like pet rent or laundry. On the expense side, the typical categories include mortgage interest, property taxes, insurance, HOA fees, repairs and maintenance, property management fees, utilities you pay, landscaping, and advertising for vacancies. Capital improvements like a new roof or HVAC system need to be separated from routine repairs because they get depreciated over time rather than deducted in full the year you pay for them.
The IRS requires rental property owners to report each property individually on Schedule E. If your books already track income and expenses per property, preparing your tax return is a straightforward exercise. If everything is lumped together, you or your accountant will spend hours sorting through bank statements trying to figure out which charges belong to which property. That costs you time and money every single year.
Beyond taxes, per-property tracking helps you make better decisions. You can see which properties have the highest maintenance costs relative to rent, which ones have the best cash-on-cash return, and which ones might not be worth holding long term. These insights only come from clean, property-level financial data.
A common mistake is letting bookkeeping slide for a few months because “it’s just rental income.” The problem is that by month three you’re guessing which Home Depot charge was for the duplex and which was for the single-family, and your records start losing accuracy. Monthly reconciliation takes 30 minutes per property when you stay current. It takes hours when you fall behind.
If you’re growing your portfolio and finding it harder to keep up, working with a firm that handles business tax preparation for real estate investors can save you from the headaches of reconstructing records later. Getting the tracking structure right from the beginning is far easier than trying to fix it after several years of loose recordkeeping.
Tampa Bay's Small Business CPA Firm
First Step:
A Short Conversation
Tell us about your business and where you need support. We'll walk through your situation, answer your questions, and give you a clear quote.
More Questions
How do I calculate sales tax when I sell in multiple states?
First determine where you have sales tax nexus based on physical presence or economic activity thresholds. Then register in those states, apply the correct local rates for each transaction, and file returns on each state's schedule.
Read answerHow does outsourced bookkeeping work?
You give your bookkeeper secure access to your bank accounts and accounting software. They handle transaction coding, reconciliations, and reporting on a recurring schedule so your books stay current without hiring someone in-house.
Read answerWhat is construction job costing?
Construction job costing is a method of tracking every expense against the specific project that caused it. Instead of lumping all costs together, you assign labor, materials, and subcontractor payments to individual jobs so you know exactly which projects made money and which didn't.
Read answerCan I deduct my home office on my business taxes?
Yes, if the space is used exclusively and regularly for business. You can choose between a simplified method worth up to $1,500 or the actual expense method, which usually produces a larger deduction but requires more documentation.
Read answerHow do I get an EIN for my new business?
Apply directly through the IRS website for free. The online application takes about ten minutes, and you'll receive your EIN immediately. Don't pay a third-party service for something the IRS provides at no cost.
Read answerShould my business be an LLC, S-Corp, or C-Corp for tax purposes?
Most small businesses start as LLCs, which is the right move. The real question is whether electing S-Corp status makes sense once your profits reach a certain level. C-Corps rarely make sense for small, owner-operated businesses.
Read answer
