Table of Contents IndexTop

SECTION 5 CERTIFICATE OF DEPOSIT SYSTEM

5.1 INTRODUCTION

The BANCADO Certificate of Deposit system performs the functions necessary for the proper accounting of customer Certificates of Deposit. These functions include interest accrual and payment, penalty calculation, ledger maintenance, and generation of reports and customer notices.

 

The only system functions required on a regular basis are the daily transaction journal/update run, daily interest checks and notices, and annual 1099's. Other than generating these reports and notices, it is up to each bank to establish its own schedule for the preparation of other reports and notices.

 

Function Selection

 When the Certificate of Deposit system is selected from the BANCADO main menu, the following screen is displayed:

 

5.2 CERTIFICATE OF DEPOSIT FILE

The Certificate of Deposit file contains one record for each certificate of deposit processed by the bank. A certificate of deposit record consists of 24 fields of data items designed to describe a certificate. The fields and valid contents of each data item are as follows:

 

         CERTIFICATE NUMBER

This field is a maximum of nine digits and contains the certificate of deposit number. Certificate of deposit number.

         CUSTOMER NUMBER

This field contains the customer number. This is a ten-character alphanumeric field.

         RATE

This field contains the annual interest rate for this certificate in the 99.999 format. If the interest rate is changed, the option is provided to make the new interest rate retroactive.

         DAYS PER YEAR

This is a three-digit field, allowing you to specify either 360 or 365 days per year.

         OFFICE CODE

This is a two-digit field that contains the office or branch number.

         RESTRICTION CODE

This field contains a two-digit code that identifies any restrictions on this certificate. The restriction code is established by your bank for such things as two signatures required or pledged as collateral for loan.

         WITHHOLDING CODE

This field contains a code that indicates the withholding status for interest paid. e.g. Code 20 = 20% withholding.

         CERTIFICATE DATE

This field contains the certificate date in MM/DD/YYYY format. When entering a new certificate, the system automatically displays the current date. You can accept this date or enter a different date..

         FACE AMOUNT

This field contains the current balance of the certificate. The maximum value is 9999999.99.

         TERM

This field contains the term to maturity for this certificate. The term is expressed in days, months, or years. The maximum value is 999.

         UNITS

This field contains a one-character code that identifies the type of term specified in the previous field. Valid values for this field are:

D for days

M for months

Y for years

         RENEWABLE/NON-RENEWABLE

This field contains a one-character code that indicates whether this certificate is to be renewed at maturity. This field contains an R if the certificate is to be automatically renewed at maturity or an N if it is not. When entering a new certificate, the system displays the following prompt for this field:

Key R for Renewable, N for Non-renewable: [ ]

         RENEWABLE AT RENEWAL RATE OR SAME RATE

This field contains a one-character code that indicates whether an automatic renewal will continue to pay the same rate of interest or a different renewal rate. Enter either S for same rate or R for a new renewal rate.

         INTEREST PAYMENT TERM

This field contains the term for interest payment expressed in days, months, or years. The maximum value is 999. If this field is blank, the system assumes that the interest payment term is the same as the term of the certificate.

         UNITS

This field contains a one-character code that identifies the type of term specified in the previous field. If no interest payment term is specified, this field is blank. Valid values are:

D for days

M for months

Y for years

         INTEREST COMPOUNDING TERM

This field contains the term for unpaid interest compounding expressed in days, months, or years. The maximum value is 999. If this field is blank, the system assumes that the unpaid interest is not compounded.

         UNITS

This field contains a one-character code that identifies the type of term specified in the previous field. If not interest term is specified, this field is blank. Valid values are:

D for days

M for months

Y for years

         PAY INTEREST TO CODE

This field contains a one-character code that identifies how interest is to be paid. Valid values are:

C for Certificate of Deposit

S for Savings

D for DDA

B for Check

When entering a new certificate, the system displays the following prompt for this field:

 Pay interest to C-Certificate, S-Savings, D-DDA, or B-By Check: [ ]

         CODE

This field contains a two-digit code established by your bank for 1099 processing at year-end. The code is used to determine whether or not a certificate qualifies for 1099 processing.

         RENEWAL RATE CODE

This two-digit numeric field contains the code that can be used to change renewal rates upon conversion.

         RENEWAL RATE

This field contains the interest rate that will be paid on the renewed certificate in the format 99.9999.

         LEGAL TITLE LINE 1

This field contains the legal title for this certificate. This field is required only when the legal title is different from the CIF name. If a legal title is present, the system substitutes the legal title for the customer name on checks and notices printed for this certificate. This field contains up to 35 characters.

         LEGAL TITLE LINE 2

This field contains any additional legal title information, up to 35 characters. It can also be used for special Social Security Number. If this certificate is for a Social Security Number other that the customer's, enter the special number on this line in the format of a Social Security Number (nnn-nn-nnnn). If a special Social Security Number is entered here, the system will print a separate 1099 during year-end processing.

         CALL CODE

This field contains a five-character code that identifies the appropriate Federal Reserve call code (Call Report line number) for this certificate.

 

5.3 CERTIFICATE OF DEPOSIT ACTIVITY

The Certificate of Deposit Activity procedures provide functions to: 

         Enter new certificates into the system.

         Change existing certificates.

         Post certificate of deposit transactions.

         Review the current status of certificate of deposit totals at any time.

         Change the accrual dates in the system records. (This is an installation procedure and is not normally performed.)

         Delete cashed certificates from the file at year-end.

         Force interest payments.

Function Selection

Throughout this section, you will be asked to select a particular function from the C.D. ACTIVITY portion of the Certificate of Deposit menu. The following is an example of the C.D. ACTIVITY portion of the menu:

C.D. ACTIVITY

 

9. New Certificate

10. Change Certificate

11. Transaction

12. Activity Summary

13. Change Accrual Date

14. Year-end Maintenance

15. Force Interest Payment

16. Change Variable Rates

5.3.1 NEW CERTIFICATE

This procedure is used to enter new certificates of deposit into the system.

From the Certificate of Deposit menu, enter 9 for New Certificate. The system displays the prompt:

Customer Number? [ ]

 

Enter the customer number and press RETURN. The system displays the customer information and lists all the customer's certificates and other accounts. The following sample illustrates this display.

111 THOMAS P. SMITH

1823 WEST SEVILLE HOME PHONE 213/960-3293

TORRANCE, CALIFORNIA 90503 BUSINESS PHONE 213/960-3000

 

ACME CORPORATION CUSTOMER SINCE

C-D 205 1,000.00

DEP 103 1,182.94

C-L 405 4,000.00

I-L 304 3,600.00

The system then prompts:

 

C.D. Number: [ ]

 

Enter the new certificate number. The system then displays:

 

Customer Number: AAA Name Social Security No.

Certificate Number: nnnnnn

Rate: [ ]

 

Enter data in each field of the certificate of deposit record as requested according to the definitions given in Section 5.2. Table 5.1 summarizes the data in the certificate record.

