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
BeginnerMonth-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
4
372
Financial Accounting
AdvancedForeign subsidiary translation and CTA rollforward
Builds translation steps for a foreign subsidiary and a cumulative translation adjustment (CTA) rollforward. Helps consolidation teams document FX methodology and reconcile equity impacts.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
97
Financial Accounting
IntermediateASC 606 Five-Step Compliance Checker
Analyzes a described revenue arrangement against each of the 5 steps of ASC 606. Flags potential issues and recommends documentation.
ChatGPT-4oClaude Sonnet 4.5
0
0
616
โญ Featured