Profit Margin Percentage on Income Statement

 

This tip shows how to add a margin percentage line in the income statement. This will enable you to see what your profit margins are from various sales channels at a glance.

 

Example

For this example we have assumed a company that has a single product line with three different channels Online, Retail and Packages

 

To create an income statement with margins navigate to Reports>Financial>Income Statement set the date range for example from 1/1/2012 to 5/31/2012 and Column to Month and hit the Customize button.

 

    1. Add Header and Summary Rows. Rename it to Product Line = “A”. Set it as Child of Net Revenue.

Tip Image 1
2. Add Header and Summary Rows. Rename it to “Online” and set it as Child of “A”.

Tip Image 2
3. Add Financial Section. Rename it to “Online” and set it as Child of “Online”, Summary Label=F, and Display=Collapsed. Set filter to Account Name=”Online”.’

Tip Image 3

 

4. Add Financial Section. Rename it to “Online COGS” and set it as Child of “Online”, Summary Label=F, and Display=Collapsed. Set filter to Account Name=”Online COGS”.

Tip Image 4

 

5. Add Formula Row and unmark Show Currencies checkbox. Set the following Formula. (([Onlline] + [Online COGS]) / [Online] * 100.0)

Tip Image 5

 

6. Follow the same steps for “Retail and Packages”

7. Rename the report (“A” Income Statement) and hit Save.