Wanting to report by margin is a common request and can be done within the CRM using the Sales Transaction Report entity. This help explains how to add Margin Value and Margin % to your Sales Transaction Report and how to add summaries using the Margin Value and Margin %.

To create a new Sales Transaction Report, create a new Report, You can do this using the Global Create button in the top right-hand corner, or from any of the Report groups located in the left-hand menu by clicking 'New Report'.

Note: If this option is not showing for you please click here.

Next, choose 'Sales Transaction' as the Report entity and click 'Next'.

Then, tick the fields you want to include in the Report. This could be one or many different fields. We recommend the following:

Once you've selected the required fields, click 'Submit'.

You'll now be presented with a list of all the sales transactions. From here, you can perform a variety of actions such as adding Filters, selecting more fields, performing bulk actions and saving the Report to Excel. Once you've made your changes, remember to click the Save icon in the top right-hand corner.

Adding summaries is a great way to enhance your Report. Simply select 'Grouping and Summary' from the three dots in the top right-hand corner of the Report, and drag and drop margin value and % - or any other fields - into summary. Then, click 'Submit'.

This will then add summaries along the top of the Report to display the total margin value on all sales transactions.