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

Tuesday, April 13, 2010

Business Charge Entry / Invoice Manager

Executive Summary:
My father-in-law is a geophysicist who owns his own consulting business. He has been managing his own finances from day one in a spreadsheet by entering in hourly charges and other reimbursable expenses. At the beginning of each month he would copy and paste the items for each client into a separate worksheet and attach the sheet to an email as the invoice. This method was not very professional looking and led to nonpayment for several invoices.

He has since been convinced to turn the handling of invoices over to my wife. The VBA application I built is a two part system will help each of them with the new process. For my father-in-law, it is an easier way to enter in all of the different charges and expenses that he accrues daily that need to be recorded for invoicing and also for tax purposes. For my wife, it is a convenient way to generate invoices by company and month, track which line item went out on which invoice and whether that line item has been paid off. When an invoice is created it can be sent from Excel to the email address listed for the client, or just saved for later use. It also allows her to manage clients in the system.

Final Project Write-up

Final Project Workbook

No comments:

Post a Comment

Blog Archive