After entering the data in each field, press RETURN and the system displays the next prompt. To skip an optional field, press RETURN only.

Table 6.1 Certificate of Deposit Record Summary

 

Field

Number

Field

Name

Field

Type

Field

Length

1

CERTIFICATE NUMBER

NUMERIC

9

2

CUSTOMER NUMBER

ALPHANUMERIC

10

3

RATE

NUMERIC

7

4

DAYS PER YEAR

NUMERIC

3

5

OFFICE CODE

NUMERIC

2

6

RESTRICTION CODE

NUMERIC

2

7

WITHHOLDING CODE

NUMERIC

10

8

CERTIFICATE DATE

ALPHANUMERIC/DATE

10

9

FACE AMOUNT

NUMERIC

10

10

TERM

NUMERIC

3

11

UNITS

ALPHANUMERIC

1

12

RENEWABLE/NON-RENEWABLE

ALPHANUMERIC

1

13

RENEWABLE AT RENEWAL RATE OR SAME RATE

ALPHANUMERIC

1

14

INTEREST PAYMENT TERM

NUMERIC

3

15

UNITS

ALPHANUMERIC

1

16

INTEREST COMPOUNDING TERM

NUMERIC

3

17

UNITS

ALPHANUMERIC

1

18

PAY INTEREST TO CODE

ALPHANUMERIC

1

19

CODE

NUMERIC

2

 

20

 

RENEWAL RATE CODE

 

NUMERIC

 

2

 

21

 

RENEWAL RATE

 

NUMERIC

 

6

 

22

 

LEGAL TITLE LINE 1

 

ALPHANUMERIC

 

35

 

23

 

LEGAL TITLE LINE 2

 

ALPHANUMERIC

 

35

 

24

 

CALL CODE

 

ALPHANUMERIC

 

5

 

 

 

After you enter the last field of the certificate of deposit record, the system allows you to enter a transaction. The customer information and certificate information are displayed as well as the prompt:

 

Transaction Code? [ ]

 

To change customers, press RETURN only. To return to this customer's CIF display, enter 99 and press RETURN. To enter a transaction, refer to Section 5.3.3 for a description of transaction entry. The following sample illustrates the information displayed on the screen.

 

ENTER SCREEN HERE PLEASE

5.3.2 CHANGE CERTIFICATE

 

This procedure can be used to change an existing certificate of deposit or to examine a certificate on record.

 

From the Certificate of Deposit menu, enter 10 for Change Certificate. The system displays the following:

 

Certificate Number: []

 

Enter the certificate number and press RETURN. The following certificate information will be displayed (one field at a time):

 

ENTER SCREEN HERE PLEASE

 

 

Move the cursor to each field to change the existing data according to the definitions given in Section 5.2. Correct fields can be skipped by pressing RETURN only. After accepting or changing the last item (Call Code), the system requests another certificate number. Perform the ESCAPE function to terminate the Change Certificate procedure and return to the Certificate of Deposit menu.

5.3.3 TRANSACTIONS

 

This procedure is used to enter transactions that are posted to certificates and stored in the Transaction file. The Transaction file is then used to print the Transaction Journal and to prepare Customer Ledgers.

 

This procedure performs a variety of functions abased on the specified transaction code. The certificate of deposit transaction are:

 

 

Code Transaction

20 New Certificate Reversal

30 Deposit Reversal

31 Credit Reversal

40 Deposit

41 Miscellaneous Credit

50 Check or Deposit to Savings or DDA

51 Miscellaneous Debit

60 Check Reversal

61 Debit Reversal

71 Extra Interest Payment

80 Interest Payment Reversal

81 Penalty

 

 

From the Certificate of Deposit menu, enter 11 for Transaction. The system displays:

 

Customer Number: [ ]

 

Enter the customer number and press RETURN. You can press RETURN only to enter the transaction by certificate number.

 

When a customer number is entered, the system displays the customer information. The system then displays the prompt:

 

Certificate Number: [ ]

 

Enter the certificate number and press RETURN. The system displays the certificate information and then requests:

 

Transaction Code: [ ]

 

 

 

 

 

 

 

 

 

 

 

Enter the desired transaction code and press RETURN. At this point, two other options are available:

 

1. To enter a transaction for a different certificate for this customer, enter 99 and press RETURN. The system returns to the customer display and requests another certificate number.

 

2. To enter a transaction for another customer, press RETURN only. The system clears the screen and displays the Customer Number prompt.

 

After the transaction code is specified, the system displays a series of prompts. The prompts that are displayed depend on the specified transaction code.

 

The following screen is a sample of the display:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5.3.4 ACTIVITY SUMMARY

 

This procedure is used to review the current status of certificate activity. This procedure displays a list of all the various transaction types and shows the number and amount of each transaction type entered thus far today for the previous day. Also, the display shows the certificate balance as of the last transaction and as of the last close of business.

 

From the Certificate of Deposit menu, enter 12 for Activity summary. The system automatically displays the activity summary on the screen as follows:

 

ENTER SCREEN HERE PLEASE

 

After viewing the Activity Summary screen, press RETURN to return to the Certificate of Deposit menu.

5.3.5 CHANGE ACCRUAL DATE

 

This procedure changes the accrual dates in the system control record. This procedure is used only at installation time prior to entering certificates and transactions for first day processing.

 

 

CAUTION: Changing the accrual dates can affect the bank accruals. Therefore, use this procedure only as directed..

 

From the Certificate of Deposit menu, enter 13 for Change Accrual Date. The system displays:

 

LAST BUSINESS DATE; MM/DD/YYYY

NEXT BUSINESS DATE; MM/DD/YYYY

 

The dates displayed are the current dates that exist in the system control record.

 

To change the last business date, perform a DELETE to position to the beginning of the field. Then enter the correct date in MM/DD/YYYY format.

 

To change the next business date, perform a DELETE again to position to the beginning of the field. Then enter the correct date in MM/DD/YYYY format.

 

The system displays the prompt:

 

ARE YOU SURE? []

 

If your entries are correct, enter YES and press RETURN. The system momentarily displays the message CHANGED and then returns to the Certificate of Deposit menu.

 

NOTE: This procedure only changes the dates in the control record, not the current active date in the system. To change the active system date, you must return to the BANCADO main menu (99) and then reenter certificates of deposit.

 

To terminate the procedure without changing the dates, press RETURN only. The system returns to the Certificate of Deposit menu.

5.3.6 YEAR-END MAINTENANCE

 

This procedure deletes Certificates of Deposit with a zero balance from the file and zeroes year-to-date interest and penalties in the file and in the control record.

 

From the Certificate of Deposit menu, enter 14 for Year-end Maintenance. This message will be displayed:

 

This program clears year-to-date figures in the C.D. master file.

 

You may with to make a special backup before proceeding.

 

Press RETURN to proceed: [ ]

 

