OPERATING LEDGER : Located on Operating Tab, Operating 2 Tab, Custom Tab
OPTIONS
Operating Tab
- Operating Statement (Fund/Org)
- Operating Statement (Fund/Org/Prog)
- Combined Statement of Operating Accts
- Periodic Comparison-Operating Accts
- Multi-year Comparison-Operating Accts
- 2 year Comparative Operating Accts
- Operating Statement w/Fund Balance
Operating 2 Tab
- Program Expense by Fund Type
- Operating Statement by Fund Type
- Operating Statement by Program
DESCRIPTION
Provides an operating / budgetary statement presentation, of all data entry operating accounts for all data entry funds, and org's within the applicable parameters specified. Page break and totals are provided at each org, and fund break, and include both stored and computed balances.
Columns
Presented by Budget, Actual, Encumbrance, and Available Budget Balance, for the Accounts, by Org, and Fund, for the Fiscal Year, as-of the period specified.
Rows
Are related Accounts, sub-totals by level 2 account types, and totals by level 1 account types, for all accounts within the fund.
Summary Totals
Income & Expenses are provided at each break of org within fund, and for the fund in total as well as for the entire report.
REPORTS & PARAMETERS
Even though the parameter screen is available for all reports, not every report will use all the parameters. In fact, if you input a chart element on the parameter screen and run a report that does not use that parameter, that parameter will be ignored. So in effect, you may think you specified certain criteria when you really didn't. For example, the "Periodic" reports on both the General and Operating tab will allow you to specify a fiscal period but since this report will display all fiscal periods for a fiscal year, your selection will be ignored.
Below is a list of all the reports and what parameters they use.
| REPORT NAME | PARAMETERS USED |
|---|---|
| Operating Statement (Fund, Orgn) | Fiscal Year, Fiscal Period, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| Operating Statement (Fund, Orgn, Prog) | Fiscal Year, Fiscal Period, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| Combined Statement of Operating Accts | Fiscal Year, Fiscal Period, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| Periodic Comparison-Operating Accts | Fiscal Year, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| Multi-year Comparison-Operating Accts | Fiscal Year, Fiscal Period, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| 2 Year Comparative Operating Accounts | Fiscal Year, Fiscal Period, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| Operating Statement w/Fund Balance | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Account Type, Index & Grant. |
| Program Expense by Fund Type | Fiscal Year, Fiscal Period, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| Operating Statement by Fund Type | Fiscal Year, Fiscal Period, Chart of Accounts, Reporting Unit, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant if a chart is specified. |
| Operating Statement by Program | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Account Type, Index & Grant. |
| Operating Accts/Budget Adjust | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Account Type, Index & Grant. |
Any combination of chart elements can be used for this report.
The Index & Grant elements will only be active if a specific chart is selected.
EXAMPLE
What was the revenue and expense, by account code, for continuing education?
Hint: Search on "Continuing Education" in the fund lookup.
Parameters Used:
- Fiscal Year = current year
Fund = 333001 Include lower levels?
SAMPLE
