Skip to main content

Billing Reports Explained

S
Written by Support Team

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

  1. Log in to Ambula Office EMR.

  2. Go to Reporting.

  3. Click Billing Reports.

  4. Click Create Report.

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

  1. 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:

  1. Generate or open a billing report.

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

Did this answer your question?