Lesson 6: Entering a Recurring Transaction Profile

Example: Establishing an RTI for Receipt of a Federal and State Pass-Through Grant

Scenario

Your agency recently put on an informational event to encourage Texas Heritage. Your agency will receive funding for this event, passed through to it from another state agency — the Texas Chili Cookoff Commission (agency 432.)

This funding is from federal and state grants. Since the funding is from two different sources — federal and state — a percentage can be used to appropriately distribute the revenue received. For this example, federal funding is $4,000 and state funding is $6,000. Consequently, the percentage the RTI will be setup for will be .40 for COBJ 3971 and .60 for COBJ 3725.

You are going to set up the RTI that will record the incoming revenue on your agency's books as Federal and State Pass-Through.

55 (550) screen - federal funding source

The following entries are entered on the 55 (550) screen to establish the RTI for the federal funding allocation:

Completed 55 (550) Screen

TEXAS S550      UNIFORM STATEWIDE ACCOUNTING SYSTEM      MM/DD/YY HH:MM PM
LINK TO:           RECURRING TRANSACTION PROFILE                      PROD
ACTIVE

ACTION: A   (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
AGENCY: 432                  TRANS NO: 000001                  RTI: 222222      
USER ID:               DESCRIPTION:
GENERATE SCHEDULE (MMDD) - 1:         2:       3:         4:
 BATCH - AGY:            TYPE:   DOC DATE:              SERV DATE:
 CUR DOC/SFX:                        REF DOC/SFX:
  TRANS CODE: 273                                       PCC:
       INDEX:                                     REQ NO:
         PCA: 01060
COMP/AGY OBJ: 3971     NACUBO SUBFUND:
      AMOUNT:                RVS: DISCOUNT:                  FUND OVRD:
     DOC AMT:                DOC AGY:
 % ALLOCATED: .40    DMI:        PDT: T  MOD: A   APPN YR: 12 APPN NO:
        FUND:         GL ACCT/AGY:
 GRANT NO/PH:         SUBGRANTEE:             PROJ NO/PH:
        MPCD:         AGY CD - 1:       2:          3:
     VEND/MC:                % SUM:       STATUS CODE: A
  EFF START DATE:        EFF END DATE:       LAST PROC DATE:


F1-HELP F3-END F4-INTERRUPT F6-PROCES

55 (550) screen - state funding source

The following entries are entered on the 55 (550) screen to establish the RTI for the state funding allocation:

Completed 55 (550) Screen

TEXAS S550      UNIFORM STATEWIDE ACCOUNTING SYSTEM      MM/DD/YY HH:MM PM
LINK TO:           RECURRING TRANSACTION PROFILE                      PROD
ACTIVE

ACTION: A   (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
AGENCY: 432                  TRANS NO: 000002                  RTI: 222222      
USER ID:               DESCRIPTION:
GENERATE SCHEDULE (MMDD) - 1:         2:       3:         4:
 BATCH - AGY:            TYPE:   DOC DATE:              SERV DATE:
 CUR DOC/SFX:                        REF DOC/SFX:
  TRANS CODE: 273                                       PCC:
       INDEX:                                     REQ NO:
         PCA: 01080
COMP/AGY OBJ: 3725     NACUBO SUBFUND:
      AMOUNT:                RVS: DISCOUNT:                  FUND OVRD:
     DOC AMT:                DOC AGY:
 % ALLOCATED: .60    DMI:        PDT: T  MOD: A   APPN YR: 12 APPN NO:
        FUND:         GL ACCT/AGY:
 GRANT NO/PH:         SUBGRANTEE:             PROJ NO/PH:
        MPCD:         AGY CD - 1:       2:          3:
     VEND/MC:                % SUM:       STATUS CODE: A
  EFF START DATE:        EFF END DATE:       LAST PROC DATE:


F1-HELP F3-END F4-INTERRUPT F6-PROCES

Analyzing the RTI profile

The total percentage of all RTI transactions under the same RTI number must always equal 100 percent for the transactions to process without error.

Remember: Never use the AMOUNT field.

Next: Learning Check