After you press RETURN, the system returns to the Certificate of Deposit menu, and the job is processed. When the job is completed, the system will generate a report summarizing the activity. A sample report appears below.

 

PLEASE PUT A COPY OF THE SAMPLE REPORT HERE

5.3.7 FORCE INTEREST PAYMENT

 

The Force Interest Payment program allows you to align the interest payments for certificates of deposit with the same code.

 

From the Certificate of Deposit menu, enter 15 for Force Interest Payment. The system displays the following screen:

 

FORCE C.D. INTEREST PAYMENT

 

FOR C.D.'S WITH CODE: [ ]

FORCE THE NEXT INTEREST PAYMENT TO BE ON:

 

Enter the two-digit code of the certificates to be changed and please RETURN.

 

Enter the interest payment date in the format MM/DD/YYYY and press RETURN.

 

NOTE: The current system date is displayed, but can be changed if necessary.

 

During program execution, the following message is flashed on the screen:

 

PROCESSING

 

Upon completion, the following message is displayed momentarily:

 

PROCESSING COMPLETE

 

The system then returns to the Certificate of Deposit menu.

5.3.8 CHANGE VARIABLE RATES

 

The Change Variable Rates program allows you to change C.D. rates for a particular code or renewal code. Note that changing the rates by code makes the new rate effective on the date of the change, not retroactive to the last interest payment date.

 

Changing renewal rates by renewal code causes all C.D.s with the associated renewal code to be automatically renewed at the specified rate. For example, if the automatic renewal rate for 30 -month C.D.s changes weekly, all 30-month C.D.s should have the same renewal code and the Change Variable Rates Program should be run weekly to change the renewal rate for the code. All automatically renewable 30-month C.D.s maturing during the week will be renewed at that week's rate.

 

From the Certificate of Deposit menu, enter 16 for Change Variable Rates program. The system displays the following screen:

 

Enter C to change Rate and Renewal Rate by Code or

 

Enter R to change Renewal Rate by Renewal Code: [ ]

 

Changing Rate and Renewal Rate by Code

 

To change the rate and renewal rate by code, enter C and press RETURN. The system will prompt you to enter the code:

 

For Certificates with Code: [ ]

 

Enter the two-digit code and press RETURN. The following lines will be displayed to prompt you to enter the rate information. If you do not wish to enter the new rate in response to the first prompt, simply press RETURN and the second line will be displayed:

 

Change the Rate and Renewal Rate to: [ ]

 

OR increase (decrease) the Rate and Renewal Rate by:

 

To indicate a decrease in the rate, type a minus sign before the amount of the change. You may enter up to seven digits in response to either of the two prompts.

 

The system will ask:

 

Include Certificate Detail? (Y/N): [ ]

 

Type Y or N, depending on your preference, and press RETURN. If you respond Y, the report will include detailed information on all certificates. If you respond N, the report will include any basic information reflecting the change in interest rates. The next prompt asks:

Print report only? (Y/N): [ ]

 

This important option allows you to print a report reflecting the change in interest rates without actually changing the files. If you respond Y and press RETURN, the file will remain unchanged. If you respond N and press RETURN, the changes will be entered in the file and the report will be printed.

 

The last prompt in this sequence allows you to go back and make any necessary changes to your entries before proceeding:

 

Are all entries ok? (Y/N): [ ]

If you wish to change any of your entries, type N and press RETURN. Your entries will be erased and the cursor will return to the prompt:

 

For Certificates with Code: [ ]

 

The series of prompts for this program will then re repeated so you can correct your entries. If your entries are correct, respond Y to the last prompt and press RETURN. The system will flash a message, indicating the processing stage. Two sample messages appear below:

 

PLEASE ENTER THE APPROPRIATE SCREEN.

 

 

 

 

 

 

 

The "(NON-UPDATE)" in the second sample indicates that this is a "PRINT REPORT ONLY" run and that the files have not been changed.

 

The system will then return to the Certificate of Deposit menu.

 

Changing Renewal Rate by Renewal Code

 

To change the renewal rate by renewal code, enter R and press RETURN. The system will prompt you to enter the code:

 

For Certificates with Renewal Code: [ ]

 

Enter the two-digit code and press RETURN. The following lines will be displayed. If you do not wish to enter the new rate in response to the first prompt, simply press RETURN and the second line will be displayed:

 

Change the Renewal Rate to: [ ]

 

OR increase (decrease) the Renewal Rate by:

 

To indicate a decrease in the rate, type a minus sign before the amount of the change. You may enter up to seven digits in response to either of the two prompts. The system will ask:

 

Include Certificate Detail? (Y/N): [ ]

 

Type Y or N, depending on your preference, and press RETURN. If you respond Y, the report will include detailed information on all certificates. If you respond N, the report will include only basic information reflecting the change in interest rates. The next prompt asks:

 

Print report only? (Y/N): [ ]

 

This important option allows you to print a report reflecting the change in interest rates without actually changing the files. If you respond Y and press RETURN, the file will remain unchanged. If you respond N and press RETURN, the changes will be entered in the file and the report will be printed.

 

The last prompt in this sequence allows you to go back and make any necessary changes to your entries before proceeding:

 

Are all entries OK? (Y/N): [ ]

 

If you wish to change any of your entries, type N and press RETURN. Your entries will be erased and the cursor will return to the prompt:

 

For Certificates with Renewal Code: [ ]

 

The series of prompts for this program will then be repeated so you can correct your entries. If your entries are correct, respond Y to the last prompt and press RETURN. The system will flash a message, indicating the processing stage. Two sample messages appear below:

 

PLEASE ENTER THE APPROPRIATE SCREEN HERE.

 

 

 

 

 

 

 

 

 

 

 

The "(NON-UPDATE)" in the second sample indicates that this is a "PRINT REPORT ONLY" run and that the files have not been changed.

 

The system will then return to the Certificate of Deposit menu.

5.4 CERTIFICATE OF DEPOSIT REPORTS

 

The Certificate of Deposit system produces a variety of reports. Most reports can be printed on an optional basis, with the exception of the Transaction Journal. The Transaction Journal must be printed as an update run at the end of each day after all activity has been entered. When this report is printed as an update, the system date is advanced and the necessary interest calculations are made.

 

Function Selection

 

Throughout this section you will be asked to select a particular function from the REPORTS portion of the Certificate of Deposit menu. The following is an example of this portion of the menu.

 

 

REPORTS

 

20. Transaction Journal

Trial Balance

Cashed C.D. Report

New C.D. Report

Call Report

Forecast

Check Register

Edit List

Interest Payment Forecast

Advance Check Register

Change Print Size

5.4.1 TRANSACTION JOURNAL

 

This report is a journal of the transactions entered for the current day. Optionally, this procedure updates the interest accrual for the day in the Certificate of Deposit file.

 

Normally, a Transaction Journal is printed once each day, and at least one run per day is required for proper interest accrual. Because the file update portion of the procedure is optional, a Transaction Journal can be produced without the update option at any time during the day to indicate the current status of transaction activity for the day.

 

