Profit and Loss - With % Expense, Income
The Profit and Loss - With % Expense, Income workbook shows year-to-date income statement results for the current year and the prior year, with two percentage metrics alongside each: % of sales and % of expenses. Both years show dollar amounts alongside each line's share of total revenue and total expenses.
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
Profit and loss 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: current year and prior year. Each block contains the same three columns.
- YTD: posted activity from the start of the fiscal year up to the end of the selected period.
- % of Sales: the YTD amount expressed as a percentage of total revenue, calculated as (YTD / Total Revenue) × 100. Shown for all rows.
- % of Expenses: the YTD amount expressed as a percentage of total expenses, calculated as (YTD / Total Expenses) × 100. Shown for expense rows only.
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 |