Handling Exchange Losses & Gains in NEOSYS: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
No edit summary
 
(New page: Many a times, the foreign exchange rate fluctuates and hence there is a difference in the invoice currency amount issued or received as compared to the actual payment received or paid. He...)
Line 3: Line 3:
Hence NEOSYS handles these differences and allots the amount to a Exchange Loss or Gain A/c.
Hence NEOSYS handles these differences and allots the amount to a Exchange Loss or Gain A/c.


Below is an example of a sale which has been done:
Below is an example:


Furniture is purchased from a supplier for 100STG on 1/1/2007. On this date the exchange rate was 1 STG=7 AED. An invoice is received from the supplier and posted as below.
[[Image:exdi1.jpg]]
 
A client is invoiced for 100STG / 700AED on 1/1/2007. On this date the exchange rate was 1 STG=7 AED


[[Image:exdi1.jpg]]


[[Image:exdi2.jpg]]


The supplier is paid on 1/2/2007. However the exchange rate on this day has changed to 1 STG=7.5 AED. Hence there is a loss of 50 AED when we make this payment due to an increase in the exchange rate. NEOSYS automatically notices this and does the following:
The client makes a payment for this invoice on 1/2/2007. However the exchange rate has changed to 1 STG=7.5 AED. Hence there is a profit of 50 AED when we receive this payment. NEOSYS automatically notices this and does the following:


# Allocates the payment of 100STG (750AED) to the supplier invoice in the supplier a/c
# Allocates the payment of 100STG = 750AED to the invoice in the client a/c
# Credits the 50AED from the allocation which is overallocated to the supplier invoice
# Credits the 50AED from the allocation which is overallocated to the invoice
# Debits the Exchange Loss or Gain A/c (EXDI in this case)
# Debits the Exchange Loss or Gain A/c (EXDI in this case)
[[Image:exdi2.jpg]]




The following are the ledger printouts of all the accounts which are involved in this transaction:
The following are the ledger printouts of all the accounts which were involved in this transaction:


[[Image:exdi3.jpg]]
[[Image:exdi3.jpg]]


[[Image:exdi4.jpg]]
[[Image:exdi4.jpg]]

Revision as of 06:06, 17 November 2007

Many a times, the foreign exchange rate fluctuates and hence there is a difference in the invoice currency amount issued or received as compared to the actual payment received or paid.

Hence NEOSYS handles these differences and allots the amount to a Exchange Loss or Gain A/c.

Below is an example:

Exdi1.jpg

A client is invoiced for 100STG / 700AED on 1/1/2007. On this date the exchange rate was 1 STG=7 AED


Exdi2.jpg

The client makes a payment for this invoice on 1/2/2007. However the exchange rate has changed to 1 STG=7.5 AED. Hence there is a profit of 50 AED when we receive this payment. NEOSYS automatically notices this and does the following:

  1. Allocates the payment of 100STG = 750AED to the invoice in the client a/c
  2. Credits the 50AED from the allocation which is overallocated to the invoice
  3. Debits the Exchange Loss or Gain A/c (EXDI in this case)


The following are the ledger printouts of all the accounts which were involved in this transaction:

Exdi3.jpg

Exdi4.jpg