Create and manage forecasts
by Intuit•43• Updated 3 weeks ago
Learn how to add forecasts.
Forecasts help you set long-term and short-term goals for your business. Forecasting is typically based on past performance and trends in your industry. Your historical data is analyzed for patterns and projections are made based on this information. With all your financial data available in your company, you can quickly and easily create forecasts and use them to create budgets.
Create a forecast
You can create a forecast at any time but, the end of the year is a great time to start planning for the year ahead. To create a new forecast, you’ll need to sign in as an admin or as a Standard All user.
Step 1: Review the fiscal year for your business
Make sure the beginning of your fiscal year is set. You can create a forecast any time, but it helps if your forecast start date is set to the beginning of the fiscal year.
- Sign into your company.
- 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 dropdown ▼ and select Save.
Step 2: Get your forecast data
If you already have your data entered, you can skip this step. If not, you can base your forecast on data from either the current fiscal year or the year before. If you plan to use historical data, run a Profit and Loss Detail report to make sure transactions and accounts look correct.
The report automatically shows transactions created during the current year-to-date. To see a prior fiscal year's transactions, you will have to customize the report. See the Customize a report section below.
Step 3: Create your forecast
Note: The forecast accounts list is created based on your chart of accounts. If you need more accounts in your forecast, add them to your chart of accounts before you create the forecast.
To create a forecast, you can use your past financial data from your company. If this is your first forecast, start here:
- Select Financial planning, then select Forecasts.
- Select Create forecast.
- From the Forecast for ▼ dropdown, select the timeframe you’re creating the forecast for.
- From the Forecast using ▼ dropdown, select one of the following forecast methods:
- Average of actuals
- Actuals from last fiscal year (Note: You can modify the forecast duration and forecast method until the first time you save from the Settings panel.)
- If you selected Average of actuals, select the past actuals duration to be used to calculate the average from the Use actuals from ▼ dropdown.
- 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.
Note: We recommend you 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:
- Select Financial planning, then select Forecasts.
- Find your forecast on the list and select View/Edit in the Action column.
- Select Save or Save and close.
Note: We recommend you refresh the forecast with the latest actuals by selecting Refresh actuals each time you view it. Additionally, you can modify each account one month at a time.
Convert a forecast to a budget
- Select Financial planning, then select Forecasts.
- Find your forecast on the list and select View/Edit In the Action column.
- Select Make this a budget to choose the fiscal year of the budgeting period.
- Select Make this a budget again to save the forecast as a new budget.
Find out more about creating a budget.
Delete a forecast
- Select Financial planning, then select Forecasts.
- Once you find your forecast on the list, select the View/Edit ▼ dropdown in the Action column.
- Select the View/Edit ▼ dropdown, then select Delete.
Note: You can’t recover deleted forecasts.
Customize a report
- Go to Reports (Take me there).
- Find and select the Profit and Loss Detail Report.
- From the Report period ▼ dropdown, select a timeframe. For example:
- If you want to use data from the prior year, select Last Year.
- If you want to use data from your current fiscal year, select This Year-to-date.
Note: Make sure the beginning and end of the year match your fiscal year.
- Select Run report.
- If you don’t want to reopen the report again, select the print or export icon to print or download a copy of the report.
Export a forecast
- Select Financial planning, then select Forecasts.
- Find your forecast on the list and select View/Edit In the Action column.
- Select Export icon, select Print/Save as PDF or Export to Excel
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Create a budget or forecast in QuickBooks Desktopby QuickBooks•27•Updated almost 2 years ago
- Add and manage custom rolesby QuickBooks•669•Updated 1 week ago
- Create goals to keep your business on courseby QuickBooks•Updated 3 weeks ago
- Create budgetsby QuickBooks•6819•Updated 4 weeks ago