Report Jobs

The General Accounting area includes batch jobs that are listed under several different areas in the Batch Catalog. The report jobs are listed alphabetically in the table below and the last column indicates the location in the Batch Catalog. For detailed information on the jobs (such as when to run, input, output, and process parameters) refer to the associated run sheet in the following user guides: CGI Advantage Financial - General Accounting Run Sheets and CGI Advantage Financial - System Assurance Run Sheets.

Job Name	Description	Batch Catalog Section
Balance Sheet for Governmental Funds	The Balance Sheet for Governmental Funds report provides totals by balance sheet account for a single accounting period. A column is provided for each fund marked as a Major Fund as an input parameter with all other funds consolidated into one column.	General Accounting
Budget vs. Actual Report for Expense	The Budget vs. Actual Report for Expense is a sample report configured to work with budget structure 29 only. The report lists each Object for a Fund, Department, Appropriation, and Unit combination. Columns exist showing the Current Budget amount as Exp Budget, along with totals for Encumbered, Accrued Expenses, and Cash Expenses for both the current period as well as inception-to-date. The report ends with a Difference column showing what would be unobligated. Records are displayed with summary totals as rollups are presented at: Fund, Department, and Appropriation Fund and Department Fund All budget lines	General Accounting
Budget vs. Actual Report for Revenue	The Budget vs. Actual Report for Revenue is a sample report configured to work with budget structure 30 only. The report lists each Revenue Source for a Fund, Department, and Unit combination. Columns exist showing the Current Budget amount as Rev Budget, along with totals for Billed Earned Rev and Collected Earned Rev for both the current period as well as inception-to-date. The report ends with a Difference column showing what would be the difference of the total billed and collected from what was budgeted. Records are displayed with summary totals as rollups are presented at: Fund and Department Fund All budget lines	General Accounting
Encumbrance Activity	The Encumbrance Activity report provides a means of reporting on open encumbrances or all encumbrances. The detail shown includes the encumbrance line amount, how much has been expended, how much has been closed (to reflect over-references and short references totals are then rolled up from the accounting line level to the following: Department, Unit, Appropriation, and Class Department, Unit, and Appropriation Department and Unit Department	General Accounting
Encumbrance Activity 2	The Encumbrance Activity 2 report is an alternative to the Encumbrance Activity report and provides the same level of reporting on open encumbrances or all encumbrances. While retaining the core reporting capabilities of the original, it includes features such as department-specific filtering, report layout changes, and the inclusion of additional COA elements.	General Accounting
Accounting Period Close	The Accounting Period Close report sets the Closing Process Run indication to true on the Accounting Period (APD) page when all activity should cease against that period.	General Accounting
Inbound Interface Reconciliation Report	The Interface Reconciliation Report is a summarization report on the status of transaction Load and Submit of each interface file from the Interface Reconciliation table records that have been populated by a non-Advantage process.	Utilities
Interface Transaction Exception Report	The Interface Transaction Exception Report is a listing of interface transactions that failed to load or submit into the Advantage Financial application.	Utilities
Investment Activity Report	The Investment Activity Report provides a means to validate activity and current balances on the Investment Activity Journal (INVACTV), ensuring they match with those at investment institutions.	Investment
SA01 Report	The SA01 Report is the last job step in the System Assurance 1 chain or the last individual job step when run outside of a chain. The report can list all budget lines or report only those with an accounting amount that is not in sync with historical transaction records.	System Assurance
SA02 Report	The SA02 Report is the last job step in the System Assurance 2 chain or the last individual job step when run outside of a chain. The report can list all records on the three accounting control pages or report only those with an amount that is not in sync with historical transaction records.	System Assurance
SA12 Report	The SA12 Report is the last job step in the System Assurance 12 chain or the last individual job step when run outside of a chain. The report will report only those budget constraint amount records that do not match the respective budget line data.	System Assurance
Transaction Listing	The Transaction Listing report job produces a detailed listing of processed transactions for a selected group of transaction types from a journal specified.	General Accounting
Trial Balance	The Trial Balance report job reads online parameters from the Parameters for Trial Balance page and generates a standard trial balance report.	General Accounting