Ideal Online Documentation

14391 T/T INQUIRIES
TT3-01 Trust Transaction Inquiry

 

PURPOSE

 

The trust transaction inquiry program is used to query information and transactions regarding trust bank accounts for client/matters.

 

The header portion of the inquiry screen displays the client/matter number and bank account selection options that you specify in addition to format information. The detail portion of the inquiry screen displays the transactions that have occurred for the client/matter, accounts and time period specified.

 

You have the option of printing the inquiry results. Printing occurs when you exit the program. You may flag multiple entries for printing in one print job.

 

Trust Transaction Inquiry is accessed from:

  • Trust Accounting menu.

 

PROCEDURE

 

Select Trust Transaction Inquiry from the Trust Accounting menu. The following prompts display.

 

** ENTER AS AT DATE. (08/31/07):

 

The prompt displays the last day of the current G/L period.

 

 

Enter last date to include in the format MMDDYY.

 

[Enter] to accept displayed default date.

 

[F2] for current system date.

 

[F4] to exit to menu.

 

** ENTER START FROM DATE. (OLDEST):

 

Enter start date to include in the format MMDDYY.

 

[Enter] to start with oldest date in system.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

** PRESS ENTER TO CONTINUE:

 

[Enter] to continue to data entry.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

TRUST TRANSACTION INQUIRY DISPLAY

┌────────────────────────────────────────────────────────────────────────────────┐
│08/21/07            TRUST TRANSACTION INQUIRY AS AT 04/30/07                    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│CLIENT  ____________                                    POOLED BAL    OTHER BAL â”‚
│MATTER                                            CDN:                          â”‚
│BANK/ALL            CDN/US/BOTH                   US:                           â”‚
│ACCT TYPE/ALL       ACCOUNT #/ALL                                               â”‚
│SUMMARY ONLY (Y)                 LAWYER: RESPONSIBLE:           ASSIGNED:       â”‚
│────────────────────────────────────────────────────────────────────────────────│
│     CDN ACCT  ACCOUNT #/   DATE   TRAN                                         â”‚
│BANK /US TYPE  SOURCE     REF #    CODE      DEPOSIT    WITHDRAWAL      BALANCE â”‚
│────────────────────────────────────────────────────────────────────────────────│
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│────────────────────────────────────────────────────────────────────────────────│
│Enter CLIENT code, F5 for inquiry.                                              â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

FIELDS - HEADER

 

Once you have made an inquiry each field will default to the previous value displayed, you may enter a new value or press [Enter] to accept the displayed value and advance to the next field.

 

CLIENT

 

Enter client code to inquire upon.

 

After selecting a client the program displays the client's name.

 

 

[F4] to exit to menu.

 

[F5] to display list of client/matters for selection.

 

MATTER

 

Enter matter code to inquire upon.

 

[F3] to return to the previous field.

 

[F5] to display list of client/matters for selection.

 

BANK/ALL

 

Enter bank code to inquire upon.

 

[Enter] to innclude all bank codes.

 

[F3] to return to the previous field.

 

[F5] to display list of banks and accounts for selection.

 

CDN/US/BOTH

 

"C""D""N" to include Canadian funds only.

 

"U""S" to include US funds only.

 

"B""O""T""H" to include both currency types.

 

[F3] to return to the previous field.

 

[F5] to display list of banks and accounts for selection.

 

Use this option to select other currency types that have been defined.

 

 

ACCT TYPE/ALL

 

Enter account type to inquire upon.

 

[Enter] to include all account types.

 

[F3] to return to the previous field.

 

[F5] to display list of banks and accounts for selection.

 

ACCOUNT #/ALL

 

Enter account number to inquire upon.

 

[Enter] to include all account numbers.

 

[F3] to return to the previous field.

 

[F5] to display list of account numbers for selection.

 

SUMMARY ONLY (Y)

 

[Enter] to accept default value "Y".

 

"Y" to display summary totals only sorted by bank account.

 

"N" to display details of all transactions plus account totals.

 

CDN POOLED BAL

 

After entering the client and matter this field displays the current balance of Canadian pooled trust amounts for the selected client and matter.

 

CDN OTHER BAL

 

