All Reports

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:  

  1. Select Report Name 
  2. Select parameters 
  3. Click “GENERATE” to generate report, click “SAVE” to save parameters for future use 

Icons on generated reports: 

Download the report to a CSV file. Most reports are downloaded into excel to analyze and manipulate data.

Manage/Customize Columns  


NotesNOTE: Any Reports that begin with “My” indicates the report is generated for login user 


How to change the date format in Excel:   
  1. Select the date cells that you would like to change
  2. Select “Control + 1” or “Command + 1” 
  3. In the Format Cells box, select “Number” tab
  4. In the Category list, select the Date
  5. Under “Type” select your preferred date format
  6. Your format will preview in the “Sample Box”
  7. If you want to use a date format according to how another language displays dates, choose the language in “Location” 


Report Name 

Description 

Category

Best Practices  

Appointment Billing Info 

Generates billing data for scrubbing and review prior to billing out. 

Billing

Used to do a final check of all appointments with a certain payer in a certain period.  It will show you which appointments are still incomplete or missing info before billing. User can also use the data from this report to bill manually in the payer portal.

 Appointment       Billing Summary

Shows the number of units and total charges for each client/service in a date range.
  Billing
User can see the total number of units and charges that  were billed out specific to a client and service.  For example, for Johnny H, there were 64 units of 97153 billed from 6/1-6/7 for a total of $1280.

Appointment Cancellation 

Lists cancellations by type.  

Scheduling

User can see a trend on staff and client cancellations over a period of time. This can be used to see repeat or common staff or client cancellations.  

Appointment Copay 

Lists expected copay for appointments.

 

***This information is populated under the insurance info for the client under Client Authorizations

Billing

User can estimate how much copay is expected.  Some customers also use this report to track “co-pays” if they are not using the AR Manager. 

Appointment Forms Info Report 

Lists all session note information for customers using Aloha Forms.

Clinical

User can check to see if all information on session note forms that a staff has entered is correct.  


**This is only applicable to Aloha Forms, not clinical integration platforms.

Appointment List  

Generates a list with all information about appointments for a given period.  

 


Scheduling

Includes appointment information (e.g., ,staff member, modifiers, payer, authorization number, etc.). Most users export to excel and create pivot tables to gain specific insights.


**This report will take a long time to run or even time out if there are too many rows.  Try to reduce the data range or use Staff Appointment List, or Service Appointment List report instead. 

Authorization Summary 

Captures all authorization fulfillment for a given period.

Billing

Useful to maximizing authorization utilization. Includes total authorized hours as well as scheduled, completed and cancelled hours. 

 Authorization Summary by Month
Displays authorization usage within each month.  
Billing
Users can search by payers to see all authorizations for that payer and a breakdown of auth totals, how much are used a month, and how many remain. User can run this report to stay on top of progress for all authorizations with monthly caps.  

BCAT Supervision Log 

Assists in tracking staff BCAT supervision requirements by month.  

 

Note: This generates a PDF document.  

Staff Info

Run this on a monthly basis to ensure staff are meeting their supervision requirement for Board Certified Autism Technicians. This report includes appointment info. 

BCAT Supervision Summary Report

Assists in summarizing staff BCAT supervision requirements by month. 

 

Note: This generates a PDF document. 

Staff Info

 Run this on a monthly basis to ensure staff are meeting their supervision requirement for Board Certified Autism Technicians. This is a summary and will not include detailed appointment info. 

BHPN Report 

Used for Northern California Kaiser (Catalight) to assist in billing.   

Billing

This report generates a document in the correct format to send to this payer to eliminate manual submissions.

Billing Ledger Report 

Used to track payments, client balance, and payer balance per charge line.

Billing

Users can also use this report to track balances and information on payments. Generates billing information based on the individual chargeline.

Client Aging Report 

Indicates outstanding client balances.

Billing

 Shows Client balance based on billed date for 30, 60, 90, or 120 days. 

Client Authorizations 

Shows all active authorizations by client. 

Billing

User can view all services authorized for every client within their organization.

Client Cabinet 

Lists all files under client cabinets.  

Client Info

At a quick glance, user can determine which information is uploaded into all client cabinets and determine if any files are missing.

Client Contacts 

Lists all client contacts.  

Client Info

 User can generate to see all responsible parties, or who has access to AlohaABA (Client Portal) without having to go to each client's profile.  

Client Eligibility Check 

Lists all clients and their corresponding insurance companies. 

Billing

User can generate this report as a quick guide when checking client insurances are still active. 


**We recommend user check client eligibility monthly. 

Client List 

Lists all clients with custom fields information. 

Client Info

At a quick glance, user can see all information for all clients without having to click into individual profiles. Includes custom field information.

Client Overlap Appointments
Displays any sessions for clients that are overlapping in time. 
Scheduling
Users can specify their search for same service overlaps or for overlapping times. 
Client Service Summary
Compare direct versus supervision services as well as cancellations. 
Scheduling
User can generate to show percentages of supervision or cancellations for each specific client.  

**This information is especially useful in creating LA Care reports.

Client Staff Assignment 

Displays which staff is assigned to which client. 

