Advanced

Upstream/downstream inventory profit elimination calculator

Computes unrealized profit in ending inventory from intercompany sales and drafts the elimination entries. Helps avoid overstatement of profit in consolidated financials.

Compute and book intercompany inventory profit eliminations.

Inputs:
- IC inventory sales details: {ic_inventory_sales}  # seller, buyer, sales price, cost, markup, dates
- Ending inventory on hand from IC purchases: {ending_ic_inventory}
- Tax considerations (optional): {tax_considerations}
- Reporting period: {period_end_date}

Output:
1) Unrealized profit calculation by IC stream (upstream/downstream), including attribution logic.
2) Elimination journal entries (COGS/Inventory and related accounts) with memos.
3) Rollforward schedule for deferred profit (beginning, new deferrals, releases, ending).
4) Evidence checklist and control tips.

Be clear about assumptions for markup and units.

Related Prompts

Financial Accounting
Beginner

Month-End Close Checklist Generator

Generates a comprehensive month-end close checklist tailored to your company type and size.

ChatGPT-4oClaude Sonnet 4.5Gemini 2.5 Pro
1
1
56
Financial Accounting
Advanced

Impairment indicator screen and impairment test outline

Screens for impairment indicators and outlines an impairment test approach with documentation steps. Useful for controllers and advisors supporting annual impairment reviews.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
30
Financial Accounting
Beginner

Vendor statement reconciliation and duplicate payment scan

Reconciles vendor statements to AP subledger and identifies duplicates/credits. Produces a clear recon with recovery actions for AP and treasury.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
1
45