Handle multiple currencies with ease!
Exchange rates and exchange rate fluctuations have a major influence on both the operation and profit results of businesses dealing in foreign currencies. Historically, considerable resources were required to record and maintain multiple currency transactions, often in spreadsheets or other processes external to the accounting and stock control systems.
Multicurrency is a core component of Jim2, ensuring that every process involving a foreign currency is fully integrated. From raising a quotation through every process in your business cycle, Jim2 enables transactions in foreign currency, making it easy to manage both unrealised gains and losses (potential changes in the value of overseas transactions) and realised gains and losses (the actual changes in the value of your assets, liabilities and equity that occur when you exchange foreign currency for your local currency) by providing accurate, live transaction reporting as you work.
Jim2 Multicurrency allows for an unlimited number of definable foreign currencies. Maintenance of exchange rates is easy using the Currency Rate table. Jim2 automates individual spread limit % (swing) and out of date warnings on each currency to ensure accuracy, and encourage vigilance when dealing with the volatility of foreign exchange.
You can only use the home currency, ie. AU$, in general journals as the general ledger is only in home currency. |
Jim2 Multicurrency removes any need for separate debtor/creditor identities to trade in multiple currencies. The suite of practical documents and professional business reports in Jim2 supports all multicurrency requirements.
The Jim2 Multicurrency Revaluation Session is a tool for recording and reporting your foreign currency position. Fully integrated into the functionality of Jim2, this feature reports your unrealised foreign exchange exposure at any point in time, automatically creates the journals required when currencies are revalued, and with automatic realisation journals created on full or part payment of invoices.
Once you have enabled Multicurrency in Jim2, you cannot disable it. |
Multicurrency Operation – An Example
▪Your commencement date for Multicurrency is January 1. The exchange rate for USD is set at $0.80.
▪The default setup for USD remains at 5% spread limit with 14-day out of date warning.
▪On January 1, purchasing and payments in USD transactions are going to be based on the $0.80 rate.
▪On January 15, users finishing a January USD purchase order will be warned that the out of date range has been reached.
▪The currency rate for USD should now be reviewed and adjusted.
On February 1st, the USD exchange rate has taken a downward turn from $0.80 to $0.70. The currency rate for USD should now be reviewed and adjusted. Once adjusted, all new February purchasing and payments in USD transactions will be based on the $0.70 rate.
However, because the spread limit for USD (5%) has been exceeded against open January documents, users attempting to finish a PO created in January will be given a spread limit warning. They can choose to adjust the document rate to match current spot rate (of $0.70), or finish as is and let the next Revaluation Session correct the gain/loss.
On February 15, all new USD purchase orders entered or payments made will still be defaulted to the 0.70 rate, and users finishing January purchases will correctly receive a spread limit warning, which can be actioned as above. The USD Currency Rate should now be reviewed and adjusted, or users finishing purchasing and payments in USD will be warned that the Out of Date range has been reached.
On March 1st, the USD exchange rate is now $0.72. The USD Currency Rate should again be reviewed and adjusted. March purchasing and payments in USD transactions will be based on this $0.72 rate. Because this rate is within your allowed variation of 5%, there will be no spread limit warnings if a user finishes a February PO, however there will be a warning if they finish a January PO (where the rate was $0.80).
On March 15, the USD currency rate should again be reviewed and adjusted, or users finishing purchasing and payments in USD will be warned that the out of date range has been reached.
Reviewing and adjusting currency rates in line with your setup is extremely relevant in a live financial environment. Jim2 warnings have been designed to assist you in maintaining accuracy, and help to enforce the administrative regimen needed when dealing with multiple foreign currencies. |
Stock Pricing and Multicurrency
Stock pricing is calculated as set in the Pricing tab on a single piece of stock for that price level and currency. In the case that the stock doesn’t have a price level in that currency, the price will be calculated based on the home currency price converted to the currency rate on the job.
It is necessary to set up Multicurrency in Jim2 before these features can be used. The following sections work through a logical progression of setup and application.
Further information: