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

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
15
Industry-Specific
Advanced

HIPAA Security Rule Risk Analysis

Evaluates the technical safeguards for Protected Health Information (PHI).

Claude 3.5 SonnetGPT-4o
0
0
7
Industry-Specific
Advanced

SaaS 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