Saturday, July 13, 2019

Compute for the consolidated foreign currency amount when a sales transaction consists of Deferred Revenue?

Given the following:

1. Subsidiary Hierarchy:

Subsidiary A - in US Dollars
               Subsidiary B - in Euro currency

2. Sales Order Account's General Rate Type is Average.

3. Exchange Rate from Euro to US Dollars = 1.00

4. Consolidated Current Exchange Rate = 1.35319996
    Consolidated Average Exchange Rate = 1.37065836

A Sales Order was created on 1/31/2014 for Subsidiary B. Its GL Impact (Actions > GL Impact) reflects:

Debit Sales Orders account for 186,000
            Credit Revenue for 16,909.09 
            Credit Deferred Revenue for 169,090.91

Calculation:

First, get the Consolidated Exchange Rate found in Lists > Accounting > Consolidated Exchange Rates

Set the Period to January 2014, and the following:

    From Subsidiary = Subsidiary B 

    To Subsidiary =  Subsidiary A

    Current Consolidated Exchange Rate = 1.35319996
    Average Consolidated Exchange Rate = 1.37065836

Since Sales Order account's General Rate Type is Average, multiply the Revenue, 16,909.09 to the Consolidated Average Exchange Rate of 1.37065836; and multiply the Deferred Revenue, 169,090.91, to the Consolidated Current Exchange Rate of 1.35319996. Then, Total are added together.

    16,909.09 * 1.37065836 = 23,176.59

    169,090.91 * 1.35319996 = 228,813.81

    23,176.59 + 228,813.81 = 251,990.39 or 251,990

No comments:

Post a Comment