Revised 06/26/2026

• 1. What’s New & Why It Changed
  • Why this was built
  • What you gain
• 2. Key Concepts
• 3. Open the Fund Fee Formulas Area
• 4. Create a New Formula (Step by Step)
  • 4.1 Name the Formula
  • 4.2 Status
  • 4.3 Frequency
  • 4.4 Calculation Type (Fixed vs Tiered/Stepped)
  • 4.5 Amount or Percent
  • 4.6 Balance Type, Averaging Period & Prorate Fee
    • Prorate Fee
  • 4.7 Balance Filter Type & Account Selection
    • Account Category (when Balance Filter Type = G/L Account Category)
    • Custom Account Filter (when Balance Filter Type = G/L Account or Net Asset)
    • Debit / Credit
  • 4.8 Minimum Fee & Rounding
    • Minimum Fee (optional)
    • Rounding
  • 4.9 Expense, Revenue & Revenue Fund
  • 4.10 Save the Formula
• 5. Field Visibility Quick Reference
  • By Calculation Type and Amount/Percent
  • By Balance Type
  • By Balance Filter Type
• 6. Build Fee Tiers (Tiered/Stepped)
  • Stacked Tier
• 7. How the Final Fee Is Calculated (Order of Operations)
• 8. Copy an Existing Formula
• 9. Assign the Formula to Funds
• 10. Deletion Protection
• 11. Legacy Formulas (SQL & FetchXML)
  • Legacy SQL formulas
  • Legacy Fund FetchXML filter
• 12. Calculating Fees in Business Central
• 13. Test Before You Go Live

  1. What’s New & Why It Changed

The Fund Fee Formula Builder replaces the old SQL-based approach to fund fees with a visual, point-and-click builder. Instead of one large, complex master formula written in SQL, you now create one formula per calculation and assign it to the funds it applies to.

Why this was built

The previous system required SQL knowledge, was difficult to maintain, and provided little visibility into how fees were calculated. The new builder removes those barriers.

What you gain

• akoyaGO Users can create and manage fee formulas without developer help
• Faster setup and easier troubleshooting
• Full transparency into fee calculations and the balance logic behind them (visible later in the Business Central calculation log).
• The ability to batch-assign a formula to many funds at once and run multiple formulas together in Business Central.

Important: Legacy formulas still work. Existing legacy SQL formulas (and legacy Fund FetchXML filters) remain fully supported during migration. Some very complex formulas may not yet be compatible with the builder. For more information, see Legacy Formulas.

  2. Key Concepts

The builder uses a guided form that shows and hides fields based on your selections, so you only see fields that apply to the formula you are building. Section 5 has a complete map of which fields appear for each combination.

Term	Meaning
Formula	A reusable definition of how a fee is calculated: frequency, fee type, balance basis, tiers, minimum, rounding, and the revenue/expense accounts used when the fee posts.
Calculation Type	Whether the fee is a single Fixed rate/amount or a Tiered/Stepped set of rates that vary by balance.
Balance Type	Which balance figure the fee is based on (for example, an ending balance or an average balance).
Balance Filter Type	Which accounts make up the balance the fee is calculated against (a G/L Account range, a G/L Account Category, or each fund’s Net Asset balance.)
Tier	A balance band with its own rate or amount, used only when Calculation Type is Tiered/Stepped.
Connected funds	The funds a formula is assigned to. Business Central calculates one staged line per connected, active fund.

  3. Open the Fund Fee Formulas Area

In akoyaGO CRM, go to Tools → Fund Fee Formulas.

The list of existing Fund Fee Formulas opens.

  4. Create a New Formula (Step by Step)

From the Fund Fee Formulas list, click New. Then, switch from the legacy form to the Fee Formula Builder form.

Work through the fields below from top to bottom. Because the builder reveals fields conditionally, completing them in order ensures that the required fields appear at the right time.

4.1 Name the Formula

