QuickBooks for Real Estate Investors: How to Set It Up Right From Day One

Getting started with QuickBooks can feel overwhelming, especially when you’re a real estate investor juggling multiple properties, entities, and strategies. Your books aren’t just a chore, they’re a decision-making tool. When your setup is off, your whole operation suffers.

But setting things up the right way from day one? That’s what sets you up for clean books, tax-ready reports, and smarter, faster decisions as your portfolio grows.

Here’s exactly how I set up QuickBooks Online for our real estate clients at Ambrose Bookkeepers and how you can do the same.

Start with the Right Subscription

This guide uses classes to organize rental income and expenses by property. For that setup, choose QuickBooks Online Plus or Advanced. Both plans support class tracking.

We may earn a commission if you purchase QuickBooks through this link.

Within the setup shown here, classes group income and expense lines by property. Before choosing a subscription, confirm the reporting and company-file structure you need with your bookkeeper or CPA.

Set Up Class Tracking by Property

With your subscription set, turn on class tracking under Account & Settings → Advanced.

For the two-property repair example below, set Assigned classes to One to each row in transaction and select Save so the two repair lines can carry different property classes.

Next, create a class for each individual property. If you’re managing five rental units and one short-term rental, you’ll create six property-specific classes.

We also recommend adding one extra class labeled Admin. This is where you’ll categorize expenses that aren’t tied to a specific property, like business software, education, or general office costs.

When transactions pull in, you can assign them not just to an account (like Repairs) but also to a class (like 123 Maple Street). This gives you clarity on which properties are performing well and which might need attention.

Add Business Tracking by Entity

Many real estate investors operate across multiple legal entities. You might have an LLC for rentals, another for flips, and maybe a holding company or two.

For separate LLCs or corporations, confirm the company-file structure with your bookkeeper and tax adviser before you choose Business and Class reporting. Location tracking organizes activity within a company file. Intuit describes it for locations, offices, regions, outlets or departments of the same company.

In a reviewed setup, the location field may be labeled Business and classes may be used for property reporting. Separate QuickBooks company files each have their own paid subscription, even when you access them with the same sign-in.

Review the property and business reports with your bookkeeper and CPA so you know what each report includes.

Identify both businesses when money moves between them

A transfer between bank accounts of one business is different from money moving between separate LLCs. For a payment between businesses, identify the sending business and account, the receiving business and account, the amount, date, payment reference and reason. Keep the supporting agreement or explanation with both sides of the record. Your bookkeeper and CPA should confirm the treatment for each business; do not assume every movement is rent, an expense or a loan. Check that the recorded payment and receipt refer to the same supported movement. Unclear ownership or purpose belongs on the review list, not in a guessed category.

Upload a Real Estate Specific Chart of Accounts

QuickBooks comes with a default chart of accounts, but it’s not built for real estate investing. You’ll need to customize it.

We upload a real estate-specific chart of accounts for every client, including:

• Rental income (segmented if needed)
• Repairs and maintenance
• Utilities
• Property taxes
  
• Insurance
• Professional services (like legal, bookkeeping, or tax prep)
• Bank fees and loan interest
• Fixed assets: land, buildings and capital improvements, tracked separately. Land is not depreciable. Closing costs need separate review because their treatment varies; confirm the entries with your CPA.

The more tailored your chart of accounts, the easier it is to organize transactions—and generate reports your CPA will actually thank you for.

It’s also key for understanding your return on investment. When you have property-level granularity, you can calculate things like net operating income (NOI), cash-on-cash return, and overall profitability with precision.

Connect Your Bank and Credit Card Feeds

Next, link your business checking accounts and credit cards to QuickBooks.

Connecting your bank feed brings transactions into QuickBooks for review. Bank rules can help fill in details for familiar transactions, but we treat those suggestions as a starting point and check the supporting records before adding them to the books.

Make sure to only connect business accounts—not personal ones. This keeps your books clean and your financial reports focused solely on investment activity.

The fewer manual touches your bookkeeping requires, the more time you’ll have to focus on what really matters, finding the next great deal.

How to track a rental mortgage payment in QuickBooks

One mortgage payment can affect several parts of your books. Use the lender statement for the month you’re reviewing to split the payment into the components that apply.

• Principal reduces the outstanding loan balance.
• Interest is the cost of borrowing. For an operating rental, it is generally tracked as interest expense, separately from principal.
• Escrow deposits increase the funds held for future property tax or insurance payments. They do not become those expenses simply because the money left your bank.
• Fees need their own review. How they are recorded depends on what the charge is for.

When the lender later pays taxes or insurance from escrow, that is separate activity that reduces the escrow balance. Use the lender’s disbursement records and the related tax or insurance documents to record that payment appropriately. Do not count both the deposit into escrow and the later payment as the same expense.

Your books should show the remaining loan balance, funds still held in escrow and the interest recorded, with support for each. Keep the statement tied to the correct loan and property, and review unfamiliar charges with your bookkeeper or CPA.

Start Categorizing Transactions by Class and Account

An account tells you what happened, such as rent income or a repair. A property class tells you which rental the income or cost belongs to. In a setup that uses classes, assign property income and expense lines to the right property. Review shared costs and bank transfers separately instead of forcing every transaction into a property class.

We check the supporting records when the property is unclear instead of guessing.

Example: one business, two rental properties

Imagine one LLC owns Rental A and Rental B, both already in use, with one QuickBooks company file and a class for each property. These are invented figures for one month on a cash basis. We are showing only rent and repairs, not a complete profit or cash flow report.

Rental A receives $2,000 in rent and Rental B receives $2,400. A paid repair invoice totals $600. The invoice identifies $200 of work at Rental A and $400 at Rental B.

1. Record both rent amounts in Rental Income, assigning each income line to its property class.
2. Split the repair invoice into two lines in Repairs and Maintenance: $200 to Rental A and $400 to Rental B. Use the invoice details rather than an even split.
3. Run Profit and Loss by Class for that month on the same cash basis.

Check that the property columns add to the total, that the repair split matches the invoice, and that no property income or expense was left in Not Specified. Add the rest of the month’s activity before judging either rental’s performance. A combined total alone would hide which property had the larger repair bill.

Reconcile Accounts Monthly

Setting up is one thing, maintaining it is another. Make sure to reconcile your accounts monthly against your bank and credit card statements.

Reconciliation compares the transactions and balance in QuickBooks with your bank or credit card statement. It can help reveal missing or duplicate entries. You still need to check the categories, property assignments and supporting records before relying on the reports.

Monthly reconciliation = cleaner books and fewer headaches during tax season.

Why Proper Setup Matters

When your QuickBooks file is built correctly, it does more than track income and expenses. It becomes a tool for growth:

• You’ll know exactly how each property is performing
• You’ll stay organized for tax time and have strategic conversations with your CPA
• You’ll spot trends and issues early
• You’ll gain the confidence to scale

Most importantly, clean books give you peace of mind. You can invest with clarity, talk to lenders with confidence, and run your business without second-guessing the numbers.

And all of that starts with getting the setup right.

If you want to skip the DIY stress and get a professional setup designed for real estate, we do this every day at Ambrose Bookkeepers because every strong portfolio starts with solid systems.