To view/edit the Fund Fee Formula(s), navigate to the Tools area, then choose Fund Fee Formulas. 

 

 

Click on the Name of the formula to open and view the details. 

 

 

Name – The assigned name of the selected formula 

Fund Fee Formula – The equation used to calculate Fund Fees 

Revenue Account – The revenue account to be used for the fund that will receive the fee income 

Expense Account – The expense account to be used for the funds that will be charged the fee 

Revenue Fund -- This is an optional field in which you may select a fund to receive the revenue from the fund fees rather than the operating fund. If this is blank, the operating fund, as determined in Accounting Settings, will receive the revenue. 

Fund FetchXML – Additional parameters that can be used in the formula, e.g., custom fields

Active – The status of the formula (Yes = Active/No = Inactive). Note: only one Fund Fee Formula may be active at a time. 

 

(If fund fees are based on something other than Net Assets, please review the Addendum: Custom Account Filter section at the end of these instructions)

 

Fund Fee Assessment Variables

 

There are fields found on the Fund form that may be referenced in your Fund Fee Formula or may impact calculations.

 

These include: 

 

 

 

Note: These fields are not used for all clients, depending on the Fund Fee Formula in effect. Consult our Support Team if you are unsure which variables are used in your calculation. 

 

 

 

Select Auto-Post Setting

 

Auto Post allows users to post Fund Fee transactions automatically once they are created by the Fund Fees Assessment process. To choose this setting: 

1. Navigate to Business Central
2. Search for General Ledger Setup 
3. Scroll to the Akoya section of the form 
4. Locate the Auto Post Fund Fee toggle and select the desired setting 

 

If Auto Post Fund Fees is OFF, the process creates a journal entry and stores it in the Fund Fee General Journal. If Auto Post Fund Fees is ON, the entry created by the process is automatically posted to the general ledger. 

 

 

 

1. From the Actions, select akoyaGO, then select Fund Fees Assessment 

 

 

2. Set or confirm the following parameters: 
   1. Ending Date - The ending date of the averaging period to be used for the calculation
   2. Averaging Period - The number of months over which the balances should be averaged for the calculation.
   3. Number of Months - The number of months the fee will cover (the fee period)
   4. Posting Date - The date on which the adjusting entry should be posted

 

3. Once these values are set, select Calculate Adjustment. 
    
4. A loading screen will appear, then end with a message indicating that a calculation is happening in the background.

 

 

 

5. You may now leave the Fund Fee Assessment form, as fund fees are being calculated in the background. The time the calculation takes will depend on the number of funds, the length of the averaging period, and the volume of transactions in the period. As the calculation takes place, you will see the Status remains as In Progress:
   
   
   You may check the status of the calculation at any point using the Refresh Status button.

 

 

 

 

If there were any issues and fund fees were not calculated, you will see a Status of "Error" and an Error Message to help you troubleshoot:

 

 

6. Once the status updates to “Calculated,” choose Review Adjustments. This will open a new window displaying the calculation results.

 

 

 

7. Results from the calculation contain information used in the calculation, as well as the results of the calculation. These results can be exported by choosing Page, then Open in Excel.

 

 

 

8. After reviewing the calculation, choose Close. You will be prompted to apply fund fee adjustments. Choose Yes to continue or No to cancel.

 

 

Note: If you have auto-post turned on for Fund Fees in the General Ledger Setup, selecting Yes will post the adjustment immediately. If auto-post is turned off, the journal entry will be stored in the General Journal named Fund Fees and can be posted from there. 

 

 

These steps only apply to clients where Auto Post is turned off for Fund Fees! 

 

1. To review and post fund fees, navigate to Finance, then General Journals. 

 

2. Open the Fund Fees journal.
    

 

3. The previously calculated journal entry should be displayed. This entry can be edited prior to posting or deleted if needed. 
    

 

4. To post the entry after reviewing, choose Post/Print, then Post.

 

 

 

 

 

If fund fees are based on balances other than Net Asset balances (typically accounts 3000 through 3999), a custom account filter should be used. If you do not see the Custom Account Filter on the Fund Fee Formula form, please contact our Support Team, and it can be added for you.

 

 

Custom Account Filter

 

The Custom Account Filter lists the G/L accounts used when Fund Fee Assessment determines each fund’s average or ending balance. If this field is blank, the process automatically uses Net Asset accounts.

The filter is written in the same context as Business Central filters. A range is expressed as two accounts separated by a “..”. The example below indicates that only accounts 1000 through 1299 will be used when considering balances.

 

 

To consider separate accounts that are not part of a range, the “|” symbol is used (shift + backslash on most keyboards). The example below would indicate that only accounts 1001, 1100, and 1110 will be used when considering balances.

 

 

Both filter types are commonly combined to get the exact accounts used for the process. In the example below, accounts 1000 through 1200, account 1350, and accounts 1400 through 1999 will be used to calculate fund fees.

 

 

Fund Fee Formula

 

By default, the balances used by fund fee assessment are Net Asset balances. In Business Central, Net Assets normally carry a credit balance. As a result, the Fund Fee Formula needs to be adjusted based on the normal balance of the accounts listed in the Custom Account Filter.  

 

In the example below, asset accounts are being used. Since assets normally carry a debit balance (opposite the normal Net Asset credit balance), the average daily balance function needs to be multiplied by -1.