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

Friday, December 3, 2010

Executive Summary: Invoice Tracker

Executive Summary

I currently work for BYU Broadcasting, which is a part of BYU, as an accounting clerk. As we are a part of BYU, we do not actually cut checks for payments. Each week we send many different purchase requisitions and invoices to be paid. With several accounting clerks submitting invoices for payment it can get rather confusing when PRs and invoices are submitted. I created a spreadsheet to keep track of all purchase requisition and invoices. The spreadsheet consists of multiple user forms to input information as well as a user form to search for a specific line item. The spreadsheet also maintains a list of invoices that have been submitted for payment highlighting those that were submitted over a week ago but have not been paid.

No comments:

Post a Comment

Blog Archive