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