How to Complete a Cash Flow Statement
What is a Cash Flow Statement?
A Cash Flow Statement is a financial statement that tracks the movement of a company’s cash over a selected period of time. This is an all-inclusive statement because it includes the inflow and outflow of cash made by the business through operations, investments, and financing activities. It is an indicator of good health when cash inflow exceeds cash outflow.
Why is a Cash Flow Statement Important?
Maintaining a clean cash flow statement is important because it allows you to project any cash flow issues down the line or can help you strategize how to best use your cash reserve. For example, as an artist you may confirm an engagement a year ahead of the actual engagement. Leading up to the event, you may need to pay for some expenses up front. This could cause cash flow issues if you have not properly prepared for the upfront costs. Knowing this information at the start will allow you to better negotiate, maintain successful relationships, and overall run a more financially healthy business.
Pentacle has provided a cash flow statement template that artists can use if they don’t have an accounting software such as QuickBooks. This template is ideal for individual artists looking for a way to organize their cash flow on a monthly basis. The formulas are pre-set into the excel sheet, so all you need to do is fill in your numbers. It’s important to remember that a cash flow statement works best when used alongside other financial statements such as an income statement and a budget.
Use the Pentacle Template to Get Started
How to Use this Template:
- Fill in your Company Name and Year in cell A1.
- The template is organized into three sections:
- Operating Activities ← Refers to all activities related directly to the function of running your business i.e. Contributed Income, Earned Income, Personnel expenses, production and travel expenses, general operating expenses.
- Cash Inflow ← We have provided some sample line items that are most common for an artistic entity.
- Cash Outflow ← We have provided some sample line items that are most common for an artistic entity.
- Investment Activities ← Refers to activities which bring a change to long-term assets such as the purchase and selling of property or equipment.
- Cash Inflow ← We have provided the most common type of investment activity for artistic entities.
- Cash Outflow ← We have provided the most common type of investment activity for artistic entities.
- Financing Activities ← Refers to activities related to raising capital and paying back long-term liabilities such as receiving and paying back a loan.
- Cash Inflow ← We have provided the most common type of investment activity for artistic entities.
- Cash Outflow ← We have provided the most common type of investment activity for artistic entities.
-
- Enter in your own numbers into each section for each month.
- Once you’ve entered in your numbers, your summary at the top will automatically be calculated. This will provide you with a clean overview at first glance. Numbers should be updated as you receive more information and receive actual numbers from month to month.
- Additional Tips:
-
- If you have QuickBooks, you can condense the Operating Activities section and just add a line for your net income for the same monthly period.
-
-
- Unlike other financial statements, this report should only reflect activity in which the cash movement actually occurred during that period.
-
Related Blog Posts
3 Accounting Terms Every Artist Should Know
3 Accounting Terms Every Artist Should Know These terms are essential for artist accounting Chart of Accounts It is important that your organization's money moves are informed and precise. In coordination with your Budget and Financial Reports, a consistent Chart of...
5 Questions to Ask Your Auditor
5 Questions to Ask Your Auditor What are the key questions to ask an independent auditor? Nonprofits are required to obtain an audit or review each year, depending on their budget size. The first step in any nonprofit audit or review is contacting an...
New York City Fiscal Sponsors
New York City Fiscal SponsorsList of Fiscal Sponsors in New York City Organizations that act as fiscal sponsors provide a vital service in the cultivation of new projects and entities. Any project or entity can be sponsored by a nonprofit fiscal sponsor if both...
Checklist for Processing 1099’s and W2s
Checklist for Processing 1099’s and W2’sEnd of Year Payroll Tax Forms: W2, 1099 Some of the most important payroll tax forms -- W2 and 1099 forms -- must be mailed out to your employees and contractors shortly after the calendar year ends. Any contractors who were...
5 Ways That You Can Benefit From Fiscal Sponsorship
5 Ways That You Can Benefit From Fiscal SponsorshipFiscal Sponsorship Has Both Financial and Administrative Benefits Fiscal Sponsorship has many financial and administrative benefits. Fiscal sponsorship refers to the practice of non-profit organizations...
Paycheck Protection Flexibility Act Adds Key Features to Existing Payroll Protection Program (PPP)
Paycheck Protection Flexibility Act Adds Key Features to Existing Payroll Protection Program (PPP) New Law Improves Provisions for PPP Loan Forgiveness PPP Applications Accepted until June 30 The Paycheck Protection Program (PPP), provides short term loans to small...
Pentacle’s nextSteps is supported, in part, by public funds from the National Endowment for the Arts, the New York State Council on the Arts with the support of Governor Andrew M. Cuomo and the New York State Legislature, and the New York City Department of Cultural Affairs in partnership with the City Council. Pentacle receives private support for nextSteps from the Booth Ferris Foundation, the Howard Gilman Foundation, the Rockefeller Brothers Fund, and the New York Community Trust.