Printing the TR Report - Analysis for Member Transactions
|
Screen ID: Screen Title: Panel Number: Report Name: |
LAUDT1-01 Teller Detail Audit Report 5015 LAUDT1 |
|
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 is displaying 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