We currently use the average cost price calculation method for our products.
This calculation takes into account the amount of the purchase invoices to calculate the cost price.
When we have a purchase invoice in a foreign currency, the system will actually use the invoice date to determine the rate.
The value of the invoice in currency is converted into the currency of the company at the rate retrieved in the management of currency rates.
Price management is defined in our configuration to retrieve prices automatically 1x per day - we use the daily price of the document for our operations.
But for the management of our purchases in foreign currency, we use the forward exchange contract technique.
This technique allows us to buy an amount X in a foreign currency for a given date with a negotiated price.
This exchange rate will be guaranteed until the date defined in the contract and provided that the amount available in currency on the contract is not reached.
We sometimes need to apply a fixed exchange rate when encoding a purchase invoice to have a fairer value of the amount converted into the currency of the company.
This amount will then be used to calculate the cost price.
If we do not have the possibility of placing a fixed currency rate ie the price of the negotiated forward exchange contract, we have a deviation of the average cost price compared to reality.
Currently in our accounting software, we have a checkbox on the purchase invoice document to indicate that we are going to place a fixed price on this document.
The accountant can encode on the purchase invoice document the fixed rate he used to pay this invoice. This rate is the one defined on the forward exchange contract.
If “fixed rate” has not been checked, our accounting software will use the rate defined in the rate management module.
We made an estimate to determine the variation between the cost price calculated with “the daily exchange rate” (purchase invoice) and the cost price calculated with “the fixed exchange rate” of our futures contracts of change (purchase invoice)
This gives us a 2.5% average difference, so our cost price is overstated by 2.5% compared to the true book value.
After a search on the internet, I saw that many software have the possibility of placing a fixed rate on a purchase invoice type document.
- Are there other companies that use forward exchange contracts?
- and if so do you have a technique to manage this situation?