QuickBooks Online Advanced Financial Forecasts

by

As a part of the Financial planning features available to QuickBooks Online Advanced users, a new 'Forecasts' functionality has been released.  Presently it is available to all U.S. QBO-Advanced subscribers. Intuit is planning on rolling-out this capability to all country versions of QBO-Advanced in the future.

Just like the daily or 7-day weather forecast can help you plan your day or the week, financial forecasts can help you set long-term and short-term goals for your business.

Forecasting is typically based on past performance and business trends. When building your forecast, your historical data is analyzed for patterns and then used to make projections based on that information.

With all your financial data available in QuickBooks Online Advanced, you can quickly and easily create forecasts and then use forecasts to create budgets.

Creating a forecast

QuickBooks Online Advanced users now have access to Forecasts, a Financial Planning feature, that allows them to create a forecast. To create a new forecast, the User must be able to sign in to QBO Advanced as either the Admin user, or as a Standard All-access user.

Review your businesses fiscal year

Prior to creating a forecast, you must confirm that the beginning date of your fiscal year has been set in QuickBooks Online Advanced. While it's possible to create a forecast any time, it is preferable to set your forecast start date to run consistent with your fiscal year.

  • Sign in to your QuickBooks Online Advanced account.
  • Go to Settings ⚙ and select Account and settings.
  • Select the Advanced tab.
  • In the Accounting section, review the First month of the fiscal year field. If it’s incorrect, select Edit ✎.
  • Select the required month from the drop-down ▼.
  • Select Save.

Creating a forecast

QuickBooks Online Advanced creates a forecast using only those accounts listed in your chart of accounts. You must modify your chart of accounts to include any additional accounts you need in your forecast prior to creating the forecast.

To create a forecast, you can use your past financial data in QuickBooks Online Advanced to build your first financial forecast:

  • From the left Navigation bar, select Financial planning, then select Forecasts (as shown below).
  • On the Forecast like a pro page, select Create forecast (as shown below).
  • On the Set up your forecast page, select the timeframe you’re creating the forecast for from the Forecast for ▼ drop-down.

3

  • From the Forecast using ▼ drop-down, select one of the following forecast methods: Average of actuals or Actuals from last fiscal year (Note: Using the Settings panel, you can modify the forecast duration and forecast method until the first time you save the forecast.)
  • If you selected Average of actuals, select the past actuals duration to be used to calculate the average from the Use actuals from ▼ drop-down.
  • If you want to set rules (increase/decrease) at account type level, add them in the Set rules section.
  • When you’re done, select Next.
  • Select the edit ✎ icon to edit the name of your forecast, if needed.
  • When you’re done, select Save and close.
  • If you are dissatisfied with the data in your forecast, you can clear the data. Use the Batch Actions, Clear data option to do this.
  • You can refresh the forecast with the latest actuals by selecting Refresh actuals each time you view it.

Edit a forecast

If you need to edit a forecast, make your changes in QuickBooks

  • Select Financial planning, then select Forecasts.
  • Find your forecast on the list and select View/Edit in the Action column.
  • You can modify each account one month at a time.
  • Select Save or Save and close.

Converting forecasts to budgets

  • Select Financial planning, then select Forecasts.
  • Find your forecast on the list and select View/Edit In the Action column.

Delete a forecast

  • Select Financial planning, then select Forecasts.
  • Once you find your forecast on the list, select the View/Edit ▼ drop-down in the Action column. 
  • Select the View/Edit ▼ drop-down, then select Delete. Be aware that you can’t recover deleted forecasts.

This is a great new feature for users of QuickBooks Online Advanced.  One can only wonder if Intuit will make this feature available to lower end SKUs of QBO like 'Plus' at sometime in the future.

Disclosures:

Feature content, including graphic materials were adapted from Intuit media source content and QuickBooks Help resources. Content created or otherwise adapted by Insightful Accountant from Intuit source content is furnished for educational purposes only.

As used herein, QuickBooks® and QuickBooks Online or QuickBooks Online Advanced, refer to one or more registered trademarks of Intuit® Inc., a publicly-traded corporation headquartered in Mountain View, California.

Any other trade names or references used herein may refer to registered, trademarked or copyrighted materials held by their respective owners; they are included in the content for informational and educational purposes only.

This is an editorial feature, not sponsored content. No vendor associated with this article has paid Insightful Accountant or the author any form of remuneration to be included within this feature. The article is provided solely for informational and educational purposes.

Note: Registered Trademark ® and other registration symbols (such as those used for copyrighted materials) have been eliminated from the articles within this publication for brevity due to the frequency or abundance with which they would otherwise appear or be repeated. Every attempt is made to credit such trademarks or copyrights within our respective article footnotes and disclosures.