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

Hello, How Can We Help You?

Instinct EMR
Navigation
Back To TopicsEMR User Guides
  • Tax Exempt Accounts
  • Late Fees
  • Standalone Invoicing
  • Advanced Invoicing Guide
  • EMR Health/Service Reminders Guide
  • Account Deposits, Account Credits, & Unapplied Payments Guide
  • Username and Passwords
  • EMR Analytics Guide
  • Accounts Receivable (A/R) Summary Report
  • EMR Controlled Substance Report
  • Deceased Patients Report
  • Incomplete Charts Report
  • Open Invoices Report
  • Order Summary Report
  • Patient Census Detail Report
  • Practice Summary Report
  • Provider Commissions Reporting in Instinct
  • Provider Summary and Details Analytic Reports
  • Referrer Details Report
  • Revenue Details Report
  • Taxes, Non-taxable Sales, and Discounts Report
  • Transaction Details Report
  • Transaction Summary Report
  • Standalone Patient Documents
  • EMR Vaccine Reminders Guide
  • EMR PDF Label Printing Guide
  • EMR Financials and Account Ledger Guide
  • EMR End of Day Processing Guide
  • EMR Discounts Guide
  • EMR Invoice Guide
  • EMR Refunds and Returns Guide
  • EMR Taxes Guide
  • Invoice Closing
  • Integrations Reference Guide
  • Antech Diagnostic Integration
  • Asteris Integration
  • Client Chat (Powered by Twilio)
  • Cubex Integration
  • Dictation Programs in Instinct
  • DYMO Integration with Web Connect Service Guide
  • Gravity Payments User Guide
  • Gravity Text/Link To Pay
  • Heska Point-Of-Care Diagnostics Integration
  • IDEXX VetConnect
  • Merging and Transfers Guide
  • EMR Administrator Guide
  • EMR Business Office Guide
  • EMR Reference Guide
  • EMR Charting Guide
  • Rapid Registration
  • EMR Anesthesia (Ax) Mode
  • 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 Prescription Guide
  • EMR Estimate Guide
  • EMR Shareville Guide
  • EMR Referrer Guide
  • EMR Shareville rVet Guide
  • EMR Comm Log 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
Integrations
  • Integrations Reference Guide
  • Antech Diagnostic Integration
  • Asteris Integration
  • Client Chat (Powered by Twilio)
  • Cubex Integration
  • Dictation Programs in Instinct
  • DYMO Integration with Web Connect Service Guide
  • Gravity Payments User Guide
  • Gravity Text/Link To Pay
  • Heska Point-Of-Care Diagnostics Integration
  • IDEXX VetConnect
Analytic Reports
  • EMR Analytics Guide
  • Accounts Receivable (A/R) Summary Report
  • EMR Controlled Substance Report
  • Deceased Patients Report
  • Incomplete Charts Report
  • Open Invoices Report
  • Order Summary Report
  • Patient Census Detail Report
  • Practice Summary Report
  • Provider Commissions Reporting in Instinct
  • Provider Summary and Details Analytic Reports
  • Referrer Details Report
  • Revenue Details Report
  • Taxes, Non-taxable Sales, and Discounts Report
  • Transaction Details Report
  • Transaction Summary Report
