BD800DET Cash Reconciliation Report (detail)

Report Name
BD800DET Cash Reconciliation Report (detail)

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 42974.  Cash Reconciliation Report Detail (BD800DET).  General ledger activity.

DISPOSITION INSTRUCTIONS:  Destroy in office after 12 months.

Use
Use this report series to verify and reconcile agency allotment, disbursement, receipt, and other cash transactions and balances on the General Ledger to the Cash Management Control System (CMCS). Also, use this series to verify that the year-to-date pooled cash account balances reported on the General Ledger are correct. The pooled cash accounts displayed on the report depend on the budget code and includes the Cash Disbursement Account (111250) and one of the following: General Fund Revenue Account (111240), Budget Code Cash (sum of 111260, 11R260, 121260, 112250), or Cash in Allotment Account (sum of 111270, 11R270, 121270).

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
The BD800DET report includes totals for all amount columns: Allotment/Reversion; Deposits/Transfers Adjustments; Disbursements/Transfers Adjustments; and Other. It also calculates the Ending Cash Balance amount.

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

EFFECTIVE DATE - (Column A) lists the GL effective date of the posted transaction.

DOCUMENT ID - (Column B) lists the BC document ID of the posted transaction.

TRANSACTION DESCRIPTION - (Column C) lists the transaction description from Description Field 1 on the BC document.

ALLOTMENT/REVERSION - (Column D) lists the amount posted to the appropriate pooled cash account using a BC document ID type 17 (Quarterly Allotment/Reversion/Revision).

DEPOSITS/TRANSFERS/ADJUSTMENTS - (Column E) lists the amount posted to the appropriate pooled cash account using the BC document ID types:

  • 21 - Cash Receipts
  • 23 - Cash Receipts Accrual
  • 25 - Cash Transfer In - Deposits
  • 28 - Cash Adjustment Automatic Entry (debit side only)
  • 29 - Cash Adjustment Entry (credit side only).

DISBURSEMENTS/TRANSFERS/ADJUSTMENTS - (Column F) lists the amount posted to the appropriate pooled cash account using the BC document ID types:

  • 22 - Cash Requisitions
  • 24 - Cash Certification
  • 27 - Cash Transfer Out-Disbursements
  • 28 - Cash Adjustment Automatic Entry (credit side only)
  • 29 - Cash Adjustment Entry (debit side only)

OTHER - (Column G) lists the amount posted to the pooled cash account using any other BC document ID types not specified in columns D, E, or F.

BALANCE - (Column H) lists the beginning balance of the pooled cash account and calculates the Ending Cash Balance.

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

BEGINNING BALANCE - (Line 6) lists the beginning balance posted to the pooled cash accounts, including the current restricted and non-current account versions, for the current reporting period (ending balance of prior reporting period). 19XXX budget codes display account 111240 balances. All other 1XXXX budget codes display the total of accounts 111270, 11R270, and 121270. For other non-general fund budget codes, the displayed value is the total of accounts 111260, 11R260, 121260 and 112250.

TRANSACTIONS - (Line 7) lists the detailed transactions posted to the pooled cash account. The pooled cash account listed is based on the budget code. 19XXX budget codes display account 111240. All other 1XXXX budget codes display accounts 111270, 11R270, and 121270. For other non-general fund budget codes, the accounts are 111260, 11R260, 121260, and 112250.

PERIOD BALANCE - (Line 8) calculated by subtracting the sum of the transactions from the beginning balance.

ENDING Balance Disbursing Account - (Line 9) lists the General Ledger ending balance of the disbursing account 111250. During the monthly certification process, the balance of this account should be zero.

ENDING Balance Pooled Cash Account - (Line 10) lists the General Ledger ending balance account of the pooled cash accounts appropriate for that budget code. 19XXX budget codes display account 111240 balances. All other 1XXXX budget codes display the total of accounts 111270, 11R270, and 121270. For other non-general fund budget codes, the displayed value is the total of accounts 111260, 11R260, 121260, and 112250.

ENDING CASH BALANCE - (Line 11) calculated as Ending Balance Disbursing Account (Line 9) plus Ending Balance Pooled Cash Account (Line 10). This calculation also should equal the Period Balance calculation (Line 8).

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. 

BD800DET example