LogoLogo
More 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)
    • 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
  • Method 1: Use the Budgets & Forecasts module
  • Method 2: Use the Designer module

Was this helpful?

  1. Budgets & Forecasts
  2. Manage budgets and forecasts
  3. Create a budget workbook

Multi-currency budget

PreviousBudget by region and branchNextUnclassified data

Last updated 8 months ago

Was this helpful?

There is a Phocas-wide project underway that will address multi-currency across the Analytics, Financial Statements, and Budgets & Forecasts modules. However, two interim solutions for multi-currency budgeting are available, as outlined on this page.

If your organization operates internationally, you will likely need to budget using multiple currencies. Multi-currency budgeting usually involves budgeting each region in the local currency and then viewing those budgets in a single reporting currency.

There are two methods for creating multi-currency budgets. Compare each method and select the one that best suits your business needs.

Method 1: Use the Budgets & Forecasts module

User permissions: Budgets & Forecasts and Manage Budgets & Forecasts

The Budgets & Forecasts method has three components:

  • The Main tab where you do the budgeting as usual in the local currency.

  • A Lookup tab to store the exchange rates for each of your regions.

  • A Reference tab with multiple measures (driver-based budgeting) to convert your budgeted local currency values to your reporting currency values. The reporting values are calculated by getting the local values from the Main tab and multiplying them by their respective exchange rates from the Lookup tab.

This method has two advantages:

  • The currency conversion happens in real time as local currency values are entered.

  • When you publish the Reference tab, both the local and reporting currency values appear in the budget stream in Financial Statements.

However, currently, there are some limitations to this method. Firstly, this method does not support 3-statement budgeting, and secondly, any General Ledger accounts or entities added to the Main tab also need to be added to the Reference tab.

Learn more...

(note the UI is out of date but the context is the same).

For example, suppose you have a budget that includes three regions: Australia, the UK, and the USA. You want to budget for those regions in their local currencies (AUD, GBP, and USD) and in one common currency, AUD, as that is where your head office is located.

Create the budget based on the applicable Financial database, ensuring you:

  1. Select the applicable dimension (Country) as Level 1 (so you can see the respective entities).

  2. Select the applicable local value (currency) measure.

to record the exchange rates:

  1. Use a descriptive name, such as FX rates.

  2. Clear the Category and Account checkboxes because you're only interested in the Country level.

  3. Enter a name for the row, such as FX rate, select the required number of decimal places, and select a suitable aggregation method, such as Median.

  1. In the Lookup tab, enter the FX rates for each country across the period.

to convert the local currency values into the reporting currency (AUD):

  1. Use a descriptive name, Reporting AUD.

  2. Select the same database and stream you used in the budget setup, but select the applicable reporting value measure (this is different from the one you selected in the budget setup). Select the required number of decimal places. Select the same Profit and Loss template you used in the budget setup and add a level for the same dimension you selected in the budget setup (Country).

  3. Set up the additional measures: a. Add an Input row, enter a name (Local Value), and select the Local Value measure. This will publish the local value to the Profit and Loss stream.

    b. Add a Lookup row, enter a name (FX), and select the lookup tab and row. You don't need to publish this row. c. Convert the primary input row to a calculation row and enter the following formula: (Local Value)*(FX)

    After you save and finish the setup, review the contents of the new Reference tab. It looks very similar to the Main tab, as you used the same template. When you expand any of the lowest-level rows, you’ll see two additional measure rows: one for the local value and the other for the exchange rate.

Link the Reference tab to the Main tab, so instead of using the prior year’s actuals (as per the tab setup), you use the values in the Main tab:

  1. Enter a formula into the first period cell of the first additional measure row (Local Value) that refers to the corresponding cell in the Main tab and press Enter. See .

  2. Copy the formula forward across the period, then select all the period cells and copy them down the expanded rows. See .

Complete the budget data entry on the Main tab. The changes to these local values flow through to the working (Local Value) rows in the Reference tab, where the reporting values are automatically updated.

Publish the Reference tab. The working (Local Value) rows are published to the local measure and the reporting values (account row values) are published to the reporting measure.

Method 2: Use the Designer module

User permissions: Administration > Designer and Sync

In Designer, you can add a transform column to the Budgets & Forecasts stream to convert the budgeted local currency value to a reporting currency value.

This method allows you to view the resulting currency conversion in Financial Statements immediately after publishing the local currency values from Budgets & Forecasts. Whereas you can use a Reference tab in the budget to display the resulting transformation from local to reporting value, the reporting value does not update in real-time within the budget. You need to both publish the budget and refresh the page to view the updated reporting currency.

Learn more...

For example, suppose you have a budget in which there are three regions, Australia, the UK and the USA and you want to budget those regions in both their local currencies (AUD, GBP and USD) and in one common currency, AUD, as that is where your head office is located.

In Budgets & Forecasts, create the budget for the three regions in the local value measure, then publish the budget to a stream in the Financial Statements module.

  1. Enter a title (Reporting Currency).

  2. Click Save.

Review the data in the new column (Reporting Currency), then drag the column up into Reporting Value measure in the Measures panel. Then click Save, then rebuild the database.

Back in Budgets & Forecasts, view the reporting currency in the budget using one of these methods:

  • Add a comparison row for the budget stream with the reporting value measure.

  • Add a Reference tab (no need for additional measures as in the above method) for the budget stream and reporting value measure, with an offset as 0, and add the same template and levels.

Complete the budget data entry for the local currency values on the Main tab. The reporting currency values do NOT update accordingly because the conversion calculations happen in Designer. To update those calculations, you need to publish the budget values to Designer.

Publish the Main tab to the existing stream.

Refresh the budget workbook, then expand the budget rows to view the updated reporting currency values.

This procedure requires the use of Designer, which is an advanced feature. If you are not confident using or have not had the required training, contact your Phocas account representative.

(note the UI is out of date but the context is the same).

In the Designer module, open the budget stream to view the local values. Click the green button, select the If-Then option and create the logic for the new column:

Enter the parameters, as illustrated in the image below. The parameters comprise of each country and its exchange rate. As Australia uses the local currency, it does not require an exchange rate.

Designer
Watch this video
Watch this video
Add a Lookup tab
Add a Reference tab
Use formulas
Copy and paste values
image-20240729-035653.png
image-20240729-041621.png
Add Transform column