Reporting Requirements for Annual Financial Reports of State Agencies and Universities
USAS
Ordering USAS Financial Reports
DAFR8920 General Ledger Fund Detail Trial Balance
Report Request Example:
To request the DAFR8920 at the fund level (D23) and comptroller GL account level (D31), set up the report request as shown below. This is the fund level at which system clearing (GL 9999) must equal zero.
TEXAS S091 UNIFORM STATEWIDE ACCOUNTING SYSTEM MM/DD/YY 02:41 PM
LINK TO: REPORT REQUEST PROFILE PROD
ACTION: A (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
AGENCY: XXX REQUESTOR: JDOE REPORT ID: DAFR8920 REQUEST NO: 01
APPN YEAR: PERIOD: 13 FY: CY FREQUENCY: MMDDYYYY
LEVEL - ORG: 2 PROGRAM: OBJECT: FUND: 4 NACUBO FUND: 0 GL ACCT: 3
GRANT: PROJECT:
AGENCY GROUP: CONFIDENTIAL INFO: N ( P,T,B,N )
SPECIAL SELECTS -
AGENCY: XXX ORG CODE:
PROGRAM CODE: NACUBO FUND:
APPROP FUND: FUND:
COMP OBJECT: AGY OBJECT:
GL ACCT: AGY GL ACCT:
GRANT: PROJECT:
SPEC SEL 1: C SPEC SEL 2: G
LST RUN DATE: LINES: STATUS CODE: A
EFF START DATE: 08011996 EFF END DATE: LAST PROC DATE:
Z01 RECORD SUCCESSFULLY ADDED
PLEASE ENTER FUNCTION
F1-HELP F3-END F4-INTERRUPT F6-PROCESS
To request this report at the fund level (D23) and agency GL account level (D32), request the report at fund level 4 and GL account level 4.
USAS Tip
When the SPEC SEL 1 field is left blank, the debit and credit columns of the report displays activity
for the selected month. Enter C in the SPEC SEL 1 field to obtain cumulative year-to-date activity. Enter G in the SPEC SEL 2 field to run the report by GAAP reporting structure.
Attention: The DAFR8930—General Ledger Detail report provides transaction code level detail by GL account. More specifics about this DAFR’s features can be found by viewing the Report Control Profile (D64) screen and News/Help Table (90) screen, or referring to the USAS Reports Guide.
Report Request Examples:
To request the DAFR8920 at the GAAP fund level (D24) and comptroller GL account level (D31), set up the report request as shown below. A report requested at this fund level should agree with the combining statement in the AFR.
TEXAS S091 UNIFORM STATEWIDE ACCOUNTING SYSTEM MM/DD/YY 02:44 PM
LINK TO: REPORT REQUEST PROFILE PROD
ACTION: A (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
AGENCY: XXX REQUESTOR: JDOE REPORT ID: DAFR8920 REQUEST NO: 02
APPN YEAR: PERIOD: 13 FY: CY FREQUENCY: MMDDYYYY
LEVEL - ORG: 2 PROGRAM: OBJECT: FUND: 3 NACUBO FUND: 0 GL ACCT: 3
GRANT: PROJECT:
AGENCY GROUP: CONFIDENTIAL INFO: N ( P,T,B,N )
SPECIAL SELECTS -
AGENCY: XXX ORG CODE:
PROGRAM CODE: NACUBO FUND:
APPROP FUND: FUND:
COMP OBJECT: AGY OBJECT:
GL ACCT: AGY GL ACCT:
GRANT: PROJECT:
SPEC SEL 1: C SPEC SEL 2: G
LST RUN DATE: LINES: STATUS CODE: A
EFF START DATE: 08011996 EFF END DATE: LAST PROC DATE:
Z01 RECORD SUCCESSFULLY ADDED
PLEASE ENTER FUNCTION
F1-HELP F3-END F4-INTERRUPT F6-PROCESS
To request the DAFR8920 at the GAAP fund type level (D21) and comptroller GL account level (D31), set up the report request as shown below. A report requested at this fund level should agree with the combined statement in the AFR.
TEXAS S091 UNIFORM STATEWIDE ACCOUNTING SYSTEM MM/DD/YY 02:47 PM
LINK TO: REPORT REQUEST PROFILE PROD
ACTION: A (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
AGENCY: XXX REQUESTOR: JDOE REPORT ID: DAFR8920 REQUEST NO: 03
APPN YEAR: PERIOD: 13 FY: CY FREQUENCY: MMDDYYYY
LEVEL - ORG: 2 PROGRAM: OBJECT: FUND: 2 NACUBO FUND: 0 GL ACCT: 3
GRANT: PROJECT:
AGENCY GROUP: CONFIDENTIAL INFO: N ( P,T,B,N )
SPECIAL SELECTS -
AGENCY: XXX ORG CODE:
PROGRAM CODE: NACUBO FUND:
APPROP FUND: FUND:
COMP OBJECT: AGY OBJECT:
GL ACCT: AGY GL ACCT:
GRANT: PROJECT:
SPEC SEL 1: C SPEC SEL 2: G
LST RUN DATE: LINES: STATUS CODE: A
EFF START DATE: 08011996 EFF END DATE: LAST PROC DATE:
Z01 RECORD SUCCESSFULLY ADDED
PLEASE ENTER FUNCTION
F1-HELP F3-END F4-INTERRUPT F6-PROCESS
The sample report below depicts how the data in the DAFR8920 report is presented when requested at the fund level (D23) and comptroller GL account level (D31).
DAFR8920 02 13 FND1 RJE 2(ORG) ( ) ( ) 4(FND) 0(NAC) 3(GLA) ( ) ( ) USAS CYCLE: MM/DD/YY 23:52 3898 RUN DATE: MM/DD/YY TIME: 01:23 31 CFY: CY CFM: 10 LCY: PY LCM: CY FICHE: XXX (AGY) XXX (ORG) (PRG) (NAC) (APP) (FND) (COB) (AOB) (GL A) (AGL) (GRT) (PRJ) (SS1)C (SS2)G COMPTROLLER - STATE FISCAL (XXX) GENERAL LEDGER FUND DETAIL TRIAL BALANCE REPORT PERCENT OF YEAR ELAPSED: 100% REPORT PERIOD= ADJUSTMENT FY= CY PROD SYSTEM **************************************************************************************************************************PAGE 1 GAAP FUND GROUP GAAP FUND TYPE GAAP FUND FUND 0003 TITLE NOT ON FILE ************************************************************************************************************************************ GP GAP COMP GL AGY GL GLA GL NRM GL CT CLS ACCT BAL ACCT TC TITLE BEGINNING BALANCE DEBIT CREDIT ENDING BALANCE ************************************************************************************************************************************ 01 004 0045 D 403 CASH TRANSFER-IN 47,956.21 .00 .00 47,956.21 404 CASH TRANSFER-OUT 47,653.28- .00 .00 47,653.28 691 FACTS - COLLECTION OF REV 302.93- .00 .00 302.93 *COMP GL ACCT 0045 CASH IN STATE TREASURY .00 .00 .00 .00 01 004 0047 D 628 GENERIC DEBIT ACT-TRANSFE 47,653.28 .00 .00 47,653.28 629 GENERIC CREDIT ACT-TRANSF 47,956.21- .00 .00 47,956.21 644 REAL GL DEBIT ACTIVITY-GE 908.79 .00 .00 908.79 645 REAL ACCOUNT CREDIT ACTIV 605.86- .00 .00 605.86 *COMP GL ACCT 0047 SHARED CASH .00 .00 .00 .00 01 004 0048 D 629 GENERIC CREDIT ACT-TRANSF .00 .00 .00 .00 *COMP GL ACCT 0048 LEGISLATIVE CASH .00 .00 .00 .00 *GLA CLASS 004 CA CASH IN STATE TREASURY .00 .00 .00 .00 *GL ACCT CAT 01 CURRENT ASSETS .00 .00 .00 .00 51 620 2240 C 009 ADJUST REVENUE BUDGET .00 .00 .00 .00 350 CLOSE REV/EXP SUMMARY DR .00 .00 .00 .00 351 CLOSE REV/EXP SUMMARY CR .00 .00 .00 .00 403 CASH TRANSFER-IN 47,956.21- .00 .00 47,956.21 404 CASH TRANSFER-OUT 47,653.28 .00 .00 47,653.28 628 GENERIC DEBIT ACT-TRANSFE 47,653.28- .00 .00 47,653.28 629 GENERIC CREDIT ACT-TRANSF 47,956.21 .00 .00 47,956.21 644 REAL GL DEBIT ACTIVITY-GE 302.93 .00 .00 302.93 645 REAL ACCOUNT CREDIT ACTIV 302.93- .00 .00 302.93 691 FACTS - COLLECTION OF REV .00 .00 .00 .00 695 PY APPROPRIATION REVENUE .00 .00 .00 .00 *COMP GL ACCT 2240 FB-UNRESERVED-UNDESIGNATED-OTH .00 .00 .00 .00