Printing the TR Report - Analysis for Member Transactions

Screen ID:

LAUDT1-01

Screen Title:

Teller Detail Audit Report

Panel ID: 5015
Tool Number: 691
Report Name: LAUDT1
    Click here to magnify

Access this screen by selecting Tool #691 Print TR Analysis (J/Es for Mbr Trans).

The Teller Detail Audit Report provides a very detailed list of all member-related transactions. You may chose a specific date to be printed and can omit transactions which show drafts (checks) clearing member accounts.

This is different from the G/L Interface Trial Balance report (LGLTRE, commonly called the “TR”) because the Teller Detail Audit Report provides complete detail of every member-related transaction, without summarizing. This report provides the support documentation for the summary balances on the TR. It can also be helpful for researching the offsetting G/L accounts for member transactions.

The sorts emulate how the G/L summarizes the transactions to assist you with finding entries on the report. 

  • In some cases, the report may summarize transactions a little differently than the general ledger when the primary and offset G/L information have different criteria, and the report displays the transactions only one time.  For this reason, at times multiple section totals may be needed to match the actual journal entry in the general ledger.

Use the filters!  Otherwise, this is a large report and can take a long time to run.

Field Descriptions

Field Name

Description

Month/Year to Process

Enter the month and year for which data should be shown.  Normally, three previous months are available.  To run a report using month-end data prior to the months held online, contact a Client Services Representative.  (There is a charge if this service is requested.)

Closing Date

To print data for only one day, enter the date here (mmddyy).

Transaction Origin

(Optional) To print data for only one transaction origin code.

Member/transaction branch

(Optional) To print data for only one member/transaction branch.

Transaction code/type

(Optional) To print data for only one transaction code/type.

Member G/L account #

(Optional) To print data for only one member G/L account number.

Offset G/L account #

(Optional) To print data for only one offset G/L account number.

Report Sample

The following is a sample portion of the Audit Detail Report:

  • HINT: This report is organized first by Transaction Origination (such as Teller Processing), then by G/L account number. If you are looking for a specific error, try searching for the appropriate origination type first.

  2/17/13   9.39.19                                         ABC CREDIT UNION                              LAUDT1           PAGE

     RUN ON   2/18/13                       TR JOURNAL ANALYSIS FOR MEMBER TRANSACTIONS                              USER

                                                           FOR:  2/11/13

 

 TRANSACTION ORIGINATION        10  CERTIFICATE PROCESSING

 GENERAL LEDGER ACCOUNT     908.02  CERTIFICATES

 

 

 TRANSACTION CODE  42  SHARE CERTIFICATE DEPOSITS

 

 TRANSACTION TYPE  09  DIVIDEND EARNED

 

 CO/BR         ACCOUNT       TRANS INTEREST  PRINCIPAL   TRANS    RESULTING  TRANSFER                           EM BR        SUBSD

                NUMBER        AMT    PAID       PAID     DATE       BALANCE   ACCOUNT      DESCRIPTION          ID ID TIME   G/L

 

 01/01       11111-300          .24                     2/11/13     1231.99                CLUB BENEFIT EARNED  90 01  1.00 111.09

 01/01        2222-301         4.77                     2/11/13    22461.57                CLUB BENEFIT EARNED  90 01  1.00 111.09

 01/01        2333-302         4.77                     2/11/13    22461.57                CLUB BENEFIT EARNED  90 01  1.00 111.09

 01/01        2444-303         4.77                     2/11/13    22461.57                CLUB BENEFIT EARNED  90 01  1.00 111.09

 01/01       15555-301         8.92                     2/11/13    41991.63                CLUB BENEFIT EARNED  90 01  1.00 111.09

 01/01        2555-301          .43                     2/11/13     2006.42                CLUB BENEFIT EARNED  90 01  1.00 111.09

 01/01        6666-300          .24                     2/11/13     1115.95                CLUB BENEFIT EARNED  90 01  1.00 111.09