I have a client who owns 6 rental properties. I plan to set up a Chart of Accounts (COA) in QuickBooks and want to manage each property as an independent "Class." At the same time, I don't want to design the entire system from scratch. Does anyone have a ready-made example I can refer to? Thanks in advance.

The core of this requirement is to achieve independent accounting for multiple properties through the "Class" feature in QuickBooks while keeping the Chart of Accounts unified and concise. Below is a general setup approach for this scenario for reference:

I. Understanding the "Class" Feature in QuickBooks

The "Class" field in QuickBooks allows users to categorize transactions without creating multiple separate company files. For rental property businesses, each property address or name can be set as an independent class, enabling filtering or summarizing by property in reports such as profit and loss statements and balance sheets.

1. Enable the Class Feature

In QuickBooks, you need to ensure the "Class" feature is enabled (usually found under "Edit" > "Preferences" > "Accounting" or "Advanced" settings). Once enabled, you will see a "Class" dropdown in transaction entry screens.

2. Create Property Classes

Go to "Lists" > "Class List" and create a new class for each property, such as "Property A - Address," "Property B - Address," etc. It is recommended to use a consistent naming convention for easier filtering in reports later.

II. General Structure of the Chart of Accounts (COA)

For a simple rental property business, the COA typically includes the following main account groups. You can adjust based on actual business needs, but there is no need to duplicate accounts for each property—independent accounting can be achieved through "Classes."

  • Asset Accounts:Cash, bank deposits, accounts receivable, property investments (with sub-accounts or classes per property), accumulated depreciation, etc.
  • Liability Accounts:Accounts payable, security deposits payable, mortgage loans (long-term/short-term), unearned rent, etc.
  • Income Accounts:Rental income, late fee income, other property income (such as laundry fees, parking fees).
  • Expense Accounts:Repairs and maintenance, property taxes, insurance, utilities, property management fees, advertising, loan interest, depreciation expense, etc.

When recording each transaction, select the corresponding property class to view the profit or loss for each property in reports by class.

III. Ways to Obtain Ready-Made Examples

Regarding your need to "not reinvent the wheel," the following channels may provide ready-made COA templates or examples:

  1. QuickBooks Official Community Forum: Search for keywords like "rental property chart of accounts" or "multi-property class," where users often share templates.
  2. Professional accounting websites (such as Fit Small Business, The Balance) offer free rental property COA templates that can be downloaded and imported into QuickBooks.
  3. QuickBooks built-in industry templates: When creating a new company file, select the "Real Estate" or "Rental Property" industry, and the system will generate a basic COA, which can then be extended with the class feature.

Please note that any template needs to be customized based on the client's specific business (such as whether it involves mortgages or how deposits are handled) and should not be blindly applied.

IV. Implementation Recommendations

During the setup process, it is recommended to confirm the following with the client:

  • Does each property need independent profit tracking, or is a consolidated report sufficient?
  • Are there shared expenses (such as advertising) that need to be allocated proportionally? If so, consider using a combination of "Classes" and "Departments," or set up allocation rules.
  • Are there special transactions such as deposits or unearned rent? Reserve corresponding accounts in the COA.

Finally, before going live, test report accuracy with historical data to ensure class filtering works correctly.

I hope the above information is helpful. If you have a ready-made example, feel free to share it below for other users' reference.