The Profit and Loss Summary enquiry differs a little bit from the rest of the enquiry screens, but they do share the same basic functionality for using the Advanced Filter panel as well as opening the Action Panel.
For more information on these, please refer to nominal ledger transaction enquiry.
This article aims to explain the Profit and Loss Summary enquiry screen in more detail.
The P&L Summary enquiry shows the company's revenues and expense during a particular period. It indicated how the revenues are transformed into the new income. The purpose is to show whether the company has made or lost money during a period.
The treatment of a nominal account within the P&L as a revenue or expense account is determined by the Major Heading assigned to each nominal account.
You can only see nominal accounts which are assigned to a P&L type major heading. These are major heading 1 to major heading 6.
For more information, please refer to default Major Headings and Reporting Codes.
Note: Any nominal account that has been set up with the Allow Zero Budgets option selected will always be included in the P&L and Balance Sheet enquiries regardless of the Include Zero Lines option on the Advanced Filter panel.
The year and period fields default to the current working or open period and can be changed.
The P&L Summary Enquiry grid in more detail:
Field | Description |
Place value or Units |
|
Decimal place number |
Note: Only changes the view of the enquiry and does not pull through to the excel report. |
Saved Filters |
|
Cog  |
|
The P&L Summary headings are as follows:
Headings | Description |
Sales |
|
Cost of Sales |
|
Gross Profit |
|
Gross Margin |
|
Other Income |
|
Gross Profit after Other Income |
|
Overheads |
|
Finance Charges |
|
Tax |
|
EBITDA |
|
Net Profit | Calculated as Gross Profit after other income - (Overheads + Finance Charges + Tax) |
Net Margin % | Calculated as (Net Profit ÷ Sales) x 100 |