Page Comparison

The calculations you see on the Statement tab of the statement setup window are used to determine values in the corresponding financial statement. If you have permission to manage financial statements, you can add new calculations, edit existing calculations and delete calculations you no longer need.

Calculations can be basic formulas that refer to groups or other calculations in the financial statement, identifiable by the square brackets around them, as illustrated in the image below.

Calculations can also be more complex formulas, used to calculate financial ratios or refer to other financial statements, as illustrated in the images below. For more information and examples, see Financial statement formulas for common ratios.

For example, suppose you want to view the gross profit margin in your Profit and Loss statement. You can achieve this by adding a calculation, as outlined below.

Add a calculation

1. In the Statements menu, click the name of the financial statement you want to customize.

2. In the statement setup window, click the green plus button > Calculation.

3. 

   Scroll to the bottom of the page to see the new calculation row.

4. Enter a name for the calculation, then enter the formula in the calculation box.

5. Select the required format of the calculation result. You can select from a list of default formatting options or create your own custom formatting. If you select the custom formatting option, click the three dots next to the figure and format as required.

6. Click and hold the calculation’s move button (a blue box displays around the row), then drag the calculation up to the required position in the financial statement.

   

7. Click Save.

8. If you are finished customizing the financial statement, click Close > Close > Yes to rebuild the database.

Edit a calculation

If you add a group or calculation, you might need to edit an existing calculation as a result. You might also want to edit calculations for other reasons.

In the statement setup window, you can change the name and formula of the existing calculations as required. You can also change the order in which the calculations display in the financial statement. The steps are similar to adding a calculation (see above for details).

On the Customize groups page there is an example of adding a new group called Revenue Online. As a result of this new group, you need edit the existing Gross Profit calculation to include the new group. Locate the Gross Profit calculationrow and edit the formula, as illustrated in the following image.

Delete a calculation

You cannot delete calculations that are referenced by another line.

In the statement setup window, click the Delete button on the calculation row, then click Save. Then, if you are finished customizing the financial statement, click Close > Close > Yes to rebuild the database.