Forecasting in QuickBooks Online Advanced: setup, constraints, and method choice

Forecasting in QuickBooks Online Advanced sits under the Financial planning heading in the Reports menu. A question on creating and managing forecasts drew a formal answer from Intuit, and that answer is a vendor checklist. We kept the steps and added the reasoning, because the constraints decide whether the projection is worth building.

What does a forecast give you?

A forecast projects income and expense from trends the software finds in your own history, not from targets you type in. Intuit frames the tool around goal setting, with long and short term objectives grounded in past performance and the direction of your industry. The practical payoff is the handoff. Projections you generate here can become the starting numbers for a budget, which is the destination most users have in mind.

Check the fiscal year first

Every forecast inherits its calendar from your company settings. Open Settings, select Account and settings, choose the Advanced tab, and look in the Accounting section. The field for the first month of your fiscal year is the one that matters. If it shows the wrong month, edit it, pick the correct one, and save.

A projection built on the wrong start month slices every period along the wrong seams, and no method choice will repair that afterward. Timing is flexible in principle: you can create a forecast at any time. Year end is simply the natural moment to plan the year ahead, and a start date that matches the fiscal year keeps the output tidy.

Clean history makes honest projections

Forecasts draw on figures from the current fiscal year or the one before it, so data quality is the first question. The guidance is to run a Profit and Loss Detail report and confirm the transactions and accounts in it are free of errors. A detail view is the right instrument because it shows the individual entries, not just the totals.

One wrinkle catches people: the report opens on the current year, and earlier fiscal years appear only after you customize it. The software will not surface last year on its own, so the burden of pulling the right period falls on you.

A projection inherits every misclassification in its source. An expense coded to the wrong account in March becomes a plausible forecast line by January. Cleanup is dull work, and it is also the difference between a model and a guess.

Your chart of accounts sets the limits

One quiet detail in the guidance matters more than it looks. The forecast account list is generated from your chart of accounts. Intuit’s instruction is to add any accounts you need before you create the forecast, because the chart you start with is the chart the projection uses. Settle the account list first, then build.

The creation steps are short

With the groundwork done, the build itself takes a few clicks. Open Reports, select Financial planning, then Forecasts, and choose to create a new forecast. You then pick the period you are forecasting for and the method the numbers will use. Access has one gate: you need to be signed in as an administrator or a standard user. A role with narrower permissions will stop before the tool opens.

Two methods and a judgment call

Two options are offered: the average of your actual costs, or the actual costs of the last fiscal year. Neither is automatically right. Averaging smooths an unusual year into the trend, which helps when the anomaly was real but not permanent. Using the most recent year alone assumes that year repeats, which fits a business that genuinely changed direction. Seasonality tilts the choice too, since averaging flattens the peaks that a seasonal business lives on.

The projections then feed the budget, closing the loop the tool was built for. Choose the method that matches your read of the year ahead, then test the output against what you already believe about the business. A forecast that surprises you deserves a second look before it hardens into a plan.