Profit and Loss - Actual vs Budget
The Profit and Loss - Actual vs Budget workbook shows a full income statement comparing actual results against budget for both month-to-date and year-to-date periods. Use it when you only need to compare actual results against budget, without prior year data or percentage of revenue metrics.
Selection page
When you open the workbook, the Selection Page appears before the profit and loss statement loads. Fiscal Year, Fiscal Period, and Budget are required fields and must be completed before you can proceed. All other filters are optional and help you narrow the results.
- Company: the company to report on.
- Fiscal Year: the fiscal year the report covers. (required)
- Fiscal Period: the period within that fiscal year used as the cutoff. (required)
- Budget: the budget to compare against actual amounts. (required)
- Segment 02
- Segment 03
- Segment 04
- Segment 05
- Segment 06
Actual vs budget report
The report follows the same income statement structure as the other profit and loss workbooks, from gross profit down to net income. Results are presented across two column blocks: Month to Date and Year to Date. Each block contains the same four columns.
- Actual: posted amount for each account for the period.
- Budget: budgeted amount for the same period.
- Var $: dollar difference between actual and budget, calculated as Actual minus Budget.
- Var %: percentage difference between actual and budget, calculated as (Var $ / Budget) × 100.
Mapping
The profit and loss statement is organized into sections such as Revenue, Cost of Sales, Operating Expenses, and Other Income and Expense. Each section is linked to a Sage 100 account group, which determines which accounts appear in that section and how totals are calculated. You typically only need to update this mapping if your account groups differ from the default setup, for example if you use different group codes or notice accounts appearing in the wrong section.
| Account Group Description | Account Group Code |
|---|---|
| Revenue | 400 |
| Cost of Sales | 450 |
| Operating Expenses - Central | 500 |
| Operating Expenses | 600 |
| General & Administrative | 700 |
| Other Income & Expense | 950 |
| Provision for Income Taxes | 990 |
| Cost of Goods Sold | 450 |
| Current Assets | 000 |
| Current Liabilities | 200 |
| Equity | 300 |
| General & Administrative Expenses | 700 |