LogoLogo
Release notesMore help and supportPhocas website
  • Home
  • Getting started
    • Navigation
    • Homepage
    • Data access
    • User licenses, profiles and permissions
    • Account settings
    • Databases
    • Periods
      • Offset dates
      • Default period for a database
    • Sharing and folders
      • Share a dashboard, favorite, or alert
    • Subscriptions
  • Analytics
    • Take a tour of Analytics
    • Work with the grid
    • View a summary of the data
    • Customize your view (Analytics)
      • Change the mode
        • Period mode
        • Period Variance mode
        • Period Stream mode
        • Moving mode
        • Stream mode
        • Total mode
        • Transaction mode
        • Matrix mode
        • Matrix Variance mode
        • Matrix Share mode
        • Variance mode
        • Search mode
        • Market mode
        • Custom mode
      • Change the properties (Analytics)
      • Change the measures (Analytics)
      • Change the stream
      • Use the activity filter
      • Change the data format
      • Change the period (Analytics)
    • Drill down into your data (view transactions)
    • Filter data (use dimensions)
    • Select data (Analytics)
    • Focus on data (Analytics)
    • Copy or export data
    • Search for data
      • Perform a basic search
      • Perform an advanced search
      • Search for similar or comparative data (right-click filter)
    • Add levels to the grid (grid nesting)
    • Compare data with Matrix mode
    • Get more options for viewing data
    • Visualize your data in a chart
      • Bar and Column charts
      • Combo chart
      • Pareto chart
      • Waterfall chart
      • Line chart
      • Area and % Area charts
      • Pie and Donut charts
      • Bubble chart
      • Radar chart
      • Gauge chart
      • Bullet chart
      • Summary and Ring Summary charts
      • Map charts
      • Configure the chart options
      • Select and focus on a chart segment
      • Export a chart as an image
      • Use the chart legend
    • Save favorites and add to dashboards (Analytics)
    • Reset data
    • Phocas AI
  • Flex Modes
    • Switch modes
    • Change the period (Flex Modes)
    • Filter data (Flex Modes)
    • Compare data in a matrix
    • Apply conditional formatting
    • Create a nested view
    • Manage columns (Flex Modes)
    • Save and share a favorite (Flex Modes)
    • View your data in a chart (Flex Modes)
  • Financial Statements
    • Take a tour of Financial Statements
    • Overview of access to financial statements
    • Customize your view (Financial Statements)
      • Change the properties (Financial Statements)
      • Change the measures (Financial Statements)
      • Change the period (Financial Statements)
      • Change the streams and scenarios
        • Change the budget data
      • Change the columns
      • Change the style
      • Change the rows (activity filter)
    • Filter the financial information
    • Select and focus on data (Financial Statements)
    • Copy or export financial information
    • Add a level in a financial statement
    • View financial information in a matrix (change column groups)
    • Add and view comments (Financial Statements)
    • View transactions (Financial Statements)
    • View financial information in a chart
      • Create a Pie and Donut chart (Financial Statements)
      • Create a Value card
      • Export a financial chart widget as an image
    • Save and share favorites (Financial Statements)
    • Add financial analysis to a dashboard
    • Manage financial statements
      • Overview of financial statements and dimensions
      • Create a financial statement
      • Delete a financial statement
      • Customize a financial statement
        • Rename a financial statement
        • Reorder a financial statement
        • Customize account groups
        • Customize calculations
          • Functions for Profit & Loss calculations
          • Formulas for financial ratios
        • Customize headings and spacers
        • Set the revenue row in a Profit & Loss statement
        • Customize columns
        • Customize a Cash Flow statement
          • Common account mapping for Cash Flow statements
        • Rebuild the database
      • Set the financial year end date
      • Map the Retained Earnings account(s)
      • Restrict access to accounts
      • Manage streams and scenarios
        • Manage budget streams (Financial Statements)
      • Create a budget (Financial Statements)
      • Use statistical streams
      • Use multiple currencies
      • Manage dimension groups
      • Map categories from your Chart of Accounts
  • Budgets & Forecasts
    • Overview of key terms and concepts
      • Budgets versus forecasts
      • Users and data access
      • Relationship with the Financial Statements module
      • 3-statement budgeting
      • Filtering methods
      • Demand planning
      • Loan repayments
    • Take a tour of Budgets & Forecasts
      • Explore the budget workbook
      • Explore the forecast workbook
      • Explore the Balance Sheet and Cash Flow budgets and forecasts
    • Customize your view (Budgets & Forecasts)
      • Filter a worksheet (search for items)
      • Group period columns
      • Use layouts
    • Use session filters
    • Edit values in a worksheet
      • Open workbook notes
      • Use keyboard shortcuts
      • Copy and paste values
      • Use comparison rows
      • Use sum and working lines
      • Use formulas
      • Spread totals
      • Revert to the baseline values
      • Edit the Balance Sheet budget
      • View and use headcount data
    • Refresh a workbook
    • Use workflows
      • Contribute to the workflow
      • View the workflow history
      • View workflow comments
    • View budget information in a chart
    • Open baseline, comparative, or opening balance data
    • Review the budget or forecast
      • Add and view cell comments
      • View and restore the cell history
      • View the audit log
      • Compare actuals, budgets and forecasts
    • Export a workbook or worksheet tab
    • Manage budgets and forecasts
      • Create a budget workbook
        • Best practices for efficient budgeting
        • Filtered budget or forecast
        • Budget by region and branch
        • Multi-currency budget
        • Unclassified data
        • Period types in budgets
        • Additional measures for driver-based budgeting
      • Create a forecast workbook
      • Clone a workbook
      • Import a budget or forecast
      • Edit the workbook setup
      • Roll a budget forward
      • Add more detail to a budget or forecast
      • Add worksheet tabs (drivers)
        • Balance Sheet and Cash Flow tabs
        • Manual Entry tab
        • Database tab
        • Headcount tab
          • Headcount tab FAQs
        • Reference tab
        • Lookup tab
        • Allocations tab
        • Scratch Pad tab
      • Manage worksheet tabs
      • Add notes to a workbook
      • Customize the format of measures
      • Manage the workflow
      • Manage user access and notifications
      • Publish a budget, forecast or other worksheet tab
      • Fix the baseline in a budget
      • Delete or restore a workbook
      • Delete a stream (Budgets & Forecasts)
  • Rebates
    • Overview of rebates
    • Get started with Rebates
    • Projects
    • Rules
      • Parent-child rebate rules
      • Rebates calculation methods
      • Yearly rebates
      • Quarterly rebates
      • Monthly rebates
      • Whole rule period rebates
      • Retrospective rebates
      • Pro rata rebates
    • Calculations
      • Run a calculation
      • Schedule calculations
      • View calculation results and transactions
      • Post calculation results
    • Seasonal calendars
    • Rebates analysis
    • Rebates near miss analysis
  • CRM
    • Overview of CRM
    • Agenda
    • Contacts
    • Accounts
    • Leads
    • Activities
      • Microsoft 365 Outlook calendar integration
    • Campaigns
    • CRM analysis
    • CRM administration
  • Favorites
    • Save a favorite
    • Manage favorites
    • Set a favorite as your default view
    • Use alerts
  • Dashboards
    • Use dashboards
    • Create a dashboard
    • Set a dashboard as your homepage
    • Manage dashboards
  • Administration
    • Overview of access to data (Administration)
    • Users
      • Add, update or delete a user account
        • User maintenance form
        • User permissions
      • Create a user template
      • Manage a user's database access and restrictions
      • Manage user passwords
      • Monitor user activity
      • Lock user accounts
      • Impersonate a user
    • Profiles
    • Folders (Administration)
    • Favorites (Administration)
    • Dashboards (Administration)
    • Subscriptions (Administration)
    • Periods (Administration)
      • Period types
      • Working days
    • Databases (Administration)
    • Sync Sources
    • Connectors
    • Configuration
      • Set up SSO
      • Set up SSO with Microsoft Entra ID
    • Logs
    • Designer
      • Modify a database
      • Get your data into Phocas
      • Design a database
        • Create a database
        • Add (connect) data to a database
        • Map data to the database
        • Save your database design
      • Design a financial database
      • Build a database
      • View and revert to older design versions
      • Add a budget file to a financial database
      • Add a budget file to a non-financial database (easy budget upload)
    • Sync
      • Automatically join or split items during Sync (split view)
      • Schedule the sync process
      • Migrate Sync
      • Test the sync process
    • Reserved words and characters
    • End of year maintenance tips
  • OTHER INFORMATION
    • File upload
    • Encrypt (share secrets)
    • Glossary
    • Release notes
      • Analytics release notes
      • Flex Modes release notes
      • Financial Statements release notes
      • Budgets and Forecasts release notes
      • Rebates release notes
      • Administration release notes
    • System requirements
    • Technical limitations
    • Security information
    • Scheduled upgrade and maintenance periods
    • More help and support
