Advanced

SaaS revenue waterfall: bookings → billings → revenue → cash

Builds a SaaS revenue waterfall reconciling bookings, billings, deferred revenue, and revenue recognition. Useful for FP&A and accounting alignment and board reporting.

Create a SaaS revenue waterfall for {company_name} for {period}.

Inputs:
- Bookings by month and term: {bookings}
- Billings/invoices data: {billings}
- Deferred revenue rollforward: {deferred_rev}
- Revenue recognized (GL): {revenue_gl}
- Cash receipts: {cash_receipts}

Output:
1) Waterfall table and bridge explanations.
2) Deferred revenue rollforward (beg, billings, revenue, end).
3) Exceptions list (cancellations, credits, timing gaps).
4) KPIs: ARR/MRR movements if inputs allow.

Keep it board-ready and reconciled.

Related Prompts

Industry-Specific

Advanced

Channel rebates and returns accrual model (consumer goods)

Designs an accrual model for rebates, returns, and allowances common in consumer goods, with rollforward schedules. Useful for close and audit support.

GPT-5.2 Thinking; GPT-4.1; o3-mini

Industry-Specific

Advanced

HIPAA Security Rule Risk Analysis

Evaluates the technical safeguards for Protected Health Information (PHI).

Claude 3.5 SonnetGPT-4o

Industry-Specific

Advanced

Healthcare patient AR reserve: contractual allowances methodology

Develops a methodology for contractual allowances and bad debt reserves using payer mix and historical collections. Useful for healthcare finance teams and auditors.

GPT-5.2 Thinking; GPT-4.1; o3-mini