EMR Training Videos, Quizzes & Webinars
  • Instinct Office Hours 
  • Instinct Academy: EMR Admin Webinar
  • Getting Started With Instinct EMR: An Admin Training Guide
  • Getting Started With Instinct EMR: A Training Guide
  • EMR Training Guide Quizzes
  • Meet Instinct EMR
  • Instinct EMR Reference Video
  • EMR Training Video: Admin - Calendar Section
  • EMR Training Video: Admin - Medical Record Section
  • EMR Training Video: Admin - Overview
  • EMR Training Video: Analytics Module
  • EMR Training Video: Analytics Reports Overview
  • EMR Training Video: Antech Diagnostic Integration
  • EMR Training Video: Appointment & Event Calendars
  • EMR Training Video: Asteris Integration
  • EMR Training Video: Ax Mode
  • EMR Training Video: Business Office Overview
  • EMR Training Video: Business Office - Accounts
  • EMR Training Video: Business Office - Appointments
  • EMR Training Video: Business Office - Events
  • EMR Training Video: Business Office - Financials
  • EMR Training Video: Business Office - Patient Registration
  • EMR Training Video: Business Office - Referrers
  • EMR Training Video: Charts
  • EMR Training Video: Client Chat
  • EMR Training Video: Comm Log
  • EMR Training Video: Estimates
  • EMR Training Video: Gravity Payments Integration
  • EMR Training Video: Heska Diagnostic Integration
  • EMR Training Video: IDEXX Integration
  • EMR Training Video: Invoice
  • EMR Training Video: Look Up
  • EMR Training Video: Navigating EMR
  • EMR Training Video: Patient Info Bar
  • EMR Training Video: Payments and Ledger
  • EMR Training Video: Plumb's Veterinary Drug Formulary
  • EMR Training Video: Rapid Registration
  • EMR Training Video: Rx Module
  • EMR Training Video: Status Boards
  • EMR Training Video: Task List
  • EMR Training Video: Treatment Sheet
  • EMR Training Video: Vaccine & Service Reminders
  • EMR Training Video: Vitals Board
EMR Training Videos
  • Instinct EMR Reference Video
  • EMR Training Video: Admin - Calendar Section
  • EMR Training Video: Admin - Medical Record Section
  • EMR Training Video: Admin - Overview
  • EMR Training Video: Analytics Module
  • EMR Training Video: Analytics Reports Overview
  • EMR Training Video: Antech Diagnostic Integration
  • EMR Training Video: Appointment & Event Calendars
  • EMR Training Video: Asteris Integration
  • EMR Training Video: Ax Mode
  • EMR Training Video: Business Office Overview
  • EMR Training Video: Business Office - Accounts
  • EMR Training Video: Business Office - Appointments
  • EMR Training Video: Business Office - Events
  • EMR Training Video: Business Office - Financials
  • EMR Training Video: Business Office - Patient Registration
  • EMR Training Video: Business Office - Referrers
  • EMR Training Video: Charts
  • EMR Training Video: Client Chat
  • EMR Training Video: Comm Log
  • EMR Training Video: Estimates
  • EMR Training Video: Gravity Payments Integration
  • EMR Training Video: Heska Diagnostic Integration
  • EMR Training Video: IDEXX Integration
  • EMR Training Video: Invoice
  • EMR Training Video: Look Up
  • EMR Training Video: Navigating EMR
  • EMR Training Video: Patient Info Bar
  • EMR Training Video: Payments and Ledger
  • EMR Training Video: Plumb's Veterinary Drug Formulary
  • EMR Training Video: Rapid Registration
  • EMR Training Video: Rx Module
  • EMR Training Video: Status Boards
  • EMR Training Video: Task List
  • EMR Training Video: Treatment Sheet
  • EMR Training Video: Vaccine & Service Reminders
  • EMR Training Video: Vitals Board
Instinct Academy
  • Instinct Office Hours 
  • Instinct Academy: EMR Admin Webinar
EMR ProTips
  • Heska Request ID
  • Filters/Sorting Guide
  • Insulin Therapy Guide
  • Snippets
  • 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
  • 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 on a tablet
  • 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
  • Zebra Label Printer Setup on macOS
  • Routine Maintenance of Instinct
  • Instinct System Status
  • Hardware & Technology Guidelines
  • Installing Instinct on Home Computers
  • Internet & Power Outage Guidelines
EMR Release Updates
  • September 2023 EMR Release Updates
  • August 2023 EMR Release Updates
  • July 2023 EMR Release Updates
  • June 2023 EMR Release Updates
  • May 2023 EMR Release Updates
  • April 2023 EMR Release Updates
  • March 2023 EMR Release Updates
  • February 2023 EMR Release Updates
  • January 2023 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
  • Getting Started With Instinct EMR: An Admin Training Guide
  • Getting Started With Instinct EMR: A Training Guide
  • EMR On-Site Go-Live Guide
  • What is an EMR Superuser?
  • EMR Virtual Go-Live Guide
  • Medical and Workflow Guidelines
