• Careville Home
  • Instinct.vet
  • Pick The Brain Articles
  • Instinct Emergencies

Hello, How Can We Help You?

Instinct EMR
Navigation
Back To TopicsEMR User Guides
  • Account Deposits, Account Credits, & Unapplied Payments Guide
  • EMR Health/Service Reminders Guide
  • Username and Passwords
  • Taxes, Non-taxable Sales, and Discounts Report
  • Transaction Details Report
  • Transaction Summary Report
  • Standalone Patient Documents
  • Open Invoices Report
  • Incomplete Charts Report
  • Accounts Receivable (A/R) Summary Report
  • EMR Vaccine Reminders Guide
  • EMR PDF Label Printing Guide
  • Provider Summary and Details Analytic Reports
  • EMR Financials and Account Ledger Guide
  • EMR Analytics Guide
  • EMR End of Day Processing Guide
  • EMR Discounts Guide
  • EMR Invoice Guide
  • EMR Refunds and Returns Guide
  • EMR Taxes Guide
  • Invoice Closing
  • EMR Integrations Reference Guide
  • Asteris Integration
  • Cubex Integration
  • Heska Point-Of-Care Diagnostics Integration
  • IDEXX Diagnostic Integration
  • EMR Controlled Substance Report
  • EMR Gravity Text/Link To Pay
  • Merging and Transfers Guide
  • EMR Administrator Guide
  • EMR Business Office Guide
  • EMR Reference Guide
  • EMR Charting Guide
  • Rapid Registration
  • EMR Anesthesia (Ax) Mode
  • Outage Guidelines
  • EMR Rounds/Case Review Guide
  • EMR Drawing Block Guide
  • Task List User Guide
  • User Roles and Permissions Guide
  • EMR Student/Draft Mode Guide
  • EMR Appointment & Event Calendars
  • EMR Estimate Guide
  • EMR Prescription Guide
  • EMR DYMO Integration with Web Connect Service Guide
  • EMR Shareville Guide
  • EMR Shareville rVet Guide
  • EMR Comm Log User Guide
  • EMR Referrer Guide
  • EMR Gravity Payments User Guide
  • EMR Inventory Guide
  • Outpatient and ER Workup Guide
  • Common Hospitalization Workflows
  • Ordering, Charging, & Changing Fluids, Additives, and CRI's
  • Maintaining Instinct
  • How Instinct EMR Captures Charges
  • Streamlining Charges - Instinct EMR Tips and Guidelines
  • Dictation Programs in Instinct
Analytic Reports
  • Taxes, Non-taxable Sales, and Discounts Report
  • Transaction Details Report
  • Transaction Summary Report
  • Open Invoices Report
  • Incomplete Charts Report
  • Accounts Receivable (A/R) Summary Report
  • Provider Summary and Details Analytic Reports
  • EMR Controlled Substance Report
EMR Training Videos, Quizzes & Webinars
  • Instinct Academy
  • EMR Training Guide Quizzes
  • EMR Training Video: Appointment & Event Calendars
  • EMR Ax Mode Training Video
  • Instinct EMR Reference Video
EMR ProTips
  • Provider Commissions Reporting in Instinct
  • Filters/Sorting Guide
  • Insulin Therapy Guide
  • Snippets
  • Routine Maintenance of Instinct
  • EMR Product Groups
  • How does Instinct EMR handle Daylight Saving Time?
  • How do I set up an on-the-way patient in EMR?
  • How Do I Print In Instinct EMR?
  • Alerts Guide
  • Patient Safety Warnings For Chemotherapy Medications
  • What is an EMR Superuser?
  • Reopening a Visit/Treatment Sheet
  • How do I copy/paste Vitals in EMR?
  • EMR Assign To Me
  • EMR Invoice Tags
  • EMR ID System
  • 24 Hour Treatment View
  • Status Board not showing all patients
  • How do I mark a patient as deceased?
  • How do I skip or not complete a treatment?
  • Common OP/IP Product Groups
  • How do I record vitals if the patient isn’t due for them now?
  • Differences between Optional q1h Frequency, Every 1h, PRN, and UC
  • How do I view a previous Tx Sheet or download/print a Tx Sheet?
  • Communication Tools in Instinct
  • Weight Calculator (optional)
  • Advanced Patient Search
  • Handy Keyboard Shortcuts
  • Adding order notes, call parameters, or specific instructions to a treatment
  • Do orders reschedule automatically if I complete a treatment before/after the scheduled time?
  • Copy All Medications
  • Viewing Discontinued Medications
  • Other/Miscellaneous orders
  • Accessing Plumb's Drug Formulary in EMR
  • How do I exit full screen so I can minimize Instinct?
  • Multi-frequency orders using tabs
  • Using Emojis in Instinct
  • Vital Notes
  • How do I print a Tx Sheet?
  • How do I copy/paste vitals?
  • How Do I View or Change the Code Status?
  • Adding a One-Off treatment
  • Who Added, Changed, or Discontinued an Order?
  • Adding an Alert that doesn’t exist
  • TV Mode/Whiteboard User ID
  • How to access Instinct from a web browser
  • How do I put Instinct on a TV screen?
  • 'Instinct needs to authenticate your practice' message
  • How do I switch hospital locations?
  • I forgot/was never given a login PIN
  • Automatic Charges
  • Bulk Edit On Treatment Sheet
  • Can I change my PIN or login credentials?
  • Workflow Tags
  • How do I indicate other Patient Care Team Members?
  • Patient Safety Warning Systems
  • Triage Tags
  • How do I copy/paste from Instinct
  • How do I edit completed Vital entries?
  • How does My Board and pinning work?
  • How do I move the tx sheet if my patient was transferred to our other location?
  • Why is there no calculator for this medication order?
  • How to edit/delete a completed treatment
  • Creating/editing a Vital product
  • Viewing vitals from another visit or across a patient's lifetime
  • Why is there a money symbol next to some orders?
