Date of Award

Spring 5-1-2004

Document Type


Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Stephen Krebsbach

Second Advisor

Ronghua Shan

Third Advisor

Zehai Zhou


Defense Finance & Accounting Services (DF AS) Indianapolis is required to work a Suspense Account Reconciliation (SAR). For this process, each individual Army installation, Activity, or State National Guard Headquarters submits an Excel workbook to the installation's accounting center. The assigned accounting center then rolls up the worksheets into one submission to Headquarters. The Excel workbook submitted by each installation is designed as a template in report format. Each workbook has a detail sheet and a summary sheet. The detail sheet has 79 rows (fund categories) and 63 columns (aging) of data. The data reported is a breakdown of Absolute value, Net Value, and transaction count by fund and age. The existing SAR process took one person from 3 to 5 days monthly and used an Excel macro to compile the numerous submissions into one file. Once all of the data was rolled up, it was necessary to "cut-and-paste" data into other specific report formats. The section working this task requested an improved method to complete the process quicker and allow data collected to remain available for other computations. The resulting project allowed for a more time-efficient and user-friendly process. All data collected remains in tact and available for on-the-spot data calls. This is a new application that mimics results previously submitted to the higher headquarters. The application is a form driven executable database application loaded on the individual users desktop.