USD Supplier Part Payments - Curr Exchange Difference

[ANDM]

Hi

We have an overseas supplier that invoices us in USD

We pay a deposit when we place the order and subsequently when the invoice is raised we make 2 more part payments on the Invoice

Which means that there are 3 payments for each order at different exchange rates

Once we record the first payment against the order, MYOB then does not allow us to update the exchange rate for the transaction.

We end up with Realised Gain/Loss even though this is not necessarily true

Is there any way around this ?

[Doreen_P]

Hi @Trithermal,

I understand your concern about handling multiple payments at different exchange rates in MYOB. From the information I found, MYOB Business AccountRight Premier offers multi-currency support which could potentially help with your situation. It allows you to send quotes and invoices in over 150 currencies and provides multi-currency cashflow reporting to track your gains and losses. It also uses live exchange rates to help you make the best decisions for your bottom line.

With your concern, you may try deleting or reversing the order and then recreating it to correct the situation. You may click here for more information.

Feel free to post again anytime if you require further assistance. 
 
If my response has answered your inquiry, please click "Accept as Solution" to assist other users in finding this information.

[ANDM]

Hi

We are already using AccountRight Premier 2024.2.0. Obviously this is the reason I am have a multi currency question.

Once a payment has been applied to an order, it cannot be deleted

Also, as clearly indicated in my question, after the first payment, the supplier ships the goods

Therefore the 2nd and 3rd payments are on an Invoice - not on an order

Once a payment has been applied, an order or invoice cannot be deleted

If I were to reverse the orders or invoices everytime I need to apply a payment, I would end up with a large volume of adjustments which will become a nuisance at EOFY.

The solution offered by you is not feasible unfortunately or accurate

[Genreve_S]

Hi @Trithermal, 

Thanks for the response. We appreciate you clarifying your concern. 

In my understanding, the multicurrency rates can be adjusted while recording the payments. This is provided by the app to make sure that the rates are correct for the period the payment was made. 

Additionally, you should have access to deleting and editing your payment transactions in the application. I recommend making sure these two preferences in the screenshot are not marked-checked to make sure that you don't have difficulties correcting the rate changes in the application. 

I recommend reading through this article 'Working with Multiple Currencies'. This will provide you with a better understanding on how to record different rates for each payment. 

Let us know if you require any further assistance with this.

Thanks,

Genreve

[ANDM]

Hi Genreve

Please read my question carefully. We already have been working with multiple currencies for the past couple of years. Our issue is not with multi currency payment

As mentioned earlier, we now make part payments to one supplier

E.g. Purchase Order AA01 Total USD 100 dated 1/7/23

Payment 1 - Deposit - 1/7/23 USD$50 @ 0.65

Payment 2  - Invoice Date - 1/9/23 USD $25 @ 0.64 - At this stage the order is converted to an Invoice

Payment 3 - Arrival of Goods - 15/9/23 USD $25 @ 0.66

Therefore the exchange rate of this transaction should be 0.649923

However, once the first payment is applied to the order the exchange rate gets allocated to this purchase and all future payments created a Exchange Gain or Loss

Yes, we can apply the exchange rate to the payment, however that exchange rate does not get applied to the purchase transaction

Hope this makes things clearer.

[Mike_James]

Hi @ANDM , the design of this currency system is based on creating a transaction at one rate, and paying it at another, without returning to the original transaction and modifying the rate. When you say that the transaction exchange rate "should be"  0.6499, this suggests that you used to modify the purchase exchange rate before making the sole payment, hence no gain or loss; but with multiple payments that is not possible, as the first payment always locks the rate, it's just never been visible to you before.