Full Sail Partners Blog

Using Multicurrency in Deltek Vision

Posted by Nicole Temple on Wed, Mar 08, 2017 @ 09:45 AM

Deltek Vision MulticurrencyDoes your firm work internationally and deal with multiple currencies? Did you know there is a way to automate the tracking and conversion data? Within Deltek Vision is the Multicurrency function which holds the key to simplifying this process for your firm.

Vision Multicurrency allows you to:

  • Manage multiple currencies for transactions, accounting and financial reporting
  • Enter and manage exchange rates which can be done manually or can be automated to pull in exchange rates (XE.com has an auto feed subscription for this)
  • Support daily and periodic exchange rate changes
  • Revalue foreign currency accounts and automatically identify a gain or loss due to currency fluctuations

Considerations when Using Deltek Vision Multicurrency

With any changes to your standard accounting practices, there are always some items that need to be taken into consideration:

Revenue Considerations: Revenue generation will now use the billing currency fields in the project info center.

Project Considerations: Once you set a project to a currency and the project has data on it, the currency code cannot be changed on the project. It is very important to set the project to the correct currency upon initial setup. All lower levels of the work breakdown structure (WBS) must also be set to the same currency as the project. Optionally, a billing currency can be set differently than the project currency, but all lower levels will need to match.

General Ledger Account Considerations: In Vision Multicurrency accounts can be left without a specific currency or set to a single currency. In some situations, the company might set a bank account to a specific functional currency. For example, a bank account is set to USD for use by only the USD company. You might leave other accounts open to be used across companies with different currencies. Once an account is set to a currency that is different than the functional currency, it is then considered a foreign denominated account.

Unit Considerations: You must specify both a project and billing currency.

Vendor Considerations: Vendor records are stored in the functional currency of the active company. Additionally, there are several details to note for vendor records:

  • Functional Currency – the home currency or the currency in which the company operates
  • Transactional Currency – the currency in which a transaction is entered into Vision
  • Presentation Currency - used in reporting to generate a report with all amounts expressed in a single currency
  • Billing Currency - the currency used to generate invoices and billing reports for specific projects and their WBS
  • Project Currency – the currency in which the project is managed which can be different than the functional currency when needed (this currency should be used for all project management purposes including reporting)
  • Payment Currency – the currency in which the payments are made
  • Consolidated Reporting Currency – only available in a Multicompany environment and is used to create consolidated financial statements for multiple companies that are using different functional currencies
  • Account Currencies – each account setup for use as a bank account and mapped to a GL code can be set to a specific currency directly through the account setup of the GL (if you specify an account currency that is different from the company’s functional currency, the account is then considered a foreign-denominated account)
  • Tax Currency – if tax auditing is enabled then a currency must be set for each tax code (this is generally the currency in which you report and pay the tax amounts to the proper tax authority)

Generally Accepted Accounting Practices in Deltek Vision Multicurrency

Deltek Vision Multicurrency is in accordance with the Accounting Standards Codification (ASC) sections ASC-830-10-55-10 and 11. In section 55-10, the guideline states that it is acceptable to use averages or other methods of approximation. Accordingly, it is recommended to use a weighted average of the exchange rate for a period rather than applying actual day-to-day fluctuations.

Furthermore, section 55-11 states that average rates used shall be appropriately weighted by the volume of functional currency transactions occurring during an accounting period. In other words, to translate revenue and expense accounts for an annual period, individual revenue and expense accounts for each quarter or month may be translated at that quarter's or that month's average rate. The translated amounts for each quarter or month should then be combined for the annual totals.

Why Use Multicurrency in Deltek Vision?

Multicurrency can be used for tracking currency exchange gains and losses. Having foreign-denominated accounts creates the need to track gains and losses based on fluctuating exchange rates. For example, if a European company has a bank account denominated in United States dollars and the value of the euro rises against the United States dollar, the value in euros of that bank account balance drops. This results in an unrealized loss to the European company. Using Multicurrency allows you to use the Gains/Losses and Revaluations process in Vision to calculate and post these types of currency exchange gains and losses. As a result, they appear on your financial statements per the generally accepted accounting practices under which you operate.

Full Sail Partners' Webinars

 

Topics: Accounting, Deltek Vision