Invoice item reporting

Navigate to Reports > Find a Report > Invoice Item > Invoice Item Setup. 

1. Select the appropriate sort order for your needs.  
2. Add range filters as needed, such as status (active) with AND statements. 

Notes: Search ‘item list’ or ‘price list ‘on the Report Search window for a list of available reports. 

Navigate to Reports > Find a report > Invoice item > Invoice Item Sales Information.

1. Enter Invoice date range, add AND
2. Add other range filters as needed, such as a range of sequential item IDs or an item class.
3. If using additional ranges, add AND or OR statements appropriately.
4. Click Preview.

Notes:

• The date range on this report looks at the line-item date from a posted invoice. If it is common to have multiple days on a single posted invoice, adjust the range accordingly. Example: Items dated from the end of August would not display on a report with date range of September.
• Lot number details are on the report when it is saved to a file.
• Search ‘patient sales’ in the Report Search window for available reports.

Sales data for quantity sold and revenue is available on several different end of period reports. Based on your criteria (item type, date range, etc.), the following reports can be used to provide the numbers. These reports will require a spreadsheet reporting tool such as excel®, to sort information to your preferences.

• Reports > Find a Report > End of Month or Year > Inventory Sales Reports
• Reports > Find a Report > End of Month or Year > Serv. Sales Reports
• Reports > Find a Report > End of Month > YTD Net Sales by Class, Item or Type, Class, Item

1. Based on the report, do one of the following:
   • For Inventory or Serv. Sales reports: Select an appropriate period. Use Ctrl + Shift to select consecutive multiple periods.
   • For YTD Net Sales reports: Select a single closed period. Year to date reports are not available from Current.
2. Click Preview, Print or Save As.
   • When saving the report to file, save to .csv or .xls or appropriate file type for the spreadsheet reporting tool you use.
3. Add range filters as needed, such as class or item type, using AND statements between range rows.
4. Click OK.

Notes:

• Items may display on report print or preview as ‘duplicates’ if the item description was modified during the selected period(s).
• Inventory and Service Sales reports use gross sales whereas year to date Net Sales reports use net sales.
• When saved to a file, the calculated data rows display as separate lines. Use a spreadsheet reporting tool to quickly recombine them.
• Basic excel® steps:
  Note: For more information on excel®, please work with someone on your practices team, with spreadsheet skills. Cornerstone support does not provide assistance on non IDEXX products.
  • Open the saved file. Note column header names used for item description, quantity, and revenue.
  • Insert a pivot table.
  • Select the item description field first.
  • Select the quantity and revenue fields next.
  • Open the drop down > more sort options.
  • Select Descending and choose column and click OK.

Note: If your practice already has the Practice Explorer® module, a Top Items report is available. This report needs to be set up by support.

Once dispensed, use the Compliance report to see what items patients have not been repurchasing. 

1. Reports > Find a Report > Invoice Item > Compliance report.
2. Enter Invoice date range, add AND. 
3. Enter Item ID range filter to view for specific items. 
4. Click Preview, Print or Save As.

Note: Without a date range or specific item IDs, the report will display all items invoiced, including services. 

Navigate to Reports > Client and Patient Report Builder. Create a new or update an existing report using Patient Information of Items Not included in history.

• Note: Once created, you can also access the report to run or update from Reports > Find a report > Client and Patient Reports.

Navigate to Reports > Find a Report > Invoice Item > Controlled Substance Report.

1. Select the appropriate sort order for your needs .
2. Add range filters as needed, such as Invoice Date.

Notes:

• This report displays data for any items on posted invoices that are indicated as controlled substances. This also includes linked items when the associated billing item is invoiced.
• This report does not fully replace paper logs which also need to include incoming inventory.