Category: Reporting & Analytics
Tags: reports, analytics, admin, billing
Overview
The Billing Report allows clinics to analyze billing activity including CPT charges, ICD-10 codes, payments, adjustments, and balances. Users can generate reports based on date of service, branches, providers, attorneys, CPT codes, and ICD-10 codes.
Billing reports help clinics review charges, payments, adjustments, and billing performance and can be exported to CSV.
Permissions Required
Access to Billing Reports is restricted.
Users must have one of the following roles or permissions:
Admin
Owner
Billing (role or permission)
Billing Admin (role or permission)
A user with Admin permission
Some fields such as Contracted Rate are visible only to:
Owner
Billing Admin
How to Create a Billing Report
Log in to Ambula Office EMR.
Go to Reporting.
Click Billing Reports.
Click Create Report.
Fill in the required fields:
Required:
Report Name
Branch
Date of Service
Optional filters:
Duration since Date of Service
Attorneys
Providers
ICD-10 Codes
CPT Codes
Insurance payer
Chart type
Click Create.
The system will generate the billing report using the selected filters.
Billing Report Table
The billing report table displays billing data related to CPT charges and payments. The table is customizable, allowing users to choose which columns appear.
Available Columns
Users can toggle the following columns:
Patient Medical ID
SSN
Date of Birth
Gender
Marital Status
Patient Address (city, state, zip)
Patient Phone
Date of Injury
Branch
CPT
Modifiers
ICD-10
Fee Description
Quantity
Billed Charges
Contracted Rate
Payment Posted
Adjustment
Payment Type
Attorney
When a user toggles a column, it will either show or hide in the report table.
Column Updates
Recent improvements to billing reports include:
Attorney column added
Cost column renamed to “Billed Charges”
Date of Service moved to the first column
Contracted Rate moved next to Billed Charges
Payment and Adjustment Display
Payments and adjustments are grouped by Date of Service.
Columns such as:
Payment Posted
Adjustment
Payment Type
are displayed together at the end of the table to provide a cleaner layout.
If multiple CPT codes exist under the same Date of Service, payment information may span across those rows.
Payment Filters
Billing reports include a Post Payment filter.
Users can filter the report by:
Only Payments – shows rows where payment amount is greater than $0.
No Payments – shows rows where payment amount is $0.
Contracted Rate
The Contracted Rate represents the portion of the fee paid to a contracted provider.
Example:
Fee = $100
Contracted Rate = $60
This means:
$60 goes to the provider
$40 remains with the business
The report also calculates a total Contracted Rate, similar to totals for billed charges and payments.
Exporting Billing Reports
Billing reports can be exported for external analysis.
To export:
Generate or open a billing report.
Click Export to CSV.
The exported file will:
Include all visible columns
Apply the same filters and grouping used in the report
Repeat the Date of Service for each row to avoid empty cells in the CSV.
Notes
The Attorney filter replaces the previous payer filter in the report creation modal.
Payment, adjustment, and payment type columns are grouped at the end of the report table.
Exported CSV files reflect the same structure, filters, and grouping as the report displayed in the system.