From the Certificate of Deposit menu, enter 20 for Transaction Journal.

 

If the system date is not the same as the next scheduled accrual date, the system starts to print the Transaction Journal and displays the Certificate of Deposit menu.

 

When the system date is the correct accrual date, the system displays the prompt:

 

Is this an update run? (Y/N): [ ]

 

Update Run

 

To accrue interest for the day, enter Y and press RETURN. The system displays the prompt:

 

Today is MM/DD/YYYY. Next working date: [ ]

 

The current system date will always appear in this prompt. Enter the next date that the bank will be open. The system then determines the number of days for which interest is to be accrued.

 

To cut off a month, quarter, or year in the middle of a weekend, you can run a separate update for the portion of the weekend after the cutoff in order to obtain an accurate cutoff on accruals.

 

After the date is specified, the system prints the Transaction Journal.

 

CAUTION: If, for some reason, the report does not complete, you must NOT restart the procedure. You must reload backup files and start the procedure from the beginning.

 

 

Print-Only Run

To print the Transaction Journal without updating the accrual date, enter NO in response to the prompt:

 

Is this an update run? (Y/N): [ ]

 

The system starts to print the report and displays the Certificate of Deposit menu.

 

 

 

 

 

 

 

 

 

PLEASE ENTER A SAMPLE REPORT HERE.

 

Figure 5.1 Sample Transaction Journal

 

5.4.2 TRIAL BALANCE

 

This report prints a trial balance of all outstanding certificates of deposit. The trial balance can be generated in the following sequences.

 

    • By Customer Sort Key

 

    • By Certificate Number

 

    • By Customer Number

 

Bank totals are printed at the end of the report. For reports that are printed in customer number or name sequence, totals are printed for each customer.

 

Normally, a trial balance is printed after the Transaction Journal procedure is performed as an update. Thus, the Trial Balance is run at the close of business each day, and the report can be saved for bank records.

 

Because the Trial Balance procedure does not update any disk files, the report can be printed at any time during the day. When the procedure is run prior to the Transaction Journal update run, the principal balances shown on the report are current as of the time of the run, but the interest balances are current as of the close of the preceding business day.

 

From the Certificate of Deposit menu, enter 21 for Trial Balance. After selection of 21, the system requests the sequence in which to print the report, as follows:

 

Report sequence:

 

1. Sort by customer sort key

2. Sort by certificate number

3. Sort by customer number

4. Sort by customer number for single code

 

Type the number of the desired sequence and press RETURN.

 

The system starts to print the Trial Balance in the specified sequence and displays the Certificate of Deposit menu.

 

ON THE BACK OF THIS PAGE PLEASE PUT A COPY OF A TRIAL BALANCE.

 

Figure 5.2 Sample Trial Balance

5.4.3 CASHED C.D. REPORT

 

The Cashed Certificate of Deposit report lists all certificates cashed either today or this month.

 

From the Certificate of Deposit menu, enter 22 for Cashed C.D. Report. After selection of 22, the system requests the time period to be reported, as follows:

 

DO YOU WANT A DAILY OR MONTHLY REPORT?

 

ENTER D OR M: [ ]

 

Enter D to print certificates cashed today. Enter M to print all certificates cashed this month (since the last monthly report).

 

The system starts to print the report and displays the Certificate of Deposit menu.

 

 

 

PLEASE PUT A C.D. MONTHLY CASHED CERTIFICATE REPORT HERE.

 

 

 

 

 

 

 

 

 

 

 

 

Figure 5.3 Sample Cashed C.D. Report

5.4.4 NEW CERTIFICATE REPORT

 

This report lists all certificates that were entered either today or so far this month. The operator selects which period is to be printed.

 

This report can be printed at any time. Normally, it is printed at the end of each business day and at the end of each month.

 

From the Certificate of Deposit menu, enter 23 for New Certificate Report. After selection of 23, the system requests which period is to be reported, as follows:

 

DO YOU WANT A DAILY OR MONTHLY REPORT?

 

ENTER D OR M: [ ]

 

Enter D to list all new certificates that were processed today. Enter M for all new certificates processed this month (since the last monthly report). Press RETURN.

 

The system starts to print the New Certificate Report and displays the Certificate of Deposit menu.

 

 

 

 

 

 

 

PUT IN A COPY OF NEW CD REPORT

5.4.5 CALL REPORT

 

This report lists all certificate totals sorted by Federal Reserve call code. The report includes the totals sorted by the size of the certificate.

 

The Call Code report can be generated whenever a request is made for the information.

 

From the Certificate of Deposit menu, enter 24 for Call Report. After the selection of 24, the following prompt is displayed:

 

Enter 5 breakdowns for the call report

 

1 0 -

 

Enter the upper limit for the first size breakdown. The maximum amount is 9999999.99. Repeat this procedure until all five size brackets have been entered.

 

Upon completion of the entries, the system begins printing the Call Report and displays the Certificate of Deposit menu.

 

ENTER A SAMPLE REPORT HERE

 

Figure 5.5 Sample Call Report

5.4.6 FORECAST REPORT

 

The Forecast report is a list of certificate totals by rate with a projected maturity schedule. This report projects the average cost over four forecast periods assuming a constant total certificate balance. The number of months in each forecast period is specified by you. This projection is based on an average increase or decrease in certificate renewal rate that is specified by you.

 

From the Certificate of Deposit menu, enter 25 for Forecast. After selection of 25, the system prompts you for the forecast information, as follows:

 

Include codes from [ ] through

 

Enter projected increase (decrease) in average rate:

 

 

Enter number of months to maturity for first forecast period:

 

Enter number of months to maturity for second forecast period:

 

Enter number of months to maturity for third forecast period:

 

Enter number of months to maturity for fourth forecast period:

 

Type the appropriate codes in response to the first two prompts and press RETURN.

 

Enter the projected rate increase or decrease (enter a decrease as a negative number) and press RETURN. The maximum value is 99.9999. Then enter the number of months in each of the four forecast periods.

 

The system prints the report and then displays a bar chart of the forecast on the CRT. Press RETURN to display the Certificate of Deposit menu.

 

PLEASE ENTER A SAMPLE FORECAST REPORT

 

Figure 5.6 Sample Forecast Report

 

PLEASE ENTER A SAMPLE FORECAST BAR CHART

Figure 5.7 Sample Forecast Bar Chart

5.4.7 CHECK REGISTER

 

The Check Register is a list of certificate of deposit interest checks printed for the day.

 

From the Certificate of Deposit menu, enter 26 for the Check Register. The system then displays:

 

Print C.D. interest check register from MM/DD/YYYY [ ]

 

The system will automatically display the current system date. If the date is correct, press RETURN. The cursor will then prompt you to enter the last date by displaying:

 

Print C.D. interest check register from MM/DD/YYYY through MM/DD/YYYY [ ]

 

