Managing fund templates

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

Before you apply the Fund accounting structure to an engagement, we recommend that you first set up one or more fund templates. Your firm's fund templates will allow you to quickly apply a pre-determined fund structure at the engagement level. 

Note: You must have appropriate permissions to create or modify fund templates.

You can also organize funds for a given template into sets that will allow you to quickly access fund information for reporting purposes.


  • You can apply the fund structure to an engagement without using a template, but you will then need to build the fund hierarchy from within the trial balance.
  • Changes that you make to a fund template won't apply to engagements that currently use that template; changes will apply only for engagements to which you apply the template after you made the changes.
  • Changes that you make to the fund structure of an engagement won't apply to any fund template that you used when you applied the fund structure.
  • You can copy fund templates that you've already set up.

Creating a new fund template

  1. Click the Administration button in the navigation pane and click the Fund Templates button.
  2. Click the Add Fund Templates Add Fund Templates button button in the Funds tab, enter a unique name for the fund, and specify a mask in the provided fields.  


    • You must enter mask characters in the order specified in the legend of the Add dialog.
    • If the fund template includes sub fund data, you have the option to include this data by adding corresponding sub fund characters in the mask. If you don't add sub fund characters in the mask, the sub fund data is copied to the engagement, but AdvanceFlow won't include sub fund information in trial balance views or when you run fund reports.

Setting up the fund hierarchy

AdvanceFlow organizes your fund data within a hierarchy and represents each fund level in its own pane within the Funds tab. The contents of each pane changes dynamically, depending on the selections you make in the pane corresponding to the next highest hierarchical level.Show me.

(I) Category

(II) Type

(III) Fund

(IV) Sub Fund

You can also import a fund structure from an Excel spreadsheet or from an existing engagement.

For each category that you'd like to add to the the current template, do the following.

  1. Click the Add Add button button In the Category pane, enter a unique category name, and click OK.
  2. To add a type for the new category, click the Add Add button button in the Type pane on the right, enter a unique type name, and click OK.
  3. To add a fund for the selected type, click the Funds Funds button button in the Type pane, click the Add Add button button in toolbar in the upper pane of the Funds dialog, enter a unique fund code, enter a description, and click OK.
  4. To add a sub fund, click the Add Add button button in the lower pane of the Funds dialog, enter a sub fund code, enter a description, and click OK.


    • AdvanceFlow allows the use of duplicate sub fund codes for sub funds used in separate funds. All other set data such as fund codes, type names, and category names must be unique throughout all of your firm's fund templates. For example, you could re-use a sub fund with code "10" for a cash account in separate funds.
    • AdvanceFlow requires that if you include sub fund data, you must include it for all funds. Therefore, if a specific fund doesn't require a sub fund, you will need to enter a sub fund placeholder.

Note: AdvanceFlow will prompt you to save any changes to the selected fund template when you navigate away from the Funds tab. Click Yes to save your changes.

Related topics

Share This