Working Trial Balance (at certified fund level) Report

Report Series Name
C-U-GL-WTB-CERT-LVL

Report Name
Working Trial Balance (at certified fund level)

Library
Source code is located in GLPUBLIC

Use
Use this report as a worksheet to review general ledger balances at the certified fund 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 account/fund combinations. Only account types 1-5 are included. The report is sorted by center within account within company/fund combinations. Each unique company/fund combination begins on a new page.

Totals
This report gives totals by accounts and funds.

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-WTB-CERT-LVL-RUN

000100 OPTIONS LIBRARY(GLPUBLIC)
000200 RUN C-U-GL-WTB-CERT-LVL ;
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 agencys 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.