Profit and Loss - Rolling 12 Month
The Profit and Loss - Rolling 12 Month workbook tracks revenues, expenses, and net income across the last 12 consecutive months based on the period you select, also known as Trailing 12 Months (TTM). Each month is its own column, so you can follow how financial performance moved over time without opening separate reports. Unlike the Yearly Comparison which looks at two fixed periods side by side, this workbook gives you a continuous view that rolls forward with each new period, making it better suited for trend analysis and identifying seasonal patterns.
Selection page
When you open the workbook, the Selection Page appears before the workbook loads. Fiscal Year and Fiscal Period are required fields and must be completed before you can proceed. You can also click the Selection Page sheet at any time to update your parameters directly.
- Fiscal Year – the fiscal year for the profit and loss statement. (required)
- Fiscal Period – the most recent period in the 12-month window. (required)
- Company
- Department
- Cost Center
Profit and Loss
The report shows posted financial performance for each of the last 12 consecutive months, starting from the fiscal period you selected and going back one full year. Each month column reflects the actual ledger posting for every profit and loss line during that period.
Mapping
The profit and loss statement is organized into sections covering operating, investing, and financing activity. Each Report Section is linked to a Report Code that determines which accounts are included and how totals are calculated. Two mapping tables control this structure. In most cases, these tables should not be modified. Changes are typically only required if your Sage 200 account structure differs from the default setup or if accounts are appearing in the wrong section.
The first table defines the main cash flow sections and is refreshed manually when code assignments change in Sage 200.
| Report Section | Report Code |
|---|---|
| Sales Revenue | KPI_REVENUE |
| Other Revenues | KPI_OTHER_REVENUE |
| Cost of Sales | KPI_COGS |
| Other Income and Expense | KPI_SUSP |
| Operating Expenses | KPI_OPERATING_EXPENSES |
| Fixed Charges | KPI_FIXED_CHARGES |
| Amortisation | KPI_AMORTISATION |
| Interest Expenses | KPI_INTEREST_EXPENSES |
The second table controls which report codes are extracted and feeds the profit and loss dynamically. Update this table if specific account groupings need to be added or adjusted.
| Report Section | Report Code |
|---|---|
| Tax Payables | KPI_TAX_PAYABLE |
| Other Income and Expense | KPI_SUSP |
| Sales Return and Allowances | KPI_SRET |
| Discount | KPI_SDISC |
| Revenue | KPI_REVENUE |