Powered by GitBook

© Phocas Software

On this page
  • How it works
  • Set it up
  • 1. Edit the multi-currency settings
  • 2. Add the exchange rate data
  • 3. Select the Equity settings in the statement
  • View financial information in reporting currency
  • Balance Sheet
  • Cash Flow
  • FAQs

Was this helpful?

  1. Financial Statements
  2. Manage financial statements

Use multiple currencies

Account for multiple business entities with different currencies in your financial statements.

PreviousUse statistical streamsNextManage dimension groups

Last updated 1 month ago

Was this helpful?

  • Multi-currency is an add-on feature suitable for multi-entity organizations. To request it, please contact your Phocas account manager.

  • For multi-currency to work, the database needs to have at least one local currency measure and one reporting currency measure.

  • User permission: Manage Custom Statements and Admin > Sync. As this is an advanced feature, you might prefer to ask our Support team to set it up for you.

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.

How it works

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.

Example of the FTCA calculation

To illustrate the consolidation calculation, consider a group that uses GBP as its reporting currency but has a USD subsidiary.

The exchange rates are:

  • 1USD = 0.8GBP at the beginning of the period

  • 1USD = 0.77GBP at the time of the transaction

  • 1USD = 0.75GBP at the end of the period

Set it up

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.

1. Edit the multi-currency settings

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:

  1. Select the measure that contains the local currency values.

  2. Select the dimension that determines the local currency of each item, such as Country, Region, Company, and so on.

  3. 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:

  1. Select the measure that contains the reporting currency values, such as Amount, Customers, Headcount, Barrels, and so on.

  2. 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.

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)
  1. 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.

  2. Select the required data item. Its exchange rate data displays in the grid underneath.

  3. 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.

  4. 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.

  1. In Financial Statements, in the Balance Sheet Exchange Rates window, identify the name of the file that is in use.

  2. Back in Financial Statements, refresh the screen to view the updated data.

Add a new file

When you upload new exchange rate data, you overwrite any existing (previously uploaded) exchange rate data.

  1. In the Balance Sheet Exchange Rates window, select the I have a new file option from the Source list.

  2. Click Upload and select the file that contains the new exchange rate data.

  3. Select how you want to transform the file: Determine the layout as 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).

  4. Click Update.

  5. Check the data uploaded as expected.

  6. 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.

  7. Click Update.

3. Select the Equity settings in the statement

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.

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

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:

Cash Flow


FAQs

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.

Financial consolidation
Use multiple currencies
Use sync
sync source
Upload files tool
sync source
Upload files tool
Upload files tool
How it works
Add a level in a financial statement
View financial information in a matrix (change column groups)
change the columns
How it works
image-20240625-230452.png