Fund statements provide fund advisors with financial information about the funds they advise. In CommunitySuite, fund statements can be created in bulk or run manually one at a time. Before fund statements can be generated, a fund statement template must be uploaded and a fund statement format must be connected to a fund.
Who: Finance teams and administrators who manage fund statement templates, formats, and distribution in CommunitySuite.
How to Use Fund Statement Templates and Formats
Use fund statement templates and formats to:
- Upload and customize a fund statement template with your organization's branding and preferred fields.
- Connect a fund statement template to a fund statement format, and assign that format to a fund.
- Test and iterate on a fund statement template before distributing statements to fund advisors.
Part 1: Find, Download, and Upload Fund Statement Templates
The following video covers how to locate fund statement templates in Support Hub, download a template, and upload it to your CommunitySuite site.
Resources referenced in the video:
Part 2: Connect the Template, Format, and Fund
The fund statement format connects a fund statement template to a fund. On the fund record, the fund statement format will be selected. The fund statement format then uses a fund statement template to populate the information for the statement. The following video demonstrates how to connect a fund and fund statement template to a fund statement format.
Resources referenced in the video:
Part 3: Testing and Editing Fund Statements
The following video covers how to test a fund statement template, make edits, and upload the updated template to CommunitySuite.
- Generate a Test Fund Statement (:30) - Create a fund statement in your Sandbox site to preview how the template looks before distributing to fund advisors.
- Update the Logo (1:48) - Replace the placeholder logo in the template with your organization's logo.
- Edit Template Sections and Fields (2:56) - Remove sections, adjust conditional fields, and add additional fields to customize the template content.
- Upload the Updated Template (5:42) - Update the existing template record in CommunitySuite with the revised file and regenerate the fund statement to confirm changes.
Resources referenced in the video:
Additional Information for Template Edits
- Delete the sections (i.e. grants, donations, receipts) if they will not be used.
- Check for conditional logic within the template by highlighting the area of interest and then right-clicking. If the menu shows the options to Update or Toggle Field Codes, click Toggle field codes to view the hidden logic.
-
- Some logic will be IF conditionals similar to what is shown below.
- Example: {IF {{grant_id}} = "" "No grants available." "{{grant_id}} {{vendor_name}}"}
- Example explanation: Based upon an output of the merge field, the IF conditional will determine the information shown in the template. In this case, if a grant id is equal to ““ (i.e. nothing), then the conditional statement will show all information/merge fields in the second pair of quotations, therefore, “No Grants Available”. If the Grant ID is not equal to ““ (i.e. nothing), then the conditional statement will show what is within the third set of quotations, in this case, the two merge fields.
- If changes within a conditional merge field were made, highlight the entire area where the change was made and right-click to view menu options. From the menu options, click Update Field Codes. This will preserve the edits.
-
- After making any changes to a template, update the template in CommunitySuite and verify/test it. Since fund statements are not automatically updated when a template or format is edited, regenerating the fund statement is necessary to see the changes.
- Template Conditions