Billed vs. Collected Report – Overview & How to Use All Filters (Facility, Clinician, Team)
To support deeper analysis, users can now filter this report by Facility, Clinician, and Team, allowing for more precise reporting across locations, staff groups, and individual providers.
What This Report Shows
When you run the Billed vs. Collected report, the system generates:
Total amount collected
Total amount billed
Total number of services
Total number of unique appointments
Total number of unique clients
A breakdown of appointments by CPT code
This report is commonly used for:
Productivity tracking
Revenue analysis
Team performance reviews
Payroll and supervision support
Identifying gaps between billed and collected revenue
Available Filters
You can refine the report using the following filters:
Date Range
Select the time period you want to analyze.
Clinicians
Filter by one or multiple clinicians to review provider‑level billing and collection trends.
Facility
Under Advanced Filters, select the facility or facilities you want included in the report.
Team (NEW)
You can now filter the report by Team, allowing practices to:
Compare performance across departments or staff groups
Review billing and collection trends for specific teams
Support team‑based supervision, payroll, and productivity workflows
How to Run the Billed vs. Collected Report
STEP 1:
Click on the Reporting tab in the navigation bar, then select Billing vs. Collected on the right‑hand side.
Date Range
Clinicians
Timeframe breakdown (Daily, Weekly, Monthly, etc.)
Advanced Filters → Group counts, CPT Length designation, Facility, Tags, Types of Appointments
Team Filter → Select one or multiple teams
STEP 3:
Click Run Report.
The report will automatically update to show only the data associated with the selected clinician(s), facility/facilities, and team(s).
- Total amount collected
- Total amount billed
- Total number of services
- Total number of unique appointments
- Total number of unique clients
- A breakdown of the number of appointments scheduled with each CPT code
Related Articles
Missed Reasons Report (Within Billing vs. Collected Report)
Within the Billing vs. Collected Report, you’ll now be able to click on the number of Missed Appts to view a breakdown of the missed reasons. Step 1: Navigate to the Reporting Page. Then, select Billing vs. Collected. Step 2: Set your filters and ...Missed Sessions Reason Report
Overview How to Run the Report How to add Custom Missed Reasons The Missed Sessions Reason Report helps practices track when and why client appointments were missed. This report provides clear visibility into cancellation patterns, no‑show trends, ...Refunding a Credit Card Transaction
In order to refund a credit card charge, you will want to navigate to the Billing tab within the menu bar or within the specific client's profile. If searching for the transaction within the main Billing tab, you'll first want to enter the date range ...Prior Authorization Report
Overview The Prior Authorization Report gives your practice a centralized view of all active, expiring, and expired prior authorizations across your client base. This report helps billing teams, administrators, and clinicians stay ahead of ...Exporting Billing
Step 1: Go to Billing from the main menu Step 2: Click on Export Billing to download it as a CSV file. Once exported, the CSV file includes the following: - Address - Office Number - Therapist - Client ID - Client Name - Date of Service (DOS) - CPT ...