Forward contracts

Question

We are a NZ based export company and have recently secured 5*forward contracts with staggered due dates for cash flow purposes. How do we account for them in the Multi Currency module of MYOB given they do not match the sales flow? I'd be grateful to hear from anyone who deals with this. Many thanks.

wilhelmina1 · Accepted Answer

Thank you for that. I have. RegardsWilly

mike_james · Answer

Hi&nbsp;Wilhelmina1&nbsp;, please explain further, are you talking about forward exchange contracts?&nbsp;

wilhelmina1 · Answer

HI MikeYes I am, forward exchange contracts.Looking forward to hearing about it.thanksWilly

mike_james · Answer

Hi&nbsp;Wilhelmina1&nbsp;, so perhaps you have taken out forward exchange contracts maturing at various dates for the sale of various foreign currency amounts, to allow you to obtain NZD funds for invoices from overseas customers at known rates, thus protecting your gross margins. (I note you mentioned you are an exporter).&nbsp;Really, there are no additional entries to be made in your AccountRight file, beyond the normal banking entries. However, you will probably need records kept in a spreadsheet to manage your FEX contracts, for example if you take up parts of the contract over a period of time and you need to know how much is left on each contract.&nbsp;The funds used under each contract will determine the exchange rate that you apply when receipting sales invoices in AccountRight. Your contracts may mature before you receive the funds, in which case you would either extend the contract (at a new exchange rate), or allow the contracts to mature and use&nbsp; existing foreign funds to purchase NZD.&nbsp;Do you have any particular questions? I hope my answer is helpful.

wilhelmina1 · Answer

HI Mike.thanks for that answer. It helps a bit but we actually brought the cover to lock in rates for the transfers we make from our AU$ account when we need it for cashflow purposes. Maybe I am misinterpreting the cover as there is an obvioius mismatch between when we raise the invoice for a sale vs. when we transfer funds months later.&nbsp; We bill in AU$s and get paid in AU$s. These funds sit in the AU$ account until cashflow needs dictates we to transfer some&nbsp; EG , our situation is like per the grid below:&nbsp;&nbsp;Oct-19Nov-19Dec-19Jan-19Feb-19Mar-19Apr-19&nbsp;Sales&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250,000&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250,000&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250,000&nbsp;Debtor pays&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,000&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Trsf funds&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150,000&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,000&nbsp;&nbsp;FX contract&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150,000&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Previously we held a rate for the month for sales and then restated the remaining balance in the AU$ account at spot at month end. Which rate should we use now for the Sales and the transfers and the month end restatement?

steven_m · Answer

Hi&nbsp;Wilhelmina1&nbsp;
&nbsp;
I would recommend consulting with an accountant to ensure that you are using a process that meets your requirements and has the appropriate rates.
&nbsp;
From an MYOB Support point of view, the rate of a transaction can be changed by selecting the rate next to the currency and adding in the desired rate. Our Help Article:&nbsp;Changing a transaction's exchange rate outlines that process.

Forum Discussion

Forward contracts

6 Replies

Related content

Employee with two contracts

Forward date pay run

Different annual salary to actual contract

STP EOFY Finalisation - error however new year rolled forward already

Forward dating pay runs

Using Forwarder for In Tray mail

Employee moving from fixed term to permanent Contract

Invoice to payout a loan contract