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.
Create an accrual model for rebates/returns/allowances for {company_name}.
Inputs:
- Channel programs and rates: {programs_rates}
- Sales by channel and period: {sales_by_channel}
- Historical redemption/returns: {historical_rates}
- Current pipeline/seasonality: {seasonality}
- Policy and controls: {policy_controls}
Output:
1) Accrual calculation steps and required inputs.
2) Rollforward schedule: beginning, new accruals, settlements, ending.
3) Journal entry templates.
4) Sensitivity analysis and key risks.
5) Evidence checklist (contracts, claim data, approvals).
Be explicit about assumptions and lag timing.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