EMR Technology Guidelines
  • Routine Maintenance of Instinct
  • Instinct System Status
  • Hardware & Technology Guidelines
  • Installing Instinct on Home Computers
  • Internet & Power Outage Guidelines
EMR Release Updates
  • December 2022 EMR Release Updates
  • November 2022 EMR Release Updates
  • October 2022 EMR Release Updates
  • September 2022 EMR Release Updates
  • August 2022 EMR Release Updates
  • July 2022 EMR Release Updates
  • June 2022 EMR Release Updates
  • May 2022 EMR Release Updates
  • April 2022 EMR Release Updates
  • March 2022 EMR Release Updates
  • February 2022 EMR Release Updates
  • January 2022 EMR Release Updates
  • December 2021 EMR Release Updates
  • November 2021 EMR Release Updates
  • October 2021 EMR Release Updates
  • September 2021 EMR Release Updates
  • August 2021 EMR Release Updates
EMR Onboarding Documents
  • EMR On-Site Go-Live Guide
  • What is an EMR Superuser?
  • EMR Virtual Go-Live Guide
  • Medical and Workflow Guidelines
EMR Analytics Guide
Print

EMR Analytics Guide

Learn how to access, download, and schedule hospital reports in the analytics dashboard!

Table of Contents

Accessing Analytics

Report Permissions

Scheduling Reports

Downloading Reports

Generate New Reports On Demand

Available Reports in Instinct EMR

Sorting and Filtering Exported Reports

Using Pivot Tables on Exported Reports

Analytics Guide Quiz


Accessing Analytics

If you have one or more Analytic Permissions, you will see the Analytics icon in the left-side menu to open the Analytics dashboard:

The Analytics dashboard displays a list of available reports and a description of what’s included. These can be scheduled to be generated on a Daily, Weekly, and/or Monthly basis (orange dots), and for quick reference, we’ve included the date the last report was generated. Scheduled Analytic Reports can be automatically emailed to key individuals on the hospital team. To add or remove an email from the list, please contact us at support@instinct.vet.


📑 Report Permissions

Administrative Users can assign Permissions to User Roles allowing access to individual Analytic Reports without allowing access to all Analytic Reports.

Some new Role examples are as follows: 

  • Analytics – EOD (End of Day) – Includes access to Transaction Details Report, Transaction Summary Report, and Accounts Receivable Summary Report
  • Analytics – Inventory – Includes access to the Controlled Substance Report
  • Analytics – Doctors – Includes access to the Incomplete Chart Report and Patient Census Report

Example of what the User with the Analytics – EOD Role would see in the Analytic Section: 

The following Permissions are needed to access individual Analytic Reports:  

  • analytics_accounts_receivable_summary_report
  • analytics_controlled_substance_report
  • analytics_deceased_patients_report
  • analytics_incomplete_charts_report
  • analytics_open_invoices_report
  • analytics_order_summary_report
  • analytics_patient_census_report
  • analytics_practice_summary_report
  • analytics_provider_summary_details_invoiced_report
  • analytics_provider_summary_details_collected_report
  • analytics_referrer_details_report
  • analytics_revenue_details_report
  • analytics_taxes_discount_report
  • analytics_transaction_details_report
  • analytics_transaction_summary_report

💡 Please note: Scheduled Analytic Reports are not affected by these permissions. Emails receiving Scheduled Analytic Reports will receive all reports regardless of the Users permissions.


Scheduling Reports

To set-up report schedules or to edit existing schedules, simply click on the checkboxes to the left of the report names.  This will activate the Change Schedule button at the top of the screen. Note that you can select more than one report at a time!

Clicking on the Change Schedule button will open a window that allows you to choose whether you would like the reports to be sent Daily, Weekly, and/or Monthly.

  • Daily Reports are generated from 12AM to 11:59PM for the previous day
  • Weekly Reports are generated from Sunday 12AM to 11:59PM of the following Saturday
  • Monthly Reports are generated from the First day of the month to the Last day of the month, 12AM to 11:59PM.

Downloading Reports

To view and download previously generated reports, click on the name of the report in the Analytics screen to be taken to the list of previously generated reports. You will see the reporting period of the report, when the report was generated, and the schedule of the report (Daily, Weekly, Monthly, OnDemand).

