BD800SUM Cash Reconciliation Report (summary)

Report Name
BD800SUM Cash Reconciliation Report (summary)

Report Series-Group Name
C-U-GL-CASH-RECON-BD800 (agency run report) or
C-GL-CASH-RECON-BD800 (OSC production report)

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

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

Records/Retention Requirements
ITEM 42975.  Cash Reconciliation Report Summary (BD800SUM).  General ledger activity.

DISPOSITION INSTRUCTIONS:  Destroy in office after 12 months.

Use
Use this report to agree the total current month, quarterly, and year-to-date receipts and disbursements to the Cash Management and Control System (CMCS).

This report series 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. This program cannot be run against the first reporting period of the prior fiscal year.

Content
This report series includes two reports: BD800SUM and BD800DET. All Budget codes are included in the report series.

BD800SUM - lists total Receipts and Disbursements for the Current Month, Quarter to Date, and Year to Date for each budget code.

BD800DET - lists the period beginning balance for the appropriate pooled cash account for the budget code and detailed information about cash transactions processed through the pooled cash allotment account for the current reporting period. The detail information listed includes entries for allotments/reversions, disbursements, receipts, transfers and other cash transactions. Each new budget code begins on a new page.

Totals
not applicable

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

  • Budget Code - (column A) lists the budget code number.
  • Title - (column B) lists the budget code title.
  • Current Receipts - (Column C) lists total receipts for the current reporting period. This amount should agree to the total of the Deposits/ Transfers/ Adjustments column on the BD800DET report.
  • Current Disbursements - (Column D) lists total disbursements for the current reporting period. This amount should agree to the total of the Disbursements/ Transfers/ Adjustments column on the BD800DET report.
  • Quarterly Receipts - (Column E) lists total receipts for the current quarterly reporting period.
  • Quarterly Reimbursements - (Column F) lists total disbursements for the current quarterly reporting period.
  • Year To Date Receipts - (Column G) lists the total year-to-date receipts.
  • YEAR To Date Disbursements - (Column H) lists the total year-to-date disbursements.

Run Statements
The run statement member name is C-U-GL-CASH-RECON-BD800-RUN.

000100 OPTION LIBRARY(GLPUBLIC)
000200 RUN C-U-GL-CASH-RECON-BD800 ;
000300 INTO LIBRARY XXXXXXX ;
000400 VARIABLE CURRENT-YEAR-IND ;
000500 'Y' ;
000600 VARIABLE PARM-PERIOD ;
000700 00 ;
000800 VARIABLE PARM-YEAR ;
000900 0000 ;
001000 SELECT C-GL-COMPANY-ID ;
001100 'XXXX' ;
001200 REPORT BD800-01 ;
001300 *SELECT BUDGET-CODE ;
001400 REPORT BD800-02
001500 *SELECT BUDGET-CODE

Type over the displayed variable values with your agency’s values.

Run Statement Notes
This report series cannot be run for July of the prior year (CURRENT-YEAR-IND variable is set to ‘N’ and PARM-PERIOD set to 01). Call the OSC Helpdesk for assistance.

PARM-PERIOD - a two digit number that represents the report month where July = 01, August = 02, etc.

PARM-YEAR - a four digit number that represents the fiscal year for which the report is being run. This variable is used to select the appropriate titles and budget codes from the TM700 Miscellaneous Descriptions file.

REPORT BD800-01 - is the BD800SUM report.

REPORT BD800-02 - is the BD800DET report.

SELECT BUDGET-CODE - to run the report for a particular budget code or series of budget codes, uncomment the statement and add a line that lists the desired budget codes. 

BD800Sum Example