SDSimpleDesigns

Home/Spreadsheets/ABA & BCBA/BCBA Caseload and Authorization Tracker

BCBA Caseload and Authorization Tracker

Authorisation burn rate. For each client the file shows units authorised, units used, units remaining, days remaining in the auth period, the current burn rate per week, and the projected end date at that rate — then flags 'will expire unused' or 'will run out early'. That projection is the single highest-value number in the product and no free template computes it. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.

What it does

  • Authorisation burn rate.
  • Built around the dates that actually bite: Insurance authorisation periods, reauthorisation report due dates, monthly supervision minimums per client.
  • Clients tab
  • Authorizations tab
  • Service Log tab
  • Supervision tab
  • Reauth Pipeline tab
  • Client Snapshot tab
  • Every threshold and dropdown editable on the Lists tab, nothing hardcoded
  • Two files included: a blank workbook and a filled example to learn from
  • Works in Excel and Google Sheets, no add-ons or macros
  • Opens in Excel and in Google Sheets
$15.99one-time, no subscription
Buy on Etsy

Instant digital download · one-time purchase · no subscription

BCBA Caseload and Authorization Tracker — the workbook open in Excel

What it looks like

BCBA Caseload and Authorization Tracker screenshot
BCBA Caseload and Authorization Tracker screenshot

Every tab in the workbook

These are the actual sheet names in the file, in order, read out of the workbook itself.

Works in

Honest scope

This is an organizational template. It reports the data you enter. It does not determine mastery, eligibility or compliance, and it does not replace your district or clinic documentation system — those stay your professional judgement.

Others in ABA & BCBA

BCBA Caseload and Authorization Tracker$15.99Buy on Etsy