Profit and Loss - Forecast (Actual & Budget)

The Profit and Loss - Forecast (Actual & Budget) workbook compares your actual results to a selected budget and provides a full-year view. It shows performance year-to-date up to the date you choose, the remaining budget for the rest of the year, and a full-year projection that combines actuals to date with the budget for the months still to come.

Selection page

When you open the workbook, the Selection Page appears. It lets you choose what you want to see before the profit and load report loads. The Run As Date and Reporting Book fields are required (shown in grey) and must be completed before you can confirm. All other filters are optional and help you narrow the results.

• Run As Date – (mandatory) the "as of" date used for the selected period.
• Reporting Book – (mandatory) the primary reporting book used for actual amounts.
• Adjustment Book
• Location – (required for multi-currency) select a single location to avoid mixing currencies.
• Budget ID
• Department
• Project
• Customer
• Product Line
• Class

Forecast (Actual + Budget)

Actuals (Up to Cutoff Date)

Shows actual profit and loss amounts posted up to the run as date, compared to the budget for the same timeframe.

• Budget YTD: budget amount from the start of the fiscal year up to the run date.
• Var $: difference between Actual YTD and Budget YTD (acutal - budget).
• Var %: percentage difference versus Budget YTD. If Budget YTD is 0, the percentage may display as 0% or as a blank space.

Remaining Budget

Shows the portion of the annual budget that remains after the cut-off date.

• Remaining Budget: budget amount from after the run as date until the end of the fiscal year.

Full-Year Projection (Actual + Budget)

Combines actual results to date with the remaining budget to estimate the result for the full year.

• Full-Year Projected: actual financial performance (ledger posting) of each profit and loss (P&L) account up to the cut-off date, plus the forecast (budget) amounts for the remainder of the fiscal year.
• Full-Year Budget: forecast the financial performance (Budget) of each profit and loss (P&L) account for the full fiscal year.
• Var$ Full-Year: variance between Full-Year Projected and Full-Year Budget, shown as a percentage difference.

Parameters and mapping

Parameters

The workbook shows the key dates and settings it used to generate the Profit and Loss (as-of date, comparison periods, books, and any filters). Review these values to make sure they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and open the workbook again. Only the blue cells can be edited and all other values come from the selection page.

Report Setting	Description
Reporting Book	The main book used to calculate profit and loss amounts. Set on the selection page.
Adjustment Book	Optional adjustment book. Set on the selection page.
Combine Reporting and Adjustment	When enabled, the workbook combines the Reporting Book and Adjustment Book results into a single set of profit and loss amounts.
Statistical Accounts	Controls whether statistical (non-financial) accounts are included. These accounts don't represent GL transactions and often store quantities or other operational values used for reporting. Options: Exclude (default), Include, Only.

For each dimension filter (Location, Department, Project, etc.), you can choose whether to include sub-dimensions. Turn this on when you want the selection to include all child values under the dimension you chose (for example, a parent department and all of its sub-departments). If a dimension doesn't show a sub-dimension toggle, it means there is no hierarchy available for that dimension in Sage Intacct.

Mapping

The Profit and Loss is organized into sections: Revenue, Cost of Sales, Expenses, Income, etc. Each section is linked to a Sage Intacct Account Group, which determines which accounts appear in that section and how totals are calculated. You typically update this mapping only if your Intacct Account Groups are different from the default setup. That might happen if you use different group IDs, renamed your financial statement groups, or notice accounts showing up in the wrong place.

Report Section	Account Group
Revenue	178
Other Revenue	183
Cost of Sales	59
Operating Expenses	114
Depreciation Expenses	161
Interest Income	106
Interest Expenses	145
Other Expenses	234
Income Tax	112