Management Fee Calculator
The Management Fee Calculator allows property management companies to calculate their management fees and create management fee bills based on commissionable income, liabilities and expenses incurred or generated on the portfolios they manage. This calculation may be performed for any given date range, whether once a month or for consecutive months at a time.
Using the Management Fee Calculator
Click on the Management Tab and then on the Management Fee Calculator button from the sub-navigation bar that appears immediately below the black Management Company page header.
Using the Portfolio filter, select:
|
All Portfolios |
Select All Portfolios to calculate your management fees and create management fee bills for All Portfolios at once. |
|
A Single Portfolio |
Select a Single Portfolio to calculate your management fees and create a management fee bill for the Portfolio selected. |
Using the Date Range filter, select a start and end date. This filter allows you to calculate your management fees and create bills for any select period.
The Management Fee Calculator will then calculate your management fees and create a management fee bill for the selected Portfolio(s) and Date Range. The calculation of your management fees is based on the commission rate set on the Portfolio's commissionable Income, Liability and Expense accounts.
|
Tips and Tricks
|
The Management Fee Calculation Table will toggle depending on your Portfolio filter selection (Single vs. All Portfolios).
Calculating your Management Fees for a Single Portfolio at a Time: When calculating your management fees for a Single Portfolio, a detailed breakdown of the Management Fee Calculation by Commission Account, whether an Income, Liability or Expense account, will display:

|
Field Names |
Description |
|
Income/Liabilities |
The Income (i.e., Rent) and Liability (i.e., Security Deposit) accounts designated as Commission Accounts on the portfolio's management fee rule. These commission accounts will detail the amounts Charged and Collected for the selected Date Range, as well as the Commission % and Calculated Management Fee. |
|
Expenses |
The Expense accounts (i.e., Repairs account) designated as Commission Accounts on the portfolio's management fee rule. These commission accounts will detail the amounts Billed and Paid during the selected Date Range, as well as the Commission % and Calculated Management Fee. |
|
Total |
The sum total of amounts Charged/Billed and Collected/Paid from all Commission Accounts, as well as the total calculated Management Fee for the Portfolio and Date Range selected. Note: Your Management Fee Commission is applied to income/liabilities actually Collected (as opposed to Charged) and expenses actually Paid (as opposed to Billed). |
Calculating your Management Fees for All Portfolios at Once: When calculating your management fees for All Portfolios, the Management Fee Calculation will display by Portfolio. The Commission Account detail will not display on this table, but may be viewed by clicking the View link under the Action column.

|
Field Names |
Description |
|
Options |
|
|
All/None |
Use the All/None links to select all or none of the listed portfolios. |
|
Lock Date |
The Accounting Close Date set on the given portfolio. Note: If an Accounting Close Date has already been set and appears in this column, your Administrator will need to unlock the Accounting Close Date before you may create a management fee bill retroactively dated before that date. |
|
Current Fees |
The sum of all existing management fee bills, both paid and unpaid, with a bill date that falls within the Date Range selected. |
|
Current Fees Paid |
The sum of all bill payments applied to management fee bills during the Date Range selected. |
|
Calculated Management Fee |
The Calculated Management Fee for the given portfolio. |
|
Action |
Click the View link in the Action column for a portfolio to view the details of the Calculated Management Fee for that particular portfolio (See Income/Liabilities and Expense field descriptions in the table above). |
Whether calculating your management fees for a Single Portfolio or All Portfolios, use the Bill To Owner Table to create management fee bills for the selected portfolio owner(s). By default, the Bill To Owner Table will display the sum of your management fees calculated in the table above. However, a separate bill will be created for each portfolio. Complete entries within the following fields:

|
Field Name |
Description |
|
Bill Date |
The date of the management fee bill. This field will default to your selected Date Range end date. |
|
Bill Ref |
Assign a reference number to the bill. The reference number will help you identify the bill when running a search. |
|
Create Bill As |
Create your management bill as Paid or Unpaid:
|
|
Bill Total |
The total management fee charge for the selected portfolio owner(s). The Bill Total will default to your Total Calculated Management Fee from the Management Fee Calculation Table above. Note:If you have selected to calculate your management fees for All Portfolios, the Bill Total will represent the sum totalcharged to all portfolio owners. But don't be fooled. Each owner will be billed individually for their respective fees calculated in the table above. |
|
Comments |
The date range of the management fee calculation will automatically fill into the Comments field for future reference. This field may be appended or modified with additional information. |
Note: Where will my Paid and Unpaid Management Bills go? Whether you select the Paid or Unpaid radio button above, your bill will
appear in the Money Out tab:
Click on the Money Out Tab. Then click the Vendors button from the sub-navigation bar immediately below the application's various tabs.
Click the Bills sub-tab from the table at the bottom of the page.
Select your Management Vendor from the Vendor Navigator on the left sidebar of the page. Your Management Vendor appears as the first Vendor on the list and effectively allows you to create bills.
Then, from the Portfolio/Building filter, select a Portfolio or All Portfolios for which you wish to view your management fee bills.
Then, using the Date filter, refine your view of management fee bills by Bill Date.
The page will then refresh to display all Paid and Unpaid Bills for the selected Portfolio(s) and Date. Unpaid Bills will display in shaded green rows with an "Unpaid" background inscription, whereas Paid Bills will display with no demarcation other than their associated Bill Payments.
To pay the management fee bill from the portfolio's available income, complete entries within the following fields:
Payment Information highlighted in this table:

|
Field Name |
Description |
|
Payment Account |
From the drop down menu, select the account from which to pay the bill. If you need to pay bills for individual portfolios from different bank accounts, these portfolios should be processed separately. |
|
Payment Method |
From the drop down menu, select the method of payment. Options include:
|
|
Check Number |
Enter the check number (if writing the check by hand). |
|
Printed in QuickBooks |
Select this option to have QuickBooks print a check for payment of the bill. |
|
Payment Date |
Use the calendar icon to select the bill payment date. |
Note: What happens if a management fee bill is deleted? The commissionable income, liability or expenses included within that bill will
always be stored in the Management Fee Calculator.
Click the Save button.
|
TIPS & RULES OF THUMB |
|
|
See Also |
FAQs |
|