Finding the Right Report

Finding the Right Report

Finding the Right Report

Aloha offers a variety of reports to help you monitor clinical, operational, and financial data. This guide explains which reports are best suited for common reporting needs and where to find specific information.

Quick Report Finder

I Need To...

Run This Report

Tips

Calculate supervision percentage by client

Client Service Summary Report

Divide total 97155 hours by total 97153 hours to calculate the supervision percentage.

View billable client hours by staff member

Staff Productivity Report

Review billable hours by staff member for a selected date range.

Track mileage

Appointment List Report

Export to Excel and total the Distance column. Appointment locations must be entered when appointments are scheduled.

Verify whether session notes are attached

Service Appointment List Report

Review appointment details and documentation status.

Review direct and indirect service hours

Service Appointment List Report

Export to Excel and filter by service name to isolate direct or indirect services.

Track billable vs. non-billable appointments

Appointment List Report

Filter by appointment type as needed.

View all billable and non-billable hours

Staff Appointment List Report or Staff Productivity Report

Export to Excel and filter by earning code or appointment type.

See total payments collected

Payment Ledger Report

Use a date range and export to Excel if additional calculations are needed.

View revenue by client

Appointment Billing Summary Report (Charge Rate) or Payment Ledger Details Report

Export and sort by client for easier review.

Review patient responsibility payments

Payment Ledger Details Report

Filter for Family Payer transactions and export for annual totals.

Review authorization utilization

Authorization Summary Report

Compare against the Client Profile or Authorization by Month when needed.

View supervision hours provided by a BCBA

Supervised Appointment List Report

Export to Excel and sort by Supervisor and Client.

Generate BHPN reporting data

BHPN Report

Use for BHPN-specific reporting requirements.

Run payroll for a staff member outside the normal payroll cycle

Payroll Ad Hoc Report

Useful when payroll has not yet been processed.

View appointment cancellations by staff member

Appointment Cancellation Report

Export to Excel and create a Pivot Table to summarize cancellations by staff member.

Find the number of claims billed by month or payer
AR Manager or Billing Ledger Report

AR Manager: Export to Excel to calculate the total number of claims by payer.

Billing Ledger Report: Export to Excel and create a PivotTable using Primary Billed Date as the rows and Claim ID as the values to view the number of claims billed by month.

Additional Reporting Tips

  • Use date range filters to narrow report results.
  • Export reports to Excel for advanced filtering and calculations.
  • Use Pivot Tables to summarize large data sets.
  • Compare report filters when totals do not match between reports.

Pivot Table Tips

  1. Select all of your data by clicking the triangle in the upper-left corner of the spreadsheet (between Column A and Row 1). 
  2. Navigate to Insert > PivotTable and click OK to create the pivot table.
  3. In the PivotTable Fields panel, drag and drop fields into the Rows, Values, Columns, and Filters sections to organize your data as needed.
  4. To change how a field is calculated, right-click the value within the pivot table and select Value Field Settings. From there, you can choose options such as Sum, Count, Average, Min, or Max.

    • Related Articles

    • Quick Books Invoice Report

      Aloha has released a Quickbooks Invoice Report as part of Release 2.6.6. Below you can find the definitions for the Report Parameters and Columns found in this report. Purpose Billing Summary report designed to be uploaded into Quick Books online and ...
    • How to Get Help or Share Ideas in Aloha

      We want to make it easy for you to get answers, report issues, and share ideas for improving Aloha Practice Management. Here’s a quick guide on where to go depending on what you need. Have a question? If you’re unsure how something works, need ...
    • All Reports

      There are many different reports that you can run to view your organization's data. Below is a breakdown for what information you can find in each of our reports. How to use reports: Select Report Name Select parameters Click “GENERATE” to generate ...
    • Payment Center: Adding and Managing Payments

      AlohaABA's Payment Center gives you the flexibility to add/edit new and existing payments and manage payer account balances under Billing > Payment Center. Auto-posting payments If you have completed your ERA enrollments, payments should start coming ...
    • Billing Overview

      Getting Ready to Bill It is vital to have the correct information in the system to submit for billing. Make sure you have the correct Payer ID (double check the clearinghouse) and have completed eligibility checks for your clients to ensure that you ...