Staff Info

 User can review client or staff caseload.  Can be used for auditing to see which staff has access to which clients. 

Concurrent Billing Appointments
Displays all appointments that have concurrent billing rules applied to them. 
Billing
Generate to show which appointments have had concurrent billing rules applied (e.g., which 97153 sessions have been zeroed out due to occurring at the same time as 97155) to ensure accurate billing for payers with concurrent billing rules (e.g, Tricare).  Will only apply when Concurrent Billing Rules are in place.  
Contact Login History
Displays the login history for users with access to the client portal. 
Client info
Ensure that client contacts (e.g., parent) are logging in to make payments or view the schedule.  Typically only admins will need access to this report.
  Contracted Rate Payment
Displays comparison between contracted rate entered into Aloha and payment received from the payer.
  Billing
User can determine if the contracted rates entered into payer services are accurately reflected in the current fee schedule based on payments received.

Expiring Authorizations 

Displays authorizations expiring in 30, 60, 90, 120, or 150 days.    

Billing

 User can run this report monthly to see which authorizations are expiring to prevent a lapse in services.

Medical Release Signature 

Displays client’s medical release signature information. 

Client Info

User can generate this report to quickly check if a client’s medical release signature information is missing. This information is generated from the client’s authorization.  Some Payer requires a new form annually while other only require one at the start of services.

Mismatched Appointment List
Displays all appointments where the scheduled appointment time differs from the staff's verified time.
Billing/Payroll
User can search for specific staff within a date range to identify mismatched appointments and what should be updated before billing or running payroll.
Mismatched Forms Data
Displays any appointments where the appointment info detail differs from the values in the Form. 
Clinical
Can only be used for Aloha Forms, not clinical integrations.  Information can be use to correct data that did not sync properly with Aloha Forms (e.g., Appointment Duration was scheduled for 2 hours, but in the attached Form, staff indicated session was 1 hour)

Monthly Attendance Sheet 

Shows proof of service on client. 

Billing

User may receive requests from school districts for this information.  

My Appointment List 

Shows logged in user’s appointments.  

Scheduling

User can generate a list of only their appointments; typically given to RBTs or direct service staff. 

My BCAT Supervision Log 

Shows logged in user’s BCAT Supervision log.  

 

Staff info

Used to ensure staff meet the maintenance requirements of their Board Certified Autism Technician (BCAT) certification issued by National Commission for Certified Agencies (NCCA). 

My Caseload Appointment List 

Shows a list of appointments for any client that the logged in user is assigned to.

 


Staff info

Used to see how many appointments or how many hours was provided for user’s clients. 


**To see client’s appointments, client must be listed as assigned to this staff on their profile. 

My RBT Supervision Log 

Shows logged in user’s RBT Supervision log. 

Staff info

Used to ensure staff meet the maintenance requirements of their Registered Behavior Technician (RBT) certification issued by Behavior Analyst Certification Board (BACB). 

Payer Aging Details
Breaks down remaining payer balance by chargeline.
Billing
Used to see which payer may need follow up on older claims if the user needs to see the specific chargelines.

Payer Aging Report

Used to indicate aging by payer by time period. This data can also be found in the AR Manager of Aloha. Billing

Used to see which payer may need follow up on older claims. We recommend to try to keep everything within the current or 31-60 day bucket.  Anything over 60 days should be followed up as soon as possible. 

Payer Services 

Lists all payers, service, and its rates.

Billing

Used to audit rates and show what services you are contracted for with each payer at a quick glance.

Payment Ledger Details
Breaks down payments and what charge lines they were applied to.
Billing
Used to see all transactions associated with your payments in Payment Center.

Payment Ledger Report 

Shows all payments received in during a given period.

Billing

Used to compare with bank statements to ensure all payments are posted and/or received. 

Payroll Adhoc Report 

A report used to run payroll for staff that are or upcoming to be terminated.  

Payroll

Run payroll report for staff immediately without going thru payroll wizard.  This is used for staff who have left the company in the middle of a payroll period.  Some states require employers to pay staff who are leaving out immediately. 

Payroll:

  1. ADP Workforce Now
  2. ADP Workforce Next Gen
  3. ADP Workforce
  4. Gusto
  5. Heartland
  6. iSolved
  7. Network
  8. Paychex Flex
  9. Paylocity
  10. Simplicity HR

Payroll report that is put in this payroll processor’s format.  

Payroll

 Export data into excel, then upload this file for these specific payroll processors.  This is a huge time saver if you have more than 30 staff. 


Note: these reports can only be used if all earning codes and staff payroll IDs have been mapped properly. See our help center article on Payroll ID Mapping.
Payroll Processed Appointments
Displays all appointments that were included in a processed pay period. 
Payroll
Used to see the breakdown of each appointment that was included in the payroll summary. Payroll summary displays staff/hours/earning codes, while this report includes appointment details for each session considered in payroll calculations.

Payroll Report 

Displays earning codes, hours, miles, rate, and  amount for staff. 

Payroll

Used to generate payroll data for your payroll processor. 

