Write Off Adjustment Scenarios

The following scenarios indicate how foreign exchange gain or loss is calculated for write off adjustments which are created against a bill:

  • Scenario 1 - Adjustment Freeze Date Not Equal to Bill Completion Date; Exchange Rate is Different; Full Bill Amount is Written Off

    Bill Completion Date (04-30-2015) Adjustment Freeze Date (05-10-2015)
    Exchange Rate From USD USD
    Exchange Rate To INR INR
    Exchange Rate 50 60
    Invoice/Adjustment Currency INR INR
    Invoice Amount 1000 -
    Base Currency USD USD
    Booked Revenue in Base Currency 1000/50 = 20 -
    Adjustment Amount - 1000
    Adjustment Amount in Base Currency on Bill Completion Date - 1000/50 = 20
    Realized Revenue (Adjustment Amount) in Base Currency on Adjustment Freeze Date - 1000/60 = 16.67
    Foreign Exchange Gain or Loss - 20-16.67 = 3.33

    Observation: In the Scenario 1, there is foreign exchange loss of 3.33 USD on 05-10-2015 because of difference in exchange rate.

  • Scenario 2 - Adjustment Freeze Date Not Equal to Bill Completion Date; Exchange Rate is Different; Partial Bill Amount is Written Off

    Bill Completion Date (01-30-2014) Adjustment Freeze Date (03-03-2015)
    Exchange Rate From USD USD
    Exchange Rate To INR INR
    Exchange Rate 60 55
    Invoice/Adjustment Currency INR INR
    Invoice Amount 1000 -
    Base Currency USD USD
    Booked Revenue in Base Currency 1000/60 = 16.67 -
    Adjustment Amount - 600
    Adjustment Amount in Base Currency on Bill Completion Date - 600/60 = 10
    Realized Revenue (Adjustment Amount) in Base Currency on Adjustment Freeze Date - 600/55 = 10.91
    Foreign Exchange Gain or Loss - 10-10.91 = -0.91

    Observation: In the Scenario 2, there is foreign exchange gain of 0.91 USD on 03-03-2015 because of difference in exchange rate.

Note: If a write off adjustment is cancelled, reverse financial transactions are created. These financial transactions are not considered during the foreign exchange gain loss calculation.