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

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

Intermediate

Loan accounting: nonaccrual, troubled debt, and interest income checks

Builds a checklist and analytics for loan nonaccrual status, modifications, and interest income recognition. Useful for bank controllers and auditors.

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