Advanced
Pharma inventory and rebate/chargeback accrual framework
Designs a framework to accrue for rebates, chargebacks, returns, and inventory reserves common in pharma. Useful for controllers and audit support.
Create an accrual framework for rebates/chargebacks/returns for {pharma_company}.
Inputs:
- Sales channels and terms: {sales_channels_terms}
- Rebate programs and rates: {rebate_programs}
- Chargeback/contract pricing terms: {chargeback_terms}
- Returns history and policy: {returns_history}
- Inventory on hand and expiry risk: {inventory_data}
Output:
1) Accrual model outline by program (inputs, calculations, timing).
2) Journal entry templates and rollforward schedules.
3) Controls and evidence requirements (data sources, approvals).
4) Key risks and sensitivities (utilization rates, lag, channel mix).
Be transparent about uncertainties and data needs.Related Prompts
Industry-Specific
AdvancedInventory 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
0
0
30
Industry-Specific
BeginnerNonprofit: Functional Expense Allocation (990)
Allocates expenses between Program, Management, and Fundraising buckets.
GPT-4oGemini 1.5 Pro
0
0
25
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
19