A Guide to Cash Flow Statements with Template

Download a free cash flow statement template, learn how to prepare a statement, and discover the direct and indirect methods of cash flow statements.

A cash flow statement, along with the balance sheet and income statement, is one of the primary financial statements used to measure your company’s financial position. It tracks the cash inflow and cash outflow of cash from operating, investing, and financing activities during a given time period. The term “cash” refers to both cash and cash equivalents, which are assets readily convertible to cash. This financial statement provides relevant information to assess a business’s liquidity, quality of earnings, and solvency.

In this article you will learn:

• What is a Cash Flow Statement?
• Why Do Businesses Need Cash Flow Statements?
• What Does a Cash Flow Statement Show?
• How to Create a Cash Flow Statement
• What are Cash Equivalents?
• Direct vs. Indirect Cash Flow Methods
• Cash Flow Statement Formulas

• Free Cash Flow Statement Template
• Improve Your Cash Flow with QuickBooks

What is a Cash Flow Statement?

A cash flow statement is a financial document typically used to understand the solvency of your business. When combined with other financial statements, it can give you a clear perspective on the financial health of your small business.

Your company may have enough revenue to appear profitable, but slow collections of invoiced sales can impede your ability to meet your current financial obligations. Delayed payments to employees, suppliers, and other creditors can be massively detrimental to your business, so to understand your cash flow over a certain period of time, you need to create a cash flow statement.

A look back over a specific period of time (typically the last month or last quarter) enables you to look forward to the next period and to ensure you have the funds on hand to pay your bills.

In order to complete the cash flow statement template, here are the most essential details to know.

Why Do Businesses Need Cash Flow Statements?

You can think of your business’s cash flow like the waves of an ocean, with revenue washing in and payments for expenses flowing out. A picture of cash flow is not easy to capture because the ebb and flow of money in your business is constantly changing. Nonetheless, you need a solid grasp on your cash flow at all times so you can spot trends in cash management and keep your company solvent.

What Does a Cash Flow Statement Show?

The cash flow statement shows changes in your cash on hand, including cash in your bank account and short-term investments that you can easily convert to cash. Cash flow statement examples might reflect activities such as:

Operating Activities

Inflow from operating activities includes revenue from selling products and/or services, interest and dividends that the business receives, and other cash receipts. Outflow from operating activities includes payroll costs (wages, benefits, and employment sales tax), payments to suppliers, overhead costs (like rent, utilities, and insurance), income taxes and other business taxes, and other operations-related cash payments.

Investing Activities

Inflow from investing activities includes sales of business assets other than inventory, payments received from loans that your business made, and other income not generated by the normal course of business. Outflow includes purchases of capital equipment and loans that you make.

Financing Activities

Inflow reflects money that’s borrowed and the proceeds from the sale of your company’s securities. Outflow includes your debt service and dividend payments.

How to Create a Cash Flow Statement

In order to fill out a cash flow statement, you will need your most recent income statement and balance sheet. This will make filling out a cash flow statement template much more simple.

To create a cash flow statement manually, select a time period and review your income and expenses in each of the three activities discussed above. Use a self-created spreadsheet or download our excel cash flow template to organise your data into a cash flow statement. Essentially, your entries show cash in and cash paid out each month for the time period that your cash flow statement covers.

Alternatively, you can easily create a cash flow statement based on an accounting system such as QuickBooks. Since you’ve recorded your income and expenses on a regular basis, your accounting software has the information it needs to generate a cash flow statement automatically without the need for you to input each item of income or expense from your business activities.

What are Cash Equivalents?

Cash equivalents appear as assets on a balance sheet. They include cash along with any liquid investments you can quickly convert into cash.

Money in your savings account is considered cash, while the funds in your money market accounts or government bonds are cash equivalents. Generally, cash and cash equivalents don’t change much in value.

For instance, the value of inventory may fluctuate wildly, but short-term treasury bills tend to yield very modest gains. Even though money market accounts usually have higher rates of return than most savings accounts, they also result in modest changes to the overall value of your assets.

Having cash and cash equivalents on your balance sheet shows investors or lenders that your business is financially healthy. If your revenues take a dive, you can still stay on top of your bills and other short-term liabilities.

On the other hand, having too much cash or cash equivalents on hand can be a sign that you’re not taking full advantage of your liquid assets. To save money in the long run, you may want to use cash to pay down high-interest debts, for example.

The amount of cash or cash equivalents your business needs varies depending on your industry, your objectives, and how much debt you have. However, as a general rule, you should have enough cash or cash equivalents to cover three to six months of business expenses.

Direct vs. Indirect Cash Flow Methods

There are two different methods used to create a cash flow statement: the direct method for direct cash flow statements and the indirect method to create an indirect cash flow statement. The difference between the two methods only affects the cash flow from the operations section. There is no difference in reported cash flows for the investing or financing section, regardless of which method is used.

Cash Flow Statement Direct Method

This method deducts cash out from cash in by focusing on cash inflows and cash outflows of cash from operating activities. Examples of receipts under the direct method include cash collected from customers and cash received from interest and/or dividends. Examples of disbursements under the direct method include cash paid to suppliers for goods, cash paid to employees for services, and cash paid to creditors for interest and tax payments.

