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:
|
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:
|
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:
|
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 |