Provider Summary and Details Analytic Reports
Print

Provider Summary and Details Analytic Reports

🚨Check out our Provider Commission Reporting Article for an overview of which production payment style may work best for your practice!

Our Provider Summary Report has been updated, renamed, and split into two different reports: the Provider Summary and Details Report – Gross Invoicing and the Provider Summary and Details Report – Collected Invoicing. These new reports will still consist of the Report Info tab and the Practice Summary tab (previously Provider Summary), but now will also have a Glossary tab and a Provider Detail tab

  • Provider Summary and Details Report – Gross Invoicing: This report is ideal for practices that pay provider commission based on the amount invoiced from closed invoices during the reporting period.
  • Provider Summary and Details Report – Collected Invoicing: This report is ideal for practices that pay provider commission based on the amount collected during the reporting period on closed invoices.

💡Note For Multi-Location Practices: If a patient is transferred from one location to another during the same visit, the Invoice will appear in the Provider Summary and Detail Report for the location the patient was assigned to when the Invoice was Closed. To have invoiced items show on the report for the appropriate location, we would recommend checking the patient out and closing the invoice at time of transfer and starting a new visit and invoice at the new location.


Provider Summary and Details Report – Gross Invoicing

The Provider Summary and Details Report – Gross Invoicing is ideal for practices that pay provider commission based on gross invoice revenue, as it displays a summary of gross invoice revenue for providers from invoices that were closed during the reporting period.

All Total amounts displayed on the report will be calculated before taxes are applied (pre-tax) and after discounts are applied (post-discount). In the Provider Detail tab, only invoice line items from invoices closed within the reporting period will be displayed, regardless of the date the individual items were added to the invoice. Total amounts include collected and uncollected revenue.

Users need to have the analytics_provider_summary_details_invoiced_report permission added to a role in order to access this report in Analytics.

💡To learn more about how to access and schedule this report, check out our EMR Analytics Guide!

The Provider Summary and Details Report – Gross Invoicing consists of the following:

Report Info Tab

The Report Info tab is the cover page for the report and consists of the Hospital Name and Hospital Location.  It will also show what date/time range the report is for, when the report was created, and the time zone for the report.

Glossary Tab

The Glossary tab contains terms and definitions for column headings located throughout the report for clarity.

The Note at the top of the sheet explains that this report shows gross invoice revenue from closed invoices during the reporting period. All amounts will be calculated pre-tax and post-discount.

Terms listed:

  • Average Invoice Amount – Total Invoicing divided by Visit Count. Note that this should be interpreted carefully since all visits are counted, including for invoice corrections
  • Visit Count – Number of visits where the provider has at least one line item. Note that his should be interpreted carefully since all visits are counted, including for invoice corrections
  • % of Total Practice Invoicing – This is the percentage of total revenue from closed invoices for a provider divided by the total hospital revenue from closed invoices during the reporting period
  • Total Invoicing – This is the total revenue invoiced per provider (pre-tax and post-discount) on closed invoices during the reporting period
  • Total Exempt Amount (Excluded from Commissions) – This is the total invoiced revenue per provider on closed invoices for line items that are flagged as “Excluded from Commissions” in the product admin settings during the reporting period
  • Total Eligible Amount (Gross Production Included in Commissions) – This is the total invoiced revenue per provider on closed invoices for items that are eligible for commissions during the reporting period
  • Eligible for Commissions – This is based on the “Excluded from Commissions” toggle in the product admin settings.  Column will list ‘Yes’ or ‘No’
  • Total Tax Amount – This is the total amount of tax applied to each line item on closed invoices during the reporting period
  • Total Discount Amount – This is the total amount of discounts that was applied to each line item on closed invoices during the reporting period
  • Tax Exempt – Indicates the tax exempt status of the account at the time the report is run. This could be different from the tax exempt status when the line item occurred.

