This page brings the learnings from the multiple customize financial statement pages to demonstrate how you can add more information to your financial statements.
Rather than customize an existing financial statement, you can clone the financial statement and customize that as much as you want, without worrying about losing the original statement layout.
Include EBITDA in the Profit and Loss statement
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 Profitcalculation.
In the Statements window, click the Profit and Loss statement.
In the statement setup window, add three groups, one for Interest, another for Taxation and the other for Depreciation, 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, as illustrated in the image below.
Drag the new groups and calculation up to sit below the Operating Expenses group.
Edit the Net Profit calculation box to reflect the changes you made - the formula is now EBITDA plus any other revenue, minus any other expenses minus the Interest, Taxation and Depreciation.
Click Save> Close > Yes to rebuild the database. [Denise need to test and get screenshot and show results]
Include Accounts Receivable in the Cash Flow statement
Suppose you want more visibility on how your Accounts Receivable are affecting your cashflow over the period. You can add a group for Accounts Receivable in your Cash Flo statement.
Cash Flow statements have two ‘Balance’ rows (cash at the start and end of the period) in addition to the usual group and calculation rows. You can move these Balance rows around, but you cannot delete them.
In the Statements window, click the Cash Flow statement.
In the statement setup window, add a group for Accounts Receivable and drag it up to where you want it to be positioned, for example, just below the Operating group.
Edit the existing calculation to include reference the new group.
Click the Accounts tab, map the applicable accounts to the new group.
Click Save> Close > Yes to rebuild the database. [Denise need to test and get screenshot and show results]