General Transaction Activity Report

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

images\kb_closed_shg.gif

LTRREGS-03

Transaction Register

4632

LTRREG1

 
Click here to magnify

Access this screen by selecting Tool #381: General Transaction Register.

Helpful Resources

Visit Show Me the Steps for easy instructions on how to use CU*BASE to verify a G/L offset account number and complete other head teller-related tasks.

Visit Show Me the Steps for easy instructions on using Automated Reports to create, change, and delete report settings.

Screen Overview

This screen is used to print a transaction register showing all transactions posted to member accounts. You can also choose to print just a summary showing total deposits and withdrawals by transaction code and type.

NOTE: Examples are below for staging this report for current and previous months.

Use this Report

Practical Uses of this Report

Use this report to find totals of transactions by origin code to analysis the activity for the month. Use this report to find a group of transactions offsetting a specific primary G/L or specific offset G/L.

For auditors, use this report to monitor members flagged with wrong addresses, as well as members who enrolled in e-Statements but have wrong email addresses.  This report allows the selection of activity by transaction code, origin and type (to allow for the selection of EFT transactions that require the production of a statement).  Filter the report results to just the members you need to monitor.  Use the “Export report to file” feature to create a file of these members for use in Report Builder and Member Connect.

How Do I Save/Retrieve My Report Settings?

For more details on setting up this feature, refer to the Automating Reports and Queries booklet, available on the CU*BASE Reference page. 

This report can be used with the “Report Scheduler,” a time-saving automation feature that allows you to select and save the filters you use to run several commonly used reports and then set these reports to be run automatically by our operations staff on the first of the month.  Or you can save the settings and run them manually by yourself at any time.

o save your report settings, first select your filters, including printer (can be a physical printer or the HOLDxx or MONTHxx OUTQs).  Then select Save Settings (F24).  On the next screen name your settings (we recommend adding your name!), and designate whether you wish to run this manually or if you wish for operations to run the report.  At a later time, use Retrieve Settings (F23) to populate the screen with the settings you have saved.  You can also edit your settings using Retrieve Settings (F23).  All saved settings can be viewed on the Report Automation: Standard Reports screen.

Field Descriptions

Field Name

Description

Report type

Choose Detail to list each individual transaction, sorted by account number. (This is usually quite a long report.)

Choose Summary to show just total deposits and withdrawals by transaction code and type.

File type

Choose one of the following to specify where data should come from when generating the report:

Current (C) - to use data from current month files TRANS1, TRANS2, and TRANS3
(Be sure to enter the current month and year into the File date field.)

 See below for report staging recommendations.

