How to use reports:
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
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:
| 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. |