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

Intermediate

Retail gross margin bridge: markdowns, mix, shrink, freight

Builds a gross margin bridge explaining changes driven by markdowns, mix, shrink, and freight. Useful for merchandising and finance alignment.

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

170

Industry-Specific

Advanced

Inventory reserve framework: obsolescence, shrink, and markdowns

Designs an inventory reserve approach for obsolescence and markdowns with calculation templates and controls. Useful for retail and manufacturing close and audit support.

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

221

Industry-Specific

Intermediate

Revenue cycle analytics: denials, days in AR, and cash acceleration

Analyzes revenue cycle KPIs and identifies actionable levers to reduce denials and improve collections. Useful for hospital/practice management and finance teams.

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

160