After you enter the second date and press RETURN, the system will display "inclusive". The check register for the specified dates will then be printed. If no checks are found, the system will return to the Certificate of Deposit menu. A sample appears below.

 

ENTER A SAMPLE CHECK REGISTER PLEASE

 

Figure 5.8 Sample Check Register

5.4.8 EDIT LIST

 

The Edit List is a report used to determine potential data entry errors. The program can optionally produce a report of all certificates on file or only those entered on the day the report is run. Any potential errors detected by the program, such as high or low interest rates or long terms, are noted on the report by an asterisk (*).

 

From the Certificate of Deposit menu, enter 27 for an Edit List. The system displays the prompt:

 

ENTER '1' FOR NEW OR '2' FOR ALL C.D.'S: [ ]

 

Enter the code for the report type desired and press RETURN. The system begins printing the report and returns to the Certificate of Deposit menu.

 

ENTER A SAMPLE OF EDIT LIST

 

Figure 5.9 Sample Edit List

5.4.9 INTEREST PAYMENT FORECAST REPORT

 

The Interest Payment Forecast Report provides a detailed list of interest payments to be made during the period specified. The projected payments are listed in date order with totals for each month included. It should be noted that the report may not be complete (especially if it includes projected payments several months in advance) because of new certificates that might be added in the future with interest payments due prior to the end of the period requested.

 

From the Certificate of Deposit menu, enter 28 for Interest Payment Forecast Report. The system displays the screen:

 

C.D. INTEREST PAYMENT FORECAST

 

Print C.D. interest payment detail from MM/DD/YYYY [ ]] through inclusive

 

The current Certificate of Deposit system date is shown as MM/DD/YYYY. To start the projection with the current date, press RETURN. Otherwise, backspace over the date shown, key the appropriate date and press RETURN. Note that the "from" date may not be prior to the current system date.

 

The system positions the cursor to the "through" date field. Enter the last date of the desired period and press RETURN.

 

The system begins to print the report and displays the Certificate of Deposit menu on the screen.

 

 

 

 

PLEASE ENTER C.D. ADVANCE INTEREST PAYMENT FORECAST REPORT

 

Figure 5.10 Sample Interest Payment Forecast Report

5.4.10 ADVANCE CHECK REGISTER

 

The Advance Check Register is a list of certificate of deposit interest checks that have been entered into the Transaction Journal. This is essentially an expanded version of the Check Register, which lists the C.D. interest checks printed for the day. The Advance Check Register allows you to print a listing of checks for an extended period of time (usually a month) rather than just one day.

 

From the Certificate of Deposit menu, enter 29 for the Advance Check Register. The system then displays:

 

Includes C.D. interest checks from MM/DD/YYYY through MM/DD/YYYY.

 

Press RETURN: [ ]

 

The system automatically displays the dates for the check register based on records in the Transaction Journal for certificates of deposit. When you press RETURN, the system will print the check register for the dates specified.

 

The system will then return to the Certificate of Deposit menu screen.

 

SAMPLE CHECK REGISTER

5.4.11 CHANGE PRINT SIZE

 

This program allows you to enter a code which will automatically change the print size on the printer.

 

NOTE: Be sure the printer is aligned to top of form before entering code.

 

From the Certificate of Deposit menu, enter 30 for Change Print Size. The system displays the screen:

 

ENTER SCREEN FOR DISPLAY PRINT SIZE

 

Enter the code of the size you desire and press RETURN.

 

The system momentarily displays the message: "CHANGED" and returns to the Certificate of Deposit menu.

5.5 CUSTOMER NOTICES

 

The Certificate of Deposit system provides for generating the following customer notices:

 

    • Notices of interest payments to savings or checking accounts or the certificates of deposit.

 

    • Notices of maturity for certificates nearing maturity.

 

    • Annual Form 1099 interest notices.

 

    • Interest checks for certificates coded for interest to be paid by check.

 

 

Function Selection

 

Throughout this section you will be asked to select a particular function from the CUSTOMER NOTICES portion of the Certificate of Deposit menu. The following example illustrates that portion of the menu.

 

CUSTOMER NOTICES

 

Notices

1099's

Checks

Advance Checks

5.5.1 NOTICES

 

The Notices program prints advance maturity notices for certificates nearing maturity or interest payment notices for certificates that have received an interest payment. This program also allows you to change the sort sequence, form length, and name position for the notices and to edit the notice messages to be printed.

 

From the Certificate of Deposit menu, enter 40 for Notices. The system displays the following menu:

 

CERTIFICATE OF DEPOSIT NOTICES

 

1. Print Maturity Notices

Print Interest Notices

 

Change Sort Sequence

Change Form Length

Change Name Position

Edit Interest Notice Message

Edit Non-Renewable Maturity Notice Message

Edit Renewable at Renewal Rate Maturity Notice Message

Edit Renewable at Same Rate Maturity Notice Message

 

 

ENTER SELECTION [ ]

 

Select the function you wish to execute by typing the number preceding it and press RETURN.

 

Maturity Notices

To print Maturity Notices, select option 1. The system will prompt you to enter the date range for the matured certificates by displaying:

 

PRINT MATURITY NOTICES

 

Include Matured Certificates from MM/DD/YYYY [ ]

 

If the date displayed is the correct beginning date, press RETURN. To change the date, backspace the cursor to the beginning of the field and enter the date you want to use. Then press RETURN. The system will display:

 

PRINT MATURITY NOTICES

Include Matured Certificates from MM/DD/YYYY through MM/DD/YYYY [ ]

 

Follow the procedure outlined above to accept or change the second date and press RETURN. The system will then print the first notice as a test and ask you:

 

Is form aligned? (Y/N): [ ]

 

If the first form is properly aligned to begin printing, type Y and press RETURN. If the form is not aligned, type N and press RETURN. The print test will be repeated after you adjust the form. After the notices have been printed, the Certificate of Deposit menu will be displayed.

Interest Notices

 

To print Interest Notices, select option 2. The system will display the following:

 

PRINT INTEREST NOTICES

 

Include Payments by Check? (Y/N):

 

Type Y or N according to your preference and press RETURN. The system will then prompt you for date information:

 

Include Interest Payments from MM/DD/YYYY [ ]

 

If the date displayed is the correct beginning date, press RETURN. To change the date, backspace the cursor to the beginning of the field and enter the date you want to use. Then press RETURN. The system will display:

 

Include Interest Payments from MM/DD/YYYY through MM/DD/YYYY [ ]

 

Follow the procedure outlined above to accept or change the second date and press RETURN. The system will then print the first notice as a test and ask you:

 

Is form aligned? (Y/N): [ ]

 

If the first form is properly aligned for printing, type Y and press RETURN. If the form is not aligned, type N and press RETURN. The print test will be repeated after you adjust the form. After the notices have been printed, the Certificate of Deposit menu will be displayed.

 

Change Options

 

