Rentals

A rental property chart of accounts that actually works

Most rental property charts of accounts come in two sizes. One has a dozen vague accounts and tells you nothing at tax time. The other has two hundred accounts nobody keeps up. I’ve kept books for thirty years, a good share of it for landlords and real estate investors, and this is the middle ground I set up in client files. It’s about sixteen accounts, and the expense categories line up with Schedule E.

The full chart

These are the accounts I create in QuickBooks Online for a straightforward rental operation. There’s no account per property. Properties get handled with classes, which I’ll get to below, so the chart stays this size whether you own one door or forty.

AccountTypeWhat goes in it
Rent IncomeIncomeMonthly rent, prorated rent, month-to-month premiums
Late FeesIncomeLate charges and NSF fees collected from tenants
Application FeesIncomeScreening and application fees from prospective tenants
Other Property IncomeIncomeLaundry, storage, pet rent, parking, anything small and miscellaneous
Repairs & MaintenanceExpenseFixes that keep the property in its current condition: leaky faucet, patched drywall, a new door lock
Capital ImprovementsFixed assetWork that adds value or extends the property’s life: new roof, HVAC replacement, an addition. This lives on the balance sheet, and your CPA depreciates it
UtilitiesExpenseWater, sewer, trash, electric, gas you pay as the owner
InsuranceExpenseLandlord policies and umbrella coverage on the properties
Property TaxesExpenseReal estate taxes on the rentals
Management FeesExpenseWhat you pay a property manager, including leasing fees
Landscaping & Snow RemovalExpenseMowing, trimming, plowing, seasonal grounds work
AdvertisingExpenseListing fees, signage, photos, anything spent to fill a vacancy
MileageExpenseVehicle costs for property trips, logged with dates and miles so your CPA can apply the right method
Professional FeesExpenseBookkeeping, legal, CPA, eviction filings
Security Deposits HeldOther current liabilityTenant deposits you’re holding. Money you might have to give back is a debt, so it sits here until you return it or lawfully keep it
Owner Contributions / Owner DrawsEquityMoney you put into the business and money you take out. Keeping these out of income and expense is what keeps the P&L right

Security deposits are not income

This is the mistake I correct most often in rental cleanups. A deposit check arrives, it gets categorized as rent, and the books overstate income all year while hiding a debt. A security deposit is money you’re holding that probably goes back to the tenant, so it belongs in the Security Deposits Held liability account the day it arrives.

When the tenant moves out, one of two things happens in the books. You return the deposit and the liability clears to zero. Or you lawfully keep part of it, and that part moves out of the liability, either to income or against the repair cost it covered. Every state sets its own deadline for returning deposits after move-out, along with rules about itemizing what you kept, and your attorney can confirm the specifics for your state and your situation. From the bookkeeping side, a clean liability account tells you at any moment whose money you’re holding and how much.

One property or twenty: classes and locations

The chart stays small because QuickBooks Online has classes, which beat cloning accounts for every address. In QBO Plus and above, I set up one class per property, then tag every transaction with its property as it comes in, income and expense alike. From there, one report, Profit and Loss by Class, puts each property in its own column, side by side, with a total column at the end.

That report tells you which property actually makes money, which one eats every dollar it brings in, and how the whole thing did. Some bookkeepers use locations instead of classes, which works fine too; the principle is the same. Pick one, tag everything, and don’t let a transaction into the file without a property on it. Anything you leave untagged, somebody has to go back and sort out later.

Want this set up in your file?

It’s part of every rental cleanup I do: the chart, the classes, the deposit liabilities, all built into your QuickBooks Online file with your history recategorized to match. You get the price in writing after a free review.

Have me call you

Repairs or improvements?

The line between Repairs & Maintenance and Capital Improvements matters more than any other call in rental bookkeeping, because it decides whether a cost comes off this year’s taxable income or gets spread over years of depreciation. My working rule when I keep the books: fixing what broke and putting the property back the way it was is a repair. Replacing a major system, upgrading, or adding years to the property’s life goes on the balance sheet as an improvement. Anything in between, a new furnace, a partial re-roof, I flag for the CPA, because depreciation method and the tax rules around it are squarely their call. My job is making sure they can see every one of those costs instead of finding them buried in a catch-all account.

If you manage properties for other owners

All of that assumes you own the rentals. Managing property for somebody else, collecting their rent and holding their funds, is a different job. Owner money stays separate from your money, in the books and usually in the bank, and every owner gets a statement that reconciles to the penny. That’s more than one paragraph, so I wrote up how I handle it on my property management bookkeeping page. If that’s your world, start there.

Questions

Questions I hear a lot

Can I import this chart into QuickBooks Online?
Yes. Put the account names and types in a simple spreadsheet, then use Settings, Chart of Accounts, and the import option to bring them in at once. You can also add them one at a time in about fifteen minutes. Either way, do it before you start categorizing transactions, not after.
Do I need a separate bank account for every property?
You need at least one dedicated business account, separate from personal, full stop. Per-property bank accounts are optional; classes in QuickBooks Online usually do that job with less upkeep. The exception is money you hold for other people, like tenant deposits or owner funds, which belongs in its own account, always.
Does this chart map to Schedule E?
Yes. That’s the point of it. The expense categories line up with the lines your CPA fills in on Schedule E, so tax time is a handoff instead of a translation job. Your CPA still makes the calls on depreciation and anything borderline.
Reviews

From a Google review

5 out of 5 stars

Highly professional and reliable bookkeeping services. Very detail-oriented and always ensures everything is accurate and well organized. I highly recommend services to anyone looking for trustworthy accounting support.

Nilesh Vyas · Google review
5 out of 5 stars

Outstanding service. Diane provides clear communication, precise bookkeeping, and dependable support. I would highly recommend her services and expertise.

Sherry Sullivan-Arand · Google review

Is this your file we're talking about?

Leave your number and tell me what's going on with the file. I'll call you back.

I call this number back myself. No email chain.

Years behind is the work I want most. Give me the honest number.

I'll call you back within 15 to 20 minutes during the day. Or call me now at (417) 323-2629.

Check my ProAdvisor listing on Intuit’s site QuickBooks Online Certified ProAdvisor, Gold Tier. 30+ years of full-charge bookkeeping. Read my Google reviews.

I’m a bookkeeper, not a tax preparer or attorney. For tax and legal questions, confirm the details with your CPA. I keep the books that make their job easier.

Want me to look at your file?

Thirty minutes on Zoom or the phone. I look at your file and tell you what shape it's in, then send a written proposal with a fixed price. You get the price in writing before I touch anything.

I call this number back myself. No email chain.

I'll call you back within 15 to 20 minutes during the day. Or call me now at (417) 323-2629.

Check my ProAdvisor listing on Intuit’s site QuickBooks Online Certified ProAdvisor, Gold Tier. 30+ years of full-charge bookkeeping. Read my Google reviews.

Want a second set of eyes on your books?

The first look at your file is free and there's no obligation. If I'm not the right fit for your business, I'll tell you that too.

I'll call you back within 15 to 20 minutes during the day.