Reporting: Aged Reports - Run in different currency – Share and support customer ideas for Xero

Reporting: Aged Reports - Run in different currency

Ability to run different currencies in Aged Payable report.

Purpose: Because some organisation make their sales in a different currency, so it’s beneficial for them to run these reports using different currencies.

264 votes

AdminXero Team (Admin, Xero) shared this idea · 09 August, 2012 · Report… · Admin →

not planned ·

AdminHannah G (Admin, Xero) responded · 11 December, 2023

Hi everyone, thanks for all the valuable feedback and ideas shared regarding aged reports in different currencies.

It seems that this idea picked up several different themes over time so we want to clarify where we’re at with this. In the past few months our product team has worked hard to improve the functionality in this area. That includes releases for totals when run in a single currency - so you can see a total of your foreign currency, and disclosures 🎉

We’ve introduced FX disclosures on the Aged Reports, which displays as a note at the bottom of your report or as an icon next to figures on the report to indicate that they include revalued foreign currency amounts to give you more flexibility. The disclosure will contain all the currency information that has been used to calculate the figures in your report. The exchange rate note will display by default, but we’ve heard from some customers that they want the ability to hide the disclosure. We’ve added this option under the More button. Hiding the disclosure this way will also remove it from all exported versions of the report. The disclosure can be re-added to the report later if desired.

While we haven't met the original request, we are confident that the new disclosures functionality will make it easier to understand foreign currency balances. Being transparent we have no plans to build the ability to run aged reports in a different currency. If you still find that you need the ability to run aged reports in a different currency, even using the improvements we’ve released, you’re welcome to create a new idea so we can gauge user need from this point on.

Show previous admin responses (3)

under review ·

AdminKelly Munro (Community Manager, Xero) responded · 24 May, 2023

We appreciate the depth of feeling from everyone regarding running Xero’s aged reports in foreign currency.

