AICS Research


ATM Network
Balancing
Report


Last updated:

February 15, 1999
Summit Spectrum 28.13

Report highlights

This report was originally written in 1990 and it is still used today to reconcile ATM network transactions. Our credit union now drives 22 ATMs on intercept processing and we are connected to eight networks.

This report pulls information from the ATMNET databases and allows us to reconcile and post network transactions. The report separates cardholder and terminal activity. It also identifies the network and credit union posting days to which the various transactions refer.

The information is printed to a comma-delimited ASCII file and downloaded into an Excel spreadsheet where exceptions are identified and input. Required entries are posted. Exceptions are sent to the ATM department and handled according to network protocol.

The worksheet is all that is necessary to create the report. A template and macro are included so users may run the report daily as needed.

Note: Summit now offers a module that is supposed to read a file provided by your ATM network provider and identify "exceptions" (disagreements between the network and your database about the outcome of ATM transactions). This module is a significant development and only recently became available. The module is available for an additional cost and only identifies exceptions.


Files included
  • ATMBalW - QueryCalc worksheet
  • ATMBalM - QueryCalc macro
  • ATMBalR - ASCII file which stores the date
  • TATMBal1 - template which runs the macro
  • ATMBalD1 - sample comma-delimited ASCII file which stores the reconciliation data
  • ATMBalD2 - sample comma-delimited ASCII file which stores the reconciliation data
  • Readme.txt - a text file of instructions

Databases accessed
  • ATMNET - 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