Async Operations Playbook
This runbook documents the investigation process for common billing issues. It provides a structured workflow that enables support engineers working across time zones to diagnose payment failures, resolve subscription issues, and document findings for asynchronous collaboration.
This playbook was created using the dashboard and database tools available in the Supabase platform. The investigation workflows simulate real billing support scenarios using Supabase tables, authentication logs, and SQL queries.
| Component | Purpose |
|---|---|
| Authentication | User identity verification |
| subscriptions table | Stores plan and billing status |
| billing_events | Payment and invoice logs |
| SQL Editor | Query billing events for investigation |
| Level | Owner | Scenario |
|---|---|---|
| L1 | Support | Standard billing questions or failed payments |
| L2 | Engineering | Payment success but subscription not updated |
| L3 | Finance | Duplicate charges or refund disputes |
Customer reports that payment was attempted but the account still shows a Free plan
| Step | Action | System Location |
|---|---|---|
| 1 | Verify the user account exists | Authentication → Users |
| 2 | Check subscription status | Database → subscriptions table |
| 3 | Review billing event logs | SQL Editor |
| 4 | Record findings | Patterns & investigation notes |
