Drop your Plato Excel export here
Or click to browse — accepts .xlsx and .xls files
Plato columns: Departure_Date · Convert_Date · Currency · Booking_Cost · Actual_cost (OBC)
| Contract date |
Expiry date |
Currency |
Contract amount |
Contract rate (INR) |
Utilized |
Remaining |
Utilisation |
Gain vs market (market − contract) / market |
Status |
|
| No forward contracts added yet — click "Add contract" to begin |
View-only snapshot
Shared by your team — data is read-only. Upload fresh data to start editing.
Booking rate · Market rate · Forward rate
By departure month
Avg booked
Market
Avg forward
Exposure vs hedged amount
By departure month — FIFO utilization vs remaining to book (FX units)
Total exposure
Hedged via contracts
| Departure month |
Currency |
Trails |
Total FX exposure |
Total INR (booking cost) |
Avg booking rate |
Matched contracts |
Avg contract rate |
Utilized FX |
Cover % |
FX still to book |
Min contract rate (2%) |
Max contract rate (2.2%) |
Blended gain % |
Status |
| Loading… |
FX exposure still to hedge
Departure months where total FX exposure exceeds FIFO contract capacity — these genuinely need a new forward contract to be booked.
Unhedged FX by departure month
Foreign currency units with no contract coverage
Contract gain vs required rate
What rate you need to achieve 2% gain vs current market
| Departure month |
Currency |
Total FX exposure |
Hedged FX (via contracts) |
Unhedged FX |
FX to book (new contract) |
Market rate |
Max contract rate (2% gain) |
Min contract rate (2.2% gain) |
Avg booking rate |
Locked gain % |
Priority |
Hedge coverage by currency
% of total exposure covered by active contracts
Contract utilisation
How much of each contract's value has been drawn
| Settlement month | Currency | Contracts |
Total hedged (foreign) | Contract value (INR) |
Utilized (INR) | Remaining (INR) |
Avg fwd rate | Gain vs market | Exposure coverage |
| Trail ID | Departure date | Booking date | Convert date |
Region | Trail status | Currency |
Gross FX | Settled FX | Net FX exposure |
INR (booking cost) |
Avg booking rate | Matched contract | Contract rate |
FX gain % | Status |
Daily booking volume (₹ lakh)
By booking date
Currency mix by volume
Share of total INR exposure per currency
Actual — bookings by departure week
From uploaded Plato data · FIFO contract allocation applied
| Departure week | Currency | Trails |
Total FX | Avg booking rate |
FIFO contracts used | Utilized FX |
FX still to book | Blended gain % | Status |
Forecast — next 3 months booking plan
Based on avg daily booking pace from uploaded data · shows recommended contract size and target rate band
Projected FX exposure — next 3 months
Extrapolated from current booking pace
Target contract rate range
Rate band needed to achieve 2–2.2% gain on projected booking rate
| Future month | Currency |
Projected FX | Projected avg booking rate |
Max contract rate (2% gain) | Min contract rate (2.2% gain) |
Existing contract capacity | Additional to book | Action |