BD725 Monthly Report on Capital Improvement Funds
Report Series Name
C-U-GL-BD725-CI-REPORT (agency run report) or
C-GL-BD725-CI-REPORT (OSC production report)
Report Name
BD725 Monthly Report on Capital Improvement Funds
Library
Source code for agency run report is located in GLPUBLIC library.
Report is also run during the nightly production cycle for the current month and the previous month. Copies of these reports may be found in Systemware groups OSCOP* MOCUR-4 BD725 REPORTS or OSCOP* MOPRE-4 BD725 REPORTS where the * is replaced by C or F depending on which region the agency is located.
Records/Retention Requirements
ITEM 42840. Monthly Report on Capital Improvement Funds (C-GL-BD725-CI-REPORT). Monthly budget reports.
DISPOSITION INSTRUCTIONS: Destroy in office when released from all audits.
Use
Use this report to manage capital improvement project expenditures and revenues. This report is part of the required month-end report package that is submitted to the appropriate central management agencies. 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). Each project is recorded in a separate fund within the budget code. There are two reports within the series:
Detail Report by Fund - reports a summary of allotment, expenditure, and revenue balances by account for each fund within the budget code. Amounts are displayed at the 9-digit account level. Each fund 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. The OSC produced versions of this report series that are available in RMDS are run only for open CI projects.
Totals
This report gives totals for expenditures and revenues in all report columns.
Column Headings - column/line numbers refer to the sample report layouts
- Total Budget - (Column C) lists the total budget amount for the CI project which should agree to the Budget Certification (BC306) amount including any budget revisions (BD606). 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
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 Codes | Account Codes |
|---|---|
| 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 Codes | Account Codes |
|---|---|
| 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.
Run Statements
The run statement member name is C-U-GL-BD725-CI-REPORT-RUN
000100 OPTION LIBRARY(GLPUBLIC)
000200 RUN C-U-GL-BD725-CI-REPORT ;
000300 INTO LIBRARY XXXXXXXX ;
000400 VARIABLE PERIOD ;
000500 00 ;
000600 VARIABLE PRIOR-YEAR-IND ;
000700 'N' ;
000800 SELECT GL-COMPANY-ID ;
000900 'XXXX' ;
001000 'XXXX' ;
001100 'XXXX' ;
001200 SELECT GL-CENTER-ID ;
001300 'XXXXXXXXXXXX' ;
001400 SELECT GL-CNTR-STATUS-CODE ;
001500 '0'
Type over the displayed variable values with your agencys 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.)
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.
