Stop guessing and start managing with these five essential weekly practice reports
Why Weekly Reporting Matters More Than You Think
Running an ABA practice means juggling clinical outcomes, staff management, billing, compliance, and growth — often simultaneously. Most practice owners know they should be reviewing their numbers regularly, but the reality is that many only look at financials once a month, or worse, once a quarter. By then, small problems have become expensive ones.
Weekly reporting is not about drowning in data. It is about spending 30 focused minutes each week looking at the right numbers so you can take action before issues compound. A missed authorization renewal discovered in a monthly review means four weeks of unbillable sessions. A credentialing gap found quarterly could mean months of compliance exposure.
The good news is that the most important information for an ABA practice owner fits into five reports. Here is what they are, why they matter, and exactly what to do when you see something that needs attention.
1. Revenue and Collections Report
This is the financial pulse of your practice. Every week, you should know three things: what was billed, what was collected, and what remains outstanding.
Why it matters: Revenue is not revenue until it is collected. Practices often confuse billed amounts with actual income, which leads to cash flow surprises. A practice billing $200,000 per month but only collecting $140,000 has a serious problem that will not fix itself.
What to look for:
- Accounts receivable aging by bucket: Break your outstanding receivables into 0–30 days, 31–60 days, 61–90 days, and 90+ days. Healthy practices keep the vast majority of AR in the 0–30 bucket. If your 90+ bucket is growing, claims are aging out and becoming increasingly difficult to collect.
- Collection rate trends: Calculate what percentage of billed charges you actually collect each week. Industry benchmarks suggest ABA practices should target a net collection rate above 95 percent. If yours is dropping, investigate whether the issue is claim denials, slow payer response, or internal billing delays.
- Denial patterns: Look at which payers are denying claims most frequently and for what reasons. Common culprits include authorization mismatches, coding errors, and timely filing issues.
What action to take: If AR over 60 days exceeds 15 percent of total receivables, escalate follow-up efforts immediately. Assign someone to work aged claims daily, prioritizing the largest balances first. If you see a spike in denials from a specific payer, investigate the root cause before submitting more claims that will also be denied.
2. Utilization Rate Report
This report compares authorized hours to delivered hours for each client. It is one of the most directly actionable reports in your practice because it ties clinical delivery to revenue.
Why it matters: Every authorized hour that goes undelivered is revenue left on the table. If a client is authorized for 20 hours per week and consistently receives only 12, that is 8 hours of billable time — potentially $400 to $800 per week — that your practice is not capturing. Across dozens of clients, this adds up to tens of thousands of dollars per month.
What to look for:
- Clients below 80 percent utilization: These are your biggest revenue recovery opportunities. Identify whether the issue is scheduling gaps, cancellations, staffing shortages, or parent availability.
- Clients above 95 percent utilization: These clients are on track, but watch for authorizations that are being consumed faster than expected. You may need to plan reauthorization earlier.
- Cancellation patterns: High cancellation rates for specific clients, providers, or time slots reveal systemic issues that scheduling adjustments can fix.
What action to take: For clients under 80 percent utilization, have your scheduling team review each case. Can sessions be added? Is there a staffing gap that needs filling? For clients burning through hours quickly, flag them for early reauthorization to avoid service interruptions. Practices report that actively managing utilization can increase monthly revenue by 10 to 20 percent without adding a single new client.
3. Authorization Status Report
Authorizations are the lifeblood of ABA billing. Without a valid authorization, you cannot bill — period. This report tracks every active authorization and flags those approaching expiration or exhaustion.
Why it matters: Lapsed authorizations mean unbillable sessions. Even a one-week gap between an expired authorization and a renewed one can cost thousands of dollars per client. Multiply that across your caseload and the impact is substantial. Worse, some payers will not backdate authorizations, meaning those sessions are permanently lost revenue.
What to look for:
- Authorizations expiring in 30 days: These should already be in process for renewal. If the reauthorization request has not been submitted, escalate immediately.
- Authorizations expiring in 60 to 90 days: Begin gathering documentation and clinical data needed for reauthorization. Starting early gives you buffer time for payer delays.
- Nearly exhausted authorizations: Some clients use hours faster than the authorization period. If a client is on track to exhaust their hours two months before expiration, you need a concurrent or supplemental authorization request.
What action to take: Create a standing process where authorizations expiring within 30 days trigger automatic reauthorization workflows. Assign clear ownership — whether it is a clinical director preparing treatment summaries or a billing coordinator submitting the request. The goal is zero gaps between authorizations, ever.
4. Compliance and Credentialing Gaps Report
This report tracks staff certifications, licenses, supervision hours, background checks, and any other compliance requirements — and tells you what is expiring, expired, or missing.
Why it matters: An RBT with an expired certification cannot legally provide ABA services. If they do and you bill for it, that is a compliance violation and a potential audit liability. Beyond the legal risk, insurance payers routinely audit provider credentials, and gaps can result in recoupments — where the payer demands money back for services rendered by an improperly credentialed provider.
What to look for:
- Certifications expiring within 30 days: RBT renewals, BCBA certifications, CPR and first aid, state-specific licenses. Every credential should have an expiration date tracked in your system.
- Overdue supervision hours: The BACB requires ongoing supervision for RBTs. If supervision logs are behind, you have a compliance problem that needs immediate attention.
- Missing documents: Background checks, liability insurance, signed policies, HIPAA training completion. Every employee should have a complete compliance file.
What action to take: For credentials expiring within 30 days, send reminders to the staff member and their supervisor. For anything already expired, remove the staff member from the schedule until the credential is renewed — this protects both the practice and the clients. Build a culture where credentialing is not an afterthought but a standing weekly review item. Practices that automate expiration alerts and document tracking report spending 60 to 70 percent less administrative time on compliance management.
5. Staff Productivity and Capacity Report
This report shows how each provider is performing: sessions delivered, cancellation rates, billable hours versus available hours, and open capacity for new clients.
Why it matters: Staff costs are the largest expense in any ABA practice, often exceeding 60 percent of revenue. If providers have open slots on their schedules, you are paying for capacity you are not using. Conversely, if every provider is at 100 percent capacity, you cannot grow without hiring, and you need to start recruiting before you hit a bottleneck.
What to look for:
- Billable hours per provider per week: Establish targets based on role. Full-time RBTs might target 30 to 35 billable hours per week. BCBAs might target 25 to 28 direct and supervisory hours. Compare actual to target weekly.
- Cancellation rates by provider: If one provider has a significantly higher cancellation rate, investigate whether it is a client issue, a scheduling issue, or a performance issue. Industry data suggests that cancellation rates above 15 percent warrant intervention.
- Open capacity: How many hours per week does each provider have available? This tells you exactly how many new clients you can take on without hiring. It also helps you match new intakes to the right providers based on availability, geography, and specialty.
What action to take: For providers consistently below their billable hour target, work with scheduling to fill gaps. For providers at or near capacity, begin recruiting before you actually run out of room. Use cancellation data to implement targeted strategies — whether that means adjusting session times, addressing family concerns, or providing provider coaching. Practices that monitor staff productivity weekly report improved retention because workload distribution becomes more equitable and problems are addressed before burnout sets in.
Bringing It All Together
Each of these five reports is valuable on its own, but the real power comes from reviewing them together. Utilization problems connect to scheduling and staffing. Authorization gaps connect to revenue drops. Credentialing issues connect to compliance risk and billable capacity. When you see the full picture in one place, patterns emerge that you would miss looking at any single report in isolation.
The challenge, of course, is that pulling these reports from disparate systems — one for billing, another for scheduling, a spreadsheet for credentialing, an email chain for authorizations — takes hours and introduces errors. By the time you have assembled the data, the week is over.
Modern practice management platforms like Wilma consolidate all of this into a single dashboard with one-click reporting. Because everything lives in one database — billing, scheduling, authorizations, credentials, staff data — the reports are always current, always accurate, and always available. What used to take hours of spreadsheet assembly becomes a 15-minute weekly review that keeps your practice profitable, compliant, and ready to grow.
Whether or not you have a unified platform today, start with these five reports this week. Even pulling them manually will reveal insights you have been missing. The practice that measures, manages.