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

Monday, April 11, 2016

Generating Month-end Reports

Executive Summary
            The goal of this project was to create a tool that would simplify the process of collecting the data for month-end journal entries for the small business my wife does the accounting for. The business is called Sky Technologies and they are a retailer of Directv and Dish Network products. They have two locations, one in American Fork, UT and another in Las Vegas, NV. They specialize in doing large satellite installations and repairs. Some of their biggest clients include several Intermountain hospitals throughout Utah, Sundance Ski Resort, as well as several casinos in Las Vegas.
            Currently in order to collect the data for month-end journal entries my wife downloads four different excel spreadsheets from the company’s point of sale system, Agemni, performs some calculations and then combines the information from each of the spreadsheets into a single table. She then uses the numbers in this table to create the journal entries that go into Quickbooks. This journal entry records the Sales Revenue from Invoices billed to customers, Commissions received from both Directv and Dish Network, and the labor and equipment portions of Cost of Goods Sold. The system that I created pulls each of these reports from her password-protected account for the Point of Sale system, called Agemni. It then sums the necessary data from each of these reports and outputs it into a table that she can use to input the month-end journal entry into Quickbooks. 
            

No comments:

Post a Comment

Blog Archive