Exclude or Include Asset Accounts for Admin Fee Calculations

Exclude Account and Include Account features control which asset accounts CommunitySuite uses to calculate admin fees.

By default, admin fees are calculated on all asset accounts. Use these features within an Admin Fee Type to control which accounts are included in or excluded from fee calculations when not all asset accounts should be used. 

Who: Finance or accounting teams who manage admin fee calculations.

When to use Exclude Account or Include Account:

• Use Exclude Account to remove specific accounts like loans, pledges, or illiquid investments from fee calculations.
• Use Include Account to calculate fees on only the selected accounts like on a single investment account.

Average Trailing Quarter Calculations
Exclude Account and Include Account features allow for the use of average trailing quarters.

Average Daily Balance Setting
Exclude Account and Include Account features also work with the average daily balance setting when calculating the admin fees for that fund fee type. The feature will simply include or exclude the accounts based on your admin fee type settings. 

Exclude an Account from Admin Fee Calculations

How Exclude Account Works
Select the accounts to exclude and admin fees will then calculate based on the remaining list of asset accounts. 

Example Scenario: Pledge receivables need to be excluded from being calculated as part of admin fees calculations because the pledge receivables are not actual cash assets. Selecting Exclude Account on the pledge receivable account will exclude it from admin fee calculations, but all other asset accounts will be used. 

1. Navigate to the Admin Fee page and click Fund Fee Types in the left-side menu.
2. Click the ID of the fund fee type.
   
    
3. Click Add Exclude Account in the left-side menu.
4. Click the account to be excluded from the balance calculation.
   
    
5. Repeat these steps to remove additional accounts as needed.

The selected accounts will now be listed under Exclude Account Balances and will no longer be included in the list of asset accounts used to calculate admin fees for that particular fund.

 

Include an Account for Admin Fee Calculations

How Include Account Works
The selected asset accounts will be used to calculate admin fees and the rest of the list of accounts will be skipped.

Example Scenario: An admin fee should only be charged on a particular investment account. Use Add Include Account to select the single investment account needed for admin fee calculations. All other accounts will be ignored. 

1. Navigate to the Admin Fee page and click Fund Fee Types in the left-side menu.
2. Click the ID of the fund fee type.
   
    
3. Click Add Include Account in the left-side menu.
4. Click the account to be included in the balance calculation.
   
    
5. Repeat these steps to include additional accounts as needed.

The selected accounts will now be listed under Include Account Balances and will be the only account included during the fee calculation for that particular fund.