Name is required. Use a clear, descriptive name so the correct formula is easy to choose later (for example, Annual 1% Endowment Fee). Names are limited to 100 characters and cannot be blank or only spaces. Two active formulas cannot share the exact same name (the check is case-insensitive). 

4.2 Status

• New formulas default to a status of Status = Active.
• Only formulas set to Status = Active appear in the Fund Fee formula picker and on the Business Central Fund Fee screen. 
• Note: More than one formula can be active at a time.

4.3 Frequency

Frequency determines how often the fee is assessed, and (for percentage fees) is used to prorate the rate.

Choose from the following options:

• Monthly 
• Quarterly
• Semi-Annually (twice a year)
• Annually

4.4 Calculation Type (Fixed vs Tiered/Stepped)

Calculation Type is required and drives much of the rest of the form.

• Fixed - a single rate or amount applies. 
• Tiered/Stepped - rates or amounts vary by balance band. The Tiers grid and the Stacked Tier option appear. For more information, see Build Fee Tiers (Tiered/Stepped) section.

Important: Switching from Tiered/Stepped to Fixed prompts a confirmation and removes the existing tier records. Only switch if you intend to discard the tiers.

4.5 Amount or Percent

Select whether the fee is entered as an Amount (a fixed dollar figure) or a Percent (a rate applied to a balance). This selection is required, and it controls which entry field appears.

• Amount → the Fee Amount field appears and is required; Fee Percent is hidden. 
• Percent → the Fee Percent field appears and is required; Fee Amount is hidden. 
• Switching between Amount and Percent clears the field that is now hidden, so no old value is left behind.

For Fixed calculation types specifically:

• Fee Amount is available only when Amount/Percent = Amount and Calculation Type = Fixed. It is saved to two decimal places. 
• Fee Percent is available only when Amount/Percent = Percent and Calculation Type = Fixed. It is saved to two decimal places and is prorated based on Frequency.

A fixed dollar fee needs no balance. 

• When Calculation Type = Fixed and Amount/Percent = Amount, the builder hides Balance Type, Balance Filter Type, Averaging Period, Prorate Fee, Stacked Tier, and Minimum Fee, because a flat dollar amount does not depend on a balance. As soon as you choose Percent (or Tiered/Stepped), the balance-related fields reappear.

4.6 Balance Type, Averaging Period & Prorate Fee

When the fee depends on a balance (any Percent fee, or a Tiered/Stepped fee), choose the Balance Type – the balance figure the fee is calculated from. 

Options include:

• Ending Balance
• Beginning Balance
• Net Change
• Highest Balance 
• Average Daily Balance
• Average Monthly Balance
• Average Quarterly Balance

Your Balance Type choice controls two related fields:

• Averaging Period – appears and is required for Average-based balance types and for Beginning Balance, Net Change, and Highest Balance. It is hidden for the Ending Balance. The Averaging Period is interpreted as a number of months, regardless of whether the average is described as daily, monthly, or quarterly.  
• Prorate Fee – appears only for Average-based balance types. It is hidden for all other balance types.

Prorate Fee

Use Prorate Fee to control how funds that were only open for part of the averaging period are treated. The system does not prorate by default. When Prorate Fee = No, the calculation includes $0 for periods with no balance, which lowers the average and can reduce the final fee. Turn Prorate Fee on when you want partial-period funds measured only over the months they were actually open.

4.7 Balance Filter Type & Account Selection

Balance Filter Type is required for percent-based fees and determines which accounts are included in the balance against which the fee is calculated.

Choose one of:

• G/L Account → reveals the Account Filter field, which becomes required. 
• G/L Account Category → reveals the Account Category lookup, which becomes required. The fee includes all accounts in the selected category. 
• Net Asset → uses each fund’s net assets. Reveals the Account Filter field, which becomes required.

Saving is blocked until the required field for your selection is filled in. If you switch away from a selection, the system clears the field that no longer applies so an outdated value can’t remain.

Account Category (when Balance Filter Type = G/L Account Category)

