Profit and Loss - Yearly Comparison
The Profit and Loss - Yearly Comparison workbook compares actual results for the selected period against the same period last year, across both Month to Date and Year to Date. For each profit and loss line, it shows this year's amount, last year's amount, and the variance in dollars and percent, making it straightforward to see where performance has improved or declined year over year across Revenue, Cost of Sales, and Expenses.
Selection page
When you open the workbook, the Selection Page appears before the report loads. Run As Date and Reporting Book are required fields and must be completed before you can proceed. All other filters are optional and help you narrow the results.
- Run As Date – the "as of" date used for the selected period. (required)
- Reporting Book – the primary reporting book used for actual amounts. (required)
- Adjustment Book
- Location – select a single location to avoid mixing currencies. (required for multi-currency)
- Department
- Project
- Customer
- Product Line
- Class
Yearly Comparison
The report is split into two blocks: Month to Date and Year to Date. Each block compares current-year actuals to last-year actuals for the same timeframe.
- TY (This year): actual financial performance of each profit and loss account for the current period.
- LY (Last year): actual financial performance of each profit and loss account for the same period last year.
- Var $: dollar change between TY and LY (TY - LY). A positive value means an increase. A negative value means a decrease.
- Var %: percentage change between TY and LY, calculated as (TY - LY) / LY x 100. If LY is 0, the percentage may display as 0% or blank.
Parameters and mapping
Parameters
The workbook displays the key dates and settings used to generate the profit and loss statement, including the as-of date, books, and any active filters. Review these values to confirm they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and reopen the workbook. Only blue cells are editable. All other values come directly from the selection page.
| 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, combines the Reporting Book and Adjustment Book into a single set of profit and loss amounts. |
| Statistical Accounts | Controls whether statistical accounts are included. These accounts store non-financial values such as quantities and do not represent GL transactions. Options: Exclude (default), Include, Only. |
For each dimension filter such as Location, Department, or Project, you can choose whether to include sub-dimensions. Enable this option when you want the selection to cover all child values under the selected dimension, for example a parent department and all of its sub-departments. If a sub-dimension toggle is not available, it means no hierarchy exists for that dimension in Sage Intacct.
Mapping
The profit and loss statement is organized into sections including Revenue, Cost of Sales, Expenses, and Income. 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 only need to update this mapping if your Intacct account groups differ from the default setup, for example if you use different group IDs, have renamed your financial statement groups, or notice accounts appearing in the wrong section.
| 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 |