Profit and Loss
Displays payroll hours/rates vs. billable hours/rates
Billing/Payroll
Utilize to identify if a client, staff, payer or service is profitable for your organization (This is only a rough estimate because it is difficult to break down salaried employees). 

**Payroll must be processed for payroll column to populate.
Provider Identifier
Shows all NPI, BPHN, Medicaid IDs, etc entered into the  system.
Staff Info
Display all provider identification numbers in one place.
Quickbooks Invoice
Designed to be uploaded into Quick Books online and mapped to its invoice template to generate invoices for clients. 
Billing
When testing this import process to QuickBooks, we recommend you test one client for a few appointments to ensure it is correct. Then expand this test to a few clients. Then, complete a larger batch until you are comfortable. Do not upload all in the first test run because you may need to manually delete one invoice at a time.

RBT Supervision Log 

A PDF report displaying RBT supervision that each staff has received per the BACB requirements. 

Staff Info

The BACB requires to keep a copy for seven years in case of an audit.  We recommend to save a copy annually for staff record. 

Service Appointment List 

List of all the service (billable) appointments within the system.  

Scheduling

This can be used for sum of hours per service per clients or analyze the services delivered to specific clients in a specific date range.  

Settled Claims Report
Lists all chargelines settled in a given period.
Billing
Can better help determine write-offs for tax purposes or which payers are not paying out claims.

Staff Adjusted Time 

Displays scheduled time versus staff verification time. 

Scheduling

 Used to verify for staff payroll time vs scheduled time.  There is also a Sync in Setting > System Settings  to ensure these are always synced. 

Staff Appointment List 

Displaying appointment information by staff member.  

Scheduling

Used to audit staff appointment information. Filter to find missing earning codes or cancellations.  Can also be used to determine of hours or number of appointments per client via pivot table. 

Staff Cabinet 

Pulls all staff cabinet data. 

Staff Info

At a glance, user can see all files or posts attached all staff.

Staff Earning Codes 

Displays staff pay rates. This is generated from the “pay rate” tab in staff profiles.  

Payroll

Used to audit staff rates or to see what earning code is missing or assigned to each staff. 

Staff Incomplete Appointment List 

Displaying appointments that are not completed.  

Billing/Payroll

Used to audit incomplete staff appointments before running billing or payroll. 

Staff List 

Lists staff information by job title and/or office.  

Staff Info

Used to audit or view all staff information at once. 

Staff Overlap Check
Displays all appointments with overlapping time per staff.
Scheduling
Used to make sure staff are not double-booked between sessions after scheduling

Staff Productivity 

Displays percentage of billing, percentage of service, billing, payroll, scheduled hours, and cancelled hours. 

Scheduling

Can be used to determine which staff members are meeting billable goals or completing the most hours. 

Staff PTO Hours 

Displays how many PTO hours are scheduled.  

Staff Info

Can be used to enter into payroll processor or see how many PTO hours used for any given period.  Aloha cannot track accrual, just what has been used.

Staff Qualifications 

Displays all staff qualifications and can be generated by upcoming expiration.

Staff Info

User can sort by expiration date to see all expiring or expired qualifications.  Helps determine if qualifications are up for renewal for all staff members.


**Qualifications must be entered into Staff Profile > Qualifications to display.

Staff Timesheet Submission 

Displays if and when staff submitted their timesheet.  

Billing/Payroll

Used to see who submitted their timesheet to ensure all past appointments were completed or cancelled.  

Supervised Appointments 
Displays all appointments in which supervision was logged. Appointments will appear in this list for staff who are being supervised.
Scheduling
Generate to determine which appointments were supervised and audit input of supervision.

Supervision Tracking Summary 

Displays RBT Supervision tracking summary information per the BACB. This displays this information for multiple staff, if rules are met when scheduling a supervision appointment.  


Staff Info

User can see if the staff have “MET” the BACB Supervision tracking requirements per month for multiple staff in an excel friendly document.


User Login History 

Displays staff log in/log out times and login duration within Aloha. 

Staff info

Used to see if staff has logged into Aloha ever (great for new staff) or during a specific period. 




    • Related Articles

    • Frequently Used Reports

      Here is a quick guide to the most frequently used reports within our system. Start by using the icon to see a list of the available reports in Aloha. We recommend using the star icon to favorite the reports you use the most often. All reports can be ...
    • 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 in Office Ally Payer List) and have completed eligibility checks for your clients to ensure ...
    • Preparing for Aloha's Insurance Billing Services

      Welcome to the Aloha family! We're super excited for you to move forward with using Aloha's billing services. Before you meet your assigned RCM manager from the Aloha Billing team, please complete the following steps: Required Steps to ensure ...
    • FAQ: Billing

      These frequently asked questions will help provide guidance as you troubleshoot through the billing section of Aloha. I settled a claim, but then ended up getting paid for it. How can I unsettle? Start by going to AR manager and double clicking on ...
    • Secondary Billing in AlohaABA

      Secondary Billing in Aloha ABA Step by step guide to setting up and billing secondary claims in Aloha FYI: As of 7/3/24, our Secondary Billing feature will exclusively support Office Ally as the selected clearinghouse at this time. Our team is ...