Multi-Currency Grant Calculator
Keep the transaction amount, rate direction and settlement costs separate so a currency difference can be explained.
Method And Expected Result
Replace example rates with dated approved sources. This calculator explains arithmetic; the accounting treatment and donor conversion rule follow the applicable policy and agreement. Do not combine transaction, entity and donor currencies without naming each basis.
Worked planning examples, not customer performance results. Changes stay in this page until exported; reloading resets them. Keep sensitive personal information out of this planning tool.
Working Sheet
| Input | Value | Basis |
|---|---|---|
| Invoice EUR | 2000 | Worked example |
| Posting rate GBP per EUR | 0.85 | Approved accounting rate |
| Settlement rate GBP per EUR | 0.86 | Bank settlement rate |
| Fee GBP | 5 | Separate provider charge |
| Liability GBP | Unresolved | Invoice × posting rate |
| Settlement before fee GBP | Unresolved | Invoice × settlement rate |
| Settlement difference GBP | Unresolved | Settlement less liability |
| Total cash paid GBP | Unresolved | Settlement plus fee |
The Excel toolkit includes the Grant FX worksheet for this resource. CSV exports contain current values; Excel retains the calculator formulas.
