DAFR8170

DAFR8170 - TRIAL BALANCE BY GENERAL LEDGER CATEGORY
Report Documentation
December 9, 1991

PURPOSE

The purpose of the DAFR8170 is for general ledger control by providing the monthly balances by general ledger category. This report is used to balance financial statements.

DESCRIPTION

For each general ledger account within the fund type and general ledger category, the description, beginning balance, debits, credits, ending balance and debit/credit indicator are displayed. The "beginning balance" is the year-to-date balance at the beginning of the month requested; the amounts shown for the "debits" and "credits" are the actual amounts debited or credited to the general ledger account during the month requested; the "ending balance" is computed from the "beginning balance," "debits" and "credits."
The report page breaks by fund group, division and agency, as appropriate.
The DAFR8170 is sorted by fund type, fund group, general ledger category, general ledger class and general ledger account, as appropriate.
This report totals the beginning balance, debits, credits and ending balance by general ledger category, fund group, fund type and agency. The report is grand totaled.

DATA SOURCE

General Ledger File

REQUIRED REPORT OPTIONS

Period

CM -	Current month - The report will display cumulative month-to-date information through the day in the current month for which the report is generated. This option is used for daily reports to monitor the current month as it progresses.
PM -	Prior month - The report will display cumulative month-to-date information through the end of the prior month.

Organization Level

0 -	No organization level sort - Information will be displayed without agency or division detail breaks. This would primarily be used at the central level to obtain information statewide without agency breaks.
1 -	Agency sort - Information will be displayed by agency with agency page breaks and totals.

Object Level

0 -	General ledger category sort - Information will be displayed by general ledger category with totals by general ledger category.
1 -	General ledger class sort - Information will be displayed by general ledger category and class with totals by general ledger category and class.
2 -	General ledger account - Information will be displayed by general ledger category, class and account with totals by general ledger category and class.

Fund

0 -	Fund type sort - Information will be displayed by fund type with page breaks and totals for each fund type.
1 -	Fund group sort - Information will be displayed by fund type and group with page breaks and totals for each fund type and group.
2 -	Fund sort - Information will be displayed by fund type, group and fund with page breaks and totals for each fund type and group.
3 -	Fund detail sort - Information will be displayed by fund type, group, fund and fund detail with page breaks and totals for each fund type and group.

Special Selection 1

Fund Code - The report will be limited to the fund specified.

All - The report will contains all funds, as appropriate.

Generate Date

Specific - (MMDDYY format) The report will be generated once, on the specific date specified. The date must be either the current date or a valid future date.

Daily - The report will generate each day the system is cycled.

Month - The report will generate when the monthly reports are printed after the close of the month.

COMMENTS

This report is requestable by agencies.
If an agency wants to monitor both months during concurrent processing periods, a separate daily report request for the prior month must be established on the first working day of the new month. This request should be deleted as soon as the prior month has been closed. If the request is not deleted, the agency will continue to receive the prior month report even though the data will not be changing.