Audit Reconciliation Program
Master of Science
The objective of this project is to start with an existing Windows network-shared Microsoft Access application (MSA) that runs at the PC-level with a web application database table named dbo.PaidDisbursement created previously with SQL Server. This new program enhances an existing MSA application named “MSA Audit Program” to allow clients and auditors the ability to reconcile federal fund daily drawdown amounts and cumulative daily check amounts for each student within an MSA Audit Program against checks produced for student distributions held in a web application table. This “interim” project is important because requests for more detailed information to reconcile accounts is a manual process by office personnel in the form of an excel spreadsheet. The turnaround time on such requests is 5-7 business days. The new program enhancement will present the detailed reconciled data on demand from auditors based on the Audit package generated in MSA Audit Program.
This program enhancement will be locally coded in MSA within a new enhancement of the Audit program named the AUDIT RECONCILIATION PROGRAM. The MSA program code and the web databases will co-exist within one MSA program with a release date of December 2022. By the end of 2023, the projection is to have this program available in the TEAM web application so that the clients and auditors can tie out each drawdown with the student disbursements when needed.
Westberg, Laurie, "Audit Reconciliation Program" (2022). All Capstone Projects. 573.