How to Use the Direct Cash Flow Method

Start by listing cash paid and received. Make sure to include line items for cash paid to employees, suppliers, and interest. Then include cash from customers.

Here’s an example of the direct cash flow statement for the sample company ABC Corporation.

Company: ABC Corporation

Statement of Cash Flows (Direct Method)

For the Year Ended December 31, 2022

Operating Activities:

Cash received from customers $200,000

Cash paid to suppliers and suppliers ($120,000)

Cash paid to employees ($50,000)

Interest received $2,000

Interest paid ($1,000)

Taxes paid ($10,000)

Net Cash Provided by Operating Activities $21,000

Investing Activities:

Purchase of equipment ($30,000)

Sale of investments $15,000

Net Cash Used in Investing Activities ($15,000)

Financing Activities:

Proceeds from bank loan $10,000

Payment of dividends ($5,000)

Net Cash Provided by Financing Activities $5,000

Net Increase in Cash $11,000

Cash at Beginning of Year $5,000

Cash at End of Year $16,000

In this example, the cash flow statement is prepared using the direct method, which reports the actual cash inflows and outflows from operating activities.

Cash Flow Statement Indirect Method

The indirect method is slightly more complex. It uses your company’s net income and then calculates depreciation. Non-cash items that are taken into account include depreciation, amortisation, account receivable loss provisions, and losses from the sales of fixed assets. The net income line items are also adjusted for changes in the ending and starting balances of current assets (with the exception of cash). The same type of adjustments must be made for changes in current liabilities.

How to Use the Indirect Cash Flow Method

Start by determining your operation’s net income and then converting the accrual net income into operating activity cash flows.

Some of the line items on a typical indirect method cash flow statement include any increase in accrued expenses payable, depreciation expense, decrease in accounts receivable, and deducting increases in inventory.

Here’s an example of an indirect cash flow statement for the sample company ABC Corporation

Company: ABC Corporation

Statement of Cash Flows (Indirect Method)

For the Year Ended December 31, 2022

Operating Activities:

Net Income $50,000

Adjustments for:

Depreciation and Amortisation $10,000

Increase in Accounts Receivable ($5,000)

Decrease in Inventory $2,000

Increase in Accounts Payable $3,000

Net Cash Provided by Operating Activities $60,000

Investing Activities:

Purchase of Equipment ($20,000)

Sale of Investments $8,000

Net Cash Used in Investing Activities ($12,000)

Financing Activities:

Payment of Long-Term Debt ($10,000)

Proceeds from Issuance of Stock $5,000

Net Cash Provided by Financing Activities ($5,000)

Net Increase in Cash $43,000

Cash at Beginning of Year $20,000

Cash at End of Year $63,000

In this example, the cash flow statement is divided into three sections: operating activities, investing activities, and financing activities. Use this example to create your own detailed cash flow statement. 

Considering Capital Expenditures in Cash Flow Statements 

Well-managed companies plan for capital expenditures, which may include investments in machinery, equipment, and other long-term assets. A chain of restaurants, for example, must eventually replace ovens, refrigerators, and furniture. The cost of replacement should be included in the restaurant chain’s annual budget.

If the restaurant can generate more cash from operations than is needed to pay for capital expenditures, the company has some options. The extra cash might be used to pay a dividend to investors, or it can be retained in the business to expand operations.

A successful business must manage liquidity and solvency. Liquidity refers to your business’s ability to generate enough current assets to pay current liabilities. Solvency has a long-term focus. If your company can produce cash inflows over the long-term, you can pay for capital expenditures in the future and repay loan balances.

Free Cash Flow Statement Template

QuickBooks free cash flow statement template with built in calculations is a great tool to help your business manage its cash flow. Once you start using our cash flow statement template you will be able to identify changes needed to improve cash inflows.

Understanding your company’s cash flow is critical to maintaining a positive cash flow. It’s important to identify the key cash drivers for your company’s operations, as well as understanding how the current period (i.e. month, quarter, or year) compares to a prior period. This template helps you outline those drivers by comparing the current and prior accounting periods in detail. A cash flow statement can provide a clearer picture of your company’s ability to pay creditors and finance growth.

Download QuickBooks cash flow statement template no matter what type of business you have. Our cash flow statement template can be customised to include the specific types of cash flow activities that apply to your company. To fill out this spreadsheet, enter the applicable values in their respective cells. The total amounts automatically populate based on the embedded formulas. An example cash flow statement is also included to help guide you through the process.

Improve Your Cash Flow with QuickBooks

Cash is essential for keeping your company afloat. Make sure you have a good understanding of where your money comes from and when, and where your money is spent so that you can meet your financial obligations.

Use QuickBooks free cash flow statement template to clarify your company’s position on cash. If you have any concerns about creating or understanding your cash flow statement, work with a CPA or other knowledgeable financial specialists. Automate your cash flow statements with QuickBooks cash flow planner and take control of your cash flow. Start a free 30 day trial today.



FAQs