FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

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


Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy