Configuring the Report Configuration dashboard

Use this dashboard to select and define the name of accounts and funds to configure in these reports:

  • Consolidated Financial Statement
  • Statement of Capital Expenditures
  • Department (Cost Center) Profit and Loss
  • Project Comparative Financial Statement
  • Projects - Remaining Budget Evaluation.
  • Government Wide - Statement of Net Position
  • Government Wide - Statement of Activities
  • Governmental Funds - Statement of Revenues, Expenditures, and Changes in Fund Balances
  • Proprietary Funds - Statement of Net Position
  • Proprietary Funds - Statement of Revenues, Expenditures, and Changes in Net Position
  • Reconciliation of Balance Sheet of Governmental Funds to Statement of Net Position
  • Reconciliation of Statement of Revenues, Expenses, and Changes in Fund Balance to Statement of Activities
Note: Configuration requires the user to have the BI-Administrators role.
  1. Select Dashboards > GL Financial Reporting > Report Configuration.
  2. Select the reports tab to configure:
    1. In Consolidated Financial Statement, select FEG, Reporting Basis, and the Chart Account Structure. Set up revenue, expenses, and profit accounts that you must use on the chart.

      In Begin Expanse On Level setting, define the initial expansion level for the Consolidated Financial Statement report.

      Select any of the Expansion All or Level 1 - 12 options.

      In No. of Visible Accounting Entities, define the maximum default number of columns to display in the report. Select 20 (default), 50, and 100.

    2. In Statement of Capital Expenditures, select FEG, Reporting Basis, and the Chart Account structure. Set up or identify the Property Plants and Equipment and Accumulated Depreciation accounts that you must include in the report.
    3. In Department (Cost Center) Profit and Loss, select FEG and Reporting Basis. Set up Department dimension that you must include in the report.
    4. In the Projects Comparative Financial Statement, select FEG and Fund Basis. Set up the Account dimension that you must include in the report. Select any of the Expansion All or Level 1 - 12 options. In No. of Visible Projects, define the maximum default number of rows to display in the report. Select 20 (default), 50, and 100.
    5. In the Projects - Remaining Budget Evaluation, select FEG and Fund Basis. Set up the Account dimension that you must include in the report. Select any of the Expansion All or Level 1 - 12 options. In No. of Visible Projects, define the maximum default number of rows to display in the report. Select 20 (default), 50, and 100.
    6. In Statement of Net Position, select FEG, Reporting Basis, and the Chart Account structure. Set up Fund Structure, Governmental Activities Fund, Business Type Activities Fund, and Component Units Fund that you must include in the report.
    7. In Statement of Activities, select FEG, Reporting Basis, and the Chart Account structure. Set up Program Revenues, General Revenues, Expenses, Fund Structure, Governmental Activities Fund, and Business Type Activities Fund that you must include in the report. Transfers and Component units Fund is optional.
    8. In Governmental Statement of Revenues, select FEG, Reporting Basis, and the Chart Account structure. Set up revenues, other financing sources, special items, Fund Structure, and expenses that you must include in the report.
    9. In Proprietary Funds, select FEG, Reporting Basis, and the Chart Account structure. Set up Fund Structure, Enterprise Fund, and Internal Service fund that you must include in the report.
    10. In Reconciliation Balance Sheet, select FEG, Reporting Basis, and the Chart Account structure. Set up Fund Structure, Governmental Activities, Governmental Fund, and Internal Service Fund that you must include in the report.
    11. In Reconciliation Statement of Revenues, select FEG, Reporting Basis, and the Chart Account structure. Set up Program Revenues, General Revenues, Expenses, Transfers, Fund Structure, Governmental Activities Fund, Governmental Fund, and Internal Service Fund that you must include in the report.
Note: The Statement of Net Position, Statement of Activities, Governmental Statement of Revenues, Proprietary Funds, Reconciliation Balance Sheet, and Reconciliation Statement of Revenues tabs are only enabled to users with the PublicSectorReport_ST role.