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

Simon Mallender commented · 11 December, 2023 13:14 · Report

Aged Reports - Run in different currency. You just closed this and invited me to add a new idea if I still have an issue. I do. We buy overseas product. We pay in foreign currencies. Having an Aged Payable by Currency report will show me how much of each currency I need to buy and by when in order to meet my needs. That's the report those of us in that situation need.

Submitting...
Kerry Bridle commented · 08 December, 2023 02:12 · Report

Please make this a priority

Submitting...
Ann Horstead commented · 02 December, 2023 00:58 · Report

Desperately need this. Too much time and potential for errors incurred doing it manually.

Please make this a priority.

Submitting...
Liesl Lowes commented · 03 October, 2023 02:39 · Report

Xero - when are you going to update this? You sell your platform as multiple currency and to bookkeepers / accountants but don't provide some basic accounting capability. Hurry Up!

Submitting...
Natasha Groenewald commented · 29 September, 2023 12:10 · Report

Further reply:

Thanks for bringing this to our attention, I can assure you we are very aware of the need to run the aged payables and receivables in different currencies. -DR

Submitting...
Natasha Groenewald commented · 29 September, 2023 12:08 · Report

I contacted Xero via Instagram message Their response still after 18 months:

“Hi, thanks for flagging this with us. Our Product team regularly reviews the suggestions and comments as we're always looking for ways to improve Xero, so we record and review all feedback and requests from our customers. However, as our Product team makes such a wide range of changes based on such a wide variety of factors, we can't always provide firm dates for which new services will be developed, or when. As you may already be aware, another way to get your voice heard is by adding your thoughts to our Xero Product Ideas. Please continue to share your thoughts around this, and I've also made another note of this to our Product team for their review. -HY”

Submitting...
Sandra van Kool commented · 29 September, 2023 08:36 · Report

With these new reports - does anyone else find that you need a crystal ball to know the 'start date' of your longest outstanding bill / invoice in order to configure the AP / AR report correctly? otherwise your data will be incorrect? Why dont these reports just run all open bills / invoices as of an end date only?

Submitting...
Sandra van Kool commented · 29 September, 2023 08:31 · Report

Anyone that is waiting on currency AP / AR reports - we have been as well for the 18 months since we changed from MYOB.
We prop up Xero with various apps in order to get decent reports. Its expensive and inconvenient.
Xero reports are becoming worse with each new development.

Submitting...
Andrew Thomas commented · 29 September, 2023 04:52 · Report

Had I known this before we switched - I wouldn't have moved from Sage.
Unless this is remedied shortly we will move back.
This is critical

Submitting...
Mark Hardy commented · 27 September, 2023 11:42 · Report

An aged debtors report that can report in FX currencies and filtered by these currencies is critical. Your suggestions above are a weak work around - it does not indicate to overseas managers the age of the unpaid debt in their FX currency. Given that Xero is trying to spread its wings globally, this FX aged debtor report is fairly mandatory - without it we cannot give complete reports to our overseas managers.

Submitting...
Cath Lamb commented · 21 September, 2023 02:06 · Report

Please be aware anyone who uses the Receivable or PayableInvoice Summary - Approved, sent and paid report. It also reports deleted, voided, etc, invoices. Which I didn't realise till I'd trawled through each individual transactions wondering why my totals didn't match...

Submitting...
Stuart Isbister commented · 19 September, 2023 23:28 · Report

The comment on this appears to suggest that this report is available in the currency that it is owed. Why is it not?
If we owe an amount in EUR we need to pay it in EUR!! having the value in GBP (or the default currency) is hopeless!!

Submitting...
Caroline Ryan commented · 16 September, 2023 00:01 · Report

Would be great if a report was available for a supplier who is from Austria, the total gives out in sterling but be good if we could have a column showing value in euros so I can compare with our supplier and match reports. Found a report Aged payables detailed with total, current months and older months, reference number and date/due date but nothing for euro amount.

Submitting...
Lana Nicholls commented · 14 September, 2023 23:34 · Report

Is there any update on this ?
All Xero need to do is to add "Outstanding/unpaid in Source currency" option in Filters! Simple as that!

Submitting...
Hilmi Dabbagh commented · 02 September, 2023 15:35 · Report

Xero reasoning for retiring the old reports is that they can't keep supporting two sets of reports. I think it is not convincing reason. Just leave the old reports set as is until the new set of reports meets at least what the old reports did.

Submitting...
Solomon Amoakwah commented · 02 September, 2023 04:07 · Report

I'm still struggling to comprehend why this straightforward request remains unresolved.The new reports, in my view, serve no purpose. We require the previous report, where both the source and base currencies are clearly displayed. This is a fundamental requirement. It's important to listen to user feedback rather than imposing changes. We are paying for the service and are expressing our preferences. We kindly request the reinstatement of the old reports.

Submitting...
Mbali Dhlamini commented · 23 August, 2023 03:41 · Report

Yes, this is a very important feature to us. Even though our base currency is ZAR, we have suppliers who send their invoices in USD, and we pay them in USD.

It becomes a hassle when making payments because the amounts reported are converted to ZAR. It honestly defeats the purpose of the aged payables report when you cannot use it.

Submitting...
Sales Interiors Australia commented · 17 August, 2023 11:50 · Report

May i know how could the older version has this option and the new version doesn't? Did Xero decided to reduce the functionalities with the new interface?
Not having a summary with respective currencies is not user friendly at all.
Im sure there are any many companies using multiple currencies and facing the same issue. Are you going to include this function anytime soon?

Submitting...
Sales Interiors Australia commented · 17 August, 2023 11:27 · Report

May i know how could the older version has this option and the new version doesn't? Did Xero decided to reduce the functionalities with the new interface?
Not having a summary with respective currencies is not user friendly at all.
Im sure there are any many companies using multiple currencies and facing the same issue.

Submitting...
Jonathan Martin commented · 17 August, 2023 01:58 · Report

None of your suggestions provide the ability to show the TOTAL BALANCE in the source currency. It is disgusting that you feel it appropriate to remove functionality for paying customers.

Submitting...