After entering the client and matter this field displays the current balance of Canadian other than pooled trust amounts for the selected client and matter.

 

US POOLED BAL

 

After entering the client and matter this field displays the current balance of U.S. pooled trust amounts for the selected client and matter.

 

US OTHER BAL

 

After entering the client and matter this field displays the current balance of U.S. other than pooled trust amounts for the selected client and matter.

 

LAWYER RESPONSIBLE

 

After entering the client and matter this field displays the responsible lawyer for the selected client and matter.


LAWYER ASSIGNED

 

After entering the client and matter this field displays the assigned lawyer code for the selected client and matter.

 

Example Trust Transaction Inquiry display:

┌────────────────────────────────────────────────────────────────────────────────┐
│08/21/07            TRUST TRANSACTION INQUIRY AS AT 04/30/07                    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│CLIENT  000001   ABC COMPANY LIMITED                    POOLED BAL    OTHER BAL â”‚
│MATTER  0001  EXTRA-PROVINCIAL REGISTRATION       CDN: 1000075899.99         .00│
│BANK/ALL      ALL   CDN/US/BOTH    BOTH           US:          .00          .00 â”‚
│ACCT TYPE/ALL ALL   ACCOUNT #/ALL  ALL                                          â”‚
│SUMMARY ONLY (Y) N               LAWYER: RESPONSIBLE: IMW       ASSIGNED: JM    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│     CDN ACCT  ACCOUNT #/   DATE   TRAN                                         â”‚
│BANK /US TYPE  SOURCE     REF #    CODE      DEPOSIT    WITHDRAWAL      BALANCE â”‚
│────────────────────────────────────────────────────────────────────────────────│
│CKH  CDN POOL             06/15/98 BDD      10,000.00          .00    10,000.00 â”‚
│               TT0037-001        ASDFAS                                         â”‚
│CKH  CDN POOL             11/09/98 NCD     100,000.00          .00   110,000.00 â”‚
│               TT0040-001 123    TEST DEPOSIT                                   â”‚
│                                 WHATEVER                                       â”‚
│CKH  CDN POOL             11/09/98 CHQ            .00    50,000.00    60,000.00 â”‚
│               TZ0012-001 C00413 MINISTER OF FINANCE                            â”‚
│CKH  CDN POOL             03/09/04 CHQ            .00    10,000.00    50,000.00 â”‚
│               TZ0013-001 C00414 NIKKY HUDSON                                   â”‚
│                                 FOR SOMETHING                                  â”‚
│────────────────────────────────────────────────────────────────────────────────│
│** PRESS ENTER TO CONTINUE; F3 TO RE-DISPLAY FROM START; F4 TO END:             â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS ENTER TO CONTINUE; F3 TO RE-DISPLAY FROM START; F4 TO END:

 

[Enter] to display the next screen of inquiry results.

 

When you reach the final screen of results the following prompt displays.

 

 

** PRESS ENTER TO CONTINUE;F3 TO RE-DISPLAY FROM START;'P' FOR PRINTOUT:

 

[Enter] to clear display.

 

You are returned to CLIENT field where you may enter a new client code or press [F4] to exit to the Trust Accounting menu.

 

 

[F3] to re-enter header field data.

 

"P" to print inquiry results.

 

You are taken to the print selection menu upon exiting the program. You may flag multiple inquiry results for printing and all will print when exiting the program.

 

 

[F3] to redisplay from the first inquiry result.

 

[F4] to exit to menu.

 

 

FIELDS - DETAIL DISPLAY

 

BANK

 

Displays the 3 character bank code.

 

CDN/US

 

Displays the currency type.

 

ACCT TYPE

 

Displays the 1 digit account type code.

 

ACCOUNT #/SOURCE

 

Displays the original batch and sequence number of the transaction.

 

DATE/REF #

 

Displays the transaction date and reference number.

 

TRAN CODE

 

Displays the transaction code.

 

DEPOSIT

 

If the transaction is a deposit the amount is displayed.

 

WITHDRAWAL

 

If the transaction is a withdrawal the amount is diaplayed.

 

BALANCE

 

Displays the balance of the account affected by the transaction after the transaction.

 

ACCOUNT TOTAL

 

Displays the total of deposits, withdrawals and final balance for the indicated bank account.