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
AdvancedConstruction WIP schedule: percent complete and billings
Builds a construction Work-in-Progress (WIP) schedule including percent complete, revenue recognized, billings, and under/over billings. Useful for contractors and auditors.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Industry-Specific
IntermediateConstruction retainage reconciliation and aging action plan
Reconciles retainage receivable/payable, flags aged items, and proposes collection/settlement actions. Useful for improving cash flow and close accuracy.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Industry-Specific
IntermediateReal estate development cost capitalization tracker
Creates a tracker for development costs, capitalization rules, and allocation to projects/units. Useful for developers and real estate accountants managing multi-project portfolios.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2