End of Month (E) - to use data from an end-of-month file ETRmmyy1, ETRmmyy2, and ETRmmyy3
(Would be helpful in cases where data is needed beyond your credit union's retention time period for HTRANSx files. A fee may apply if a tape needs to be loaded.)
See below for report staging recommendations.

History (H) - to use data from transaction history files HTRANS1, HTRANS2, and HTRANS3
(Remember that the length of time history is retained will vary depending on your credit union's retention settings.)

File date

Enter the month and year for the file to be used when pulling data for the report.

Application type

To include only transactions that affected a certain type of accounts, use the Select button to reveal a screen to select one or more application types. When you return to the screen, the count of the items selected with appear next to the button.

SEE ALSO: Filter and selection directions.

Transaction origin code

To include only transactions that came from a specific origination point, use the Select button to reveal a screen to select one or more transaction origin codes. When you return to the screen, the count of the items selected with appear next to the button.

SEE ALSO: Filter and selection directions.

Transaction code/type

To include only transactions with a certain transaction code and/or type, enter the codes here (Tran Code goes into the first field, Tran Type in the second field). You can use either or both, as needed.

Date/Date Type

To include only transactions with a certain date, use the Date field to enter the date of the transactions to be included on the report.

Then select whether you wish to specify Activity Date (TR) or Business Date (PR).  What is Activity Date?  What is Business Date?

  • For most transactions these dates are the same; however, in some cases the timing of daily processing may cause the dates to be different by a day or so.

Leave both fields blank to include all transactions, regardless of date.

Branch type

To include only transactions that were posted to a particular branch/location number, choose one of the following to specify which branch data to use:

Member Branch (M) - When a transaction is posted, the system automatically records the branch number from the member's MASTER record. Choose this to pull transactions according to this branch.

Transaction Branch (T) - When a transaction is posted, the system includes the branch number from the workstation used to post the transaction. Choose this to pull transactions according to this branch.

Then use the Branch # field (see below) to enter the desired branch number.

Leave both fields blank to include all transactions, regardless of branch.

Branch #

(Optional) (Optional) (Use in conjunction with Branch type.) To include only transactions associated with a specific branch, use the Select button to reveal a screen to select one or more branches. When you return to the screen, the count of the items selected with appear next to the button.

SEE ALSO: Filter and selection directions.

Member G/L account #

To include only transactions that were posted to a certain member G/L account number (the “primary” G/L), enter the account number here. Leave the field blank to include all transactions, regardless of member G/L account.

Member account base

To include only transactions that were posted for a certain member, enter the account base here. Leave the field blank to include all members.

Offset G/L account #

To include only transactions that were posted against a certain G/L account number (the “offset” G/L), enter the account number here. Leave the field blank to include all transactions, regardless of offset G/L account.

Employee ID

To include only transactions posted by a particular person, enter an Employee ID here. Leave the field blank to include all transactions, regardless of which employee posted them.  

Viewing data center employee activity:

  • Enter 99 to view transactions by all data center employees.  

  • If you enter an alias ID, such as 89, the system will automatically translate that to all data center employee IDs that use that alias.

Include only accounts flagged with wrong addresses

Filter the results to show only members with their address flagged as a wrong address. (Where the wrong email address flag is set to Y.)

Include only accts enrolled for e-stmts with wrong email addresses

Filter the results to show only members who are enrolled in e-Statements but who also have their email address flagged as an invalid (wrong) email address.

Export to file

(Optional) Check the “Export to file” go to a screen where you can choose to create a file that lets you use Member Connect to communicate instantly with these members via email and online banking messages, set up a marketing outreach via mailing labels and selective statement inserts, and track the responses via a telemarketing Tracker. This file will contain account base only. Or choose to export more data to use with CU*BASE Report Builder.

Staging of Screen for Printing a List of ACH Transactions Posted Today Through the ACH Exceptions Post Function

Use the staging below to print this report for use with reconciling your ACH Exception Report (F14-Print on the ACH Exceptions Screen) totals after using the Post option on the ACH Exceptions screen.

·     NOTE: In this example, the report is staged to list all the member transactions that posted on October 11, 2012 by Employee AA that were offset to G/L 870.11. Employee will use this report every day to verify the transactions they posted to the member’s accounts from the ACH Exceptions Screen using the Post option (function).

Report Sample

Detail

NOTE: The “Prc Flg” column shows various status flags from transaction history records, which are primarily used behind the scenes by the system when processing transactions.

S = Suppressed from member statement.

P = Can represent a fee for printing a Transaction History list; also used for some types of transaction reversals.

11/14/12   8:21.24                                  CU*BASE TEST CREDIT UNION                            LTRREG1          PAGE    1

    RUN ON  11/15/12                                   TRANSACTION REGISTER                                      USER

 

Process Month/Year:   11/12

 

 DETAIL/SUMMARY (D/S)  D

 

 Include only accounts flagged with wrong address: N

 Include only accts enrolled for eStatements with wrong email address: N

 

      Account   Tran   TR   Deposit/     Interest   Withdraw/     Current                    Draft      Tracer  BR TL Prc  Subs Org

       Number   Date   TP   Principal     Payment    Disburse     Balance  Description        Nbr       Acct #  ID ID Flg  G/L  Cod

 

        1-000 11/06/12 11       20.00                          9002461.96  00                                   01 *M     870.00  4

        1-000 11/06/12 31                               10.00  9002451.96  WITHDRAWL VIA MA                     01 *M     870.00  4

        1-000 11/06/12 11       60.00                          9002511.96  DEPOSIT VIA MAIL                     01 *M     870.00  4

        2-000 11/06/12 31                                1.00      361.32  WITHDRAWL VIA MA                     01 *M     870.00  4

        2-000 11/06/12 11       30.00                              391.32  DEPOSIT VIA MAIL                     01 *M     870.00  4

        2-000 11/06/12 31                               10.00      381.32  WITHDRAWL VIA MA                     01 *M     870.00  4

        2-000 11/06/12 11        8.00                              389.32  DEPOSIT VIA MAIL                     01 *M     870.00  4

        2-000 11/06/12 11      100.00                              489.32  DEPOSIT VIA MAIL                     01 *M     870.00  4

 

Summary

 11/14/12   9:11.03                                  CU*BASE TEST CREDIT UNION                            LTRREG1          PAGE    1

     RUN ON  11/15/12                                   TRANSACTION REGISTER                                         USER

 

  Process Month/Year:   11/12                              -- Summary --

  

  DETAIL/SUMMARY (D/S)  S

 

  Include only accounts flagged with wrong address: N

  Include only accts enrolled for eStatements with wrong email address: N

 

       Transaction

        Code  Type  Description                             -Deposit-           -Withdraw-         Total

 

        LN-22  12   REGULAR PAYMENT                              27.00                   .00                 1

                                 ** Total                        27.00                   .00                 1

        SD-32  10   DEPOSIT BY PHONE TRANSFER                     5.00                   .00                 1

        SD-32  11   DEPOSIT                                     220.00                   .00                 4

        SD-33  31   WITHDRAWAL, CASH                               .00                843.20               191

        SD-33  37   WITHDRAWAL, CHECK                              .00                  1.00                 1

        SD-33  68   WITHDRAWAL, SALES TAX                          .00                  1.00                 1

                                 ** Total                       225.00                845.20               198

 

 

 

        SH-13  59   WITHDRAWAL FOR ATM INQUIRY                     .00                 10.00                 1

                                 ** Total                       488.00              1,345.00                27

                      *** FINAL TOTALS ***                      740.00              2,190.20               226

                                                           ***END OF REPORT*** 

 

 

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#LTRREGS-03.htm