• Navigate to Fund Statement Formats
• Manage Fund Statement Formats
  • Logo
  • Report Lines
  • Blank Lines
  • Specify Font Colors

 

  Navigate to Fund Statement Formats

From the Actions, select Reports, then Report Setup, then Fund Statement Formats

 

A list of existing Fund Statement Formats will be displayed, including the following properties:

• Code: Short code used to identify the format
• Name: Full name for the format
• Available in akoyaGO: Indicates whether this format can be assigned to funds/used in akoyaGO
• Used by Funds: The number of funds assigned to this format
• Used by Fund Groups: The number of fund groups assigned to this format
• Is Coupled: Indicates if this format is linked to a format listed in akoyaGO
• Description: Optional description to indicate how/when to use this format

 

Important: The format labeled "AKOYAGO" is used as the default fund statement format for funds not assigned to a specific format

 

 Manage Fund Statement Formats

1. Open a Fund Statement Format by clicking on the Code, such as "akoyaGO"

The top section of the form contains the following settings:

• Code: Short code used to identity the format
• Name: Full name for the format
• Description: Brief description of how/when to use the format 
• Comparison Type: The default comparison column for this report format. The Compare To field in the report dialog will override this selection.
• Current Period Column Header: If a comparison type is set (either in these settings or in the report dialogue) this is what will read as the current period column header. If no comparison is selected, this label will not appear.
• Comparison Column Header: If a comparison is set (either in these settings or in the report dialogue) this is what will read as the comparison column header. If no comparison is selected, this label will not appear.
• Show Fund Donor: Indicates whether the Primary Fund Donor value should be displayed in the report header
• Fund Donor Caption: Optional label value for the Fund Donor. If blank, the default label is "Primary Fund Donor".
• Is Available in akoyaGO: Indicates whether this format can be assigned to funds/used in akoyaGO.
• Report Footer: Optionally allows the user to define footer text to be applied to all funds using this format.

 

See options highlighted in green below:

 

Logo

The logo displayed on the Fund Statement report is controlled by the company settings in Business Central. A single logo is applied to all Fund Statement Formats.

To select a logo for the Fund Statement:

1. From the dashboard, select the Setup menu, then Company Settings.

2. Select a file for the Picture property.

3. To replace an existing Picture, click on the current Picture

 

Important: The Picture may be used for reports other than the Fund Statement, such as remittance files.

 

Report Lines

Report Lines represent the rows and columns of the report data. each line contains the following properties:

Style: Indicates how the row will be formatted:

• Section - Bold, thick underline, and thick topline 
• Header - Bold, underline 
• Detail - Standard font (not bold) 
• Footer - Bold 

Field 1 Expr.:  

• For summary sections/headers, the label for the selected row (generally, a text value) can contain any alphanumeric character or space. 
• For detailed sections, they may contain a data value selected from the available G/L Entry fields. 

Field 2 Expr.:  Used only for detail sections. Header lines contain column formats. Detail lines contain a data value selected from available G/L Entry fields. 

Field 3 Expr.: Used only for detail sections. Header lines contain column formats. Detail lines contain a dollar value. 

Account Type: Indicates the type of account to use when filtering accounts.

• G/L - Any account number from the general ledger. Includes items posted to that account. 
• Net Asset - Accounts between 3000 and 3999, includes indirect net activity (posted based on revenue/expenditures) 

Filter: Specify which accounts to include.  

• For a range of accounts, use two periods (“..”) e.g., 1000..1999 
• To select multiple non-consecutive accounts, use a vertical bar (“|”), e.g,. 4010|4020|4040 

Show Amount: Select to display data for the selected row. Rows with calculated values, etc., can be hidden if desired. 

Reverse Sign: Display the amount with the opposite sign (e.g., display a credit balance as a positive value). 

Negative Style: Choose Negative or Parentheses. If Negative, amounts less than $0.00 in the fund statement will appear with a minus (-) sign in front of them. If Parentheses, amounts less than $0.00 in the fund statement will appear in parentheses. 

Red Negative Values: Check the box in this column to make amounts less than $0.00 in the fund statement display in red.

Calculation Method: 

• Beginning Balance - Balance at the beginning of the filtered date range 
• Net Change - Net change during the filtered date range 
• Ending Balance - Balance at the end of the filtered date range 

Show if No Data: Select to display the row even if no data exists for the specified criteria.  Use this option to insert blank lines for spacing. 

Hide Compare Value: Select this option to hide the comparison column value for the selected row, e.g., details lines that are itemized.

Group By: Used only for detail sections. Select a field on which to group data, e.g., Group by [Akoya Payment No.] to consolidate data by payment number. This would consolidate payment lines that net to zero, such as reversals. 

Order By: Used only for detail sections. Select a field on which to sort data. 

 

Blank Lines

To insert a blank line in the format, add a New Line with Style "Detail". Then enter at least one space in the Field 1 Expr.

 

Specify Font Colors

 

Fund statement formats can add color to certain columns in the fund statement. To see these fields, add them to your fund statement format using the Personalization settings. 

 

1. Select the settings gear icon in the top right corner, then select Personalize.

 

 

2. Your screen will change to allow for personalization. Click More to expand your personalization options. 

 

 

3. Choose + Field. 

 

 

 

4. Now, make sure to select the Report Line section of this page. Simply click into that section to select it. You will know it is selected when it is surrounded by a red box.

 

5. Once the Report Lines section is selected, you should see the options for Field 1-4 Color fields. If not, use the magnifying glass icon to search for those field names. Next, drag and drop those fields into the Report Lines section. To move the fields around within the section, use the red arrow on the top right of the column to drag and drop.

 

 

The Field Color columns operate using HEX codes (#XXXXXX) or RDLC-safe colors. The number corresponds to the Field 1-4 Expr. columns on the fund statement format. 

• Field 1 Color - updates the color of values in Field 1 Expr.
• Field 2 Color - updates the color of values in Field 2 Expr.
• Field 3 Color - updates the color of values in Field 3  Expr. Typically this column on the fund statement is a dollar amount value.
• Field 4 Color - updates the color of values in Field 4  Expr. Typically this column on the fund statement is a comparison column and a dollar amount value.

 

For example, if I want the header of the left column of my fund statement to be a certain color, I would add a HEX code to the Field 1 Color, on the Header line.

 

And this is the result of that on the fund statement. 

 

 

Follow this same logic to add colors to additional fund statement lines.