To download a report, simply click on the desired reporting period of the report and it will automatically open as an excel spreadsheet for viewing and save it to an Instinct Folder on your computer. The file name of the downloaded reports will include your Abbreviated Practice Name, Report Name, and Date of the Report.  For example: ABC Clinic – Practice Summary Report (Day of April 24, 2021)


Generate New Reports On Demand

Generate a new report whenever you need it!  Simply click on the report name to enter the historical generation information for the report.  At the top of the screen, click on Generate New Report. 

Select the start and end dates and times for the report and click on Generate.  At this time, reports can only be generated for up to 31 days at a time. 

A notification will appear in the lower left corner of the screen that the report is being generated and emailed to the email address on the distribution list that was set up by your hospital administrator. 

If your email is not on the distribution list, you can still access the report by selecting the line that populates in the report history.  


📈 Available Reports in Instinct EMR

To view detail information regarding each report, simply click on the report name!

  • Accounts Receivable (A/R) Summary Report – Summary of account balances and aging
  • Controlled Substance Report – Controlled substance compliance report
  • Deceased Patient Report – Deceased patient details including signalment, status, ward, provider, and referring veterinarian (Details coming soon!)
  • Incomplete Charts Report – Summary of incomplete and unsigned charting documents
  • Open Invoices Report – All currently open invoices
  • Order Summary Report – Summary of counts of products/services (Details coming soon!)
  • Patient Census Detail Report – Patient details including signalment, status, ward, provider, referring veterinarian, and invoices (Details coming soon!)
  • Practice Summary Report – Key practice and financial summary metrics (Details coming soon!)
  • Provider Summary and Details Report – Collected Invoicing – Summary of collected invoicing by provider for payments made within the reporting period on closed invoices
  • Provider Summary and Details Report – Gross Invoicing – Summary of counts and gross invoicing by provider for all invoices closed during the reporting period
  • Referrer Details Report – Referrer details by hospital and referring veterinarian (Details coming soon!)
  • Revenue Details Report – Invoiced line item details by product or service sold (Details coming soon!)
  • Taxes, Non-taxable Sales, and Discounts Report – A summary of taxes, non-taxable sales, and discounts
  • Transaction Details Report – Collected payment, refund, and adjustment details
  • Transaction Summary Report – Summary of payment/refund/adjustment data

Sorting and Filtering Exported Reports

Prepping the Spreadsheet to Sort or Filter:

  • Highlight all cells in the Spreadsheet by clicking on the triangle where the rows and columns meet in the upper left corner.
  • Keyboard shortcuts can also be used! (Mac: command + A; Windows: Ctrl + A)

To Sort Excel Spreadsheets:

  • With all cells still highlighted, click on the “Sort & Filter” button and then select “Custom Sort”.
  • A popup will appear for Sorting options. Check the box next to “My Data Has Headers”, then in the “Sort by” drop-down select the column to sort.
  • Clicking “OK” will sort the Spreadsheet for the desired information.

To Filter Excel Spreadsheets:

  • Go to the column you’d like to filter the Spreadsheet by and highlight the entire column.
  • Click on the “Sort & Filter” button and then select “Filter”.
  • The selected column header will now have a dropdown arrow.
  • Clicking on this arrow will pull open a list of values to filter by. Place a checkmark next to the values you would like to see, then click “OK”.
  • Only rows with the selected filter value(s) will show on the Spreadsheet.

📊Creating Pivot Tables for Exported Reports

Pivot tables are a great way to get summary insights from raw data.

Prepping the Spreadsheet for Creating a Pivot Table:

  • Highlight all cells in the Spreadsheet by clicking on the triangle where the rows and columns meet in the upper left corner.
  • Keyboard shortcuts can also be used! (Mac: command + A; Windows: Ctrl + A)

Creating the Pivot Table:

  • In the toolbar at the top of the spreadsheet, select Insert, then Pivot Table
  • A Create Pivot Table pop-up window will appear, allowing you to choose range of the data that you want to analyze.
  • Choose where to place the pivot table, we recommend selecting New Worksheet. Then click on OK
  • A new spreadsheet tab will be created and you will automatically be taken to it. This tab will be blank except for the below box:
  • Click within the box to open the PivotTable Fields box. This box consists of 4 areas: Filters, Columns, Rows, and Values.
  • Drag the appropriate field into the Row Box, then click and drag it into the Values box. In the Values box, the label will change to sum of, count of, etc. To change how the value is being calculated, click on the i button and select the desired value.
  • As Rows and Values are being added, the Pivot Table should be updating in real-time with the requested information.
  • To remove any blank rows, click the arrow next to the Row Labels heading and filter the blanks so they are not displayed.

🧠Test your knowledge with our Careville Quiz!


CONTACT US

Instinct Science
54 East Oakland Ave
Doylestown, PA 18901
sayhi@instinct.vet
866.267.1818
GET ON OUR LIST TESTIMONIALS PRIVACY & TERMS
ABOUT JOIN US INVESTORS
Made with 🧡 in Philadelphia
© 2023 Instinct Science, LLC
Instinct System Status
  • Careville Home
  • Instinct.vet
  • Pick The Brain Articles
  • Instinct Emergencies
 

Loading Comments...