These options are designed to provide greater flexibility when printing notices. Using these options, you can change the sort sequence, form length, or name position or use any option to check the values currently in use.

 

    • To change the Sort Sequence of the list on file, type 10 and press RETURN. The system will respond by displaying:

 

CERTIFICATE OF DEPOSIT NOTICES

 

Sort Sequence

 

1. By Customer Number

2. By Name

3. By Certificate Number

4. By Date

5. By Zip Code

 

ENTER SELECTION: N[ ]

 

The number appearing left of the cursor indicates the current basis by which the file is sorted. Select the basis for sorting the list by typing the appropriate number (1 through 5) and press RETURN. The system will respond by displaying the NOTICES menu.

    • To change the Form Length of the notices to be printed, type 11 and press RETURN. The system will respond by displaying a prompt and the current form length:

 

Form Length: 20[ ]

 

To keep the same form length, simply press RETURN. To change the form length, backspace the cursor over the current number and then type the new length. Then press RETURN. The system will respond by displaying the Notices menu.

 

    • To change the Name Position on the notices to be printed, type 12 and press RETURN. The system will respond by displaying a prompt and the current line number on which the customer's name will appear:

 

Name Position: 10[ ]

 

To continue printing the customer's name in the same place, simply press RETURN. To change the line number, backspace the cursor over the current entry and then type the new line number, then press RETURN. The system will respond by displaying the NOTICES menu.

Edit Options

 

These four options allow for entry, recording, and updating of the notice messages. To edit one of the messages, select the appropriate option (13 through 16) depending on the type of notice to be printed. After you type a selection number and press RETURN, the system will display the message currently recorded for that notice. A sample appears below:

 

EDIT RENEWABLE AT SAME RATE MATURITY NOTICE MESSAGE:

 

LINE 1: THIS CERTIFICATE WILL BE []

LINE 2: AUTOMATICALLY RENEWED ON THE

LINE 3: MATURITY DATE FOR A LIKE TERM

LINE 4: AT THE RENEWAL RATE SHOWN

LINE 5: ABOVE UNLESS PRESENTED AT THE

LINE 6: BANK FOR PAYMENT WITHIN TEN

LINE 7: DAYS OF THE MATURITY DATE.

 

To leave a line of the message as is, simply RETURN. The cursor will move to the end of the next line. To change the message, position the cursor on the line to be changed and then backspace to the point at which your changes begin. Then type your new message, and press RETURN at the end of each line. After you press RETURN at the end of the last line (in the above example, line 7), the system will display the NOTICES menu.

5.5.2 1099'S

 1099's for Certificates of Deposit are printed by the Government Reporting Library along with 1099's from the Deposit Account system and 1098's from the various loan systems. Due to the many changes in government reporting mandated by the IRS each year, a new manual is distributed along with the new government reporting library each year.

 

5.5.3 CHECKS

 

The Checks program prints interest checks for certificates that have received an interest payment coded to be paid by check.

 

From the Certificate of Deposit menu enter 42 for checks and press RETURN. The system displays:

 

Print C.D. interest checks from MM/DD/YYYY [ ]

 

The system will automatically display the current system date. If the date is correct, press RETURN. Otherwise, backspace over this date and enter a different start date.

 

The cursor will then prompt you to enter the last date by displaying:

 

Print C.D. interest checks from MM/DD/YYY through MM/DD/YYYY [ ]

 

After you enter the second date and press RETURN, the system will display Ainclusive@, and then flash:

 

Scanning for checks

 

If no checks are to be printed, the system will return to the Certificate of Deposit menu. If there are checks to be printed, the system displays:

 

Enter printer format code: [ ]

 

Type the appropriate code and press RETURN. The system will then prompt you to:

 

Enter first check number: [ ]

 

Enter the number of the first check to be printed and press RETURN. Jthe system will print the first check as a test and then ask:

 

If form aligned? (Y/N): [ ]

 

If the form is properly aligned, type Y and press RETURN. If not, realign the form and type N. The system will repeat the test until you respond Y to print the checks. After the checks are printed, the system returns to the Certificate of Deposit menu.

 

PLEASE PUT SAMPLE CD CHECK HERE

5.5.4 ADVANCE CHECKS

 

The Advance Checks program prints interest checks for certificates of deposit that are coded to be paid by check. This is essentially an expanded version of the CHECKS program. The advantage of the ADVANCE CHECKS program is that greater numbers of checks can be printed all at once, thereby saving time and checks (by avoiding repetition of the test print procedure).

 

From the Certificate of Deposit menu, enter 43 for Advance Checks and press RETURN. The system displays:

 

Print C.D. interest checks from MM/DD/YYYY [ ]

 

The system will automatically display the current system date. If the date is correct, press RETURN. Otherwise, backspace over this date and enter a different start date.

 

The cursor will then prompt you to enter the last date by displaying:

 

Print C.D. interest checks from MM/DD/YYYY through MM/DD/YYYY [ ]

 

After you enter the second date and press RETURN, the system will display Ainclusive@, and then flash:

 

Scanning for checks

 

If no checks are to be printed, the system will return to the Certificate of Deposit menu. If there are checks to be printed, the system displays:

 

Enter printer format code: [ ]

 

Type the appropriate code and press RETURN. The system will then prompt you to:

 

Enter first check number: [ ]

 

Enter the number of the first check to be printed and press RETURN. The system will print the first check as a test and then ask:

 

If form aligned? (Y/N): [ ]

 

If the form is properly aligned, type Y and press RETURN. If not, realign the form and type N. The system will repeat the test until you respond Y to print the checks. After the checks are printed, the system returns to the Certificate of Deposit menu.

5.6 FILE INQUIRIES

 

The Certificate of Deposit system provides the following functions for file inquiries.

 

    • Display customer and certificate of deposit information on the terminal screen.

 

    • Display a report showing account activity for a particular customer.

 

    • Print a report showing account activity for a particular customer.

 

    • Calculate the penalty for early withdrawal of a certificate of deposit.

 

 

 

Function Selection

 

Throughout this section you will be asked to select a particular function from the INQUIRIES portion of the Certificate of Deposit menu. The following example illustrates the INQUIRIES portion of the Certificate of Deposit menu.

 

INQUIRIES

Customer/C.D. Inquiry

Display Customer Ledger

Print Customer Ledger

Calculate Penalty

5.6.1 CUSTOMER/C.D. INQUIRY

 

The Customer/C.D. Inquiry procedure displays the information for a specific customer. The system displays customer information, numbers, and balances for requested customer accounts. Accounts requiring attention will appear in a blinking mode on the screen.

 

Inquiries are made by specifying the customer number of the desired customer. The system then requests whether data for a specific account is to be displayed.

 

NOTE: This procedure is exactly the same as the Inquiry procedure that is selected as option number 2 from the CIF portion of the Certificate of Deposit menu.

 

From the Certificate of Deposit menu, enter 5 of Customer/C.D. Inquiry. After selection of 5, the system displays the prompt:

 

