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.
http://files.gove.net/shares/files/10f/camdavis/Project_Writeup.pdf
No comments:
Post a Comment