We live in a global economy and it’s common for businesses to operate in multiple countries. We’re going to focus here mostly on multi-currency reporting for multiple entities in a group.
What is Multi-Currency Reporting?
Xero itself does a quite a good job of multi-currency reporting within one company. However, what if you have 2 companies, or 20, operating in different currencies?
As an example, some of our European customers might have their French head office trading in Euro. To add to this, they also have subsidiaries in the UK (using GBP), Switzerland (CHF) and Iceland (ISK). In these cases, you will need a tool like Calxa to get true multi-currency reporting across this group. Whether you need a P&L and Balance Sheet for statutory reports or monthly management reports, Calxa offers the full range. Simply, prepare financial statements to report in local currency or across multiple currencies.
Overview of Multi-Currency Reporting Setup in Calxa
Our Consolidation Guide is the place to get all the details but here’s the quick summary on what you need to consolidate your multi-currency group in Calxa:
- Get the Company Data: Link Calxa to each company. As well as Xero, this could be QuickBooks, or MYOB if you are in Australia or New Zealand. Use a Manual Organisation and import actuals for other accounting systems.
- Set the Base Currency: Do this for each company in Settings, Organisation Settings, General.
- Create the Common Account Structure: Use Calxa’s Account Trees to generate a common layout and to eliminate inter-company accounts.
- Set Up your Group: Create an Organisation Group and nominate your reporting currency and year-end date.
- Build Budgets: At this point, add budgets if you’re doing management reports and 3-way forecasts.
- Generate Reports: Now, start running your multi-currency reports and add to your report bundles.
Nominate your Reporting Currency
Each organisation group has a nominated reporting currency. This is usually the currency of the parent company or head office location. You’re not limited to just one reporting currency though. By copying the organisation group, you can quickly create another with an alternate currency.
This is useful where you have major investors who want to see the group accounts in their home currency.
Alternatively, you can set up an organisation group to have just one organisation in it. Use this where you are running a subsidiary company and need to report to your head office in their currency. They may be using some big ERP system, but you can keep your accounting simple while still giving them the information they need in the way they want it.
Currencies Supported in Calxa
When we developed multi-currency reporting for Xero users, our ambition was to be the best possible in this field. For that reason alone, it makes sense that you can access all currencies recognised by the United Nations and currently used for trading. This gives you a list of 170+ currencies.
Apparently, there are other reporting solutions that don’t give you that much flexibility. We’ve had customers come to us needing to report in Congolese Francs (CDF), Icelandic Kronor (ISK) and Algerian Dinar (DZD). We’ve not yet had to say no and don’t intend that to ever happen.
How Does Currency Translation Work?
There are international accounting standards that guide us in our implementation of multi-currency reporting. With Calxa, you have access to exchange rates daily from our provider.
It will calculate monthly averages for P&L accounts and month-end rates for Balance Sheet accounts. On any of these, you have the option to override the imported rates and specify your own.
For budgets, our default rate is to extend the latest rate into the future, assuming no changes. We realise that’s not always what you need though, so you can create as many scenarios as you like to model future rate changes. This helps you answer questions like:
How would my cashflow change if my currency appreciated or depreciated compared to some other currency?
There are also times when you want to permanently fix the exchange rate used on an account. This mostly relates to balance sheet accounts such as fixed asset purchases or capital investments. Set the rate and Calxa will always use that no matter how other rates have changed.
Xero Multi-Currency Reporting
What multi-currency reports does Calxa provide for Xero Users? Essentially, the short answer to this question is that almost all the reports in Calxa, all 150+ of them, can be run for a multi-currency group.
If you need data for statutory reports, you can choose from a range of Profit & Loss, Balance Sheet, Trial Balance and Statement of Cashflow reports. Report in your home currency or any foreign currency you need.
Management reporting is the focus of many of our customers and there Calxa really comes into its own. You can use it for key things like:
- Build budgets in each entity and combine them in your chosen reporting currency to compare to actuals.
- Easily create a bundle of reports to produce a balanced 3-way forecast for your entire group. Sometimes it makes sense to look at the consolidated reports for your group. Use the Create a Bundle option and the standard bundle kit to make this easy.
- However, there are times when you need to look at each entity side by side. We provide both a P&L Comparison and a Balance Sheet Comparison report for this purpose.
- These reports are especially useful for troubleshooting and you can choose to display Actuals, Budgets or a Forecast at a future date.
What Are the Limitations?
We are confident that our multi-currency consolidation for Xero (and other systems) is the best there is. You are welcome to check the accounting integrity of our calculations and assure yourself that our 3-way forecast truly does balance, but we’ll be very surprised if there’s a problem.
With our range of reports and support for all available foreign currencies, we give you the flexibility you need within your reporting. So, once you’ve done the setup and created a handful of report bundles, production and delivery is simple each month.
We do recommend that you talk to us if you need to consolidate more than 100 companies. Depending on the amount of data in each company, we may need to do some optimisation of reporting times. But, our team will work with you on that.
Getting Started with Multi-Currency Reporting