2020-05-20 13:40:36 Cash Flow English Learn how to generate a cash flow forecast for your medium to small sized business. Find out how to do this directly in your QuickBooks... https://quickbooks.intuit.com/ca/resources/ca_qrc/uploads/2020/05/cash-flow-playbook.png https://quickbooks.intuit.com/ca/resources/cash-flow/generating-cash-flow-forecast/ Generating a Cash Flow Forecast

Generating a Cash Flow Forecast

2 min read

First thing first: let’s get a clear picture of the current state of your business. It helps you determine how long you can maintain business operations, given typical patterns of bringing in and spending money.

You can then use the forecast as a planning tool to evaluate “what-if” scenarios, based on potential adjustments to revenue and expenses. Set a goal to create a three-month plan to keep your cash positive.

Get the forecasting spreadsheet

Before you start, make sure all transactions are reconciled and the books are clean. To put together the forecast, you’ll need the data from a few QuickBooks reports.

  • Run a Profit and Loss report for the past 3 months to understand the average income and expenses for each month. For income, focus on the top sources of revenue. On the expense side, pay particular attention to payroll, rent, insurance, and marketing expenses.
  • Run the Open Invoices Report so you’ll be able to see anticipated sources of cash.
  • Run the Unpaid Bills Report to identify expected short-term cash outflows.


Next: Maximizing cash flow>>

<<Back: Cash flow playbook for small business owners


Coronavirus relief programs are evolving regularly. Please visit Canada’s COVID-19 website https://www.canada.ca/en/department-finance/economic-response-plan.html for the most up to date information.

The funding described is made available to businesses located in Canada and are not available in other locations.

This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Intuit Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Intuit Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers should verify statements before relying on them.

We provide third party links as a convenience and for informational purposes only. Intuit does not endorse or approve these products and services, or the opinions of these corporations or organizations or individuals. Intuit accepts no responsibility for the accuracy, legality or content on these sites.

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Related Articles

What Is Cash Flow?

When it comes to the operations of a business, cash is the…

Read more

How to Calculate Cash Flow

Accounting calculations reveal a lot about a business’s financial health. Knowing the…

Read more

How to Track Cash Flow

A business must track the inflow and outflow of cash to determine…

Read more