
Use three-way financial forecasts in Intuit Enterprise Suite
by Intuit• Updated 1 month ago
With Intuit Enterprise Suite, get integrated financial modeling that helps you find opportunities and risks. Three-way financial forecasts link your profit and loss statement, balance sheet, and statement of cash flow for a balanced view of performance. Link specific accounts and adjust projections in your profit and loss or balance sheet statements to see how changes affect all three linked statements.
View forecasts
Follow this link to complete the steps in product
- If this is your first time accessing three-way forecasts, select View detailed forecast to get started.
- If your company has enough financial data, you’ll see an AI-generated forecast quick view that includes net income, income, and expenses. If you’ve created and saved a customized forecast, select it from the list to open it again.
- Select
to select the statement and metric by which to filter the forecast. Select Apply to return to the updated forecast.
- Select View detailed forecast to see a more in-depth view of the forecast in a grid format.
- Select Profit and loss, Balance sheet, or Statement of cash flow to view each forecast.
- Select About this forecast to learn more about the accounts and rules used to generate the forecast.
Customize forecasts
Once you're viewing your forecast, you can customize or adjust your profit and loss or balance sheet forecast with the following options.
- Select General options to change the date range of the forecast or the method used to generate the forecast. Depending on your choice, you may need to specify additional information. When you’re finished, select Apply to save and update the forecasts.
- Select Rules to review any existing rules applied to accounts. Then select Add rule and specify the account type and rule to apply to it. Once you’ve finished adding rules, select Apply to save and update the forecasts.
- Select any forecasted value to edit it and see the impact to each of the three forecasts.
- On the balance sheet, select Link to connect a specific account to the account shown on the balance sheet. Select Primary cash account, Accounts receivable, or Accounts payable to expand each list and select the account you want to link. Select Apply to save and update the forecasts.
Create custom forecasts
You can create a custom three-way forecast at any time. The accounts list used to create a forecast is 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 new forecast, you’ll need to sign in as an Admin or as a Standard All user.
Follow this link to complete the steps in product
- Select Create custom forecast.
- Select the time frame you’re creating the forecast for.
- Select one of the following forecast methods:
- Average of actuals
- Actuals from last fiscal year
- Budgets
- If you chose Average of actuals, select the past actuals duration to be used to calculate the average.
- If you want to set rules at the account type level, add them in the Set rules section.
- When you’re done, select Next.
- Select
to edit the name of your forecast, if needed.
- When you’re done, select Save and close.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this