Audit Reconciliation Program

Publication Date

Fall 2022

Document Type

Capstone Project

Degree Name

Master of Science


Computer Science

First Advisor

Yunchuan, Liu


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.


This manuscript has been requested to be withheld from unrestricted open access.

This document is currently not available here.