Working Trial Balance Report

Report Series Name
C-U-GL-Trial-Balance-Work

Report Name
Working Trial Balance

Library
Source code is located in GLPUBLIC

Use
Use this report as a worksheet to review general ledger balances at the detail center level and to manually post accrual adjusting entries.

Content
This report contains the year-to-date balances as of June 30 (13th period) as of the report run date for all account/center combinations. The report is sorted by center within account within company. Each unique company number begins on a new page.

Totals
This report gives totals by account.

Column Headings

  • ACCOUNT - lists the account number and title. Centers used with the account are listed below the account number.
  • BEGINNING BALANCE - lists the account/center balance as of June 30 (13th period) of the prior year.
  • ENDING BALANCE - lists the current years June 30th balance (13th period) as of the report run date.
  • ADJUSTMENTS DEBITS CREDITS - a blank column used to write in accrual adjustment amounts>
  • REVENUE/EXPENDITURE DEBITS CREDITS - a blank column used to write in accrual adjustments to revenue/expenditure accounts
  • Balance Sheet Debits Credits - a blank column used to write in accrual adjustments to balance sheet accounts

Run Statements
The run statement member name is C-U-GL-Trial-Balance-Work-Run

000100 Options Library(Glpublic)
000200 Run C-U-Gl-Trial-Balance-Work ;
000300 Into Library Xxxxxxxx ;
000400 Variable Fiscal-Year-Ending-Date ;
000500 '00/00/00' ;
000600 Select Gl-Company-Id ;
000700 ('Xxxx' 'Xxxx')

Type over displayed values with your agency's values.

Complete the FISCAL-YEAR-ENDING-DATE variable with the 13th period ending date (06/30/YY) for the current fiscal year. This variable is used as part of the report heading only. It is not used as selection criteria. This report can only be produced for the current years 13th period as of the report run date.