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
253
Financial Accounting
IntermediateAP three-way match exceptions and accrual recommendations
Finds exceptions between PO, receiving, and invoice data; recommends resolutions and accruals for goods received not invoiced. Helps AP teams and controllers reduce close surprises.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
130
Financial Accounting
IntermediateAR aging review and expected credit loss (ECL/CECL-lite)
Analyzes AR aging, flags collection risks, and proposes an allowance methodology and JE. Useful for controllers in smaller entities who need a practical, supportable approach.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
70