How Accountability handles multi-currency transactions
Establishing Currencies
When a new Company is established within Accountability, its Company Home Currency is created. The Company currency is the default for all transactions for this Company, unless overridden by an Office Home Currency, Client Currency or at the point of creating a transaction, and will be the currency used for consolidation purposes.
How to Create a New Currency
- Under the Setup Files menu select Currencies
- Click on New Currency
- Type in a Currency Code to signify the New Currency - in this example EUR
- Enter the New Currency Name eg Euro
- If the New Currency is denominated in decimals check the Decimals? box, if not leave unchecked.
- Enter the Exchange Rate to the Company Home Currency signifying the value of the New Currency to one unit of the Company Home Currency. (In this example the rate has been created at 1.25, meaning 1.25 EUR Euro is equivalent one GBP Great British Pound Company Home Currency).
- The system will automatically calculate the reverse exchange rate, being the reciprocal rate ie the equivalent rate for one unit of the New Currency relative to the Company Home Currency. In this example 0.8 meaning 1 EUR is equivalent to 0.8 GBP.
- Check the Active box to signify that the rate is active.
- Click on Save button
Defining an Office Home Currency
When creating a new Office (reporting entity/legal entity) you must specify its Currency (Office Home Currency). This will be the default currency used for all transactions for this Office, unless overridden by a Client Currency or at the point of creating a transaction.
The Office Home Currency is the accounting Currency for this office – all system Journals created for the Office will be created in this Currency, and by default all major system reports for the Office will be calculated and displayed in that Currency.
- To change an Office Home Currency go to Setup Files menu and select Offices
- On the Search Offices screen, select the office code hyperlink for the office you want to edit.
- Select the Currency from the drop down list of currencies established in the system.
Tip - You can choose to view the foreign exchange rates based on a different currency from the default home currency. Use the Home Office Currency drop down from the Search Currencies page, to see the FX rates based on your selection.
Defining a Client Currency
The default currency for a client (Client Currency) will be set to the Office Home currency of the selected office during client setup.
However, you can change this setting if you need to invoice the client in a different currency than the Office Home currency.
To change the Client Currency, follow these steps:
- Navigate to Master Files > Clients
- On the Search Clients Page, select the Client Code Hyperlink
- On the Client page located the Default Currency option and use the drop down menu to select the desired currency
- Click on the Save
This update ensures that all estimates and invoices for the client will be generated in the selected Client Currency unless a different currency is specified during the creation of a transaction. Similarly, any billable rates established for this client will default to the Client Currency unless overridden during a transaction.
Creating an Estimate in a different currency
- Create Estimate Header and click “Save”
- On the top right hand side, Click on the hyperlink for Currency
- Use the drop down menu under Estimate Currency and select the currency you would like to use.
- Click Save
- On the top right hand side of the screen you will see the estimate currency with an asterisk
- The estimate will be created in the selected currency and when you invoice this estimate the invoice will be produced in the selected currency.
Note that where there are multiple estimates for a job, that all estimate versions created for that job must be in the same currency.
There is a database setting that allows you to apply Estimate FX Rates for all Production invoices invoices created from estimates. In other words there will be no exchange variance between the Estimate and the Production Invoice it was created from.
If you wish to turn on this database setting go to Setup Files > Setup Options > Other Settings and check the box to the left of "Use Estimate FX Rate for Production Invoices".