BD725 Monthly Report on Capital Improvement Funds (sort by center elements version)
Report Series Name
C-U-GL-BD725-CI-RPT-MASK
Report Name
BD725 Monthly Report on Capital Improvement Funds (sort by center elements version)
Library
Source code for agency run report is located in GLPUBLIC library.
Use
Use this report to manage capital improvement project expenditures and revenues at the full center level. The reporting period is each calendar month of the fiscal year.
Content
This report series contains information on current activity, project to date activity, and allotment balances for capital improvement projects (budget code 4XXXX). It is similar to C-U-GL-BD725-CI-REPORT; however, this report series allows the user to view and sort information based all center elements beyond fund (positions 1-4 of center). The sort order variable in the Run Statements determines at what level and in what order the center elements appear on this report. The center mask determines which positions of center compose each center element used in the sort order.
Each project is recorded in a separate fund within the budget code. There are two reports within the series:
Detail Report by Center - reports a summary of allotment, expenditure, and revenue balances by account for each center level within the budget code. Amounts are displayed at the 9-digit account level. Each new center level begins on a new page.
Budget Code Recap - reports a summary of allotment, expenditure, and revenue balances for the budget code.
This report series may be run for closed CI projects, open CI projects, or both open and closed projects.
Totals
This report gives totals for expenditures and revenues in all report columns for each level specified in the sort request.
Column Headings - column/line numbers refer to the sample report layouts
- Total Budget - (Column C) lists the total budget amount for the CI project posted to the detailed center. This amount is calculated as UNALLOTTED (Column D) plus TOTAL ALLOTMENTS (Column E).
- Unallotted - (Column D) lists the accumulated amounts posted to the 78XXXX or 68XXXX accounts for the life of the project. These amounts represent the portion of the CI project budget not yet approved for use by the Office of State Budget and Management on form BD303.
- Total Allotments - (Column E) lists the accumulated amounts posted to the 73XXXX or 63XXXX accounts for the life of the project. These amounts represent the obligations from contracts or other expenditures approved by the Office of State Budget and Management on form BD303.
- Current - (Column F) lists the actual accounting activity posted to the 53XXXX or 43XXXX accounts for the current reporting period.
- Year to Date - (Column G) lists the actual accounting activity posted to the 53XXXX or 43XXXX accounts for fiscal year-to-date.
- Project to Date - (Column H) lists the actual accounting activity posted to the 53XXXX or 43XXXX accounts for the life of the project. This amount is cash based and does not include any amounts posted as accruals to the 13th period.
- Allotment Balance - (Column I) lists the balance of the allotment that is not yet expended nor received. This amount is calculated as Total Allotments (Column E) less Project to Date (Column H).
Row Notes - column/line numbers refer to the sample report layouts
CENTER MASK (Row 4a)- lists the center elements associated with the center displayed.
EXPENDITURES (Line 6) - lists information on budgetary and actual expenditure accounts.
ADJUSTMENT TO CASH BASIS (Line 6A) - lists accounts which are used to adjust expenditure activity to cash basis reporting. Only the following accounts are included in this section:
| Account # | Account # |
|---|---|
| 111210 through 11121099999 | 111220 through 11122099999 |
| 111230 through 11123099999 | 112000 through 11224999999 |
| 113800 through 11389999999 | 112251 through 11299999999 |
| 113931 through 11399999999 | 113900 through 11392999999 |
| 122000 through 12299999999 | 119000 through 11999999999 |
| 124000 through 12499999999 | 129000 through 12999999999 |
| 211970 through 21197199999 | 11R220 |
| 11R121 | 121220 |
REVENUES (Line 7) - lists information on budgetary and actual revenues and contra-expenditure accounts.
ADJUSTMENT TO CASH BASIS (Line 7A) - lists accounts which are used to adjust the revenue activity to cash basis reporting. Only the following accounts are included in this section:
| Account # | Account # |
|---|---|
| 211200 through 21129999999 | 222300 through 22239999999 |
| 211900 through 21196999999 | 222500 through 22259999999 |
| 211972 through 21199999999 | 222600 through 22269999999 |
| 213200 through 21329999999 | 223200 through 22329999999 |
| 213800 through 21389999999 | 224100 through 22419999999 |
| 214100 through 21419999999 | 227000 through 22799999999 |
| 217000 through 21799999999 | 113930 through 11393099999 |
| 221900 through 22199999999 |
EXCESS OF EXPENDITURES OVER REVENUES (Line 8) - lists the amount of expenditures not supported by receipts. If there is no activity in the ADJUSTMENT TO CASH sections (Lines 6A or 7A), this amount is calculated as TOTAL EXPENDITURES less TOTAL REVENUES. If there is activity in the ADJUSTMENT TO CASH sections (Lines 6A or 7A), this amount is calculated as TOTAL CASH EXPENDITURES less TOTAL CASH REVENUES.
LVL # TOTALS - (Row 9) lists total expenses, revenues, and excess of expenditures over revenues for each sort level specified in the run statements.
Run Statements
The run statement member name is C-U-GL-BD725-CI-RPT-MASK-RUN
000100 OPTION LIBRARY(GLPUBLIC)
000200 RUN C-U-GL-BD725-CI-RPT-MASK ;
000300 INTO LIBRARY XXXXXXXX ;
000400 VARIABLE PERIOD ;
000500 00 ;
000600 VARIABLE PRIOR-YEAR-IND ;
000700 'N' ;
000800 VARIABLE CENTER-MASK ;
000900 'FFFFAAAABBCC' ;
001000 VARIABLE SORT-ORDER ;
001100 'FABC ' ;
001200 SELECT GL-COMPANY-ID ;
001300 ('XXXX' 'XXXX') ;
001400 SELECT GL-CENTER-ID ;
001500 ('XXXXXXXXXXXX' 'XXXXXXXXXXXX') ;
001600 SELECT GL-CNTR-STATUS-CODE ;
001700 'X'
Type over the displayed variable values with your agency's values.
Valid values for PRIOR-YEAR-IND are Y or N . Use Y for prior fiscal year balances. Use N for current fiscal year balances.
Valid values for PERIOD are 01, 02, 03, ... 12. ( 01 = July, 02 = August, 03 = September, etc.)
- The CENTER-MASK field indicates the center structure for your agency. It is a twelve byte field. Valid values for positions 1-4 of this field is FFFF. Use A, B, C, D to represent the remaining center elements. Use blanks to fill out the field to twelve bytes. Examples follow:
- Agency Center Structure: Fund/CI Project 4 bytes
- Sub-project 4 bytes
- blanks 4 bytes
- ---------
- 12 bytes
The CENTER-MASK field should be 'FFFFAAAA '
- The SORT-ORDER field is a five byte field in which you indicate the order for the report to be sorted. Valid values to represent the center elements are F, A, B, C, D. Use blanks to fill out the field to five bytes. Examples follow:
- Agency Center Structure: Fund/CI Project 4 bytes Level F
- Sub-project 4 bytes Level A
- blanks 4 bytes
- ---------
- 12 bytes
- To sort report by Sub-project with Fund/CI Project, the SORT-ORDER field should be FA
Valid values for GL-CNTR-STATUS-CODE are 0 or 1. Use 0 to report only open CI projects accounting distributions. Use 1 to report only closed CI project accounting distributions. Comment out the selection and value statements to report both open and closed CI project accounting distributions.