Use multiple currencies
- Denise McGettigan
This is an additional feature suitable for multi-entity organizations. To request it, contact your Phocas account manager.
If you have permission to manage financial statements, you can set up the multi-currency feature for your organization. However, as this is an advanced feature, you might prefer to ask our Support team to set it up for you.
Financial Statements seamlessly handles Profit and Loss and Balance Sheet reporting in a range of currencies, including the balancing impacts of the currency conversion. Whereas the Profit and Loss treatment is set up during the Implementation process, this page outlines how you can revalue the Balance Sheet for each reporting period.
The multi-currency feature allows you to display Balance Sheet statements for multiple entities with different local currencies, in an appropriate reporting currency. The local currency conversion is handled as follows:
For non-equity accounts, the conversion is based on the respective Balance Date.
For equity accounts, the conversion is based on the reporting currency measure.
The balancing difference is displayed in an exchange rate conversion reserve account.
For multi-currency to work, the database needs to have at least one local currency measure and one reporting currency measure.
Step 1: Edit the multi-currency settings
You need to edit the currency settings to suit your needs.
Click the Settings button > Currency Settings in the top right corner.
In the Currency Settings window, select the Multiple currencies option.
Configure the local currency settings:
Select the measure that contains the local currency values.
Select the dimension that determines the local currency of each item, such as Country, Region, Company, and so on.
Selected the local currency (such as AUD (Australian Dollar), GBP (Pound Sterling), USD (US Dollar), and so on) for each of the entities in the dimension.
Configure the reporting currency settings:
Select the measure that contains the reporting currency values, such as Amount, Customers, Headcount, Barrels, and so on.
Select the reporting currency.
Set the translation reserve account using one of these options:
Select the None option to map the account to the default Foreign Currency Translation Reserve account.
Select the This account option, then select the required account from the list of your Balance Sheet accounts. By default, your first Balance Sheet account code is selected for you but you can change this to another account, as required. Start typing the code or account name to quickly find the account you want to use.
Click OK.
Step 2: Add the exchange rate data
You need to set up a link to the exchange rates you want to use in the Balance Sheet calculations. Typically, you do this every month. A range of file types are supported.
For example, suppose in your multi-currency settings you have a reporting currency of NZD and three local currencies, AUD, Euro, and GBP. You need to upload exchange rate data for each of those currencies.
Click the Settings button > Balance Sheet Exchange Rates in the top right corner.
The Balance Sheet Exchange Rates window displays a list of exchange rates that were previously added here (if any). There are different options for adding the new exchange rate data: select an existing sync source, replace a file or manually upload a new file.
Select an existing sync item (recommend for first time setup)
This method links to a sync source item that contains the exchange rate data. The item belongs to a sync source, which has already been added to your Phocas site. It might be an item that flows through from your ERP. See Use sync more detailed information.
In the Balance Sheet Exchange Rates window, select the required sync source from the Source list. An additional dropdown list of all the exchange rate items in that source displays.
Select the required data item. Its exchange rate data displays in the grid underneath.
Review the exchange rate data.
The data is automatically mapped to the items in your multi-currency settings, based on the header and data type of each column in the data item.
If any items are not mapped automatically or are mapped incorrectly, select the correct values from the dropdown lists at the top of the grid.
Select the Ignore option for any data columns you do not need.
Click Update.
Replace an existing file (recommended for subsequent updates)
When you upload new exchange rate data, you overwrite any existing (previously uploaded) exchange rate data.
This method replaces the exchange rate file (sync source) that is currently being used in Financial Statements with a file that contains the latest exchange rate data. This method is suitable after you have set up your Balance Sheet exchange rates, when you simply want to retain the setup but add the latest rates.
In Financial Statements, in the Balance Sheet Exchange Rates window, identify the name of the file that is in use.
Use the Upload files tool to replace the file.
Back in Financial Statements, refresh the screen to view the updated data.
Add a new file
This method adds a new file that contains the exchange rate data as a sync source in your Phocas site. There are two ways to do this. The recommended way is to use the Upload files tool. However, you can also add a file via the Balance Sheet Exchange Rates window, as outlined below.
In the Balance Sheet Exchange Rates window, select the I have a new file option from the Source list.
Click Upload and select the file that contains the new exchange rate data.
Select how you want to transform the file:
Determine the layout to be either currency columns with period rows or period columns with currency rows.
Include a header row (or not).
Select the format in which the exchange rate data was stored, either local currency over reporting currency (base) or reporting currency over local currency (numerator).
Click Update.
Check the data uploaded as expected.
Map the data in the exchange rate file to the items in your multi-currency settings.
Typically, these items are automatically mapped based on the header and data type of each column in the uploaded file.
If any items are not mapped or they are mapped incorrectly, select the correct the values from the dropdown lists at the top of the grid.
Select the Ignore option for any data columns you do not need.
Click Update.
Going forward, if you want to upload a new version of the file you used above, you can use the Upload files tool rather than repeat the above steps.
Step 3: Ensure the Equity settings in the statement are selected
Typically, Equity accounts are not revalued; they usually stay at the transaction rate. For example, your Retained Earnings should equal your profit for your prior years plus your profit for this year, to equal your closing balance.
The multi-currency feature revalues your net assets. To prevent the revaluation of a group such as Retained Earnings, select the Equity checkbox for that group in the setup window of each of your financial statements.
Step 4: View financial information in reporting currency
After you set up the multi-currency capability for a financial statement and upload the exchange rate data, you can see the local currency values converted into the reporting currency values.
Balance Sheet statement
Open the Balance Sheet and select the reporting measure from the Measures menu. A message displays in the top right corner of the statement to let you know the reporting currency you are viewing in the statement.
Scroll down to the Equity group row to view the foreign currency translation reserve values.
All Assets and Liabilities are the local measures converted by their respective currency exchange rate at balance date.
The Equity group is the reporting measure at the transaction rate.
A Foreign Currency Reserve reserve row is inserted into the Equity group, which calculates the difference between the Balance Sheet rate and the transaction rate of the net assets.
Change your view of the financial statement to view the multi-currency information more clearly:
Drag the dimension you used in the multi-currency setup, such as Country, to the Levels box to view the contribution of the individual items (countries) within the overall performance. If there is no translation reserve, it is because the local currency is the reporting currency. See Add a level in a financial statement.
Drag the same dimension to the Column groups box to transform the grid into a matrix format and view the performance of the items side-by-side against overall performance. See View financial information in a matrix (change column groups). You might also want to change the columns that display in the grid.
Cash Flow statement
Open the Cash Flow and locate the Foreign currency translation adjustment row that is automatically calculated.
Expand the row to view the underlying data.