Async Operations Playbook

Purpose

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.

Environment

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.

System Components

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

Escalation Policy

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

Common Billing Investigations

1. Failed Payment (Card Declined)

Situation

Customer reports that payment was attempted but the account still shows a Free plan

Investigation Workflow

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

image.png