SPM Financials: Currency Rate Usage in Cost Plan Breakdown

[Md Asim Khan]

The cost_plan_breakdown table uses different currency rate types for different financial values to ensure accurate financial planning and reporting.

---

1. Planned Cost & Budget → Uses Reference Rate

What is it?

Planned costs and budgets use Budget Reference Rates — predefined exchange rates set for future fiscal periods to enable consistent financial planning. These are stored in the itfm_fx_rate table.

Why this rate?

It provides stable, predictable conversion rates for planning purposes, allowing organizations to budget consistently across fiscal periods without fluctuations from daily currency volatility.

Relevant fields in cost_plan_breakdown

Field	Description
cost_investment_currency	Planned cost in investment currency
amount_investment_currency	Budget in investment currency
fx_rate_invst_currency	Reference to itfm_fx_rate record

---

2. Actual Cost → Uses Exchange Rate

What is it?

Actual costs use FX Exchange Rates (spot rates) — the actual market exchange rates at the time the cost was recorded. These are stored in the fx_rate table (daily rates).

Why this rate?

It reflects the true cost as it was actually incurred, providing accurate accounting of what was spent and ensuring financial statements reflect real-world currency conversions.

Relevant fields in cost_plan_breakdown

Field	Description
actual_cost_investment_currency	Actual cost in investment currency
exchange_rate	Reference to fx_rate record at transaction time

---

Why the Difference?

Aspect	Reference Rate (Planning)	Exchange Rate (Actuals)
Table	itfm_fx_rate	fx_rate
Purpose	Budgeting & Forecasting	Actual Financial Recording
Stability	Fixed for fiscal periods	Changes daily with market
Use Case	Planning future costs	Recording real costs
Accuracy	Predictable estimates	True transaction value

---

Business Impact

Planned costs and actual costs in investment currency will differ even if the functional currency amounts are the same, because each uses a different rate source. This is expected behavior.

Example Scenario (Q1 2025, USD → EUR)

Item	Rate	Result
Budget Reference Rate (itfm_fx_rate)	0.90	$1,000 → €900
Market Rate on Jan 15 (fx_rate)	0.92	$1,000 → €920
Variance	—	€20

---

Summary

Field Type	Source Table	Field Reference
Planned Cost	itfm_fx_rate	fx_rate_invst_currency
Budget	itfm_fx_rate	fx_rate_invst_currency
Actual Cost	fx_rate	exchange_rate

---

Conclusion

This design ensures investment planning reflects both:

• Budgeted expectations — via stable planning rates from itfm_fx_rate
• Actual financial outcomes — via real market rates from fx_rate