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, December 14, 2009

Final Project Journal Entries

Executive Summary-

The VBA program that will be discussed involves reconciling journal entries made at my current place of employment. Each day a journal is created to record the general accounts that were affected during the previous day’s business. The daily journals vary in length and amount according to what transactions took place. At the end of the month, the daily journals are compiled into a detail summary spreadsheet. This spreadsheet is compared with the monthly journal entries that summarize all transactions during the month. The process of combining the daily journal entries with the summarized monthly entries takes two to three hours depending on the number of errors.

The process that was automated consists of compiling all daily journals into the summary spreadsheet and comparing the sum of the daily journals with what was uploaded to the journal site. This process takes anywhere from half an hour to an hour to complete, depending on the corrections that need to be made. The automation of this process has reduced the time required for completion because one need only correct potential discrepancies between the two sources of data.

No comments:

Post a Comment

Blog Archive