Run this report to see how well your business has performed between your Income and expenditure. Compare to your Budget and see the variance generated.
What is the Profit and Loss report?
This report is a record of how well your business has performed. It records your income and expenditure showing you if you made or lost money along the way.
On screen version
This report will show the balance generated from your Profit and Loss GL accounts which includes any GL accounts defined as type Sales or Expenditure.
At the top of the screen it displays the Gross and Net Profit figures which are calculated as follows:
Gross Profit = Turnover (minus) Cost of Sales
Net Profit = Gross profit amount +/- Operating Costs/Non-operating costs and Taxation of extraordinary Items
You can expand any of the above categories on the report to see what GL accounts affect this balance.
You can apply further filters to your report as follows:
Date range – this defaults to the current year; you can enter dates for example to see a specific month or previous year range
Cost Centres/Project Codes – choose from list to run the report for specific dimensions or Projects if they are in use on your transactions
Compare – this allows you to run a comparison report against another set of dates, for example you may want to compare January of this year to January of last year. The report will generate your Profit figures for both periods and will also show a Comparison Balance column for each Category and GL account.
You can also click on Export to Excel to analyse further
Now you can also compare your P&L performance to your Budget!
- New ‘Compare’ tick box on P&L report for direct comparison of performance to budget.
- New variance column added to the P&L which is Budget less actual.
- Simply tick the Compare Budget option, click on the pencil icon to select your budget for comparison, click on Apply to see the results returned with the Variance column showing also.
PDF version in Dashboard
The PDF version reports on the same set of Profit and Loss GL accounts. The difference is the options available for you to select to run your report.
Date range – you can enter dates for example to see a specific month or previous year range
Report Type – you can select from Monthly or Annual.
Monthly report option will show you the report with a breakdown per month in the columns, showing the totals for that month and Year to date, this is based on the date range that you entered
Annual report option will show the Balance for each account with the Year to date total based on the date range that you entered
Cost Centres (Regions, Product Groups, Dimensions) /Project Codes – choose from list to run the report for specific dimensions or Projects if they are in use on your transactions
For any of the above options to work you will need to click on the Filter button to generate your report.
Sample PDF Profit and Loss report below.
Did this answer your question?