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
12/12/2013
No comments:
Post a Comment