Profit and Loss - Yearly Comparison
The Profit and Loss - Yearly Comparison workbook shows a full income statement comparing the current year against the prior year for both month-to-date and year-to-date periods. Unlike the advanced version, there is no budget comparison. The focus is purely on how this year's results differ from the same period last year.
Selection page
When you open the workbook, the Selection Page appears before the profit and loss statement loads. Fiscal Year and Fiscal Period 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)
- Segment 02
- Segment 03
- Segment 04
- Segment 05
- Segment 06
Yearly comparison 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.
- 2026 (current year): posted amount for each account for the selected period.
- 2025 (prior year): posted amount for the same period in the prior fiscal year.
- Var $: dollar difference between the current and prior year, calculated as current year minus prior year.
- Var %: percentage difference between the current and prior year, calculated as (Var $ / prior year) × 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 |