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.

http://files.gove.net/shares/files/10f/rsrobert/Fletcher_Rebecca_WriteUp1.pdf

http://files.gove.net/shares/files/10f/rsrobert/Fletcher_Rebecca_FinalProject.xlsm