Excel workbook previewFX Exposure Register
3 free downloads per account. Just your email and a 6-digit code.
About this template
An FX exposure register lists the amounts the organization will receive or pay in a currency other than the one it reports in, together with the hedges that protect them. Boards and auditors ask for it to see how a move in exchange rates would affect cash and profit, and whether hedging follows the treasury policy. It also prevents hedging the same exposure twice or hedging one that has already gone.
This workbook records eleven exposures of an invented group, links ten forward contracts and bought options to them, calculates the hedge ratio for each exposure and compares it with a policy range that depends on how far away settlement is. A net position sheet shows the open amount per currency pair and the effect of an adverse move you choose. It follows general treasury practice.
Who it is for
The treasurer or controller who must show the board or auditor what foreign currency risk the group carries and how much of it is hedged.
What is inside
- Exposures sheet with 11 worked exposures across 3 functional currencies and 20 blank rows
- Months to settlement and a horizon band calculated from the expected settlement date
- Hedged amount and hedge ratio pulled live from the Hedges sheet and tested against policy minimum and maximum
- Hedges sheet with 10 worked forwards and options, cross rates and an indicative value against spot
- Policy sheet with hedge ratio ranges for 6 bands, all editable
- Net Position sheet for 6 currency pairs: net exposure, net hedge, net open position and the impact of an adverse move
- Rates sheet with USD per unit for 5 currencies and cross rates by formula
- How to use sheet, dropdowns, status colours, freeze panes, filters and print fit
How to use it
Update the Rates sheet and the hedge ranges on the Policy sheet, then replace the sample exposures with your open receivables, payables and forecast flows.
Files
- XLSXfx-exposure-register.xlsx24 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What types of FX exposure does the register cover?
It covers transaction exposures, such as receivables and payables in a foreign currency, forecast exposures, such as next quarter's expected sales or purchases, intercompany balances and the net investment in a foreign subsidiary. Each type is a dropdown so you can filter and report them separately.
Why does the policy hedge ratio fall with the horizon?
Near-term flows are more certain, so many policies hedge a larger share of them and a smaller share of flows six or twelve months away. That avoids hedging forecasts that may not happen. The ranges on the Policy sheet are an example and are meant to be replaced with your own approved ratios.
Is the indicative hedge value a fair value?
No. It compares the contract rate with today's spot rate and ignores forward points, discounting and option time value. It is a quick signal of direction and size. For accounting or reporting, use the valuation from your bank or a valuation tool.