Customer Number: [ ]

 

Enter the number of the customer to be displayed. The system displays the information from the customer record. The following screen is a sample of the display:

 

PUT SAMPLE SCREEN HERE

The system then requests whether the detail for a particular certificate of deposit is to be displayed. The system displays the prompt:

 

Certificate Number: [ ]

 

To display the detail for a certificate of deposit, enter the number. If the number does not exist in the file, the system assumes that you want to enter a new certificate. Refer to Section 5.3.1 for entry of a new certificate of deposit.

 

When the number does exist in the file being processed, the certificate of deposit information is displayed. The following screen is a sample of the display.

 

SAMPLE SCREEN

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This procedure also allows you to process a transaction against the specified certificate of deposit. After the certificate information is displayed, the system displays the prompt:

 

Transaction Code? [ ]

 

To process a transaction, refer to Section 5.3.3 for a description of transaction entry.

 

When all inquiries have been made, perform an ESCAPE operation to return to the Certificate of Deposit menu.

5.6.2 DISPLAY CUSTOMER LEDGER

 

The Display Customer Ledger procedure displays a report showing account activity for a particular customer.

 

From the Certificate of Deposit menu, enter 6 for Display Customer Ledger. After selection of 6, the system displays the prompt:

 

Customer Number: [ ]

 

Enter the number of the customer to be reported.

 

The system displays the requested customer ledger on the screen.

5.6.3 PRINT CUSTOMER LEDGER

 

The Print Customer Ledger procedure prints a report showing account activity for a particular customer.

 

From the Certificate of Deposit menu, enter 7 for Print Customer Ledger. After selection of 7, the system displays the prompt:

 

Customer Number: [ ]

 

Enter the number of the customer to be reported. The system prints the requested customer ledger and returns to the Certificate of Deposit menu. A sample customer ledger appears on the following page.

PUT A CUSTOMER CD LEDGER HERE

5.7 UTILITIES

 

The Certificate of Deposit system includes a set of utility procedures that are used to maintain the system files. These utility programs include procedures to:

 

    • Display status information about any desired data file.

 

    • Compress a file which rearranges the data space used by a file, thus reclaiming any unusable areas.

 

    • Create and/or modify control records used by the various files.

 

    • Change the year-to-date interest.

 

    • Change certificate of deposit dates.

 

    • Remove the transaction history for cashed certificates from the Transaction file.

 

    • Initialize and rebuild a lookup file that is used by the system for maintaining customer and account numbers.

 

    • Delete cashed certificates of deposit.

 

 

This section describes the steps necessary to complete the above functions.

 

 

 

Function Selection

 

Throughout this section you will be asked to select a particular function from the BANCADO UTILITIES menu. The BANCADO UTILITIES menu is selected from the UTILITIES portion of the Certificate of Deposit menu. The following is an example of the UTILITIES portion of the Certificate of Deposit menu:

 

UTILITIES

BANCADO Utilities

Record Display

JUST ASK II

Change Applications

 

This section describes selection 96. Selection 97 is used only by your CADO representative; this utility is used to determine the cause of file errors. Selection 98 calls up the JUST ASK II system, which is used to generate reports; the JUST ASK II system is documented in the CADO JUST ASK II User=s Manual. Selection 99 causes the system to display the BANCADO main menu.

 

The following is a sample of the BANCADO UTILITIES menu:

 

BANCADO UTILITIES

  1. Display File Status
  2. Compress File
  3. Edit Control Records
  4. Change YTD Interest
  5. Change C.D. Dates
  6. Print and Purge Old History
  7. Build Lookup File
  8. Delete Cashed C.D.=s
  9. Change Applications

 

 

Selections 1 through 8 are described in this section. Selection 9 causes the system to display the BANCADO main menu.

5.7.1 DISPLAY FILE STATUS

 

This utility produces a display of information about any desired data file. This information can be used to learn whether the file needs to be compressed or resized. In exceptional cases, the information may also indicate that data records have been lost.

 

A file status table, with sample figures, is shown in Figure 6.19.

 

PUT SAMPLE HERE

The DEFINED section of the table lists numbers that were specified when the file was defined, as follows:

 

# RECORDS Maximum number of record keys in the file.

 

KEY LENGTH Search key length.

 

AV REC LENGTH Average record length.

 

FILE START File start location (drive and track).

 

FILE END File end location (drive and track).

 

The ACTUAL section of the table indicates the current condition of the file as follows:

 

NORMAL Number of normal records in the file, the number of data bytes used by these records, and the average data length of the records in the file.

 

OVERFLOWED Number of overflowed and overflow records, the number of data bytes

OVERFLOW used by overflowed records, and the average record length of overflowed records.

 

DELETED Number of records deleted and amount of data spaces in bytes rendered unusable by record deletion and updating.

 

AVAILABLE Amount of space available in the file, including the number of available record keys (COUNT) and number of available bytes. AVG is the average number of bytes in each record if the total number of available records keys are defined in the available space.

 

Note that the ACTUAL figures for a sort file are meaningless; in any case, a sort file should never require maintenance.

 

The ACTUAL data in the File Status report is used to determine whether or not a file needs compression, is approaching full capacity, or contains damaged data. A file needs compression if the numbers OVERFLOWED and/or DELETED bytes are large compared to the AVAILABLE bytes.

A file is approaching full capacity if, immediately after compressing the file, the AVAILABLE count and bytes are small compared to the NORMAL count and bytes. The AVAILABLE count gives the maximum number of records that can still be added to the file.

 

An overflow occurs when an attempt is made to write a record on a track and there is room for the key portion, but there is not room for the data portion of the record. The kye, which is marked as an OVERFLOW record, points to the OVERFLOWED record, which is placed on the next track with room for both the key and data portions of the record.

 

A file contains data that has been damaged if the OVERFLOWED and OVERFLOW counts are not equal. If these counts are unequal, data has probably been lost from the file.

 

From the Certificate of Deposit menu, enter 96 for Utilities. From the BANCADO UTILITIES menu, enter 1 for Display File Status.

 

The screen displays a blank file status table and waits for you to enter a file number. Enter the number of the desired file, as follows:

 

0 System Control File

1 Customer Information File

2 Commercial Loan File

3 Installment Loan File

4 Installment Loan Earnings File

5 Certificates of Deposit File

6 Deposit Account File

7 Transaction File

8 Name Lookup File

9 Lookup File

 

The system fills in the file status table for the specified file. If the system completes only the upper half of the table, the data diskette that contains the file is not mounted correctly.

 

After viewing the file status, press RETURN to request the status of another file, or perform an ESCAPE to return to the Certificate of Deposit menu.

5.7.2 COMPRESS FILE

 

Routine file editing procedures, such as deleting records or changing record lengths, can create temporarily unusable storage area in a data file. As a consequence, the time required to retrieve records and the likelihood of overflowing the file are increased. The Compress File utility rearranges data space, reclaiming most of the unusable area.

 

