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

Dipti Kanta commented · 17 January, 2023 21:00 · Report

It's very critical. please do urgently.

Submitting...
Joey Teng commented · 17 January, 2023 20:58 · Report

This is a crucial report to have, appreciate if this feature is available yesterday as this is quite a set back for not having this report.

Submitting...
Hayley Reeder commented · 13 January, 2023 00:44 · Report

Need the AR & AP reports in the currencies the transactions ware entered in, not just the base currency.

Submitting...
Bipin Shah commented · 10 January, 2023 03:42 · Report

Not sure if Xero should market the Premium subscription as a multi currency feature if it cannot produce A/R & A/P reports in multi-currency values. Very misleading if it does not do that. On Sage 50 it is possible to do so.

Submitting...
Natasha Groenewald commented · 10 January, 2023 00:09 · Report

We are not able to view the ledger for AP or AR in the correct currency.
This is a basic accounting necessity. Without this functionality the multi currency option is basically not viable

Submitting...
Dipti Kanta commented · 10 January, 2023 00:04 · Report

it is Critical for us

Submitting...
Mabel Pang commented · 05 January, 2023 22:36 · Report

Multi currency is critical to our business. This is international business environment and you cannot withdraw the older version of the reports without providing a solution to this. The balance sheet does not even tie with the AR & AP reports!

Submitting...
Bipin Shah commented · 04 January, 2023 00:47 · Report

Multi currency subscription (Premium) should have report options in multicurrency. Surely that is obvious expectation! I assued it would be as in Sage but was wrong.

Submitting...
Nicholas Tangney commented · 04 January, 2023 00:39 · Report

I really need this as a multicurrency business!

Submitting...
Natasha Groenewald commented · 24 December, 2022 00:59 · Report

I have contacted Xero on Instagram but was again revered to leave a suggestion on this page.

The lack of this functionality should be disclosed to paying customers so they can make an informed decision and possibly choose another accounting platform.

You cannot charge for something that is not available

Submitting...
Bipin Shah commented · 24 December, 2022 00:44 · Report

On Sage 50 it has always been possible to run the AR/ap reports in foreign currency. I assumed this is normal and instigated a migration to Xero and now find this is not possible of Xero, despite paying Premium subscription to allow muticurrency.

Big dissappointment!!

Submitting...
Andrew Maclean commented · 24 December, 2022 00:37 · Report

Just to say this was raised as an issue when I started using Xero 9-10 years ago. So please don't expect change now!
They have been charging my clients extra for multi-currency in all that time but can't even allow us to produce a currency report!

Submitting...
Natasha Groenewald commented · 21 December, 2022 00:37 · Report

I have contacted them on Instagram and was advised to post here.
No reply or any effort to make these very necessary amendments to the current reporting. Xero any update???

Submitting...
John` Temple commented · 21 December, 2022 00:32 · Report

This is super important for us as we have large client and supplier bases in EUR and USD

Submitting...
Chee Hao Wong commented · 19 December, 2022 20:47 · Report

Agreed with @David, Xero does not implement a lot of "basic" "accounting" feature which i suspect the software is not even developed by accountant, or they just trying to let 3rd party app to solve their problem

Submitting...
darren farrugia commented · 13 December, 2022 15:27 · Report

This is very important as we wanted to see today what was the total of USD outstanding. Can Xero be developed to do this please.

Submitting...
David Waterfield commented · 08 December, 2022 02:07 · Report

Again it seems a no brainer to me; and thanks John Watkins for the suggested workaround. But it seems to me Xero need to embed key features as standard reports and not leave it to the "app world". When will you address this xero?

Submitting...
Natasha Groenewald commented · 08 December, 2022 00:45 · Report

This is a big frustration. We capture multiple currencies and the report converts all captured currencies to GBP. This is a critical business control function and its ridiculous that this function is not available. Please have this fixed

Submitting...
Danietta Janse van Noordwyk commented · 05 December, 2022 20:08 · Report

Do we need to look at alternative accounting packages or is Xero going to resolve these issues?

Submitting...
John Watkins commented · 02 December, 2022 23:24 · Report

This is not my first comment on this issue and obviously it has been a crucial issue for my company as it is for many others. It may help many companies to read of the solution that we have implemented using the EntryRocket app that you will find in the Xero App store. While this is not a two click fix, it is very easy to implement. All of the local currency values are of course sat waiting in the Xero backend database and while it is bizarre that Xero does not offer a suitable report to display them, they are readily accessible through direct connection to the raw data tables. Speak to Vlad at Entry Rocket, which you can do through the chatbox on their website and request the invoice history data in local currency and any other fields you require such as the payment status. When you need the data, press the button on your new EntryRocket interface to receive a CSV file. You would probably want to make the CSV file data more presentable by manipulating the data in Excel but a better solution I find is to use MS Access to link the data directly into queries and reports designed in that program. Sounds complicated? Anyone familiar with Access would be able to set this up, to your precise requirements, in a couple of hours at most. I am John at Grakka Limited and happy to discuss further if it helps.

Submitting...