Customize a Profit and Loss statement
This page combines and summarizes the steps from multiple pages to demonstrate how you can add more information to your Profit and Loss statement. See the related pages (links on the right) for more detailed information.
Suppose you want to view the earnings before interest, taxation and depreciation (EBITDA) in the Profit and Loss statement. You firstly need to add new groups to split out the interest, taxation and depreciation expenses from the operating expenses, and map the applicable accounts to those new groups. Next, you add a new calculation to determine the EBITDA value. You then need to move the new group and calculation to the position you want them display in the statement. As a result of adding the new group and calculation, you need to edit the existing Net Profit calculation.
In the Statements window, click the Profit and Loss statement in which you want to add the EBITDA row.
In the statement setup window, add three groups, one for Interest, another for Taxation and the other for Depreciation.
Drag the new groups up to sit below the Operating Expenses group, then click Save.
Click the Accounts tab, map the applicable accounts to the new groups, then click Save.
Back in the Statements window, click the Profit and Loss statement again.
In the statement setup window, add a calculation for the EBITDA value. The formula is Gross Profit minus Operating Expenses.
Drag the new calculation up to sit below the Operating Expenses group, above the three new groups.
Edit the Net Profit calculation box to reflect the changes you made. The formula is now EBITDA plus any other revenue, minus the Interest, Taxation and Depreciation, minus any other expenses.
Click Save > Close > Close > Yes to rebuild the database.