Choose from an active-only list of account categories. The fee will include all accounts in the selected category. 

Account Filter (when Balance Filter Type = G/L Account or Net Asset)

Enter a tailored list or range of G/L accounts. The field supports pipe-separated values and range notation — for example, 4000..4999 or 4000|4100|4200. 

For G/L Account filter types, the system uses all specified accounts for the calculation.

For Net Asset filter types, the system uses the specified Net Asset accounts, as well as any income statement account that nets to one of them.

Debit / Credit

Once a Balance Filter Type is selected, a Debit/Credit field is available to indicate how the balance is treated. For example, a filter based on asset/liability accounts would typically carry a debit balance. A filter based on net asset accounts would typically carry a credit balance.

4.8 Minimum Fee & Rounding

Minimum Fee (optional)

If the calculated fee is below the minimum you set, the system applies the minimum instead. A negative calculated fee never triggers the minimum.

Rounding

Choose how the final fee is rounded. Rounding uses half-up logic.

• None - Rounded to the nearest penny
• Nearest One - Rounded to the nearest dollar
• Nearest Ten - Rounded to the nearest ten dollars
• Nearest Hundred - Rounded to the nearest hundred dollars

4.9 Expense Account, Revenue Account & Revenue Fund

These selections specify how the system codes the transaction when it is moved to the General Journal.

Field	Rule
Expense Account	Required. Must be an active, expense-type account. This is the account debited.
Revenue Account	Required. Must be an active, revenue-type account. This is the account credited.
Revenue Fund	Directs which fund receives the credit side of the fee.

4.10 Save the Formula

Click Save. 

• The form will block saving until all required fields for your chosen options are complete (Name, Frequency, Calculation Type, the Amount/Percent selection and its value, the Balance Filter Type dependent field, and the Expense/Revenue accounts). 
• If the formula is Tiered/Stepped, build the tiers next (Section 6). When the formula is verified, set Active = Yes so it can be assigned and used.

  5. Field Visibility Quick Reference

The builder shows or hides fields automatically based on your selections. Use this table to see what to expect.

Fields not listed in a row keep their normal visibility. Rounding and the Expense/Revenue account fields remain available regardless of these selections.

By Calculation Type and Amount/Percent

Your selection	Fields shown / required	Fields hidden
Fixed + Amount	Fee Amount (required)	Fee Percent, Balance Type, Balance Filter Type, Averaging Period, Prorate Fee, Stacked Tier, Minimum Fee
Fixed + Percent	Fee Percent (required), Balance Type, Balance Filter Type, Minimum Fee	Fee Amount, Stacked Tier
Tiered/Stepped	Tiers grid, Stacked Tier, Balance Filter Type, Minimum Fee	Fee Amount, Fee Percent

By Balance Type

Balance Type	Averaging Period	Prorate Fee
Average-based	Shown & required	Shown
Ending Balance	Hidden	Hidden
Beginning / Net Change / Highest Balance	Shown & required	Hidden

By Balance Filter Type

Balance Filter Type	Custom Account Filter	Account Category	Debit/Credit
G/L Account	Shown & required	Hidden	Shown
G/L Account Category	Hidden	Shown & required	Shown
Net Asset	Hidden	Hidden	Shown

  6. Build Fee Tiers (Tiered/Stepped)

When Calculation Type is Tiered/Stepped, the Tiers grid appears and the Stacked Tier option is enabled. Each tier defines a balance band and the rate or amount that applies to it.

1. In the Tiers grid, add a tier for each balance band. 
2. Set the ending balance and rate or amount for the tier.
3. Repeat for each tier you need.

Copying a tiered formula also copies its tiers (with new internal records). For more information, see Copy an Existing Formula section.

Stacked Tier

Stacked Tier	How rates apply
Yes	Each tier’s rate applies only to the portion of the balance within that tier, and the results are summed (a blended/marginal calculation).
No	The single matching tier’s rate applies to the entire balance.

  7. How the Final Fee Is Calculated (Order of Operations)

