Home/Spreadsheets/ABA & BCBA/ABA Authorization Tracker

ABA Authorization Tracker

An ABA authorization tracker: log sessions once and see units used, units left, burn rate and the re-auth submit-by date for every client and payer. 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 you get

Units used, remaining, burn ratio and projected units per authorization
Submit-re-auth-by dates and expiring-auth alerts
Every session checked against its authorization
Dollars at risk from unused units
Monthly RBT supervision check against the 5% rule
Opens in Excel and in Google Sheets

$19.99one-time, no subscription

Buy on Etsy

Instant digital download · one-time purchase · no subscription

ABA Authorization Tracker — the workbook open in Excel

What it does

Units used, remaining, burn ratio and projected units per authorization
Submit-re-auth-by dates and expiring-auth alerts
Every session checked against its authorization
Dollars at risk from unused units
Monthly RBT supervision check against the 5% rule
CPT 97151-97158 and 0362T / 0373T preloaded, 8-minute or whole-unit rules

What it looks like

Every tab in the workbook

These are the actual sheet names in the file, not a feature list.

Auth Dashboard
Authorizations
Session Log
RBT Supervision
Staff

Works in

Microsoft Excel 2016 or later, Windows and Mac
Google Sheets — upload to Drive and open
No macros, no add-ins, no subscription

Others in ABA & BCBA

ABA Authorization Tracker$19.99Buy on Etsy