Profit and Loss - Basic
The Profit and Loss - Basic workbook shows revenue, costs, and expenses for a selected fiscal period, with results broken down into month-to-date and year-to-date columns. It follows the standard income statement structure, from gross profit down to net income, and includes a gross profit margin percentage row.
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 is organized into revenue, cost of sales, expenses, and other income and expense sections, each with a subtotal row. Results are shown across two columns.
- Month to Date: posted activity from the start of the selected fiscal period to its close.
- Year to Date: posted activity from the start of the fiscal year up to the end of the selected period.
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 |