AICS Research


ATM Deposit
Report


Last updated:

February 15, 1999
Summit Spectrum 28.13

Report highlights

This worksheet reports the deposits received at a credit union ATM in a format that allows staff to balance them in an efficient manner. The network, account number and the command, identifies non-member deposits. Loan payments are also highlighted. Additional space is provided to reconcile deposit differences.

This detail list report allows the user to specify the date of the report with a template run within MDBO. The date supplied by the user is stored into an ASCII file via QUAD. The QueryCalc worksheet then "Reads" the ASCII file and places the date into the worksheet. This date is then used to calculate the rest of the worksheet.

On the scratch page, a list of all ATMs that received deposits on the report date is stored into a storelist. The macro then reads this list, one item at a time and recalculates and prints summary and detail information for each ATM in the list.

This report has been incorporated into our end-of-day job. It runs each night without input or interference from an operator. The report is printed and waiting on the department printer when employees come in in the morning.


Files included
  • ATMDepW - QueryCalc worksheet
  • ATMDepM - QueryCalc macro
  • ATMDepR - ASCII file which stores the date
  • TATMDep1 - template which runs the macro
  • Readme.txt - a text file of instructions

Databases accessed
  • ATMNET - Spectrum Image Database
  • 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).

QC Reports   QueryCalc

     Top