MNC Intra-Group Exclusions — only used since 'Foreign MNC's Indian Subsidiary?' is Y
Per RBI guidance, intra-group exposure (e.g. borrowing from parent) may be excluded from UFCE if the bank is satisfied it is hedged/managed by the parent. Only rows marked Bank Satisfied = Y are excluded.
Category
Maturity Bucket
INR Amount (Cr)
Bank Satisfied (Y/N)
FCY Exposures
Enter your INR-crore total directly (already converted at the quarter-end closing rate). Pick the maturity date with the calendar icon.
FCY RECEIVABLES (Assets)
Ref no (bill / PO)
Category
Currency
INR Amount (Cr)
Maturity Date
Bucket
Ref check
FCY PAYABLES (Liabilities)
Ref no (bill / PO)
Category
Currency
INR Amount (Cr)
Maturity Date
Bucket
Ref check
Financial Hedges
No need to match a hedge to a specific exposure line — RBI permits hedging on an anticipated-exposure basis. Just say whether it covers your Receivables or Payables side. Every hedge entered is treated as effective. Enter the bank's contract / deal reference for each hedge: the same contract entered twice is flagged, and any Hedge Tracker bill ticked "Hedged?" must quote a contract no listed here (a check only — it does not link the hedge to the bill or change the certificate).
Contract no (bank ref)
Currency
Instrument
INR Amount (Cr)
Maturity Date
Hedges
Bucket
Contract check
Natural Hedges
No need to link this to a specific category — e.g. export proceeds used to directly fund an import payment is shown against both your Receivables and Payables side at once. Shown for disclosure only — it does not reduce the certified TOTAL UFCE, only a financial hedge does.
Ref no (bill / PO)
Currency
INR Amount (Cr)
Offsetting Cash-Flow Type
Expected Cash-Flow Date
Accounting Year of Offset
Eligible?
Bucket
Ref check
Accounting year is compared to Entity_Info's Reporting Financial Year — spacing and case don't matter, but the year numbers must match.
UFCE Format in line with FEDAI & RBI Guidelines
Quarterly Data on Foreign Currency Exposures
@ Residual unhedged receivables & payables after netting off financial hedge in full — a negative figure means the financial hedge on that side exceeds the exposure it covers. Natural Hedge above is shown for disclosure and is not deducted here.
Financial and Natural hedges are booked against the Receivable/Payable side as a whole, not a specific category — shown against a category only when it's the sole one with exposure in that bucket (unambiguous); otherwise shown only at the TOTAL rows.
Yours Sincerely, Authorised Signatory
Name: ___________
Designation: ___________
Executive Summary
Bank-format net exposure cross-check — NOT a substitute for the certificate
The bank-format view has no Natural Hedge column and deducts only Financial Hedge from net (Receivables−Payables) exposure. A negative result is shown as is (net short / over-hedged), the same as the certificate's net row.
Daily / Management Snapshot
Recalculates instantly as Exposures/Financial Hedges/Natural Hedges change — usable as a daily snapshot for management even though the certificate itself is only submitted quarterly.
Gross Asset Exposure (net of financial hedges)
0.00
Gross Liability Exposure (net of financial hedges)
0.00
Net Open Exposure
0.00
Sensitivity — Risk of Loss (Rs Cr)
1% INR move
0.00
3% INR move
0.00
5% INR move
0.00
Positive Net Open Exposure = net long foreign currency (asset side bigger, INR depreciation risk). Negative = net short (liability side bigger, INR appreciation risk).
"Had They Hedged?" — Decision Tracker
For every open bill: what the forward rate was on the day it was booked, what it is today, and how much of the budget cushion is left. Cushion is bucketed by booking month (when the exposure was created), not by due date. This view flags and reports only — it does not recommend hedging.
Rates: this demo uses the market table below (type, paste CSV, or load the demo). An automatic FBIL / market-feed fetch plugs into the same table — not connected here. Storing and displaying FBIL / vendor forward-curve history needs the data provider's licence.
Settings
Budget rate by currency (client decides)
Currency
Budget rate (INR per unit)
Market rates (spot and forward premium in INR, by date)
Date
Currency
Spot
1M premium
3M premium
6M premium
12M premium
Forward for a bill = spot + premium interpolated for the months remaining to its due date.
Bill / PO ledger
Ref
Side
Category
Ccy
FCY amount
Booked on
Due on
Hedged?
Hedge contract no
Budget rate
Day-1 spot
Day-1 premium
Day-1 outright
Today spot
Today premium
Today outright
Day-1 cushion
Cushion now
Change / unit
% of day-1 cushion left
Cost of waiting (INR)
Status
Enter only the bill details. Day-1 and today's spot, premium and outright (spot + premium for the months left to the due date) are picked up from the market table. Cushion per unit = outright − budget for receivables, budget − outright for payables; positive = headroom left. "Cost of waiting" = change in the outright since booking × FCY amount (positive = staying unhedged has helped so far). A bill is treated as settled once the valuation date reaches its due date, at the spot on its due date.
Cushion by booking month
Scorecard by booking quarter (Indian FY) — hedged on day 1 vs staying unhedged
Open bills are marked at today's forward for their remaining tenor; settled bills use the actual settlement spot. Hedged bills are excluded.
Send to Certificate
Pushes the bills that were open at the Reporting Date (booked on or before it, due after it) into the Exposures tab as ledger rows, in INR crore at the closing spot on or before the Reporting Date. Bills booked later, or already settled by then, are left out and listed in the message. Bills ticked Hedged? go in at gross; their forward must be on the Financial Hedges tab (quote its contract no). Manual rows are kept; earlier ledger rows are replaced. The certificate itself is unchanged and still works without this.
Validation & Exceptions
Clear every REVIEW item below before treating the certificate as final.