These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 9, 2010

Sales Batch Auditor

My wife works for a small company as a V.P. of Accounting. Because of some circumstances within the company, they do not have a single accounting system that can store all necessary data and create desire reports. In order to prepare necessary reports for analysis my wife must import sales data from three different sources and compare it against what has been collected. By going back and forth between four different spreadsheets, searching for customer names and purchases, and copying data from the three sales spreadsheets onto the batch collections spreadsheet she is able to identify, categorize, and summarize the transactions needed for reporting. My project automates this entire process.

This entire auditing process would take anywhere from 3-4 hours for each day when done manually, depending on the size of the batch. Using this program however, this process has been cut down to less than one minute.

No comments:

Post a Comment

Blog Archive