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
0
0
6
Financial Accounting
AdvancedASC 606 contract intake: performance obligations & allocation
Analyzes a customer contract under ASC 606/IFRS 15: identifies performance obligations, determines transaction price, and allocates consideration. Produces a concise memo and a revenue schedule outline.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Financial Accounting
AdvancedIFRS 15 variable consideration constraint assessment
Evaluates variable consideration and the constraint, documenting probability-weighted outcomes and recognition impacts. Helps controllers defend judgments and build consistent templates across contracts.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2