Advanced
Foreign 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.
Translate a foreign subsidiary into the reporting currency and roll forward CTA.
Inputs:
- Subsidiary trial balance in local currency: {local_tb}
- Average period FX rate(s): {avg_rates}
- Closing FX rate: {closing_rate}
- Historical rates for equity accounts: {historical_equity_rates}
- Prior period CTA balance: {prior_cta_balance}
- Translation method (e.g., current rate method): {translation_method}
Output:
1) Translated trial balance with rate applied per line (closing/average/historical).
2) CTA calculation and rollforward (Beg CTA + current period translation effect = End CTA).
3) Reconciliation checks (assets=liabilities+equity; translation differences explained).
4) Suggested consolidation entries for CTA (if needed by your system).
Do not invent rates; use provided inputs and list missing ones.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
264
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
437
โญ FeaturedFinancial Accounting
AdvancedASC 606 disclosure checklist mapped to data sources
Generates an ASC 606/IFRS 15 disclosure checklist and maps each disclosure to internal data sources and owners. Ideal for SEC reporting teams and controllers improving disclosure readiness.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
70