This program will provide reports which will enable the user to reconcile debit card transactions appearing in DNA with those reported by Fiserv services. This program compares ATMRECON.CSV to the CD10 report and outputs a list of exceptions. In addition it uses the totals in the IF67 file to verify that we indeed got all the exceptions.
This DNAapp will save the accounting departments of each institution 15 to 30 minutes daily.
The current reconciliation process works as follows. First the details of each transaction is extracted from CD10 using a program called MONARCH. The output from MONARCH is a csv file. This csv file is compared with ATMRECON.csv via an ACCESS program. The output of this access program is fed into EXCEL and then manually sorted through to come up with the final exceptions.
Our App accomplishes all this and more with one click. We have created a new screen where we can select the three files CD10, ATMRECON and IF67 from a local filesystem. When the "Process" button on the screen is clicked the comparison is done and the exceptions are written to an exceptions file.
In addition this program checks its own work by adding up the exceptions it generates and comparing it to the difference in totals from the IF67 and ATMRECON. It should come out to be the same number.