QuickBooks HelpQuickBooksHelpIntuit

Record transactions for a property management company

by Intuit9 Updated 1 year ago

Learn how to record transactions for rental properties you manage and for your own management company in QuickBooks Desktop.

As a property manager, you provide service to property owners and the tenants of those properties. In such a case, you need to create and manage two company files:

  • Rental property company. You collect rent, pay bills, and manage the property for an owner.
  • Property management company. This is your own company where you receive income for managing properties.

Using these two company files, you can keep the companies’ transactions separate from each other. We’ll show you how.

Do you want to manage the two company files at the same time?

If you use Pro or Premier, you can upgrade your QuickBooks Desktop once you’re ready to manage the rental property and property management files simultaneously.

Note: Not sure what accounts to use, or how to record the transactions? Consult your accountant. If you don't have an accountant, we can help find one near you.

Create a company file for rental property company

In this company file, you keep track of the transactions for each property you manage. This is where you record the rent income and expenses.

If you haven’t already, set up the customers and vendors:

 Properties you manage Customers
 Tenants Customer: jobs of properties
 Owners of the properties Vendors
 Your own property management company Your own property management company

Note: You can set up property owners as vendors since you pay them their property’s net income.

Before you record any transaction, you need to set up accounts and service items you use. Here are some you can set up:

Accounts
Account type Account name
 AssetChecking account
 LiabilitySecurity deposits
IncomeRent income
ExpensesProperty management expense, property owner payment
 Service Items
Item name Linked account
Tenant security depositsLiability: Security deposits
RentIncome: Rent income
Property management feeExpense: Property management expense

Do you manage commercial properties?

You can also set up an income account and service item if you charge tenants for common area maintenance expenses (CAM). This helps you track CAM income separate from the other fees you charge.

Most property owners ask for a security deposit from their tenants at the beginning of a rent period. This is the rental company’s liability since you might return all or some of the amount at the end of the period.

You can use a liability account, such as Security Deposit, to track each tenants’ deposit.

  1. Go to the Banking menu, then select Make deposits.
  2. In the Received From column ▼ dropdown, select the tenant.
  3. In the From account ▼ dropdown, select the security deposit account you set up.
  4. Enter the amount, then select Save & Close.

You can record rent from your tenants in two ways. It depends on when you receive the actual rent payment.

  1. Record the rent income from each tenant:
    • as invoices if you receive payments at a later date.
    • as sales receipts if you receive their payments right away.
  2. Make sure to select the tenant and the item you set up in “Step 1” and “Step 2.”

How do I charge late fees?

Tenants sometimes make late payments. You can use QuickBooks’ finance charge feature to calculate and add the late fees to their invoices.

You also need to keep track of the expenses. These include property expenses and the property management fee.

Property expenses

These are expenses to maintain the property, such as utilities and repairs.

  1. Record the expenses based on when you pay them:
    • As bills if you pay them at a later date.
    • As checks if you pay your vendors right away.
  2. From the Customer: Job ▼ dropdown, select the property or tenant.

Property management fee

The property management fee depends on your agreement with each property owner. If you base it on a property’s gross or net income, you can use a profit and loss report to calculate the fee.

You can record the property management fee as a bill or a check. Make sure to select the property or tenant from the Customer: Job ▼ dropdown.

How do I charge an expense to a tenant?

When a tenant damages the property or asks you to have some work done, you charge the expense on their account instead of the owner. You call these costs “billable expenses.”

When it’s time to charge the tenant, you add these additional expenses to their invoice or sales receipt.

  1. Record the expense as a bill or check.
  2. From the Customer:Job ▼ dropdown, select the tenant.
  3. In the Billable column, select the checkbox.
  4. Once you create an invoice or a sales receipt, add the billable costs.

Once you record all the properties’ income and expenses, you can now check how much is due to each property owner.

Note: You can use a profit and loss report to check or calculate how much to transfer to the property owners’ account.

  1. Write a check for the payment.
  2. Make sure to select the property owner you set up in “Step 1."
  3. From the Account column ▼ dropdown, select the owner payment account you set up in “Step 2.”
  4. Run a profit and loss report to check the net income for each property. If the property owner chooses to leave a part of the net income, you see a net income amount. If not, the net income should be zero.

Create a company file for a property management company

In the property management company file, you track your own business’ transactions. This is where you record your income and expenses for managing properties.

If you haven’t already,

set up property owners as customers

.

Set up accounts and service items so you can easily record transactions. Here are some you can set up:

Accounts
Account type Account name
AssetChecking account, furniture and equipment
LiabilityPayroll liabilities
IncomeProperty management income
ExpensesInsurance expense, utilities expense
 Service Items
Item name Linked account
Property managementIncome: Property management income
UtilitiesExpense: Utilities expense

You can record income from property owners in two ways. It depends on when you receive the actual payment.

  1. Record the management income from property owners:
    • as invoices if you receive payments at a later date.
    • as sales receipts if you receive their payments right away
  2. Make sure to select the tenant and the service item you set up in “Step 1” and “Step 2.”
  3. Enter the amount you receive from property owners. This amount is what you calculate for in “Step 4” from “Company file 1: Rental property company.”
QuickBooks Accountant Desktop 2018QuickBooks Accountant Desktop 2019QuickBooks Accountant Desktop 2020QuickBooks Desktop Enterprise Accountant 18QuickBooks Desktop Enterprise Accountant 19QuickBooks Desktop Enterprise Accountant 20QuickBooks Desktop Premier 2018QuickBooks Desktop Premier 2019QuickBooks Desktop Premier 2020QuickBooks Desktop Pro 2018QuickBooks Desktop Pro 2019QuickBooks Desktop Pro 2020

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this