Billing Reporting

ChiroUp's Billing Reporting features 5 key reports:

  • Discount Detail: An overview of all clinic discounts that have been applied to any purchase.
  • A/R Aging
  • Purchase Detail: A detailed view of all purchases made within a specified date range.
  • Payment Detail: A detailed view of all applied and unapplied Payments collected within a specified date range.
  • Provider Compensation: A detailed view of a provider's earnings over a specific date range, based on when payments are applied to purchases associated with that Provider.

These reports give you a quick and comprehensive look at your patient and payor billing activities. 


Here's how to access Billing Reporting: 

1)  Select the Reporting tab located in the left-side panel.

2) Select Billing


Click either option below to find out more about Billing Reporting:

Discount Detail Report

The Discount Detail report provides a summary of all clinic discounts that have been applied to any purchase. By default, it shows all discounts applied in the current week. 

To view the Discount Detail report, simply click Discount Detail from the Billing Reporting screen. 

 

You will see a breakdown of each discount applied within the selected timeframe, including: adjustment (discount) name, adjustment amount, date applied, patient name, item purchased, total before discount, and total after discount. 

Use the filter bars at the top to narrow your search by adjustment (discount), item, date range, and amount. The amount filter allows you to view discounts that are greater than (>), less than (<), or equal to any amount. 

To download and print the report, select the relevant filters and click the Download button. This will download the report as a CSV file.

💡Pro tip: 

Click on any line item within the Discount Detail report to be brought directly to the corresponding transaction!

 

 

 
 

A/R Aging Report

Coming soon!

 
 

Purchase Detail Report

The Purchase Detail Report provides a detailed view of all purchases made within a specified date range. This report is specific to purchases made during that time period—meaning it only shows relevant information for those purchases.

 

What is a Purchase?

A purchase in the system is a transaction created for an item bought, such as a supplement or treatment.

Filters Available:

You can filter the Purchase Detail report based on the following criteria:

  • Providers: You can filter by any clinic provider. This will filter all Purchases by the Provider the Purchase was with. 
  • Locations: You can filter by any clinic location. This will filter all Purchases by the Location where the Purchase took place. 
  • Supplements: Filter by any clinic supplements and supplies purchased.
  • Treatments: Filter by any clinic treatments purchased.
  • A/R (Accounts Receivable): Filter by the length of time a purchase has had an unpaid balance, calculated from the purchase date.
  • Patient Invoice Status:
    • Unsubmitted: Purchases not yet checked in, no-showed, or canceled will have Patient Invoices with the Unsubmitted status.
    • Submitted: Purchases that have been checked in, no-showed, or canceled will have a Patient Invoice with the Submitted status.
    • Partially Paid: Patient Invoices where a partial patient payment has been made.
    • Paid: Patient Invoices that have been fully paid by the patient.
  • Patient Invoice Dispatched:
    • Dispatched: Patient invoices that have been printed or emailed.
    • Undispatched: Invoices that have not yet been printed or emailed.
  • Appointment Status (Treatment Purchases):
    • Scheduled: The assocaited appointment has been booked but not Checked in, No-showed, or Canceled.
    • Canceled: The associated appointment has been Canceled.
    • No-Show: The associated appointment has been No-Showed. 
    • Checked-In: The associated appointment has been Checked-In. 

Stats Overview:

  • Total Purchases: Number of purchases that took place within the specified date range.
  • Total Billed: The total amount billed for all purchases (includes collections, A/R, discounts, and write-offs).
  • Total Collected: Amount collected on the purchases within the specified date range.
  • Total A/R: Unpaid amount on Purchases within the specified date range.
  • Total Discounts: Total discounts applied to purchases within the specified date range. 
  • Total Write-Offs: Total amounts written off from purchases within the specified date range.

Column Overview:

  • Purchase Date: Date the purchase was made.
  • Patient: Patient the purchase was made for.
  • Provider: Provider linked to the purchase
  • Detail: Describes the treatment or supplement purchased; shows service codes if applicable.
  • Purchase Total: Total amount for the purchase after discounts.
  • Patient Payments: Amount the patient paid towards the purchase.
  • Payor Payments: Payments made by insurance companies toward the purchase.
  • Discounts: Discount amount deducted from the purchase.
  • Write-Offs: Amount written off from the purchase.
  • A/R (Accounts Receivable): Total unpaid amount for the purchase, excluding write-offs and discounts.

This report is crucial for tracking Purchases during the specified time frame and understanding how payments, discounts, and A/R impact those Purchases. For a focused view on compensation, it's recommended to use the Provider Compensation Report, which specifically tracks payments applied within the selected time period for a Provider.

 
 

