Difference between revisions of "Handling of hourly prices in foreign currency"

From Marathon Documentation
Jump to: navigation, search
(Marked this version for translation)
 
(2 intermediate revisions by the same user not shown)
Line 4: Line 4:
   
 
== Background == <!--T:2-->
  
== Background == <!--T:2-->
−
With the parameter Hourly rates in any currency in Base register | PRO | Parameters, tab Fee switched on, the field Project currency opens in the project under the Invoicing tab. The project's currency can be entered there, and it makes it possible to have price lists on projects in a currency other than the company's base currency. Hours get the price from the price list in the project currency and the amount does not change when the exchange rate changes.
 +
With the parameter Hourly rates in any currency in Project | Backoffice | Base registers | Parameters, tab Fee activated, the field Project currency opens in the Invoicing tab. There you can enter a currency for the project; that enables having price lists in another currency than the company’s base currency. The hours get the price from the price list in the project currency, and the amount does not change when the currency rate changes.
   
 
=== Get started === <!--T:3-->
  
=== Get started === <!--T:3-->
−
* Set the parameter Hourly rates in any currency in Base register | PRO | Parameters, tab Fee
+
* Set the parameter Hourly rates in any currency in Project | Backoffice | Base registers | Parameters, Fees tab.
−
* Enter the project’s currency in Base register | PRO | Clients and Projects in the Invoicing tab.
+
* Enter project currency on the project in Project | Backoffice | Base registers | Client and project, Invoicing tab.
−
* Make sure that the project has Hours ticked in Base register | PRO | Clients and Projects in the Invoicing tab. If not, and the project is synchronised with client, the synchronisation must be switched off in the Parameters 2 tab.
 +
* Make sure that the project has Hours ticked in Project | Backoffice | Bas registers | Clients and Projects, Invoicing tab. If the client doesn’t have Hours set and the project is synchronised with client, it must be switched off in the Parameters 2 tab.
−
* Select a price list on the project in Base register | PRO | Clients and Projects in the Price fees tab.
 +
* Select a price list in the project in Project | Backoffice | Bas registers | Clients and projects, Price Fees tab.
−
There are two ways to enter the hourly rate and, in both cases, there must be a row as a price row for all employees regardless of the fee code.
+
There are two ways to specify an hourly rate, and in both cases, there must be a row showing the rate for all employees regardless of their fee code.
  +
  +
<!--T:13-->
 
{{ExpandImage|PRO-HSC-EN-Bild1.png}}
  
{{ExpandImage|PRO-HSC-EN-Bild1.png}}
−
The price list can either be filled in as Special price on the project in project currency or linked to a price list at According to price list. According to price list uses a price list from Base register | PRO | Special hourly rates. In this price list there is a field for the currency to be used.
+
TThe price list can either be entered under Special price for the project in the project currency or linked to a price list under According to price list. Under According to price list, a price list from Project | Back Office | Base registers | Special hourly rates is used. This price list contains a field for the currency to be used.
 
{{ExpandImage|PRO-HSC-EN-Bild2.png}}
  
{{ExpandImage|PRO-HSC-EN-Bild2.png}}
−
No prices from the Employee Register or from the Fee code register are used when the project currency is entered.
 +
No rates from the employees register or the fee code register are used when the project currency is specified.
   
 
<!--T:4-->
  
<!--T:4-->
Line 21: Line 23:
   
 
== Prerequisites and limitations == <!--T:5-->
  
== Prerequisites and limitations == <!--T:5-->
−
* All projects with a project currency that differs from the company's base currency must be specified with hours. The number of hours is ticked under Base register | PRO | Clients and projects, Invoicing tab.
 +
* All projects with project currency that deviate from the company’s base currency must be hourly reported. Tick the box Hours in Project | Backoffice | Base registers | Clients and Projects, Invoicing tab.
 
* The setting should only be made on projects where nothing has been registered or adjusted.
  
* The setting should only be made on projects where nothing has been registered or adjusted.
 
* Hourly rates in foreign currency should not be changed during the life of the project. Instead, new hourly rates should always be handled by creating new projects and new hourly rate lists. Project analysis of the project as a whole is handled by linking the projects to a master project.
  
* Hourly rates in foreign currency should not be changed during the life of the project. Instead, new hourly rates should always be handled by creating new projects and new hourly rate lists. Project analysis of the project as a whole is handled by linking the projects to a master project.
Line 29: Line 31:
 
 
  
 
 
== Project analysis == <!--T:6-->
  
== Project analysis == <!--T:6-->
−
With the parameter activated, there is a choice in the project analysis to show the amounts in project currency. The default is to show the amounts in project currency, but it is possible to switch between Base currency, Invoicing currency and Any currency and currency rate date.
 +
With the parameter Hourly rates in any currency activated, there is a possibility to see the amounts in project currency in the Project analysis. The standard view shows the amounts in project currency, but it is possible to alternate between Base currency, Invoicing currency and Any currency with currency rate date.
   
 
{{ExpandImage|PRO-HSC-EN-Bild3.png}}
  
{{ExpandImage|PRO-HSC-EN-Bild3.png}}
Line 41: Line 43:
   
 
== Cost estimate == <!--T:9-->
  
== Cost estimate == <!--T:9-->
−
With Hourly rates in any currency enabled, the project currency is set as the estimate currency by default when registering a new cost estimate.
+
With hourly rate in any currency activated, the project currency will be set as cost estimate currency as default when creating a new cost estimate.
−
The hourly rate is retrieved from the hourly rate list in the project currency.
 +
The hourly rate is taken from the hourly rate list in the project currency
−
The currency rate will continue to default to the daily rate but with the possibility to change it.
 +
