application support

- 3 Posts
- 0 Reply Likes
- curious

Posted 4 years ago

Josie Tropeano, Product Manager

- 64 Posts
- 45 Reply Likes

This is not possible as we do not record the changing purchase price of products purchased by the practice over time. We only record the last price paid to help you in your next order.

- 3 Posts
- 0 Reply Likes

Sorry Josie, I didn't frame this question properly.. What I want to do is compare the profit margins amongst current stock. Essentially I am trying to identify the most profitable stock at any given time.

Steven, Business Care

- 281 Posts
- 78 Reply Likes

It is possible with some simple mathematics to calculate this profit margin using the Export to Excel function on the Billing Report.

Run a Billings Report by selecting

Filter

Use the

Select

It is possible to view the Unit Cost/Cost Price of your stock items individually on the

Alternatively you can run the

In Excel, you must

Use the formula =(Number * Unit Cost) to calculate Total Cost.

Calculating profit is as easy as subtracting amount listed in the Total from the Total Cost Column.

Run a Billings Report by selecting

**Reports > Billings Report**Filter

**By Item**using your “Non-Service (Product)” schedule or Item Group. You will also need to untick all of the**Group By**options.Use the

**Preview**function to make sure the report encompasses the data you need.Select

**Export**to manipulate the data and add your own calculations in Excel.It is possible to view the Unit Cost/Cost Price of your stock items individually on the

**Stock Control**tab of each item code.Alternatively you can run the

**Stock Levels Report**to see a full list of your items’ Unit Cost.In Excel, you must

**add columns**for Unit Cost, Total Cost and Profit. Populate Unit Cost with the information collected above.Use the formula =(Number * Unit Cost) to calculate Total Cost.

Calculating profit is as easy as subtracting amount listed in the Total from the Total Cost Column.