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