Skip to main content

Handle accrued fees and capitalization

If you calculate and charge management fees from clients based on portfolio market values, return or fixed amount per portfolio, you can use FA’s Fee calculation module. Calculation is done based on the daily values, and the calculation frequency is based on your contracts.

In this scenario the fees are accrued when calculation is done (for example once a month) and money is taken out from a real bank account, capitalized separately (for example once a year).

Get started

Define accounts

Add an accrued fee account:

  • accrued fee accounts with the Accrued fee tag.

Define a bank account for capitalisation:

  • accounts from which you will capitalise money with the Fee capitalization tag.

Define capitalization parameters

  • Open capitalization configurations from Tools → Fee calculations → Fee capitalization...

  • Select the portfolio group for capitalization (It is ok for example to add all active portfolios, when we limit the capitalization to the tagged accounts only).

  • Use the Accrued fee and Fee capitalization account tags for source and target, respectively.

  • Define transaction types and effects like described in the screenshot below.

    • Usually the accrued fee accounts (with account tag Accrued fee) have a negative account balance, so if you use Cashflow in (Internal) transaction type, the balance is reset to 0.

    • The target account is the cash account from which the fee is capitalized. This account should have tag Fee capitalization and transaction type Cashflow out (Internal). If you only wish to reset the accrued fees to zero and not make a corresponding capitalization booking, leave the Transaction type 1 selection empty under Target.

fee_management_capitalization_setup.png

Accrued fee calculation and fee capitalisation

Calculate fees

  1. Go to the Portfolios view.

  2. Search for the portfolios for which you want to calculate fees; to calculate for all portfolios, click Show all (fees are calculated only if a formula is linked to the portfolio).

  3. Choose Fee calculation → Management fee / Performance fee at the bottom of the page.

  4. Define the parameters (if needed; sensible defaults are pre-selected for most parameters):

    1. Calculation date - The date up to which fees are accrued.

    2. Account tag or Use default account or same currency account - Account tag for the fee accrual. If a tag is chosen, the fee is accrued to the account with the given tag. If the checkbox is chosen, the default account is used.

    3. Transaction type - The fee transaction type.

    4. Status - The status for created fee transactions (Accepted, Not finished or Deleted). You can use Accepted transactions to automatically deduct the account balance, or you can use Not finished transactions and approve them later after checking the balance.

    5. Tags to add to calculated portfolios and Tags to remove from calculated portfolios. Use these, if you want to tag or untag the portfolios.

    6. Memo - Notes that are visible under the calculation run in the Fee calculations view.

    7. Run in security level - Advanced setting that you should not select for regular cost formulas.

    8. Set settlement dates - Fill in the settlement date on the generated transactions.

    9. Set taxes using default tax rates - Automatically add applicable taxes, such as value-added tax, based on the configurations done in Preference → Taxation → Default tax rates.

    10. Do not save resulting fee transactions, but store the accrual in portfolio key figures instead - Track the accrual as portfolio key figures instead of an accrual account. This way the fee does not affect the portfolio value, but you can stay up to date with what kind of fees have been accrued.

    11. Create task - Create a task with the calculation details in the Tasks view.

  5. Click Calculate.

Capitalize fees

  1. Open Tools → Fee calculations → Fee capitalization....

  2. Define the fee capitalization date.

    2243952650.png
  3. Select the fee capitalization configuration that you defined in Define capitalization parameters.

  4. Click Run selected configurations.

How to schedule accrued fee calculation

You can schedule accrued fee calculation the same way as other processes. See Scheduling in FA Admin Guide for more details.

Follow these steps if you wish to change some of the default parameter values used in the scheduled calculation:

  1. Go to Tools → Administer → Fee calculations.

  2. You can define different settings for management fee and performance fee by making the following selections under the corresponding heading:

    1. Account tag - see Account tag above in the Calculate fees section.

    2. Save accrued management fee to portfolio key figures - see Do not save resulting fee transactions, but store the accrual in portfolio key figures instead above in the Calculate fees section.

    3. Keep only the latest calculated value - used together with the previous selection. When selected, only the latest key figure value is kept. When unselected, the full history is kept.

    4. Transaction status - see Status above in Calculate fees section.

  3. Click Done.

Example transactions

In this example there is only one management fee after the previous capitalization. Then accrued account cleared with Fee Capitalisation transaction (Deposit type) and bank account has a withdrawal type of transaction (negative Fee Capitalisation).

2244378627.png

How to monitor, if there has been calculations / capitalization

All successful calculations and capitalizations create done tasks in FA.

2540273779.png
2540371969.png