How to Run a Statement of Cash Flows in QuickBooks Online

Welcome to the Fit Small Business QuickBooks Online training course! In this lesson, we’re going to cover the importance of reviewing your statement of cash flows and how to prepare a statement of cash flows with examples in QuickBooks Online.

To complete this lesson, you can either watch the video below, read through the step-by-step instructions, or do both. Let’s begin!

Before we get started with the lesson, it’s worth mentioning that there are affordable virtual bookkeepers that can set-up and manage your QuickBooks for you. They will even help you get caught up if you are behind. For example, SmartBooks offers help with cash flow management, monthly financial statements, payroll processing and more starting at $250/month. Get a free consultation to learn more.

What is a Statement of Cash Flows?

The statement of cash flows shows the flow of cash within the business, including where it came from and how it was spent during a specific time period. Depending on the type of transaction, cash flow is categorized into 3 types of activities:

Operating Activities –This section shows how much cash was generated from operations which make up the day-to-day running of the business. For example, for our fictitious plumbing company Paul’s Plumbing, the cash generated from the sale of plumbing products and services would be considered operating activities.

Investing Activities–This section shows how much cash was generated from assets purchased for the business. For example, say Paul purchased a truck to use in the business. Regardless of whether the transaction was paid in cash or financed, it would appear under investing activities. In addition, any portion that was financed will also appear under financing activities.

Financing –This section is the cash that has come in or gone out of the company for the purpose of financing all of the other business activities. For example, any funds invested in the business by the owner would show up here. Also, if a portion of the truck that Paul purchased was financed, then the loan would also be categorized in this section.

Cash flow is essential to stay in business. If you don’t have enough cash to meet your obligations and to reinvest, then you won’t be in business very long. In the How to Run a Profit & Loss statement lesson, we discussed the importance of reviewing your income and expenses and looking for trends that can give you insight into the contributing factors to your “bottom line.” In the How to Run a Balance Sheet lesson, we discussed how that report will provide you with the net worth of your business as of a point in time. However, these two reports alone cannot tell you everything that you need to know to make good business decisions.

You need all 3 reports–the P&L Statement, the Balance Sheet, and the Statement of Cash Flows–to give you a complete picture of the health of your business. In the next section, we will walk through the components of the Cash Flow Statement. It includes figures that you may also see in both the P&L Statement and the Balance Sheet.

What are the Components of the Statement of Cash Flows?

To help demonstrate the components of the Cash Flow Statement, we will take a look at the Cash Flow statement for our fictitious company, Paul’s Plumbing. As we discussed previously, there are 3 sections of the Cash Flow Statement, as highlighet below by the three red boxes in the statement of cash flows example. There are also several different terms you need to understand.

Statement of Cash Flows Example

Net Income – This figure will come directly from the “bottom line” of your Profit & Loss statement.

Net cash provided by operating activities – This section is comprised of the net cash inflow and outflow of day-to-day business operations.

Net cash provided by investing activities – This section is comprised of the net cash inflow and outflow of any investments made in the business. Paul purchased a truck to use in his business, so that purchase is listed here as a cash outflow item.

Net cash provided by financing activities – This section is comprised of the net cash inflow and outflow of any type of financing that supports the business operations. In this example, Paul financed his truck, so the amount of the loan that he took to purchase the truck is listed in this section as a cash inflow item.

Net Cash Increase for the period of $9,867.72 is the total of all 3 activities as follows:

Operating Activities: $7,611.73

Investing Activities: (-$10,000.00)

Financing Activities: $12.255.99

Cash at the end of the period – This total is cash at the beginning of the period, which is $5,500 in this example, plus the net cash increase of $9,867.72. That gives a total of $15,367.72.

How Do I Run a Statement of Cash Flows in QuickBooks Online?

Step 1 – Navigate to the Report Center

From the Home page, click on Reports located on the left menu bar as indicated below.

