BD701 Authorized Monthly Budget Report - Org Mask

Report Series Name
C-U-GL-BD701-Org-Rpt-Mask
C-U-GL-BD701-Org-Rpt-Mask-PY (for closed years)

Report Name
BD701 Authorized Monthly Budget Report (sort by center elements version)

Library
Source code is located in GLPUBLIC library.

Use
Use this report to compare budget and actual activity and to verify that all transactions have been properly recorded in NCAS to the center level. 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. It is similiar to C-U-GL-BD701-AUTH-REPORT; however, this report series allows the user to view and sort information based all center elements beyond fund (positions 1-4 of center). Each budget code within an agency is reported separately. All budget code types except Capital Improvement codes (4XXXX) are included in this report series.

The sort order variable in the Run Statements determines at what level and in what order the centers appear on this report. The center mask determines which positions of center compose each center element used in the sort order. Accounts are displayed at the full 9-digit detail account number. A Grant Year variable in the Run Statements allows the user to produce an additional sort by positions 10-11 of the account number.

Totals
This report gives totals for expenditures and revenues in all report columns as well as grand totals for each center element sort.

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

CENTER MASK (Line 5a)- lists the center elements associated with the center displayed.

GRANT YEAR (Line 5b)- lists the grant year from the 10th and 11th digit of account. Grant year is used as a sort only when SORT-BY-GRANT-YEAR-IND is set to Y in the run statements. Otherwise all grant year accounts will be summarized at the 9-digit account level.

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:
 
 

 
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:
 
 

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.

Run Statements
The run statement member name is C-U-GL-BD701-Org-Rpt-Mask-Run

000100 Option Library(Glpublic)
000200 Run C-U-Gl-Bd701-Org-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 'Fabcd' ;
001200 Variable Sort-By-Grant-Year-Ind ;
001300 'N' ;
001400 Select Gl-Company-Id ;
001500 'Xxxx' ;
001600 Select Gl-Center-Id ;
001700 'XXXXXXXXXXXX'

For closed years, the run statement member name is C-U-GL-BD701-Org-Rpt-Mask-PY-R

000100 Option Date-Option('Mm/Dd/Yyyy')
000200 Run C-U-Gl-Bd701-Org-Rpt-Mask-Py ;
000300 From Library Glpublic ;
000400 Into Library Xxxxxxxx ;
000500 Variable Period ;
000600 00 ;
000700 Variable Center-Mask ;
000800 'Ffffaaaabbcc' ;
000900 Variable Sort-Order ;
001000 'Fabcd' ;
001100 Variable Fiscal-Year ;
001200 9999 ;
001300 Variable Sort-By-Grant-Year-Ind ;
001400 'N' ;
001500 Select Gl-Company-Id ;
001600 'Xxxx' ;
001700 Select Gl-Center-Id ;
001800 'XXXXXXXXXXXX'

Type over the displayed variable values with your agency’s values. C-Center-Mask is a 12 character variable representing your agency's center structure. The first level is fund and is represented by 'F'. The second level is represented by 'A'; the third level is represented by 'B'; the fourth level is represented by 'C', the fifth level is represented by 'D'. Use spaces to represent positions your agency does not use. The Variable Sort Order must be 5 digits, spaces allowed, for center descriptions to appear on the report.