BD701 Agency Management Budget Report (certified version)

Report Series Name 

C-U-GL-BD701-CERT-REPORT (agency run report) or 
C-U-GL-BD701-CERT-RPT-PYR (for closed years) 
C-GL-BD701-CERT-REPORT (OSC production report) 
 

Report Name 
BD701 Agency Management Budget Report (certified version)

Library 
Source code for agency run report is located in GLPUBLIC library.

Report is also run during the nightly production cycle for the current or previous month. Copies of these reports may be found in Systemware groups OSCOP* MOCUR-1 BD701 REPORTS or OSCOP* MOPRE-1 BD701 REPORTS where the * is replaced by C or F depending on which region the agency is located.

Records/Retention Requirements 
ITEM 42837.  Agency Management Budget Report (C-GL-BD701-CERT-REPORT).  Monthly budget reports.

DISPOSITION INSTRUCTIONS:  Destroy in office when released from all audits.

Use 
Use this report to compare budget and actual activity and to verify that all transactions have been properly recorded in NCAS. 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 expenditure, revenues, and changes in appropriation balances for both budgeted and actual activity. Each budget code within an agency is reported separately. All budget code types except Capital Improvement codes (4XXXX) are included in this report series. There are four reports within the series, each successive report displaying more detailed information than the previous report.

Budget Code Recap - reports a budget code level summary of total budgeted and actual expenditures, revenues, and fund (or appropriation) balances. Each budget code begins on a new page.

Summary by Purpose - reports a summary of the total budgeted and actual expenditures and revenues balances by the first four positions of the center within the budget code. The first four positions of the center is the fund (purpose) code. Each budget code begins on a new page.

Summary by Account - reports a summary of the total budgeted and actual expenditures and revenues balances by the account number within each budget code. All amounts are summarized and displayed at the 6-digit certification account level. Each budget code begins on a new page.

Detail Report by Fund - reports a summary of the total budgeted and actual expenditures and revenues balances by account for each fund within the budget code. All amounts are summarized and displayed at the 6-digit certification account level. Each fund begins on a new page.

Totals 
The report lists totals for expenditures and revenues in all report columns.

Column Headings - column/line numbers refer to the sample report layouts

  • BUDGETED CERTIFIED - (Column C) lists the appropriation amounts as shown on the Budget Certification form BD 307 adjusted for any type 11XXXX budget revisions. Amounts from 78XXXX and 68XXXX account types are included in this column.
  • BUDGETED AUTHORIZED - (Column D) lists the appropriation amounts as shown on Budget Certification form BD 307 adjusted for any type 11XXXX, 12XXXX and 14XXXX budget revisions. Amounts from 73XXXX and 63XXXX account types are included in this column.
  • ACTUAL CURRENT-MONTH - (Column E) lists the disbursements and deposits and the impact on appropriation for the current reporting period. Amounts from 53XXXX and 43XXXX account types (excluding 439100 - State Appropriations General Fund) are included in this column.
  • ACTUAL YEAR-TO-DATE - (Column F) lists the disbursements and deposits and the impact on appropriation year-to-date. Amounts from 53XXXX and 43XXXX  (excluding 439100 - State Appropriations General Fund) account types are included in this column.
  • UNEXPENDED/UNREALIZED CERTIFIED - (Column G) calculates the difference between the certified budget and the year-to-date column (Column C minus Column F).
  • UNEXPENDED/UNREALIZED AUTHORIZED - (Column H) calculates the difference between the authorized budget and the year-to-date column (Column D minus Column F).
  • ENCUMBRANCE - (Column I) lists the obligations from purchase orders, contracts or other encumbrance documents. Amounts from 03XXXX and 83XXXX account types are included in this column.
  • RATE - (Column J) is the annual projected rate of expenditures or revenues based on the year-to-date fiscal activity. This amount is calculated as [ACTUAL YEAR-TO-DATE plus ENCUMBRANCE ] divided by [BUDGETED AUTHORIZED times (report period number/12)]

Row Notes - column/line numbers refer to the sample report layouts

Expenditures (Line 7) - lists information on expenditures for the current reporting period. There are subtotals for the major expenditure categories on the Summary by Account and Detail Report by Fund reports.

Adjustment to Cash Basis (Line 7A) - lists accounts that adjust expenditure activity to cash basis reporting. Only the following accounts are included in this section: 
  
 

Account Codes Account Codes

111210 through 11121099999

113931 through 11399999999

111220 through 11122099999

119000 through 11999999999

111230 through 11123099999

122000 through 12299999999

112000 through 11224999999

124000 through 12499999999

112251 through 11299999999

129000 through 12999999999

113800 through 11389999999

211970 through 21197199999

113900 through 11392999999

