Profit and Loss - Rolling 12 Month
The Profit and Loss - Rolling 12 Month workbook shows income statement activity across the last 12 fiscal periods from the selected date, also referred to as Trailing 12 Months (TTM). Each column represents one period, giving a month-by-month view of how revenue, costs, and expenses have moved over time.
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 of the most recent period in the 12-month window. (required)
- Fiscal Period: the period used as the end point of the 12-month window. (required)
- Segment 02
- Segment 03
- Segment 04
- Segment 05
- Segment 06
Rolling 12 month report
The report follows the same income statement structure as the other profit and loss workbooks, from gross profit down to net income. Each column represents one fiscal period within the 12-month window, labeled in YYYY-MM format. The Total column on the right sums all 12 periods for each account.
- [Period]: posted activity for each account during that fiscal period.
- Total: the sum of all 12 period amounts for each account.
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 |