Am I able to generate a report showing the diffrerent profit margins of non service products wthin particular time frames

  • 1
  • Question
  • Updated 3 years ago
  • Answered
application support
Photo of Thrive Chiropractic

Thrive Chiropractic

  • 3 Posts
  • 0 Reply Likes
  • curious

Posted 3 years ago

  • 1
Photo of Josie Tropeano

Josie Tropeano, Product Manager

  • 64 Posts
  • 44 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.
Photo of Thrive Chiropractic

Thrive Chiropractic

  • 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.
Photo of Steven

Steven, Business Care

  • 244 Posts
  • 68 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 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.