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
AdvancedChannel 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
0
0
15
Industry-Specific
AdvancedHIPAA Security Rule Risk Analysis
Evaluates the technical safeguards for Protected Health Information (PHI).
Claude 3.5 SonnetGPT-4o
0
0
5
Industry-Specific
AdvancedSaaS 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
0
0
7