When Business Central calculates the fee, adjustments are applied in a defined order. The result can differ from the raw tier math alone, so it helps to understand the sequence:

1. Base calculation – fixed amount, fixed percent, or tier logic (stacked or non-stacked) against the chosen balance. 
2. Proration – applied where relevant (Average balance types with Prorate Fee on). 
3. Minimum Fee – if the result is below the minimum, the minimum is applied (negative results never trigger the minimum). 
4. Rounding – the final amount is rounded per the Rounding selection (half-up).

Important: Every step is recorded in the Business Central calculation log for each fund line, so you can confirm exactly how an amount was reached. For more information, see the Calculating Fees in Business Central section.

  8. Copy an Existing Formula

Use the copy action to start a new formula from an existing one without changing the original.

• The new formula is created using the original name, followed by “Copy” and a timestamp.   
•  If the original is tiered, its tiers are copied as well (as new tier records). 
• The copy is fully independent; adjust it freely without affecting the original.

After copying, open the new formula and its tiers, confirm everything looks right, save, and rename it.

  9. Assign the Formula to Funds

A formula can only be used once it is assigned to funds. You can assign a formula to individual funds or in bulk from a view.

1. Select the fund or funds you want to assign the formula to. Choose "Assign Fund Fee"
   
    
2. Choose the active Fund Fee Formula to be assigned to the selected funds, then choose "Add"
   
    
3. The system reports the results.
   

If a selected fund already has an active fee formula assigned with the same selection, it is skipped to avoid duplicates. A bulk assignment may therefore return a mix of newly assigned and already-satisfied funds.

  10. Deletion Protection

A Fund Fee Formula that has been used in calculations cannot be deleted. This protects the history and traceability of fees that have already been calculated or posted. If you no longer want a formula used, deactivate it instead of deleting it.

  11. Legacy Formulas (SQL & FetchXML)

Organizations migrating from the legacy fund fee builder can continue using legacy formulas during the transition.

Legacy SQL formulas

• An existing legacy SQL formula remains editable and usable, and the system indicates when a formula is operating in legacy mode. 
• If the SQL field contains a value, the system runs that legacy SQL and ignores the builder inputs for that formula. 
• If you clear the SQL field and save, the formula automatically switches to the builder-driven calculation.

Legacy Fund FetchXML filter

If your fee logic constrained which funds it applied to using a legacy Fund FetchXML filter, that capability remains available during migration to the builder and bulk-assignment approach.The FetchXML filter is not available/used in the updated Fund Fee Assessment tool. 

Important: Some complex legacy formulas may not yet be compatible with the builder. Validate a small set of funds before migrating a complex formula fully.

  12. Calculating Fees in Business Central

Once your formula is built, ensure its Status is set to Active, and it is assigned to the appropriate funds. Business Central uses this information to calculate and post fees. At a high level:

1. From the akoyaGO Action header in Business Central, choose Fund Fees Assessment to open akoyaGO Fund Fee Formulas.
2. Select your formula and choose Queue Calculation.
3. Refresh until the batch is calculated, then review the staged lines and the calculation log. 
4. Address any Batch Errors. These can occur if the calculated fee exceeds the fund's balance, or if the fund's balance exceeds the linked fund group's balance.
5. When Batch Errors is zero, Move to General Journal and Post (or use the combined move-and-post action when auto-posting is on).

Important: For a detailed overview of how Fund Fee Formulas work in Business Central, see Assessing Fund Fees in Business Central

  13. Test Before You Go Live

Before assigning a new formula to production funds, validate it:

• Build the formula and assign it to a small set of test funds. 
• Queue a calculation in Business Central and confirm that Batch Errors is zero. 
• Open the calculation log and confirm the balance basis, the base calculation (percent × balance, fixed amount, or tier math), and any proration, minimum fee, and rounding produce the amount you expect.
• For tiered formulas, confirm that the Stacked Tier setting behaves as intended.   
• Once tested, assign the formula to all appropriate funds.