AICS Research


Returned Deposit
Form Letters


Last updated:

February 15, 1999
Summit Spectrum 28.13

Report highlights

Not all of the checks deposited by members are paid as expected. Some of these deposits are returned. The impact on the member's account is twofold. First, their accounts must be debited for the amount of the deposit. Second, their accounts will be debited for any discretionary fee imposed by the credit union. (e.g. a fee charged to recover the fee paid to the returning institution.)

If deposit items are returned against a member's account, one of three letters may be sent to the member:
  1. The first is sent to a member whose account is in good standing after the charges have been posted to the account. The letter and the returned item are mailed to the member.
  2. The second letter is sent to a member whose account balance is now negative.
  3. The last letter is sent to a member whose account balance is positive, but whose account is now below par.
In the latter two examples, the original item would be retained until the accounts have been placed in good standing.

This report uses QueryCalc to write the letters. All three letters are prepared at the same time. The macro reads the data from the worksheet and only prints the "correct" letter to send to the member. The credit union logo and an authorized signature have been scanned to reduce processing time.

Note: AICS will scan signatures provided by you for a very modest fee - $50 at this writing. Logos can also be also be created for an average charge of $500.

A template is provided to allow user input of relevant information. The same information could be provided by using QCPrompt.


Files included
  • RetnDepW - QueryCalc worksheet
  • RetnDepM - QueryCalc macro
  • TRetDep1 - template which runs the macro
  • Readme.txt - a text file of instructions

Databases accessed
  • MEMBRS - Spectrum Image Database

Special Requirements

PostScript printer. In order to print the report to the PostScript form provided, you must have a PostScript printer. If you do not have a PostScript printer, you will need to edit the layout page(s).

Logos. In order to use logos and signatures, you must contact AICS and have them added to your system.

QC Reports   QueryCalc

     Top