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
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