Understanding End of Year reports

By Michelle Campoli CVT, CVPM

One of the most comprehensive reports is the Yearly Sales Summary. But before you review this report it’s important that you understand the key data points and how they are defined:

  • New Clients: The number of new clients added to the database.
  • Patient Visits: The number of patients invoiced (E.g. if a posted invoice has 2 patients, it counts as 1 invoice and 2 patient visits).
  • Invoice count: the number of posted invoices.
  • Total Sales: Gross service and inventory sales (before any discounts, but does include any manual price changes) from those posted invoices (E.g. if an item was $120, the price changed to $100 and had a 10% discount applied, the gross would be $100 on this report).
  • Service Sales: Gross sales from all service type invoice items.
  • Inventory Sales: Gross sales from all inventory type invoice items.
  • Preset Discounts: Total of all applied discount (from DISC column on the PVL or invoice window).
  • Manual Discounts: Total of all manual discounts (from the DISCOUNT button on the invoice window).

Using the information displayed, you can also do a little math to gain additional insights, like:

  • Average invoice (sales divided by invoices)
  • Average patient transaction (sales divided by patient visits)
  • Net Sales (total sales less all discounts)
  • Net average invoice (net sales divided by invoices)
  • Net average patient transaction (net sales divided by patient visits)

The two End of Year client reports you should be looking at are:

  • The High/Low Client Sales Report = Net sales (post discount, also includes paid sales tax!)
  • The Client Sales Report = Gross sales (pre-discounts/taxes)

The Client Sales Report (above) also separates the gross sales into their service and inventory components and lists last year’s total sales as well. Very fun report! And here’s another cool trick with the Client Sales report: save it to Excel and you can get the service and inventory components of last year’s sales as well!

Don’t forget to check out the end of year training and download the check list!

 

Michelle Campoli loves teaching people how they can do more with Cornerstone. When she’s not sharing her favorite tips and tricks in one of our Cornerstone user group meetings, Michelle enjoys spending time with her husband, cat, and three retired greyhounds; playing in her kitchen and volunteering for her local greyhound adoption group.

Request a demo