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

Sunday, December 12, 2010

End-of-Semester Reconciliation

I am an accountant in BYU’s Student Leadership department. One of my responsibilities includes reconciling all of the expenses we approved throughout the semester with all of the expenses that actually came through on our reports. Our department does most of the activities put on by the university, and it is mostly run by students. By the end of one semester there are hundreds of transactions to go through in ten different areas, handled by hundreds of students. This job is very tedious and can consume up to weeks of time.

This program automates the semester-end reconciliation process by matching budgeted expenses with actual expenses and organizing them into four different categories: 1) already-reconciled and completed expenses, 2) expenses that need to be marked as reconciled, 3) budgeted expenses that never occurred and should be voided, and 4) actual expenses that occurred but were not budgeted for, and so must be documented in the database. Further review and processing is required for the last three categories of expenses, so the program also sorts them into separate spreadsheets for quick analysis.

  • No comments:

    Post a Comment

    Blog Archive