Use multiple currencies
Account for multiple business entities with different currencies in your financial statements.
Last updated
Was this helpful?
Account for multiple business entities with different currencies in your financial statements.
Last updated
Was this helpful?
Watch these videos:
Phocas Demo:
Phocas Academy:
Financial Statements seamlessly handles Profit and Loss, Balance Sheet, and Cash Flow reporting in a range of currencies. This includes calculating the Foreign Currency Translation Reserve (FCTR) on the Balance Sheet and the impact of exchange rate fluctuations on the Cash Flow statement.
Phocas automates the process of multi-currency consolidation, while providing transparency into exchange rate effects. Understanding how Phocas calculates Cash Flow adjustments helps you to interpret financial reports accurately and manage foreign currency impacts effectively.
The Profit and Loss treatment is set up during the Implementation process. Then, Financial Statements revalues the Balance Sheet for each reporting period at close rates and calculates the exchange rate movements in your Cash Flow Statement.
In the Balance Sheet, the local currency conversion is handled as follows:
All Assets and Liabilities are the local measures converted by their respective currency exchange rate at close date.
The Equity group is the reporting measure at the transaction rate.
A Foreign Currency 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.
The local currency cash transactions are converted and consolidated into a reporting currency Cash Flow statement, in which:
The Operating, Investing, and Financing cash flows' reporting values (total net cash from activities) are the local value translated at the exchange rate at the time of the transaction.
The Foreign Currency Translation Adjustment (FCTA) is calculated as follows:
Foreign currency gains or losses on cash at the start of period, revalued at close rates
Plus
Foreign currency gains or losses on the local currency transactions at close rates less the reporting value equivalent.
The multi-currency feature allows you to display Balance Sheet statements for multiple entities with different local currencies, in an appropriate reporting currency. To set this up for your organization's needs, there are three key steps, including the addition of your exchange rate data.
Click the Settings button > Currency Settings in the top right corner. Then, 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.
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.
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.
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.
Open the Balance Sheet statement 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.
To view the multi-currency information more clearly, change your view of the financial statement:
1. Why does my Balance Sheet show a movement in reporting currency but my Cash flow doesn't?
If there is no movement in the local currency for an account, then any change in the reporting currency balance is due to exchange rate fluctuations. The Cash Flow statement reflects actual cash transactions, while the Balance Sheet captures currency revaluations.
2. How does Phocas determine which exchange rate to use?
Phocas references the reporting values, which typically have the average rate for transaction-based movements and the closing rate for period-end balances.
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 more detailed information.
This method replaces the exchange rate file () 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.
Use the to replace the file.
This method adds a new file that contains the exchange rate data as a in your Phocas site. There are two ways to do this. The recommended way is to use the . However, you can also add a file via the Balance Sheet Exchange Rates window, as outlined below.
Going forward, if you want to upload a new version of the file you used above, you can use the rather than repeat the above steps.
Scroll down to the Equity group row and expand it to view the foreign currency translation reserve values. See the section above to learn about how the local currency conversion is handled.
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 .
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 . You might also want to that display in the grid.
Open the Cash Flow statement and locate the Foreign currency translation adjustment row (automatically calculated). Expand the row to view the underlying data. See the section above to learn about how the FCTA is calculated.