What This Report Shows


  • Revenue, Expenditure and Fund Equity summary amounts for the chosen Fund Groups are displayed.
  • Based on which fund group the fund has been assigned to, the amount affecting that fund will be listed in the column of that group.
  • The amounts derive from the year files of each type (FINEYR, FINRYE, FINBYR).
  • Based on the period chosen, the amounts for each type are shown through that period, not on that period (ex. If January is chosen, the report shows amounts from the beginning of the fiscal year through January, not only the amounts for January).


Requirements


  • Fund Defintion - In order to properly run this report, each fund and fund group must be defined. In addition, each fund must be assigned to a fund group.


Account Statement Summary by Fund Groups Report


  1. Finance → Financial Management → Reports → Summary → Combined Account Type → Account Statement Summary by Fund Group
  2. Enter the fiscal year and fiscal period (which).
  3. Populate which dimensions you wish to see for each type.
  4. Choose the fund groups you wish to see.
  5. Range accordingly if necessary in the Range Tab.
  6. Once all necessary fields are populated, click Select (process wheel).

Select and Sort Tab

FIELDSOpt.Rec.Req.Description
Report Title♦——A user-created title of the report
Fiscal Year——♦The fiscal year the amounts are associated with
Which——♦The fiscal period (YTD, reporting period) the amounts are associated with
Expenditure/Revenue/General Ledger Dimension——♦Account code dimension selected for each account type based on the account structure
Group 1-6——♦The fund groups chosen to be displayed
Type 7 Title 1 & 2—♦—If more than six fund groups exist, the seventh column will be for the remaining group funds; a title is recommended to classify this combination; i.e. Other Fund Groups


Range Tab

FIELDSOpt.Rec.Req.Description
Range Criteria♦——Range accordingly if necessary
Opt. = Optional  Rec. = Recommended  Req. = Required