Fund statement templates require a fund statement format. Unlike other templates, fund statements require additional settings, which are applied in the fund statement format, to allow data to populate in those merge fields. For instance, if you add the {{#foreach_donation}} section to your fund statement, you also need to include donations in your fund statement format.
Create Fund Statement Format
- Navigate to the Fund Statements page and click Formats in the left-side menu.
- Click Create in the left-side menu.
- Enter the applicable Fund Statement Format information.
- Name - Description of the fund statement format.
- Include YTD - If checked, YTD merge fields included in the fund statement template will generate.
-
Template - Select the fund statement template that will correspond to this fund statement format from the drop-down menu.
- Each fund statement format can have one fund statement template assigned.
-
Financial View - Displays financial information on the fund statement in the same order of the financial view that is selected from the drop-down menu.
-
Financial View and Statements Accounts cannot both be checked. They are both customizations to how data is displayed on the template. If Financial View or Use Statements Accounts is being used, ensure the other box is not checked.
-
-
Default - One default fund statement format is required.
- The default fund statement format is assigned to funds that do not have another fund statement format listed in the fund record. The fund statement for those funds will be the fund statement template that is assigned to the default fund statement format. The fund statement process relies on the default setting on the fund statement format rather than the fund statement template.
-
Include Sub-Funds - Impacts whether sub-fund activity displays on the parent fund statement.
- Parent funds and sub-funds only receive statements if the fund records have statements enabled.
- If checked, the balance of the parent fund reflects parent fund and sub-funds' balances. Sub-fund statements are generated with their individual fund balances.
- If not checked, the balance of the parent fund reflects the parent fund balance. Sub-fund statements are generated with their individual fund balances.
- Use Statement Accounts - If statement accounts are set up, check this box so fund statement generate using statement accounts.
-
Print Copy for Each Advisor - When there are multiple advisors on a fund, print statement per advisor.
-
Only check this if the fund statement template includes information related to each specific fund advisor such as advisor name or address.
- If included, this checkbox will generate a file for each fund advisor.
- If the fund advisor template fields are not included in the template and the statement type is set to paper, a fund statement will still generate for each advisor.
- Job processing speeds will be reduced when this setting is not checked.
- Investment Data - If the fund statement template includes the investment report table, check this box to allow those merge fields to generate.
- Check the box next to each data section that is built into your fund statement to enable that data to generate.
- A section is a part of the statement that starts with a {{#foreach xxxxx}} and ends with {{/foreach xxxxx}}.
-
Do not check any sections that are not included in the fund statement template. If a section that is not in the fund statement template is checked in the fund statement format, job processing speeds will be reduced.
-
Example Fund Statement - The following example fund statement contains four sections, Receipts, Distributions, Donations, and Grants, which are indicated with bold text.
- The fund statement format for this fund statement should have those four sections, and only those four sections, checked.
-
-
- Set the sort order at the bottom of the screen where each section selected will populate, and then click Save.
- Once a sort order is set, another appears.
- For instance, if a fund has multiple contributions on the same date, a secondary sort can be set to tell the statement to then sort by another criteria such as name or amount.
- For instance, if a fund has multiple contributions on the same date, a secondary sort can be set to tell the statement to then sort by another criteria such as name or amount.
- Once a sort order is set, another appears.
Assign Fund Statement Format to a Fund
Once fund statement formats have been created, they can be assigned to funds individually or in bulk. If a fund statement format is not set on a fund, the fund will use the default fund statement format.
- Navigate to the Funds page.
- Enter the fund name in the Search Fund field and select the fund from the drop-down list.
- Alternatively, click List Open in the left-side menu to view a list of all funds. Click the ID of the fund.
- Alternatively, click List Open in the left-side menu to view a list of all funds. Click the ID of the fund.
- Click Edit in the left-side menu.
- Select the fund statement format from the drop-down menu, and then click Save.
Edit Fund Statement Format
This option allows editing of the fund statement template which is associated with the fund statement format as well as all other format information.
- Navigate to the Fund Statements page and click Formats in the left-side menu.
- Click the name of the format to be edited.
- Click Edit in the left-side menu.
- Make the applicable edits to the Fund Statement Format.
- Click Save.