Following retirement of our old reports on 31 July ( https://central.xero.com/s/article/Retiring-old-versions-of-reports-in-Xero ) , we’ll be looking at adding new features and being able to run the aged reports in a different currency will certainly be in consideration.

To help with your foreign currency needs now we have recently released some common format reports in the Payable and Receivable Invoice reports. you’ll find these alongside the new Aged Receivables Summary and Aged Payables Summary reports within the left hand side panel under ‘Related reports’.

Payable Invoice Summary – Approved and paid and Receivable Invoice Summary – Approved, sent and paid

These reports list every outstanding payable or receivable item. By configuring the start date to include all outstanding items, and excluding prepayments (under the More button), you’ll have a list where the total balance due matches your Aged report. You’ll be able to see the original currency of every item and the amounts in source and base currency.

Supplier Invoice Activity and Customer Invoice Activity

Use these reports to see all activity for a customer or supplier for a chosen date range. Add the Original Currency column to see which currency the item was issued in.

After you’ve configured the reports the way you want them, remember to save them as Custom ( https://central.xero.com/s/article/Create-reusable-custom-report-layouts ). You can also favourite a custom report ( https://central.xero.com/s/article/Access-and-browse-reports#Markareportasafavourite ) so it’s available in the Accounting menu dropdown, to help you navigate to your most used reports quickly.

Currently, we’re working on adding notes to the aged reports showing the exchange rates used to convert to base currency. This work is underway but won’t be finished before 31 July – In the meantime, if required you can add your own note to the report using the Insert content button ( https://central.xero.com/s/article/Add-text-blocks-and-notes-to-reports?userregion=true#Addanote ). Rates used on this report are taken from the Currencies screen under Settings. We have another idea centered around this ( https://productideas.xero.com/forums/939198-for-small-businesses/suggestions/45418840-aged-payable-receivable-report-foreign-currency ) that we’ll be keeping you updated through. Thanks

submitted ·

AdminKelly Munro (Community Manager, Xero) responded · 03 February, 2023

Understand all the enthusiasm and interest in being able to see the currency the business deals in included in more of Xero’s reports.

As many will be across, we’re working hard to make sure you have all the functionality you need in new reports, before older versions are retired on 31 July 2023 – See more on this in Xero Central ( https://central.xero.com/s/article/Retiring-old-versions-of-reports-in-Xero )

This being the main priority and focus for our reporting product teams, immediate developments for additional features like what’s being asked here aren’t in the pipeline at present.

Some of our new reports already convert foreign currency amounts to your base currency and do the appropriate revaluations and gain/loss calculations for financial reporting. The Account Transactions report also lets you view transactions in their original currency amounts, and coming soon – we’re developing the Receivable and Payable Invoice reports to view, sort and filter transactions by their original currency.

We’re continuing to stay on the beat of all the feedback about reports across product ideas, and will have more opportunity to review new developments when older reports have been retired.

submitted ·

AdminRudi Moritz (Admin, Xero) responded · 28 March, 2022

An error occurred while saving the comment

Neil Passingham commented · 17 May, 2023 23:41 · Report

This is an area that Xero seems to be very poor on & looking back through the requests below, am I wasting my time asking for a report change to see amounts in EUR (when the base currency is GBP)?

I have been a big champion of Xero over the years but the lack of progress here (and concern on your part) is worrying!

It is very hard to match bank receipts (in EUR) with the amounts on the Aged Receivables report. It causes a lot of extra reconciliation work for us!

Submitting...
Laura Hollands commented · 17 May, 2023 22:25 · Report

My first response when using Xero 2x years ago which was recommended by our accountants, was that Xero should not be calling them selves multi-currency when they cannot run a simple report like creditors in the currency due for payment. So many comments added today should enlighten Xero to the importance that simple foreign currency reports are needed ASAP.

Submitting...
Sam Todescato-Rutland commented · 17 May, 2023 21:56 · Report

QuickBooks can accommodate this requirement, why can't Xero?

It's beginning to cause major problems.

I may need to rethink using Xero for all my clients and move to something that better suits my needs.

Such a pity.

Submitting...
Chee Hao Wong commented · 17 May, 2023 21:54 · Report

Not to mention the multicurrency is giving us unknown cents difference after the revaluation...kinda hard to sell the multicurrency feature and lesser headache to explain

Submitting...
Lee Forbister commented · 17 May, 2023 21:52 · Report

Loving how this getting traction, the lack of this simple feature to split out and report my debtors into EUR, GBP, USD, CHF et al adds so much time and Excel trickery to my bank IDF reporting each month.

As many have said, the strong multicurrency element of Xero was a major draw for me to bring the entire international group of companies over from Quickbooks. Seems to be going backwards not forwards!

Submitting...
Natasha Groenewald commented · 17 May, 2023 21:46 · Report

Since I'm not getting any answers on here, I will have to ask this question on Instagram and Facebook...

Submitting...
Helen Chandler commented · 17 May, 2023 21:36 · Report

I actually cannot believe that after all this time it is not even "in the pipeline". I do agree with David and others that it feels like the multi-currency has been mis-sold and in turn I have inadvertently mis-sold it to my clients. I am amazed that this isn't seen as an important feature. So many companies large and small deal in other currencies. OK it will sort out the accounting side but I would ask do Xero have any bookkeepers in their development team? If you are dealing with large payable invoice runs its quite ridiculous the way it has to be dealt with in Xero. I have been a real Xero supporter and changed all our clients onto this software but really really disappointed with the response to this request.

Submitting...
Helen Chandler commented · 17 May, 2023 21:31 · Report

I actually cannot believe that after all this time it is not even "in the pipeline". I do agree with David and others that it feels like the multi-currency has been mis-sold and in turn I have inadvertently mis-sold it to my clients. I am amazed that this isn't seen as an important feature. So many companies large and small deal in other currencies. OK it will sort out the accounting side but I would ask do Xero have any bookkeepers in their development team? If you are dealing with large payable invoice runs its quite ridiculous the way it has to be dealt with in Xero. I have been a real Xero supporter and changed all our clients onto this software but really really dissapointed with the response to this request.

Submitting...
David Waterfield commented · 17 May, 2023 19:45 · Report

Kelly please stop telling us what xero can do - we want it to do more; xero could be said to have missold us their foreign exchange functionality which includes essential reporting. Stop adding whistles and bells - for example the 'new' bills screen. Do you have any accountants actually in the development teams?

Submitting...
Kylie Crowe commented · 17 May, 2023 10:59 · Report

It is very problematic to not be able to see foreign currency in accounts payable easily like we have been able to previously. One if the main reasons we went with Xero was for their capabilities with foreign currency. We are really hoping for a fix for this quickly.

Submitting...
Cheryl Clayton commented · 12 May, 2023 00:21 · Report

The new Accounts Receivable report does not show that there are different currencies on an account whereas the old report did with blue highlighted 1. If the new report showed the highlight it would be easier for me to balance the ledgers and at a glance show me the accounts that have various currencies

Submitting...
Justyna Stankiewicz commented · 21 April, 2023 20:48 · Report

Aged reports and accounts transactions in multi-currency

Submitting...
Theresa Nyamaropa commented · 17 April, 2023 22:51 · Report

This is a great idea - just to add to this, if this is not done earlier, please add the feature that iscurrently on the old reports, where you will be able to see the original currency that the invoice was raised in. It is easier for customers reconciliations if you have the original currency that the invoice was raised in.

Submitting...
Archie Ortiz-Cabutotan commented · 13 April, 2023 14:51 · Report

Hi admin,

Please make the multi-currency available for aged report as well, same way as "Profit&Loss New-Report in multi-currency" idea which has been recently granted.

Thank you.

Submitting...
Akira Ichimura commented · 13 April, 2023 02:32 · Report

I know that it is possible to see from the Sales and Purchase Ledgers the original currencies but it would be very helpful to be able to see in the Aged Receivables report the original currencies that the recievables are denominated it.

We were asked by one of our clients if it was possible to see the total recievables owed in original currency from customers.

This would be very helpful for our clients who sell to customers globally.

Thank you.

Submitting...
Ingrid De Visser commented · 04 April, 2023 02:40 · Report

We work with HSBC invoice finance, the report we use now, for outstanding debtors list in gbp and euro, will be cancelled after 31-07-2023. What alternative are you offerings us. In the contract we need to product a full aged outstanding invoices list per end of the month per currency.

Please advice urgently.

Submitting...
Laura Hollands commented · 23 March, 2023 22:26 · Report

if you have several large transaction foreign currency suppliers it is critical to be able to quickly and easily see what you owe for the foreign currency bills/balances to enable quick and easy checks and payments to be accurately set up. 2x years of using XERO with it's current method is very frustrating with foreign supplier accounts

Submitting...
Victoria Murray commented · 17 March, 2023 09:55 · Report

Accounts receivable and payable report detail should be able to have "invoice currency" and "invoice amount (source)" column.

I have to create my own separate accounts receivable detail or summary in USD.

Submitting...
Victoria Murray commented · 17 March, 2023 09:55 · Report

Accounts receivable and payable report detail should be able to have "invoice currency" and "invoice amount (source)" column.

I have to create my own separate accounts receivable detail or summary in USD.

Submitting...
Sean Farnell commented · 11 March, 2023 04:56 · Report

Really need this for payables & receivables, it's preventing a number of clients from switching to Xero

The ability to filter by currency would also be helpful
Thanks

Submitting...