Practice Summary Tab

The Practice Summary tab includes a summary for each provider showing the Average Invoice Amount, Visit Count, % of Total Practice Invoicing and the amounts of Total Invoicing, Total Exempt Amount of invoicing, and Total Eligible Amount of invoicing for all closed invoices during the reporting period.

Provider Summary Counts Tab

The Provider Summary Counts tab displays the total quantity and amount invoiced for specific invoice line items per provider based on closed invoices during the reporting period.  

This tab can be used to see how many of a certain item a provider sold or performed during that reporting period (Radiograph – Thoracic Series qty 4 in the example above) and how much revenue that provider brought in for selling or performing that item ($1,008.00 based on the example above).

Provider Details Tab

The Provider Details tab provides a detailed list of all invoice line items assigned to a specific provider on closed invoices during the reporting period.  Within the Provider Detail tab, items will be grouped by providers, and providers will be listed alphabetically by last name. The items within each provider group will be listed in order of invoice line item date/time.

The Provider Detail tab includes the following information: 

  • Invoice Line Item Date/Time (sorted chronologically for the reporting period)
  • Provider
  • Product ID
  • Product Name
  • Quantity of Item
  • Account ID
  • Account Type
  • Tax Exempt – displays Yes if exempt and No if not exempt
  • Client Last Name
  • Client First Name
  • Patient ID
  • Patient Name
  • Invoice Number
  • Invoice Tag
  • Tax Class
  • Discount Class
  • Total Tax Amount – Products with taxes will display $0.00 if the Tax Exempt column displays Yes
  • Total Discount Amount
  • Eligible for Commissions
  • Total Invoicing

🚨 Important to Note:  Practices paying doctors using Gross Invoicing should create a new invoice for the account write off and enter line items that are being written off with a negative quantity and price to reflect appropriate invoice revenue totals for providers.


Provider Summary and Details Report – Collected Invoicing

The Provider Summary and Details Report – Collected Invoicing is ideal for practices that pay provider commission based on collected revenue, as it displays collected revenue by providers based on payments and refunds made during the reporting period to closed invoices.

All Total amounts displayed on the report will be calculated before taxes are applied (pre-tax) and after discounts are applied (post-discount) and only invoice line items from closed invoices will be displayed.  This report will include any payments or refunds that were made on open invoices that are closed during the reporting period, as well as any payments or refunds that were made during the reporting period on invoices that were closed prior to the reporting period. 

If partial payment is taken for a closed invoice, the payment amount will first be applied to pay off any taxes, then the remaining payment amount will be applied to line items on the invoice from oldest date to newest date. Refunds will be applied to line items in the reverse order, most recent date to oldest date, then to any taxes on the invoice.

Account Credit payments will be considered as a payment on the invoice and will be included in the transaction amount in the total collected invoicing amounts of this report. Unapplied payments from an invoice will be considered a refund in the total collected invoicing amounts.

💡 Please Note: Payments or Refunds made on open Invoices will not be considered in this report until the invoice has been closed. The payment or refund date will then be considered the date of invoice closed and will appear in any reporting periods that contain that closed date.

Users need to have the analytics_provider_summary_collected_report permission added to a role in order to access the report in Analytics.

💡To learn more about how to access and schedule this report, check out our EMR Analytics Guide!

The Provider Summary and Details Report – Collected Invoicing consists of the following:

Report Info Tab

The Report Info tab is the cover page for the report and consists of the Hospital Name and Hospital Location.  It will also show what date/time range the report is for, when the report was created, and the time zone for the report.

Glossary Tab

The Glossary tab contains terms and definitions for column headings located throughout the report for clarity.

