Patient reporting

Navigate to Reports > Find a Report > Equine > Treatment Report.

1. Keep the date range as first line, add AND
2. Add Invoice Status range to include only open or closed invoices, if needed, and add AND. See notes.
3. Add patient ID range (if client’s patient ID-s are sequential) or add Patient ID row per patient ID with OR statements in between.

Treatment report for a YTD date range with only closed invoices for a client’s two patients.

Notes:

• Report date filters on either report looks at the line-item date, not the invoice save/post date.
• Reported amount includes any applied preset discounts. Sales tax amounts are included when report is saved to file (csv, xls).
• All invoices statuses (open/closed) are included on the report unless they were added as a report range filter. The invoice status is indicated when saved to a file. Example: closed/posted = 1, open/saved = 0.
• Manual discounts and payment information is not included in the report.
• It is not recommended to run the report for more than 1 patient at a time.
  • This is to ensure the application of the date range and the invoice status is consistent.
  • If patient IDs are consecutively sequential, a patient ID range for the client’s pets could be used.
    Example: patient IDs 33201, 33202, 33203.

Navigate to Reports > Find a report > Patient > Patient History Report.

1. Only select Call Backs from History types.
2. Change the range to Date and enter the applicable date range.
3. Click “OK” button.

Patient History report for all call backs for month to date.

Notes:

• The report can be run for a date range. The report preview displays a drop-down selection for all patients included on the report.
• Click Print to print the report for only the selected patient. Print All to print a separate report per patient.
  
• A patient’s history can be printed/emailed from the Patient Clipboard

Navigate to Reports > Find a report > Patient > Reminder Letter Report.

1. Add a reminder date range, if needed, add AND.
2. Add a specific item ID, if needed.
3. Click Preview, Print, or Save As. If using Save as, choose the file type compatible with reminder service.

Notes: Search ‘reminders’ in the Report search window for all available reports on reminders.

Navigate to Reports > Performance Tracker.

1. Select a tracking and comparison period, based on end of month closings.
2. Click Retrieve.
3. Click Reminders tab.
4. Adjust the date as needed for overdue reminders. It defaults to one year prior to the current date.
5. Right-click on Patients over 1 year with missing reminders for report and reminder file options or in services not received areas.

Notes:

• Requires reminder setup in Performance Tracker defaults.
• Data on the Reminders tab uses current information, regardless of the selected periods. To look at reminders specifically, select the last closed month for tracking and the previous closed month for comparison, so the report runs quicker.
• Search ‘no reminders’ in the Report Search window for all available reports on reminders.

Navigate to either of the following:

• Reports > Find a report > Patient > Patient History Report.
• Click Print History on the Patient Clipboard with the patient selected.

1. Enter the patient ID in the starting and ending values.
2. Enter AND in the And/Or column.
3. Enter the applicable date range.
4. Select the appropriate History types to include.
5. Click OK
6. Click Print or Email.

Notes:

• The History report is best run per patient ID.
• There may be file size limits in place for email or by your email provider. Either run history for a small time periods or adjust History types. Example: Run medical notes and correspondence separately.

Navigate to Reports > Client and Patient Report Builder.

Create a new or update existing report using Patient Information of Date record created.

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 > Patient > Patient by Name. Add range filter for breed ID and sex description, if needed.

To get a report that filters for breed and/or sex, and also includes the age:

1. Navigate to Reports > Client and Patient Report Builder.
2. Create a new or update existing report using applicable Patient Information. Example: Last visit date, age, breed, sex, classification, etc.
3. Run the report and click Print or Labels.

Notes:

• The breed list is maintained under Lists > Species.
• Client and Patient Report Builder report output is preformatted for mailing labels (Avery 5160 equivalent). The client email address is available in the saved file format.

Navigate to Reports > Find a Report > Client > Mailing labels.

1. Select the appropriate sort order for your needs .
2. Add additional range filters as needed, such as client ID, postal code or species/breed.

Notes:

• Report is pre-filtered for active clients and patients.
• The only option for this report is to save to a file. Print and preview options are not available.

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

1. Enter Invoice date range, add AND.
2. Enter invoice item and lot number ranges, as needed, using AND or OR statements appropriately.
3. 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 a date range of September.
• Lot number details are on the report when it is saved to file.
• Search ‘patient sales’ in the Report Search window for all available reports.

Navigate to Reports > Invoice Item > Compliance Report.

Notes:

• The patient would have had to purchase an item at least once to display on the report.
• Alternately, a Client and Patient Report Builder report can be used. Enter your heartworm test items in Items included in history and the applicable heartworm products in Items not included In patient history.

Navigate to Reports > Patient > Deceased Patient.

1. Set the date range.
2. Click Preview, Print, or Save As.

Notes: Search ‘deceased’ in the Report Search window for all available reports.

Navigate to Reports > Find a Report > Patient Census report.

1. Select Date In and/or Date Out range
2. Click Preview, Print, or Save As.

Notes:

• Report data is dependent on the patients being checked in and out (via invoice or manually) on a consistent basis.
• The report also provides check in date/time, check out date/time, reason for visit and staff IDs (provider and checked in by).