0
DAYS
0
HOURS
0
MINS
0
SECS
Over 4.5 million customers use QuickBooks.
Sign up for a free trial!
2020-04-21 21:25:33AccountantsEnglishhttps://quickbooks.intuit.com/au/resources/au_qrc/uploads/2020/04/Hero.jpghttps://quickbooks.intuit.com/au/resources/accountants/generating-a-cash-flow-forecast/2. Generating a cash flow forecast

2. Generating a cash flow forecast

2 min read

Before you can advise your clients on how to adapt to changing conditions, you need a clear picture of the current state of their business. A cash flow forecast helps you determine how long clients can maintain business operations, given their 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 clients cash positive.

We created a forecasting spreadsheet for you to use. Make a copy of the Google Docs spreadsheet.

QuickBooks cash flow planner

Enter your client’s name and the start date for the planner. Then enter your client’s name and the start date for the planner.

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 three 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.

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 Australia Pty Ltd. 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 Australia Pty Ltd. 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.

Rate This Article

This article currently has 2 ratings with an average of 5.0 stars

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.

Help Your Business Thrive

Sign up for our newsletter

Thanks for signing up!

Check your inbox for a confirmation email.*

*Check your spam folder if you don’t see a confirmation email.

Related Articles

Creating Financial Statements: How to Prepare a Cash Flow Statement

Cash flow in your business is like the waves of an ocean,…

Read more

Understanding business profitability with free cash flow

Most working businesses have a constant stream of income and expenditures stemming…

Read more