The Display File Status utility is available to indicate whether a file needs compression. However, there is no harm in compressing a file which does not actually need it, and compression is generally run as a routine maintenance procedure. Some application programs may compress files automatically.

 

File compression is one of the operations that can damage data if interrupted by the operator or by hardware failure. It is best to obtain a backup immediately before compressing a file.

 

NOTE: The Sort file, File 9, cannot be compressed.

 

From the Certificate of Deposit menu, enter 96, for BANCADO UTILITIES. From the BANCADO UTILITIES menu, enter 2 for Compress File. The system displays:

 

FILE COMPRESSION

 

ENTER FILE NO. [ ]

 

Enter the number of the desired file. The system compresses the file. Upon completion, the system displays:

 

DONE

 

Press RETURN to use this utility again or perform an ESCAPE to return to the Certificate of Deposit menu.

5.7.3 EDIT CONTROL RECORDS

 

This utility is used only by your CADO representative during system installation and during program updates. This utility is used to create and/or update special control records. These special control records store bank control information, such as bank totals and transaction totals.

 

The special control records are maintained in the Transaction file, File 7.

 

From the BANCADO UTILITIES menu, enter 3 for Edit Control Records. The system displays the current bank totals. For each total, press RETURN to accept the value or enter a new value. The following screen is a sample of the display:

 

YEAR TO DATE INTEREST:

YESTERDAY=S BALANCE:

CURRENT BALANCE:

ACCRUED INTEREST@

The system displays the transaction codes and descriptions. For each item, press RETURN to accept the code or enter a new code. The following screen is a sample of the display:

 

TC: 10

DESCRIPTION: New Certificates:

 

When all modifications are complete, enter a transaction code of 0. The system displays the Certificate of Deposit menu.

5.7.4 CHANGE YTD INTEREST

 

Normally, the Change Year-to-date Interest program is used only during conversion.

 

From the BANCADO UTILITIES menu, enter 4 for Change YTD Interest. The system displays the screen:

 

PUT SAMPLE SCREEN HERE

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Enter the customer number, if known, and press RETURN. If the customer number is entered and there is only one certificate on file for the customer, the system displays the certificate information. Otherwise, the cursor is positioned to the Certificate Number prompt.

 

Enter the certificate number and press RETURN. The system displays the customer=s name and the values accumulated for the customer.

 

To accept an amount as correct, press RETURN only. To change an amount, backspace and make the correction. For the prompts requesting a net change, the amount entered may be preceded by a minus sign to decrease the figure on file. To leave a field unchanged, press RETURN without an entry.

After the New Accrued field has been accepted or changed, the system returns to the Customer Number prompt for the next entry. To terminate the procedure and return to the Certificate of Deposit menu, perform an ESCAPE.

5.7.5 CHANGE C.D. DATES

 

Because certificate dates are only changed due to an original entry error, this program has been separated from the main certificate change routine.

 

From the BANCADO UTILITIES menu, enter 5 for Change C.D. Dates. The system displays the following screen:

 

CHANGE CERTIFICATE DATES

 

Certificate Number: [ ]

Issue Date:

Balance Forward Date:

Next Maturity Date:

Next Payment Date:

Next Compound Date:

Last Payment Date:

Last Maturity Date:

 

Enter the certificate number and press RETURN. If the certificate requested is on file, the system displays the current dates on file. To accept a date as correct, press the RETURN key to proceed to the next date. To change a date, backspace over the date in error and key the correct date.

 

After the last Maturity date is accepted or corrected, the record is rewritten and the system returns to the Certificate Number prompt. Perform an ESCAPE to terminate the program and display the Certificate of Deposit menu.

5.7.6 PRINT AND PURGE OLD HISTORY

 

This utility is used to delete transactions from the Transaction file. For certificates of deposit, transactions are deleted by date; that is, all transactions processed prior to a specified date are deleted.

 

The system first prints a list of all transactions that will be deleted by this utility. You then have the option of deleting the transactions or terminating the procedure.

 

Depending on available disk space and file size, transactions can be retained for several years prior to deletion.

 

From the BANCADO UTILITIES menu, enter 6 for Print and Purge Old History. After selection of 6, the system displays the following prompt:

 

Purge Transactions Prior To: MM/DD/YYYY [ ]

 

Press RETURN to accept the displayed date as the date of the oldest transaction history to be retained on the file. To change the displayed date, enter the correct date in MM/DD/YYYY format.

 

The system briefly displays the message:

 

Sorting

 

followed by the message:

 

Merging

 

and then the message:

 

Printing History

 

The system prints the history to be deleted and displays the prompt:

 

Do you want to delete the printed transactions? (Y/N): [ ]

 

Enter Y to delete the transaction history; enter N to retain the transactions on the file.

 

When a yes response is entered, the system deletes the specified transactions and reorganizes the remaining transactions in the file. As the system performs the deleting and reorganizing, the following messages are displayed on the screen:

 

Deleting Paid History

 

Rebuilding Transaction Lists

 

Upon completion, the system automatically displays the Certificate of Deposit menu.

 

 CAUTION: In the event of error or power failure, this utility must not be restarted until after recovery from backup.

5.7.7 REBUILD LOOKUP FILE

 

This utility is used to initialize and reconstruct the Lookup files, Files 8 and 9. This utility is used only if the size of a Lookup file is increased.

 

The Lookup files contain records for each customer and each account. The records in the files are sorted by customer number and account number.

 

From the BANCADO UTILITIES menu, enter 7 for Rebuild Lookup File. The system displays the prompt:

 

BUILD LOOKUP FILE

 

Press RETURN:

 

To rebuild the files, press RETURN. The system automatically initializes and rebuilds the files.

 

Upon completion, the system returns to the Certificate of Deposit menu.

 

 CAUTION: If this program is terminated due to file error or power failure prior to normal completion, the utility must be restarted and completed before any customer or account lookup can be performed..

 

5.7.8 DELETE CASHED C.D.=S

 

This utility deletes cashed certificates of deposit. Because you determine the amount of time that a certificate remains on file, the system does not automatically delete cashed certificates.

 

Certificates are deleted by date; that is, all certificates that were cashed prior to a specified date are deleted.

 

Note that deleting cashed certificates does not affect the preparation of a customer ledger. The customer ledger is prepared using the customer transactions only.

 

From the BANCADO UTILITIES menu, enter 8 for Delete Cashed C.D.=s. The system displays the prompt:

 

DELETE C.D.=S CASHED ON OR BEFORE: [ ]

 

Key the date of the newest cashed certificate to be deleted from the file. The system automatically deletes all certificates that were cashed prior to the specified date.

 

The system then automatically compresses the Certificate of Deposit file. A report will be printed indicating the number of certificates deleted and the current date. A sample appears below.

 

COMPLETE. 117 CERTIFICATES DELETED, 04/05/99

 

 END OF CERTIFICATE OF DEPOSIT SECTION

Table of Contents IndexTop