Intermediate

SaaS deferred revenue reconciliation: contract mods and credits

Reconciles deferred revenue with contract modifications, credits, and proration, producing an exception log. Useful for close and audit support in SaaS businesses.

Reconcile deferred revenue for {company_name} for period ending {period_end_date}.

Inputs:
- Deferred revenue GL and subledger: {deferred_rev_data}
- Contract modifications and upgrades: {contract_mods}
- Credits/refunds: {credits_refunds}
- Proration rules: {proration_rules}
- Revenue recognition schedule: {rev_schedule}

Output:
1) Rollforward reconciliation with tie-outs.
2) Exception log: item, root cause, proposed fix, owner.
3) Recommended entries/adjustments.
4) Control improvements (approval of credits, contract mod tracking).

Keep it audit-friendly.

Related Prompts

Industry-Specific

Intermediate

Standard costing variance dashboard (PPV, labor, overhead)

Creates a variance dashboard structure and investigation playbook for standard costing variances. Useful for plant controllers and operations reviews.

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

Industry-Specific

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.

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

Industry-Specific

Intermediate

ARR/MRR rollforward with churn, expansion, and cohort view

Creates an ARR/MRR rollforward and cohort-based retention view using subscription data. Useful for SaaS metrics reporting and investor updates.

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