The rate will continue to be set by default to the day rate, but with the option to change it.
  +
   
 
== Adjusting WIP == <!--T:10-->
  
== Adjusting WIP == <!--T:10-->
Line 49: Line 52:
   
 
==Invoicing == <!--T:11-->
  
==Invoicing == <!--T:11-->
−
Invoice content is given in base currency and text is given in invoice currency.
 +
The invoice content is entered in base currency and the text in invoicing currency.
−
The amount in the invoice text is calculated in base currency at the daily currency rate and may therefore differ from the content (which is registered at the exchange rate on the time report date).The difference between the base currency amount in the invoice content and the text is handled by setting the parameter "Max currency discr. on foreign invoice text" in the Base register | PRO | Parameters tab Invoicing to an allowed percentage for deviation. To completely avoid checking for difference, the parameter can be set to 999.99% but can also be set to a lower percentage to reduce the risk of difference caused by misregistration rather than exchange rate variations.
 +
The amount stated in the invoice text is calculated in the base currency at the current exchange rate and may therefore differ from the amount (which is registered at the rate on the date of the time report).
  +
The difference between the base currency amounts in the invoice content and the text is managed by setting the parameter Max. currency discr on foreign invoice in Project |Backoffice | Base Registers | Parameters, Invoicing tab, to a permitted percentage for discrepancy. To completely avoid checking for discrepancies, the parameter can be set to 999.99%, but it can also be set to a lower percentage to reduce the risk of discrepancies caused by incorrect entries rather than exchange rate fluctuations.
  +
   
   

Latest revision as of 10:47, 25 June 2026

Handling of hourly prices in foreign currency

Background

With the parameter Hourly rates in any currency in Project | Backoffice | Base registers | Parameters, tab Fee activated, the field Project currency opens in the Invoicing tab. There you can enter a currency for the project; that enables having price lists in another currency than the company’s base currency. The hours get the price from the price list in the project currency, and the amount does not change when the currency rate changes.

Get started

  • Set the parameter Hourly rates in any currency in Project | Backoffice | Base registers | Parameters, Fees tab.
  • Enter project currency on the project in Project | Backoffice | Base registers | Client and project, Invoicing tab.
  • Make sure that the project has Hours ticked in Project | Backoffice | Bas registers | Clients and Projects, Invoicing tab. If the client doesn’t have Hours set and the project is synchronised with client, it must be switched off in the Parameters 2 tab.
  • Select a price list in the project in Project | Backoffice | Bas registers | Clients and projects, Price Fees tab.

There are two ways to specify an hourly rate, and in both cases, there must be a row showing the rate for all employees regardless of their fee code.

File:PRO-HSC-EN-Bild1.png TThe price list can either be entered under Special price for the project in the project currency or linked to a price list under According to price list. Under According to price list, a price list from Project | Back Office | Base registers | Special hourly rates is used. This price list contains a field for the currency to be used. File:PRO-HSC-EN-Bild2.png No rates from the employees register or the fee code register are used when the project currency is specified.

  • Make sure that the currency rates are up to date. The hourly rate is recorded in the project currency and converted into the company's base currency at the exchange rate applicable on the time sheet date.

Prerequisites and limitations

  •  All projects with project currency that deviate from the company’s base currency must be hourly reported. Tick the box Hours in Project | Backoffice | Base registers | Clients and Projects, Invoicing tab.
  • The setting should only be made on projects where nothing has been registered or adjusted.
  • Hourly rates in foreign currency should not be changed during the life of the project. Instead, new hourly rates should always be handled by creating new projects and new hourly rate lists. Project analysis of the project as a whole is handled by linking the projects to a master project.
  • Hourly rates in foreign currency can be entered on hourly rate lists and as hourly rates on projects but not for hourly rates on employees and hourly rates per code.
  • The solution is for fees only and does not include special handling for purchases or other. Purchases and other are displayed in Project currency with the daily rate. currency.

 

Project analysis

With the parameter Hourly rates in any currency activated, there is a possibility to see the amounts in project currency in the Project analysis. The standard view shows the amounts in project currency, but it is possible to alternate between Base currency, Invoicing currency and Any currency with currency rate date.

File:PRO-HSC-EN-Bild3.png

Fee amounts are calculated as the number of hours multiplied by the hourly rate list for all fee transaction types (Cost estimate, Registered, Adjusted, Invoiced and WIP). Purchases and other are calculated with day rate.

Updating hours

The amount accrued in the base currency is calculated as the number of hours multiplied by the hourly rates in the project currency multiplied by the currency rate applicable at the time reporting date.

Cost estimate

With hourly rate in any currency activated, the project currency will be set as cost estimate currency as default when creating a new cost estimate. The hourly rate is taken from the hourly rate list in the project currency The rate will continue to be set by default to the day rate, but with the option to change it.


Adjusting WIP

Adjusting is done on number of hours and in base currency.

Invoicing

The invoice content is entered in base currency and the text in invoicing currency. The amount stated in the invoice text is calculated in the base currency at the current exchange rate and may therefore differ from the amount (which is registered at the rate on the date of the time report). The difference between the base currency amounts in the invoice content and the text is managed by setting the parameter Max. currency discr on foreign invoice in Project |Backoffice | Base Registers | Parameters, Invoicing tab, to a permitted percentage for discrepancy. To completely avoid checking for discrepancies, the parameter can be set to 999.99%, but it can also be set to a lower percentage to reduce the risk of discrepancies caused by incorrect entries rather than exchange rate fluctuations.

Retrieved from "https://wikidoc.kase.se/index.php?title=Handling_of_hourly_prices_in_foreign_currency&oldid=92446"