Using the Fund Statement Designer

• Statement: This is the statement name or code used to identify the statement when the report is run. It is the combination of the Row and Column Formats.

• Description: This is the description associated with the statement selected. You may edit the value in this field if desired.

• Base Year: This is the default run time year for the statement.

• Base Period: This is the as of period for the statement.

• Row Format: This field determines the General Ledger account or range of accounts that should be reflected on each line or row of the financial statement.

• Column Format: This field defines the following:

  • Period(s) reflected on the financial statement.

  • Whether Actual or Budget figures will be used.

  • Whether the GL value should reflect a specific fund or fund category (range of Division, Class, Type, Sub-Type or Functional Expense codes)

  • If the column should display a calculated value based on previous columns.

Once a Statement is selected, the Form Statement Designer can be viewed in two ways:

• General Ledger View – this view shows the general ledger grid. You can toggle between Formula or Values display by clicking the Show Formulas / Values button on the left.

• Statement Layout View – this view displays the current statement design as it would look if it were printed.