Loading data, please wait...
Search across all fields including patient names, invoice numbers, visit IDs, notes, and more.
Ask questions in plain English and get SQL-powered answers. Click a template or enter your own query.
Generating SQL and fetching data...
Analyze individual AR representative performance over custom date ranges.
Loading report data...
Please select an AR Representative to view their dashboard.
Analyze collection rates for any contract over a custom date range - no user assignment restrictions.
Analyzing contract performance...
| Contract | Year | Month | Total Billed | Total Collected | Collection Rate |
|---|
| Contract | Representative | Role | Assigned Date |
|---|
No invoice data found for the selected contract and date range.
Loading user data...
| User ID | Role | Status | Created Date | Last Login | Contracts | Actions |
|---|
Loading unassigned contracts...
| Contract Name | Total Amount | Outstanding Amount | Invoice Count | Avg Aging | Oldest Aging | Actions |
|---|
Loading your saved prompts...
| Prompt | Created | Used | Actions |
|---|
No saved prompts yet. Your search history will appear here.
Manage temporal tracking of which rep managed which contract during specific time periods
Loading assignment data...
| ID | User | Contract | From Date | To Date | Status | Duration | Notes | Actions |
|---|
Total Assignments
Active
Ended
Unique Users
| Visit ID | Patient Name | Date | Service | Hours | Billed | Paid | Remaining |
|---|
Ask questions about this invoice using natural language. Click a template or enter your own query.
| Invoice # | Contract | Data Source | Payment Status | Match Status | Total Billed | Total Paid | Payment % | Latest Date | Line Items | Actions |
|---|
| Received Date | Contract | Patient Name | Invoice # | Claim # | Check # | Check Date | Billed Amount | Paid Amount | Rejected Amount | Claim Status | Service Date | Actions |
|---|
Search and analyze individual ERemittance records with advanced filtering options.
0 primary, 0 fallback
| Source | Invoice # | Patient | Check Number | Service Date | Received Date | Claim Number | Billed | Paid | Rejected | Status | Reason | Contract |
|---|
| Check Number | Review Status | Contract | AR Rep | Data Source | Received Date | Service Date | Patient Name | Patient ID | Invoice Number | Claim Number | Rejected Amount | Reason | Actions |
|---|
Loading priority checks...
All checks have been reviewed or no data matches your filters.
Loading contract details...
Try adjusting your filters or search criteria
| Visit ID | Visit Date | Invoice # | Patient Name | Service Code | Billed Hrs | Billed Rate | Billed Amt | Paid Amt | Remaining | Admission ID | Aging | Office | Actions |
|---|
Loading visit details...
Visit ID:
Visit Date:
Scheduled Time:
Actual Time:
Primary Bill To:
Primary Service Code:
Contract Hours:
Discipline:
Timesheet Required:
Timesheet Received:
Billed Hours:
Billed Rate:
Billed Amount:
Invoice Number:
Aide ID:
Pay Rate:
Pay Amount:
Admission ID:
Office ID:
No notes found for this visit. Add the first note above!
Are you sure you want to reset the API key for ?
This will invalidate their current API key and they will need to log in again.
Are you sure you want to delete the user ?
This action cannot be undone and will permanently remove the user and all their data.
Assign contract to:
Loading recent activity...
No notes or check updates found in the selected time range.
Patient+Contract Combinations
Total Billed Amount
Total Remaining Amount
Date Range
Loading unexported patients data...
| Patient Name | Contract | Visit Count | Invoice Count | Billed Amount | Remaining Amount | Date Range | Admission ID | Alt Patient ID | Medicaid Number | Invoice Numbers |
|---|
No unexported patients found in the selected date range. All patient billing has been exported successfully.
Click "Load Unexported Patients Report" to view all historical patients with no exported billing activity.
Patient+Contract Combinations
Total Unpaid Amount
Average Unpaid per Patient
Date Range
Loading never paid invoices data...
| Patient Name | Contract | Unpaid Invoice Count | Total Unpaid Amount | Date Range | Admission ID | Alt Patient ID | Medicaid Number | Invoice Numbers |
|---|
No never paid invoices found. All invoices have received some payment.
Click "Load Never Paid Invoices Report" to view invoices that have never received any payments.
Comprehensive standard reports for accounts receivable management and analysis.
Identifies patients with no exported billing activity, grouped by patient+contract combinations.
Uses invoice-level logic: If ANY visit in an invoice is exported, that patient+contract is excluded from this report.
Includes identifiers: Visit ID, Admission ID, Alt Patient ID, and Medicaid Number to help locate records.
Identifies invoices that have never received any payments, grouped by patient+contract combinations.
Uses payment status logic: Shows invoices where payment amount = 0 or payment status = 0.
Focus: Collection opportunities and potential revenue recovery targets.
Enhanced weekly pattern analysis to detect authorization limit changes like admission 928639 (OBADI SAEED).
Detects: Cases where authorization was changed (e.g., 42hrs/week → 30hrs/week) causing systematic denials for excess hours.
Shows detailed visit records for patients who historically had paid visits but now have patterns of unpaid visits.
Detail view: Individual visit records instead of aggregated summary data.
Includes: Visit dates, amounts, authorization numbers, and payment status changes over time.
Shows detailed visit records for patients who have 10+ visits on the same day (extremely suspicious cases).
Focus: Filters out legitimate 24-hour care (8 visits) to show only impossible billing patterns.
Includes: Visit start/end times, authorization numbers, and all billing details for investigation.
Additional standard reports will be added based on user feedback and requirements.
These contracts are automatically excluded from "Unexported Patients" reports because they structurally never use electronic billing.
Criteria: >95% of invoice details have NULL last_exported_date (minimum 100 invoices since 2024-01-01).
-
-
-
-
| Contract Name | Total Invoice Details | NULL Export Count | Has Export Count | % NULL | Earliest Visit | Latest Visit |
|---|---|---|---|---|---|---|
|
Loading...
Loading non-exporting contracts... |
||||||