Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
April
April
Our organisation works with the following currencies - AUD, EUR, GBP, SGD, USD
How would I correctly enter the following payment into MYOB:
Payment of EUR Invoice from USD bank account:
Example = Paid EUR3,300 invoice from the USD bank Account (Debit amount USD3,549.08)
FX rate: 1.07548
Date: 10 Feb 2023
We have a currency transfer holding account set up.
Thank you.
April
April
Hi @KathrynF1
1. Pay Bills, select clearing account (AUD), pay EUR 3000 bill at 1.64 (any realistic rate will do), = AUD$4920. You could also choose the rate as AUD value of bill divided by 3000; this will avoid a spurious exchange varaince on the payment, and will change the maths in part 2).
2. Spend Money, select USD Bank, amount USD 3549.08 at rate 1.386274 (4920/3549.08) = AUD$4920.
Allocate to the F/C clearing account used in (1).
If you can't get the AUD amount in (2) to match exactly, put through another Spend (AUD$<$4920)/Receive (AUD$>$4920) money on the clearing account for the difference of a cent or two.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)