11R220

11R121  

121220 

Revenues (Line 8) - lists information on revenues and contra-expenditure accounts for the current reporting period.

Adjustment to Cash Basis (Line 8A) - lists accounts that adjust the revenue activity to cash basis reporting. Only the following accounts are included in this section:  

Account Codes Account codes

2112 through 21129999999

2219 through 22199999999

2119  through 21196999999

2223 through 22239999999

211972 through 21199999999

2225 through 22259999999

2132 through 21329999999

2226 through 22269999999

2138 through 21389999999

2232 through 22329999999

2141 through 21419999999

2241 through 22419999999

2170 through 21799999999

2270 through 22799999999

113930 through 11393099999

 

Appropriation or Increase/(Decrease) in Fund Balance (Line 9) - lists information on the appropriation or fund balance for the current reporting period. The "Appropriation" title displays for a general fund budget code (1XXXX). Otherwise, the "Increase/(Decrease) in Fund Balance" title displays.

CASH ANALYSIS (Line 10) - calculates the year-to-date ending cash balance for non-general fund budget codes. Non-general fund budget codes are those other than 1XXXXX type codes. Amounts display in the Year-to-Date column (Column F). This section includes the following components:

Beginning Balance - lists the sum of the prior fiscal year June 30 balance for the Budget Code Cash Accounts: 111260, 11R260, and 121260.

Cash Receipts - lists the total of all revenues and adjustments. This amount equals the Total Cash Revenues line.

Cash Disbursements - lists the total of all expenditures and adjustments. This amount equals the Total Cash Expenditures line.

Assets - lists the total of all Asset (1XXXXX) accounts not otherwise included as an Adjustment to Cash and excluding the following additional accounts: 111120, 11R120, 111130, 11R130, 111240 (199XX budget codes only) 111250, 111260, 11R260, 112250, 121260, 111270, 11R270, and 121270. This total should match the sum of all Asset accounts included in the Increase/Decrease in Assets/Liabilities/Equity section on the BD702 report.

Liabilities - lists the total of all Liability (2XXXXX) accounts not otherwise included as an Adjustment to Cash. This total should match the sum of all Liability accounts included in the Increase/Decrease in Assets/Liabilities/Equity section on the BD702 report.

Equity - lists the total of the following Equity accounts: 310000, 311000, 321101, 321102, 321105, 321198, 331910, 331920, 340000, 390000. This total should match the sum of all Equity accounts included in the Increase/Decrease in Assets/Liabilities/Equity section on the BD702 report.

Ending Balance - lists the results of the following calculation: Beginning Balance plus Cash Receipts minus Cash Disbursements plus Assets plus Liabilities plus Equity. This amount should equal the Ending Cash in Budget Code amount on the BD702 report.

ADDITIONAL ASSETS (Line 11) - lists the prior year June 30 balances for the following accounts: 112000 through 11299999999, excluding 112300 and 112250; 11R121; and 122000 through 12299999999.

TOTAL AVAILABILITY (Line 12) - lists the results of the following calculation: Ending Balance plus Total Additional Assets. This amount represents how much cash an agency would have available if investments are liquidated.

Run Statements 
The run statement member name is C-U-GL-BD701-CERT-REPORT-RUN

000100 OPTION LIBRARY(GLPUBLIC) 
000200 RUN C-U-GL-BD701-CERT-REPORT ; 
000300 INTO LIBRARY XXXXXXXX ; 
000400 VARIABLE PERIOD ; 
000500 00 ; 
000600 VARIABLE PRIOR-YEAR-IND ; 
000700 'N' ; 
000800 SELECT GL-COMPANY-ID ; 
000900 ('XXXX' 'XXXX') 
001000 *SELECT GL-CENTER-ID ; 
001100 * 'XXXXXXXXXXXX' ; 
001200 *SELECT GL-INTER-LVL-3-RPT-CENTER-ID ; 
001300 * 'XXXXXXXXXXXX'

For closed years, the run statement member name is C-U-GL-BD701-CERT-RPT-PYR-RUN

000100 OPTION DATE-OPTION('MM/DD/YYYY') 
000200 RUN C-U-GL-BD701-CERT-RPT-PYR; 
000300 FROM LIBRARY GLPUBLIC ; 
000400 INTO LIBRARY XXXXXXXX ; 
000500 VARIABLE PERIOD ; 
000600 XX ; 
000700 VARIABLE WK-FISCAL-YEAR ; 
000800 XXXX ; 
000900 SELECT GL-COMPANY-ID ; 
001000 'XXXX' ; 
001100 SELECT GL-CENTER-ID ; 
001200 'XXXXXXXXXXXX'

Examples:

bd701 example

BD701 example

BD701 example