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

Cheryl Martin commented · 10 August, 2023 02:40 · Report

All well and good suggesting the above, but the Receivable invoice summary does not match the trade debtors value.

If you select a date range of 01/01/2019 - 31/07/2023, and then filter the status to approved only (as others are paid etc) this should be the value of your debtors. However there is a glitch in the report, as if a customer has paid after the date range selected e.g. 03/08/2023, even though the reporting period is before, it will change the status to paid so then this is omitted from the balance.

We urgently require a solution to this, as we are not able to obtain a multi-currency trade debtors report which we have to submit to our bank on a monthly basis.

Please please can this be resolved as a matter of urgency!

Submitting...
Duncan Bye commented · 09 August, 2023 03:43 · Report

very helpful indeed!!

Submitting...
Alice Pearce commented · 09 August, 2023 03:17 · Report

This would be so helpful

Submitting...
Caroline Ryan commented · 09 August, 2023 03:12 · Report

I have a supplier from Austria so we deal in euros but can't find a report now for payment due with sterling and euro figures showing-how can this be reported for the future as my supplier may need activity/remittance reports.

Submitting...
Hilmi Dabbagh commented · 07 August, 2023 20:10 · Report

So sad the old reports retired before having this feature in the new one.

Submitting...
Sharon Bolderson commented · 07 August, 2023 18:21 · Report

I don't know if this is helpful, but I raised a ticket and got this response:

Hi

Thank you for reaching out to us.

Our Product team are working towards providing the conversion rate footer on the New reports to maintain consistency with the older report. However, we're currently unable to provide a date for when this will be available.

In the meantime you can add a footnote and enter in this information.

You can add a notes column to link report amounts to text elsewhere in the report. Simply:
Add a text block and enter the note detail.
Insert a Note column.
Click into the Note column for the report line you want to link to the note detail, and select the related number.

Please note that when adding a note to the report, you'll need to manually add the exchange rate details as it isn't currently possible to include a currency exchange placeholder to pull the exchange rate data from the Currencies settings.

You'll therefore need to look up at the exchange rate set at the date of the report in your organisation currency settings to add the exchange rates used for conversion.

I've attached links to our support articles with detailed instructions on how to do this.

Xero Central articles:

View exchange rate or conversion rate

Add text blocks and notes to reports

Submitting...
Lauren Richards commented · 04 August, 2023 00:14 · Report

Please provide aged reports showing amount due in the different currency ASAP, it is a crucial element required for reporting tasks for our clients.

Submitting...
Linda Sekobelo commented · 03 August, 2023 00:32 · Report

Please reinstate the aged payable bills activity reports tor reflect both local and base currency as this function is very crucial.

Submitting...
Lyndy Mok commented · 31 July, 2023 19:00 · Report

It is import to GENERATE AP AR DETAIL/SUMMARY AGING REPORT IN FOREIGN CURRENCY. THE CURRENT REPORT ONLY SHOW MY HOME BASE CURRENCY SGD, I NEED TO REPORT THE FOREIGN CURRENCY TO MY AUDITOR. PLEASE SERIOUSLY LOOK INTO IT. THANKS

Submitting...
Anna Aston commented · 27 July, 2023 14:22 · Report

I have just tried to run an aged payables report in foreign currency with the new reports, what an absolute nightmare. Please do not retire the old reports until you have this functionality in the new reports. Its going to make life very difficult!!

Submitting...
Cristina Alford commented · 17 July, 2023 13:04 · Report

It is incredible that we have not received any updates from Xero regarding this issue.

They are ignoring our comments. today they sent an email informing they are retiring old reports. There is a list of reports that won't be retired and AP/AR reports are not included.

QUESTION: Do you actually understand this is critical for all users that deal with foreign currency transactions?

We require urgently not to retire these reports until the new version is a better option for the users.

Thank you
Cristina

Submitting...
Natasha Groenewald commented · 14 July, 2023 22:17 · Report

Where do we find the Supplier Invoice Activity and Customer Invoice Activity reports?
Its not under reporting...

We have been asking for a viable option or solution since April 2022.
Surely there has been enough time for Xero to find a solution to this critical issue. "We won't be finished before 31 July" is just not acceptable.

I am not sure the persons responsible for updating the features actually have any accounting background.

No use in something looking pretty, but its not usable

Submitting...
Lorna Fraser commented · 14 July, 2023 20:26 · Report

Any update from Xero or are they just going to take away the existing functional reports and replace them with one's that clearly aren't going to satisfy the users of their product? It is extremely frustrating... I really don't want the upheaval of moving to a new accounting system, but really do feel this is the only option.

Submitting...
Flavio Cecconi commented · 14 July, 2023 11:42 · Report

I agree with the last comment. Do not retire the older reports while you have a solution for this. It doesn't make any sense to move to a new report when you don't have any alternative in the new reports options.

Submitting...
Mayam Petak commented · 14 July, 2023 01:33 · Report

Kindly extend the old report versions with foreign currencies until you fix the new reports.

Invoice Payable Summary/Detail, needs more work - I can see redundant line figures and does not total outstanding in the report, which causes additional work time.

Submitting...
Catherine McManus commented · 13 July, 2023 11:26 · Report

Hi,

I agree with Ian Jabson, we need this fixed ASAP - Please, please keep old report versions with foreign currencies available.

If it ain't broke then don't fix it - why oh why did you get rid of this vital feature?

Please bring it back

Catherine McManus

Submitting...
Ian Jobson commented · 11 July, 2023 11:52 · Report

Please fix this ASAP. Its going to drive customers into the arms of your competitors.
Maybe keep the old aged payables report live until you have a fix for the new report. Taking a very important feature away before providing the fix is not great for business.

Submitting...
stephen forrest commented · 28 June, 2023 14:58 · Report

As pretty everyone else that is using foreign currency has already commented the lack of ability to report in the supplier / debtor base currency ( and summarise the information) is a massive backward step.

The report upgrades are supposed to make things easier not more difficult. Why change something that was already working really well??? The latest change has cost at least an additional half hour/ day. Maybe a bit of beta testing with customers that actually use the features before mandating change would be a good idea!!

Submitting...
Anne Mooney commented · 20 June, 2023 02:18 · Report

It is bad enough that we cannot run an aged debtor report for a particular currency in Xero, I have to export and delete and put a formula in with the exchange rate to be able to produce a USD Aged debtor report.
Now, with the new version the foreign currency customers are not even identified with 'note 1' so it will make my job a lot more time consuming.
I thought when new versions of reports were produced it should make things better, not worse.

Submitting...
Cath Lamb commented · 20 June, 2023 01:33 · Report

I was told this back in April

"Please note, the old report will be retired on 31st of July 2023, however our Product team is actively working on implementing multicurrency functionality on the new reports before this deadline".

Seems they've gone from promising action before the deadline to saying it won't be available by then.....

Thanks Xero

Submitting...