Table of Contents
Introduction
The Profit and Loss Report helps you answer the million-dollar question every business owner faces: Am I earning more than I'm spending? By summarising your income and expenses for a selected period, it shows whether your business made a profit or incurred a loss.
For a bigger picture, include a Balance Sheet Report alongside your Profit and Loss data. Together, they provide a clearer view of both business performance and financial position.
In this article, we'll show you how to generate a Profit and Loss Report and, when required, include the Balance Sheet Report.
The Report
To run the report:
Go to Nominal > Reporting > Nominal Profit and Loss Report.
Set up the Report Options as needed in the Profit and Loss Report page:
Financial Year: select the financial year you want to report on.
Period From: enter the month number (e.g. 1 for January) you want to the report to start from.
Period To: enter the month number (e.g. 12 for December) you want to the report to end.
Exclude Accounts With Zero Balance: hides income and expense accounts with no balance.
Include Balance Sheet Report: includes Balance Sheet account figures after the Profit and Loss section in the same report.
Start Balance Sheet Report on New Page: starts the Balance Sheet section on a new report page. This keeps the Profit and Loss and Balance Sheet sections separate and prevents them from appearing on the same printed or PDF page.
Detailed Report: tick it to run a detailed report, untick it to run a summary report.
Extend Across Periods: breaks down report figures into monthly amounts for the selected period range, allowing you to analyse trends and compare results month by month.
Filter and select the data you want to report on in the left grid, if necessary.
Choose the report format and generate the report at the bottom right of the page.
⚠️ Important: User permissions and active system record filters influence the data displayed in the report selection grid and the resulting report. Excluded records may cause incomplete figures or unexpected totals.
The Result
The regular and extended Profit and Loss Report can be generated in either PDF or Excel format, for both the Summary and Detailed versions.
Summary and Detailed: Regular
After a successful run, the Summary and Detailed regular reports will display the the following columns, both in PDF and Excel formats: Code, Name, Movements [starting period] to [ending period (EUR), and Year to [ending period] (EUR).
PDF
Excel
Summary and Detailed: Extended Periods
Successfully generated Summary and Detailed reports for extended periods include the following columns in both PDF and Excel formats: Code, Name, Opening Balance, Year to [ending period] (EUR), and a separate column for each selected period. For example, if you select three periods, the report will display individual columns for January, February, and March.
Excel
Related Articles







