Tag Archives: MoneyWorks multicurrency

MoneyWorks | The Exchange Gain/Loss, how it works?

Software: MoneyWorks accounting software

How it works?

Assume that as of 31 May you had set the exchange rate for 1SGD to 0.8000USD (using the month end exchange rate).

You recorded a USD bill (Purchase Invoice) as of 12 June for the amount of USD10,000, the base currency equivalent amount will be SGD12,500 (10,000/0.8000). The double entry for this Purchase Invoice transaction:

DEBIT Purchase 10,000

CREDIT USD Accounts Payable 10,000

DEBIT Purchase (exchange) 2,500

CREDIT USD Accounts Payable~~DEL (Exchange) 2,500

As of 30 June, you changed the exchange rate to 1SGD:0.7800USD. Since the USD Purchase Invoice is still outstanding, MoneyWorks will create an exchange journal for the unrealized exchange gain/loss automatically. The double entry for the exchange journal:

CREDIT USD Accounts Payable~~DEL 320.51

DEBIT Exchange Gain/Loss Unrealized 320.51

When the exchange rate changed from 1SGD:0.800USD to 1SGD:0.7800USD, there is an unrealized exchange loss of 320.51.

On the following month, as of 31 July, if the exchange rate has changed further to 1SGD:0.7900USD, MoneyWorks will create another exchange journal to correct the outstanding USD Accounts Payable.

Working:
10,000/0.8000 = 12,500.00
10,000/0.7900 = 12,658.23
Corrected Exchange Loss = 12,500 – 12,658.23 = -158.23
Therefore, the exchange journal amount is 320.51 – 158.23 = 162.28

The double entry of the exchange journal will be:

DEBIT USD Accounts Payable~~DEL 162.28

CREDIT Exchange Gain/Loss Unrealized 162.28

This will give a net unrealized exchange loss of 158.23 (320.51 – 162.28).

On 5 August, you paid USD10,000 to the supplier at the exchange rate of 1SGD:0.7900USD (exchange rate as of 31 July), the base currency equivalent will be SGD12,658.23. The double entry for the payment transaction:

DEBIT USD Accounts Payable 10,000
DEBIT USD Accounts Payable~~DEL 2,658.23

CREDIT Bank USD 10,000
CREDIT Bank USD~~DEL 2,658.23

DEBIT Exchange Gain/Loss 158.23

CREDIT Exchange Gain/Loss Unrealized 158.23

MoneyWorks reclassified the unrealized exchange loss of 158.23 to the exchange loss account automatically during the payment transaction.

MoneyWorks - The exchange gain/loss

MoneyWorks has simplified the exchange gain/loss process for the accountant. Unlike some of the accounting software, which you are required to pass the unrealized exchange gain/loss journal manually; MoneyWorks automatically did the necessary unrealized gain/loss adjustment for you once you have updated the exchange rate of the foreign currency.

 

 

MoneyWorks | The historical exchange rate

Software: MoneyWorks accounting software

MoneyWorks does keep track of the monthly exchange rate you set for the foreign currencies. The exchange rate report can be found in the Reports menu | Foreign Currency | Exchange Rate.

MoneyWorks - Historical Exchange Rate

The exchange rate shown is the rate set on the last day of the month.

Receive foreign currency into base currency bank account

Software: MoneyWorks accounting software

What are the transactions involved in receiving foreign currency amount of an invoice into a base currency bank account?

Assuming we have a Sales invoice of USD 10, 000.00 at an exchange rate of SGD1 : USD0.8. Then, we received this amount, USD 10,000.00 and banked into our SGD bank account (Cash at Bank (SGD)). Due to the loss in exchange, the actual amount received in the SGD bank account (Cash at Bank (SGD)) is only SGD 12,350.00 instead of SGD 12,500.00 (based on house rate of SGD1: USD0.8).

The double entry for receipt of USD 10,000.00 is:

Credit USD Accounts Receivable: 10,000.00

Credit USD Accounts Receivable (currency delta): 2,500.00

Debit USD Bank Account: 10,000.00

Debit USD Bank Account (currency delta): 2,500.00

Note: USD Bank account is the clearing account used in this transaction.

We did use a SGD Bank account (Cash at Bank (SGD)) in our receipt transaction, why SGD Bank account (Cash at Bank (SGD)) was not part of the above double entry?

When a USD amount was banked into a base currency bank account (SGD), MoneyWorks created a payment transaction automatically to transfer USD 10,000.00 from USD Bank Account (clearing account) to the SGD Bank account (SGD 12,350.00).

The double entry for this payment transaction is:

Debit SGD Bank Account (Cash at Bank (SGD)) : 12,350.00

Credit USD Bank Account: 10,000.00

Credit USD Bank Account (currency delta): 2,500.00

Debit Exchange Gain/Loss: 150.00