Statement of Profit or Loss Tutorial
Overview
A Statement of Profit or Loss (P&L), also known as an Income Statement, is a financial document that summarises an organisation's revenue, costs and expenses over a specific period. This period can be a month, a calendar year, a financial year or several months.
💡These tutorials explain how to view and customise a Statement of Profit or Loss.
By following the step-by-step guide, you learn to change and understand the different settings. This way, you get the financial information you need from your accounting records, such as a month-by-month breakdown, cost-of-sale percentages, budget comparisons and a detailed financial overview of your organisation.
How to Change the Dates for the Statement of Profit or Loss
Choose the financial year (Fin Year) to show the profit or loss for tax and audit purposes.
Choose the financial year by month (Fin Year (Months)) to check for missing information as each month should follow the same pattern.
Choose the financial year by month (Fin Year (Months)) to compare your actual expenses to your budgeted expenses.
Choose the calendar year (Year) to check for seasonal fluctuations.
- Navigate to the Statement of Profit or Loss.
- Click the dropdown list next to Set to select your dates:
- Click User Date to show the profit or loss for the specific periods selected under Date.
- Note: Enter the start date in the first date field and the end date in the second date field.
- Click Month to show the current month.
- Note: Change the 2 next to Show to display the Statement of Profit or Loss for various periods (limited to 12).
- Click Year to show the calendar year to date (from January to December).
- Click Fin Year to show your organisation's profit or loss for the current financial year.
- Click Fin Year (Months) to show the monthly profit or loss for the current financial year.
- Click User Date to show the profit or loss for the specific periods selected under Date.
- Click View (button) to display the Statement of Profit or Loss on the left and the graph on the right.
How to View Percentage Changes from Period to Period
- Navigate to the Statement of Profit or Loss.
- Click the dropdown list next to %.
- Click None to hide the % field.
- Click Change to show the percentage change between the period (column) shown on the right and the period (column) shown on the left.
- Click Revenue to show the line items as a percentage of sales.
- Click Budget to show the percentage difference between the actual and budgeted amounts if a budget is selected (else an error message displays).
- Click View (button) to display the Statement of Profit or Loss on the left and the graph on the right.
How to View a Budget Comparison
- Navigate to the Statement of Profit or Loss.
- Click Set > Fin Year (Months).
- In the same row, a new option appears: Budget. Click the dropdown list next to Budget and click the budget you want to display.
- Note: If no budget exists yet, there are no names to select.
- Click View (button).
- Note: The Statement of Profit or Loss appears on the left, and a graph appears on the right.
- Note: The budget comparison is not shown on the graph.
How to View the Percentage Change between the Budgeted and Actual Amounts
- Navigate to the Statement of Profit or Loss.
- Click Set > Fin Year (Months).
- In the same row, a new option appears: Budget. Click the dropdown list next to Budget and click the budget you want to display.
- Click the dropdown list next to % and click Budget.
- Click View (button).
- Note: The Statement of Profit or Loss appears on the left, and a graph appears on the right.
- Note: The budget comparison is not shown on the graph.
How to Show or Hide the Decimal Values on the Statement of Profit or Loss
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Click Menu (button) > Hide Decimal Values.
- Note: If checked, decimal values are hidden. If unchecked, they appear.
How to View Detailed Transactions from the Profit or Loss
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Double-click an Account to see the detailed transactions on the General Ledger Account.
How to View All the Accounts on the Statement of Profit or Loss
- Navigate to the Statement of Profit or Loss.
- Check Show all Accounts to see all the individual accounts including those with zero balances.
- Click View (button).
- Note: The Statement of Profit or Loss appears on the left, and a graph appears on the right.
- Note: The graph still only shows the main categories.
How to Print the Statement of Profit or Loss
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Click Output (button) > Print to print the report to the default printer or click Print (Show Dialogue) to select a printer, for example, a .pdf printer.
How to Preview the Statement of Profit or Loss
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Click Output (button) > Preview to display the Statement of Profit or Loss.
- Note: You can click the printer icon to print the statement to a printer of your choice, including PDF.
How to Email the Statement of Profit or Loss
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Click Menu (button) > Email Excel to email the Statement of Profit or Loss in Excel format.
- Click Output (button) > Email and select 2, 3, 6 or 12 periods to email the Statement of Profit or Loss in PDF format.
How to Fix a Statement of Profit or Loss that is not Displaying
- If you click View (button) to display the Statement of Profit or Loss and nothing appears, click Menu (button) > Restore Grid to restore the display.
- You can also click Restore Default (All Users) to reset the Statement of Profit or Loss to the default setups (this step requires a restart to take effect).
How to Hide the Graph or Chart
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Click Menu (button).
- Click Hide Chart.
How to Customise the Graph or Chart
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Click Customize (button) directly below the graph and select any settings from the popup to modify the graph.
- Click Column Diagram (link) to select a different type of diagram.
How to Fit all the Columns on the Screen
- Navigate to the Statement of Profit or Loss.
- Click View (button).
- Click Menu (button) > Column Auto Width to automatically fit all the columns on the screen.