Payments Detail Report

The Payment Detail Report provides a detailed view of all applied and unapplied Payments collected within a specified date range. This report focuses solely on payments collected during that time period, showing only relevant information for those transactions. By default, this report displays all collected payments from the past month through today.

What is a Payment?

A payment is a transaction collected from a patient or insurance company, which can be either applied to a specific purchase or remain unapplied until it’s allocated to a purchase at a later date.

  • Applied Payments: Payments that have been allocated to a specific purchase or balance, reducing the outstanding amount.
  • Unapplied Payments: Payments that have been collected but not yet assigned to any specific purchase or balance, remaining available for future allocation.

Filters Available:

You can filter the Payment Detail report based on the following criteria:

  • Payment Method: filter by the method of payment
    • Cash 
    • Check
    • Credit Card
    • Credit Transfer
    • EFT
  • Date-Collected Range (Transaction Date): filter by the Date or Date Range the Payment was Collected, aka the Transaction Date saved to the Payment. 
  • Patient: filter by the Patient who made the Payment. 
  • Payor: filter by the Payor who made the Payment; this is fueled by Payors in the clinic’s Payors database. 
  • Verified: filter by verified vs unvierfied payments.
    • Verfiied: verified payments mean the payment has been reconciled 
    • Unverified: unverified payments mean the payment is waiting to be reconciled

Stats Overview:

  • Total Collected: the total payments collected within the specified date range (the Total Applied and Total Unapplied equals the Total Collected)
  • Total Applied: the total of the Total Collected payment that has been Applied
  • Total Unapplied: the total of the Total Collected payment that has not been Applied
  • Total Cash Payments: the total of the Total Collected that are Cash Payments. 
  • Total Check Payments: the total of the Total Collected that are Check Payments. 
  • Total Credit Card Payments: the total of the Total Collected that are Credit Card Payments. 
  • Total EFT Payments: the total of the Total Collected that are EFT Payments. 

Column Overview:

  • Date Collected: the Transaction Date of the collected Payment
  • Verified: the Date of Verification will appear here if the Payment has been verified. 
  • Payor: lists the name of the Patient or Insurance Company in which the payment was collected from. 
  • Payment Method: lists the Payment Method saved to the collected Payment. 
  • Ref. No./ERA Details: lists the Reference Number and Batch Payment Amount for Insurance Payments. 
  • Payment Amount: lists the Payment Amount saved to the collected Payment.
  • Date Applied: list the Date that the Payment was last Applied to a Purchase. 
  • Invoice(s): links the associated Purchases in which the payment was applied to.
  • Applied Amount: lists the amount of the collected Payment Amount that has been applied. 

This report is crucial for tracking Payments collected during the specified time frame. This report is based on the Payment Collection Date rather than when the Payment was applied. For a focused view on compensation, it's recommended to use the Provider Compensation Report, which specifically tracks payments applied within the selected time period for a Provider.

 
 

Provider Compensation Report

The Provider Compensation Report offers a detailed view of a provider's earnings over a specific date range, based on when payments are applied to purchases associated with that Provider. Compensation rates are set for treatments, supplements, and supplies, with either a default rate or a provider-specific rate applied. 

When a payment is applied to a purchase where a provider and compensation rate are assigned, the provider’s earnings are calculated according to that rate and applied payment amount. This report helps you track each provider's earnings accurately, focusing on payments that have been applied, ensuring compensation reflects real-time allocations.

How to Set Up Compensation Rates:

See the support article here on how to set up compensation rates. It's crucial to complete this setup before your go-live date, as compensation rates will only apply to purchases made after the rates are configured.

Filters Available:

You can filter the Provider Compensation report based on the following criteria:

  • Provider: filter by any single clinic provider.
  • Date Range: filter by the Date or Date Range; this will filter the report by the Date the payment was applied for compensation. 

Column Overview:

  • Patient: Lists the patient from whom compensation is received.
  • Applied Date: Indicates the date the Payment was applied to the purchase.
  • Payment Amount: Shows the Payment amount applied to the purchase.
  • Payment Method: Lists the Payment Method of the Payment applied to the purchase.
  • Compensation Amount: Displays the amount the provider will be compensated for, based on the provider/compensation rate combination of the applied payment.
  • Product Category: Identifies the type of item the payment was applied to, either Treatment or Supplement/Supply.

Understanding that the Provider Compensation Report is based on the date payments are applied is crucial for accurate tracking of provider earnings. This focus ensures that compensation reflects real-time allocations and aligns with when payments are actually linked to purchases.

 
 

 

Was this article helpful?

Have more questions? Contact us