Foreign Exchange Exposure Tracker

If you sell or buy in euros, dollars or any other currency, every movement in the pound changes what those invoices are worth in sterling. This workbook keeps all your foreign currency invoices, expected future receipts and payments, forward contracts and currency bank accounts in one place. It works out the gains and losses you have already made when invoices were paid, the gains and losses sitting in open invoices at any revaluation date, how much of each currency you are exposed to over the next 12 months, how much of that is covered by forward contracts against your hedging policy, how actual rates compare with your budget rates, and what a 5% or 10% move in the pound would do to profit.