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

Thursday, December 12, 2013

VBA Final Project: Cash Flow Report for Paul Mitchell the School by John Brunt

Executive Summary:
                I built my project specifically for Paul Mitchell the School franchise owners who needed a quick and easy way to see cash inflows and outflows on a timeline to determine future cash needs.  The Paul Mitchell schools receive income from student tuition and fees as well as from service revenues and product sales.  Their cash outflows include rent, wages, and a variety of general administrative expenses.  My code helps school owners by logging into their QuickBooks Online account and pulling key reports and further analyzing them to create a one-page calendar of cash flows with some key ratios.  This report helps the owners understand their cash conversion cycle and see specifically when bills are coming due so that they are prepared to meet the cash needs of the business in case of a shortfall.  This cash management report should be of great value to the owners and management as they seek to operate in a manner that optimizes cash flow to the business.  The code is divided into three parts: data gathering (scrapping QuickBooks online for relevant data), report generation (manipulating data gathered into a concise report), and report printing (saving a PDF copy of the report for easy reading and quick email distribution).

Created by John Brunt

No comments:

Post a Comment

Blog Archive