How to Track Profit and Loss by Property in QuickBooks Online

Set up class tracking in QuickBooks Online to see a separate profit and loss report for each rental property. Here is exactly how to do it.

If you own more than one rental property, you already know the problem. Everything flows into the same bank account. Rent comes in, a repair bill goes out, insurance renews, property management fees land. At the end of the month you have one big pile of numbers and no way to tell which property is actually making money and which one is eating it.

The fix is called class tracking, and it takes about twenty minutes to set up in QuickBooks Online.

What class tracking does

A “class” in QuickBooks is a label you attach to transactions. You can attach it to income, expenses, or both. When you run a Profit and Loss (P&L) report, QuickBooks can sort every line by class. The result is a separate P&L column for each property, side by side.

This is the main tool real estate investors use to answer a simple question: is this specific property worth keeping?

Without it, you are managing your portfolio blind.

How to turn on class tracking

In QuickBooks Online, go to the gear icon and choose Account and Settings. Click Advanced. Under Categories, turn on Track Classes. For most investors, choose “One to each row in transaction.” Save.

You will now see a Class column on every transaction form in QuickBooks.

How to set up your classes

Each property gets its own class. Keep the naming short and consistent.

Examples:

123 Main Street
Oak Park Duplex
FL Vacation Unit
NYC Unit 4B

If you hold properties in separate limited liability companies (LLCs), you have a choice. You can track each LLC as a class inside one QuickBooks file, or use a separate QuickBooks file per LLC. Most investors with fewer than five properties use one file with classes. Beyond five or six properties, separate files often make more sense for clean reporting.

If you want both LLC-level and property-level visibility, QuickBooks supports sub-classes. The parent class is the LLC. The sub-classes are the individual properties inside it.

Tagging transactions

Once classes are set up, the rule is simple: every transaction gets tagged to a property.

Rent comes in from a tenant at Oak Park Duplex. Tag it to Oak Park Duplex. The plumber invoices you for work at 123 Main Street. Tag it to 123 Main Street. Property management fees, landscaping, HOA dues, landlord insurance premiums: all tagged.

The only transactions that do not get tagged to a specific property are true shared costs. Your bookkeeping software subscription, your accountant’s fee, a shared umbrella policy: tag those to a General class or leave them unclassified.

Build this habit from day one. If you skip tagging even a handful of transactions, the per-property P&L becomes unreliable and you will spend time hunting down what belongs where.

Running the per-property report

Go to Reports in QuickBooks and open Profit and Loss. Click Customize. Under Rows and Columns, change the Columns dropdown to Classes.

QuickBooks will display a column for each property and a Total column on the right. You can see at a glance:

Which properties are cash-flow positive
Which properties have high repair costs relative to rent
Whether the overall portfolio is profitable after shared expenses

Run this report monthly. Once your transactions are tagged, it takes about ten seconds to pull.

Common mistakes that break the numbers

Booking the full mortgage payment as an expense. Your mortgage payment has two parts: interest and principal. The interest is an operating expense. The principal is a reduction of your loan balance and belongs on the balance sheet, not the P&L. If both get recorded as expenses, your numbers will overstate costs.

Mixing repairs with capital improvements. Capital expenditures (CapEx) are improvements that extend the useful life of the property: a new roof, a full HVAC replacement, an addition. These are not operating expenses. They go on the balance sheet as an asset and depreciate over time. Repairs (fixing a leaky faucet, patching drywall) are expenses. Keeping these categories clean is important for accurate books.

Only running the report at year-end. By December, a problem that started in August has been sitting in your books for months. A monthly per-property P&L catches a high-repair property or a billing error in the same month it happens.

One class for the whole portfolio. A single “Rentals” class gives you no useful information. Set up one class per property, even if you only have two.

The bottom line

One combined P&L for your whole rental portfolio tells you almost nothing. A per-property P&L tells you which properties are performing and which are not. Set up class tracking once, build the tagging habit, and pull the report every month.

The setup takes less time than a single phone call with a contractor. The information it gives you is worth far more.