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
665
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
914
โญ FeaturedFinancial Accounting
AdvancedIFRS 16 lease modification analysis and remeasurement
Evaluates lease modifications under IFRS 16 and computes remeasurement impacts, including updated discount rate logic. Helpful for complex real estate and equipment portfolios.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
209