BD701 Agency Management Budget Report (authorized version)
Report Series Name
C-U-GL-BD701-Auth-Report (agency run report)
C-U-GL-BD701-Auth-Rpt-Pyr (for closed years)
C-GL-BD701-Auth-Report (OSC production report)
Report Name
BD701 Agency Management Budget Report (authorized 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-9 BD701 Auth At Fnd or OSCOP* MOPRE-9 BD701 Auth At Fnd where the * is replaced by C or F depending on which region the agency is located.
Use
Use this report to compare authorized budget and actual activity including quarterly activity and to verify that all transactions have been properly recorded in NCAS. 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 detail account level (11-digits). 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 detail account level (11-digits). Each fund begins on a new page.
Totals
This report lists totals for expenditures and revenues in all report columns.
Column Headings - column/line numbers refer to the sample report layouts
- AUTHORIZED BUDGET - (Column C) 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 - (Column D) lists the disbursements and deposits and the impact on appropriations for the current reporting period. Amounts from 53XXXX and 43XXXX (excluding 439100 - State Appropriations General Fund) account types are included in this column.
- ACTUAL QUARTERLY- (Column E) lists the disbursements and deposits and the impact on appropriations for the current quarter period. Amounts from 53XXXX and 43XXXX (excluding 439100 - State Appropriations General Fund) account types are included in this column
- ACTUAL TO DATE - (Column F) lists the disbursements and deposits and the impact on appropriations year-to-date. Amounts from 53XXXX and 43XXXX (excluding 439100 - State Appropriations General Fund) account types are included in this column.
- BALANCE - (Column G) calculates the difference between the authorized budget and the year-to-date column (Column C minus Column F).
- ENCUMBRANCES - (Column H) lists the obligations from purchase orders, contracts or other encumbrance documents. Amounts from 03XXXX and 83XXXX account types are included in this column.
- UNENCUMBERED - (Column I) lists the difference between the authorized budget and the sum of the balance and encumbrances.
- 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 TO DATE plus ENCUMBRANCES] divided by [AUTHORIZED BUDGET 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 report.
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:
|
Expenditures |
Adjustment to Cash Basis |
|---|---|
|
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 revenue activity to cash basis reporting. Only the following accounts are included in this section:
|
Revenues |
Adjustment To Cash Basis |
|---|---|
|
211200 through 21129999999 |
221900 through 22199999999 |
|
211900 through 21196999999 |
222300 through 22239999999 |
|
211972 through 21199999999 |
222500 through 22259999999 |
|
213200 through 21329999999 |
222600 through 22269999999 |
|
213800 through 21389999999 |
223200 through 22329999999 |
|
214100 through 21419999999 |
224100 through 22419999999 |
|
217000 through 21799999999 |
227000 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, 121260, and 112250.
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 - 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-Auth-Report -Run
000100 Options Library(Glpublic)
000200 Run C-U-Gl-Bd701-Auth-Report; ;
000300 Into Library Xxxxxxxx ;
000400 Variable Period ;
000500 00 ;
000600 Variable Prior-Year-Ind ;
000700 'N' ;
000800 Select Gl-Company-Id ;
000900 'Xxxx'
001100 *Select Gl-Center-Id
001200 *Select Gl-Inter-Lvl-3-Rpt-Center-Id
For closed years, the run statement member name is C-U-GL-BD701-Auth-Rpt-Pyr-Run
000100 Option Date-Option('Mm/Dd/Yyyy')
000200 Run C-U-Gl-Bd701-Auth-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'
Type over the displayed variable values with your agency's values.