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.
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.
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”.
5. Add Formula Row and unmark Show Currencies checkbox. Set the following Formula. (([Onlline] + [Online COGS]) / [Online] * 100.0)
6. Follow the same steps for “Retail and Packages”
7. Rename the report (“A” Income Statement) and hit Save.