IMOS - Period FX Adjustments

The Veson IMOS Platform is the market-leading cloud solution for commercial marine freight and fleet management.

Period FX Adjustments can be used for these purposes:

• Adjust FX Rate: To create temporary payments at a current exchange rate for outstanding non-base-currency invoices.
• Clear Balance: To resolve differences in invoice and payment amounts caused by using different exchange rates on the invoice and payment.

On the Financials menu

Adjust FX Rate

To adjust the FX rate, follow these steps:

1. Check the Exchange Rates form and make sure that exchange rates are entered for the Eff Date from which you want to adjust exchange rates. (This is the date to enter in the Accounting Date From field.)
2. Check the Account Periods form and make sure that there is an entry in the Exch Diff field for the date range for which you want to adjust exchange rates.
3. In the Accounting Date From and Accounting Date To fields, enter the date range for which you want to adjust exchange rates, from step 1. (This checks the Accounting Date of transactions.)
4. In the Action field, select Adjust AP/AR, Adjust Advance, or Adjust Bank.
5. As needed, apply filters for Company(s), Curr(s), Counterparty(s), or Counterparty Type(s).
6. Click

   

    to calculate the adjustment. A list is generated of all invoices that have an open balance.
   • Opening balance line items that reflect the Exchange Rate are labeled Adjust Bank (Beginning Balance).
7. Scroll through the list and review the items in black text.
8. If all amounts appear correct, click

   

    to save. A Payment is automatically created against the original invoice for the amount in the Adjustment column, and then a Payment Reversal is created for the next date. The account set in Exch Diff in Account Periods is used as the clearing account for these two transactions. They can be seen in the Payments section of the Transaction Data Entry.

Clear Balance

To clear the balance, follow these steps:

1. Check the Account Periods form and make sure that there is an entry in the Exch Diff field for the date range for which you want to clear the balance.
2. In the Accounting Date From and Accounting Date To fields, enter the date range for which you want to clear the balance. Accounting Date To will be the posting date of the balance clear transaction.
3. In the Action field, select Clear Balance.
4. As needed, apply filters for Company(s), Curr(s), Counterparty(s), or Counterparty Type(s).
5. Click 

   

    to calculate the adjustment. A list is generated of all invoices with a zero invoice currency balance and a non-zero base currency balance.
6. Scroll through the list and review the items; these are the lines for which permanent adjustments will be posted.
7. If all amounts appear correct, click

   

    to save. A Payment is automatically created against the original invoice for the amount in the Adjustment column. No reversal is created; these are permanent adjustments to clear balances on invoices caused by foreign exchange differences. The account set in Exch Diff in Account Periods is used as the clearing account for this transaction. It can be seen in the Payments section of the Transaction Data Entry form.

Adjustment Calculations

• For the Adjust AP/AR, Adjust Advance, or Adjust Bank action, the adjustment is calculated as: ((Amount - Amount Paid) / Exch Rate) - ((Amount - Amount Paid) / Close Exch Rate)
• For the Clear Balance action, the adjustment is calculated as: (Ttl Base Amt - Ttl Base Paid)