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
1
55
Financial Accounting
AdvancedImpairment 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
28
Financial Accounting
BeginnerVendor 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
44