Trial Balance (by company) Report

Report Series Name
C-U-GL-COMP-TRIAL-Balance (agency run report)
C-GL-COMP-TRIAL-Balance (OSC production report)

Report Name
Trial Balance (by company)

Library/RMDS Report Group
Source code for agency run report is located in GLPUBLIC library.

This report is also run during the nightly production cycle for the current month and the previous month. Copies of these reports may be found in RMDS groups OSCOP* Mocur-7 BX TOT/TRIAL BAL or OSCOP* Mopre-7 BX TOT/TRIAL BAL where the * is replaced by C or F depending on which region the agency is located.

Beginning July 1 of each year, this report is also run during the nightly production cycle for the period June 1 - June 30 to aid in financial statement preparation. Copies of this report may be found in RMDS group OSCOP* GL EOY TRIAL Balances where the * is replaced by C or F depending on which region the agency is located. Once the Comprehensive Annual Financial Report is complete, nightly updating of this RMDS group is suspended until the next July 1.

Records/Retention Requirements
ITEM 42957.  Trial Balance by Company (C-U-GL-COMP-TRIAL Balance).  General ledger activity.

Disposition Instructions:  Destroy in office after 12 months.

Use
Use this report to review account balances to ensure that NCAS is in balance within a company.

Content
This report contains total debit and credit amounts as well as balances for all accounts located within a company. For asset, liability, equity, and encumbrance accounts which do not close at fiscal year end, the Ending Balance is a life-to-date balance. For expenditure, revenue, budgeted expenditure, and estimated revenue accounts, the Ending Balance is a year-to-date balance.

The run statements allow the user to create this report for any period on either the GL Open Years File (GMP11) or GL Closed Years File (GMP21). Run statement selection criteria also determine the amounts displayed in the Beginning Balance, Debits, and Credit columns. Refer to the run statement section for more information.

The report page breaks as the Company changes.

Totals
This report gives totals for account class (position 1 of account) and company.

Column Headings

  • ACCOUNT NUMBER - lists the account key from the NCAS uniform chart of accounts. While the prior year remains open on the GL Open Years File (GMP11), the calculated closing amount is added to the report under account 39999999999. This account number is for the report display only and is not part of the NCAS uniform chart of accounts.
  • ACCOUNT DESCRIPTION - lists the NCAS description for the associated account number.
  • BEGINNING BALANCE - lists the system balance as of the previous period as determined by the run statement selection variable.
  • DEBITS - lists the sum of the total debit transactions for this account number for the time period specified in the run statements. The detail debit transactions are selected from either the GM331 file or the GH792 file as determined by the run statement variables.
  • CREDITS - lists the sum of the total credit transactions for this account number for the time period specified in the run statements. The detail credit transactions are selected from either the GM331 file or the GH792 file as determined by the run statement variables.
  • Month To Date Net - lists the result of the calculation Debits - Credits
  • ENDING BALANCE - lists the result of the calculation Beginning Balance + Month To Date Net.

Run Statements
The run statement member name is C-U-GL-COMP-TRIAL-BALANCE-RUN.

000010 OPTION LIBRARY(GLPUBLIC)
000020 RUN C-U-GL-COMP-TRIAL-BALANCE ;
000100 INTO LIBRARY XXXXXXXX ;
000200 VARIABLE GL-POSTED-ENT-FILE-VARIABLE ;
000300 'PERIOD' ;
000400 SELECT GL-RUN-TIME-SELECT-DATA ;
000500 'XXXX MM/DD/YY MM/DD/YY'

Type over the displayed variable values with your agencys values.

The GL-POSTED-ENT-FILE-VARIABLE determines the values in the Debits and Credits columns. Valid values for GL-POSTED-ENT-FILE-Variable are as follows:

'CURRENT' - reads the GWP12 file. This file includes detailed transactions for the previous posting only. This value is generally not used.

'PERIOD ' - reads the GM331 file. This file contains detailed transactions posted during the current year and the previous year while it is still on the GL Open Years File (GMP11). The PERIOD value is used when reporting against open years.

The previous year is not closed on NCAS until after final Comprehensive Annual Financial Report adjustments are made. Generally the previous year is closed on NCAS no earlier than February of the next year. When the previous year is closed, the GM331 transactions for that year are purged to the history file (GH792).

'ANNUAL ' - reads the GH792 file. This file contains the detailed transactions purged from the GM331 file. As previous years are closed on NCAS, the GM331 transactions are purged to this file. The ANNUAL value is used when reporting against closed years. NCAS has five closed years available on the GH792 file. In order to run a report against this file, users must have the following statements in their RUN-JCL program.

  • P region : //GH792 DD DSN=OSC.OPC.GL9002.GH792(0),
  • // DISP=SHR
  • NC23 region: //GH792 DD DSN=OSC.OPF.GL9002.GH792(0),
  • // DISP=SHR

This file is on tape and should be commented out of the RUN-JCL program when not needed. Only one user can run against this tape at a time.

GL-RUN-TIME-SELECT-DATA is a selection for companies and time period. The select must be in the format of 'XXXX MM/DD/YY MM/DD/YY' where

  • XXXX = Company ID
  • MM/DD/YY = Beginning Date
  • MM/DD/YY = Ending Date

To report against multiple companies, each company must be listed in a separate statement. The Beginning and Ending Dates for all statements must be the same.

The Beginning and Ending Dates determine the values for the Beginning Balance, Debits, and Credits columns. These dates do not have to include an entire reporting period, but only the Ending Date value is displayed in the report pageheadings.

chart

chart

chart

chart

chart

chart