The Note at the top explains that this report shows collected revenue, that is pre-tax and post-discount, from closed invoices based on payments and refunds made during the reporting range. 

  • If a payment or refund was made on an open invoice, that revenue would not show in the report until the invoice is closed. In this instance the transaction date would be considered the closed invoice date, as that is when the payment or refund will be applied to the invoice. 
  • If a closed invoice receives a partial payment, it will be applied in chronological order, covering the total invoice tax amount first, then applying payments to line items from oldest to newest. Once an invoice has a $0 or negative balance, it is considered fully paid.
  • Providers could be over or under compensated for a transient period of time when uncollected invoices are later adjusted. This will resolve itself as long as invoices are paid off over time. For example, if a provider has a closed invoice that wasn’t collected in a prior reporting period and later a new invoice is created to correct the provider to another provider (negative for this provider, positive for a new provider). At that time, the second provider would have an invoice considered paid ($0 balance) and the original provider would get a negative amount deducted for the change at that time even though they weren’t paid initially. Once the original invoice is marked as paid, the original provider will receive compensation in a future reporting period.

Terms listed:

  • % of Total Practice Invoicing Collected – This is the percentage of total payments collected on closed invoices by a provider divided by the total payments collected on closed invoices for all providers during the reporting period
  • Total Invoicing Collected – This is the total amount of payments and refunds collected on closed invoices per provider (pre-tax and post-discount) for a reporting period
  • Total Exempt Amount Collected (Excluded from Commissions) – This is the total amount of payments and refunds collected on closed invoices for items flagged as “Excluded from Commissions” per provider for the reporting period
  • Total Commissions Amount Collected (Paid Line Items Included in Commissions) – This is the total amount of payments and refunds on closed invoices for items that are eligible for commissions per provider during the reporting period
  • Eligible for Commissions – This is based on the “Excluded from Commissions” toggle in the product admin settings.  Column will list ‘Yes’ or ‘No’
  • Total Tax Amount – This is the total amount of tax applied to each line item on closed invoices during the reporting period
  • Total Discount Amount – This is the total amount of discounts that was applied to each line item on closed invoices during the reporting period
  • Tax Exempt – Indicates the tax exempt status of the account at the time the report is run. This could be different from the tax exempt status when the payment was made.

Practice Summary Tab

The Practice Summary tab includes a summary for each provider showing the % of Total Practice Invoicing Collected and the amounts of Total Invoicing Collected, Total Exempt Amount of Invoicing Collected, and Total Eligible Amount of Invoicing Collected during the reporting period for all closed invoices .

💡 Please Note: In rare cases the % of Total Practice Invoicing Collected for a provider can be negative. This can occur when a provider’s collected amount is from a refund only. For example if the provider had a total of $25 refunded on line items (-$25 collected) during the reporting period, and the practice had a total of $100 collected during the period, then the provider’s % Total Invoiced by Practice would be -25%.

Provider Details Tab

The Provider Details tab provides a detailed list of all invoice items assigned to a specific provider on closed invoices during the reporting period. Within the Provider Detail tab, items will be grouped by providers, and providers will be listed alphabetically by last name. The items within each provider group will be listed in order of invoice line item date/time.

 The Provider Detail tab includes the following information: 

  • Invoice Line Item Date / Time – This is the date the line item was placed on the invoice and may be outside of the reporting period if a payment or refund was made during the reporting period on an invoice that was closed prior to the reporting period or if a payment or refund was made to an open invoice that was then closed during the reporting period.
  • Provider
  • Product ID
  • Product Name
  • Account ID
  • Account Type
  • Tax Exempt – displays yes if exempt and no if not exempt
  • Client Last Name
  • Client First Name
  • Patient ID
  • Patient Name
  • Invoice Number
  • Invoice Tag
  • Tax Class
  • Discount Class
  • Total Tax Amount – Products with taxes will display $0.00 if the Tax Exempt column displays Yes
  • Total Discount Amount
  • Eligible for Commissions
  • Total Invoicing Collected – This column shows the total payment or refund applied to the line item during the reporting period.  (If multiple payments/refunds are made to a line item, the Total Invoicing Collected will show the total payment/refund that was applied to the line item. 

🚨Important to Note: Practices paying doctors by total collected should not create a new invoice with negative quantity and price line items to write the account off, as this could penalize the doctor since the items were never paid for.


🧠 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...