Step 2 – Report Center

Click on the All Reports tab. Statement of Cash Flows is the fourth report listed as indicated below.

Step 3 – Report Filters

From this screen, you have several options to choose from as indicated below:

Print – You have the ability to print this report.

Email – You can email this report to anyone that you would like to review it (i.e. CPA or tax professional)

Export – You can export this report to Excel and make notes or do further analysis.

Customize – This feature allows you to customize a number of areas of the report, including but not limited to the following:

General info: Date range

Level of detail to show: One total column or one column for each month

Header/Footer: Change or add title or page #

Numbers: Select font for numbers

Save customizations – Allows you to save any custom changes that you have made to the report so that you can use them again.

Transaction Date – Select the time period that you would like to run the report for.

Calendar – You can enter a specific date range that you would like to run the report for.

Click Run Report button once you have made all of your selections.

Step 4 – Display Report

Click the Finish button, and your Statement of Cash Flows will display on the screen like the one below for Paul’s Plumbing.

Statement of Cash Flows Example

Recommended Action Plan

Now that you have a better understanding of what the Statement of Cash Flows will tell you about your business and how to create one in QuickBooks Online, there are a few things you should implement as soon as possible.

As you now know, the Statement of Cash Flows pulls several key numbers from both the Profit and Loss Statement and the Balance Sheet. Therefore, it is very important that the following have taken place before you prepare a Statement of Cash Flows:

Wrap Up

That wraps up the section on How to Run a Statement of Cash Flows in QuickBooks Online. The next lesson in our QuickBooks Online Training Course will be How to Run an Accounts Receivable Aging report in QuickBooks Online. In this course, we will discuss what the Accounts Receivable Aging report will tell you about your business and how to create an A/R Aging report in QuickBooks Online.

Our Recommended QuickBooks Apps

Forget paper punch cards or sign-in sheets–go digital with Tsheets and have accurate time cards every week! You can also manage PTO requests and import records directly to QuickBooks. Click here for a free trial.

About the Author

Crystalynn Shelton

Crystalynn Shelton is a CPA and staff writer at Fit Small Business, specializing in small business Bookkeeping, Accounting, and Taxes. She is also an Adjunct Instructor at UCLA Extension where she has taught hundreds of small business owners how to setup and manage their books using QuickBooks for 8 years. Prior to joining Fit Small Business, Crystalynn was a Senior Learning Specialist at Intuit for 3 years and also ran her own QuickBooks consulting and training business. When Crystalynn isn’t writing or teaching, she enjoys rollerblading in Venice Beach and reading a good book.

Related Posts

Submit Your CommentDisclaimer: Reviews on FitSmallBusiness.com are the product of independent research by our writers, researchers, and editorial team. User reviews and comments are contributions from independent users not affiliated with FitSmallBusiness.com's editorial team. Banks, issuers, credit card companies, and other product & service providers are not responsible for any content posted on FitSmallBusiness.com. As such, they do not endorse or guarantee any posted comments or reviews.Cancel reply

Comment

Review Source

How likely are you to recommend this product to a friend or colleague?

What does the company do well?

What does the company not do well?

What about the company do you wish you had known before purchasing?

Upload a screenshot...

To be marked as a Verified User, upload a screenshot of you logged into the platform. The image will be reviewed by our team and will not be posted publicly.

Social

Contact Us

Disclaimer: We spend hours researching and writing our articles and strive to provide accurate, up-to-date content. However, our research is meant to aid your own, and we are not acting as licensed professionals. We recommend that you consult with your own lawyer, accountant, or other licensed professional for relevant business decisions. Click here to see our full disclaimer.

Product or company names, logos, and trademarks referred to on this site belong to their respective owners.

Insert/edit link

Enter the destination URL

URL

Link Text

Open link in a new tab

Or link to existing content

Search

No search term specified. Showing recent items.Search or use up and down arrow keys to select an item.