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

Annie Lindale commented · 02 December, 2022 15:00 · Report

Reconciling intercompany accounts between countries is a nightmare these days. Aged Receivable and Payables used to report the domestic and foreign equivalent in our New Zealand accounts. This made comparison a doddle. Now it requires a manual calculation to match items off. So ridiculously unnecessary!

Submitting...
Amish Patel commented · 16 November, 2022 21:57 · Report

This is a critical business control function. We would greatly need receivables in the currency that it was invoiced. The Home Currency tends to fluctuate a lot.

Submitting...
Dayo Adeyemi commented · 12 November, 2022 02:13 · Report

For us, the whole point in having a multi currency software, is the ability to also have reports and screen displays, that show the currency balances in the related FX currency. For the aged reports, the only alternative for us, as with comments from other users, is to locate the invoice via "view recent invoices report", then manually change this on downloaded excel aged report! Also for the screen display for these FX ledgers, because the total outstanding is in our base currency, GBP, we can't even see how much is outstanding without resorting to the same link to "view recent invoices report". Not ideal and a bit of a time waster when doing credit control functions and dealing directly with customers.

Is there any reason why XERO is not treating this matter as a priority and giving it the attention that it deserves?

Submitting...
David Waterfield commented · 10 November, 2022 23:42 · Report

Aged receivables too. Absolutley critical. Debt chasing is wonderful when my colleagues keep relying on the contact value in GBP!!!! Also reporting my debtors and creditors as many third parties want system generated reports with the confidence ther is no user intervention. I have to use at least two reports to do what I want via excel.

Submitting...
Stuart Prime commented · 09 November, 2022 22:07 · Report

Xero are offering multi currency version (whicj our business uses) but they dont tell you that its not complete.....i have found it incredible they havent got this functionality for both accounts receivable and payable.....is anyone got a finance background at Xero.....dont know how they expect users to operate...

Submitting...
Maryke Spies commented · 09 November, 2022 08:29 · Report

It is one of the most critical functions in an accounting system and Xero does not have it. What is the purpose of paying for multi-currency if you cannot run reports in the different currencies? It is very difficult to reconcile forex suppliers / customers as it involves a lot of manual intervention. This has to be addressed as a matter of urgency .

Submitting...
Julia Hudson commented · 12 October, 2022 05:27 · Report

Foreign Currency values to be a column on aged payables and aged receivables

Funds are paid and received in eg euro or $ for a number of invoices , sometimes net of bank charges, need to be able to see how much the original transaction value was, not the £ equivalent

Submitting...
Vicki Wong commented · 13 September, 2022 20:15 · Report

Aged Payables & Receivables in Functional Currency is important, takes too much time reviewing each invoice for functional currency one by one

Submitting...
John Watkins commented · 12 September, 2022 23:15 · Report

I use entryrocket.com (csv2cloud) who built a connection to my xero back end in order to extract a list of outstanding invoices in the original currency. I think it costs me 30 USD a month for the connection but it is crucial. The csv that is generated I just import into a local MS Access database to report the data in the format I need

Submitting...
Tom Mullaly commented · 12 September, 2022 23:10 · Report

What app is everyone using, as it is taking up so much time to export to excel and change all of it.

Submitting...
John Watkins commented · 12 September, 2022 22:59 · Report

It is so important that we are running a 3rd party app to extract this information from the back end.

Submitting...
Stella Gardner commented · 04 September, 2022 00:34 · Report

Should be able to run aged payables and receivables indicating the currency of the invoices due for payment

Submitting...
Abbie Baird commented · 19 August, 2022 10:51 · Report

Aged Receivables & Payables in multicurrency is critical to our business, many hours spent exporting to Excel, reformating & rekeying in relevant currencies. Was involved in an old thread with many others that I am unable to find. This is a necessary report Xero does not provide that MYOB does - please give a timeline when this will be addressed.

Submitting...
Sarah Choo commented · 03 August, 2022 23:58 · Report

It is important for us to have Aged Payables in source - foreign currencies, similar to Supplier Invoice Report with currency option (which I understand that it will phase out in July 2023).

Submitting...
Hank Zheng commented · 02 August, 2022 17:02 · Report

I can't run a aged receivable report in the document currency to send to our customers. Embarrassing.

Submitting...
Carol Niemand commented · 02 August, 2022 08:51 · Report

We confirm AP and AR balances monthly, within our international group, using original transactional currency. This feature is very important for us too! This information must balance to per customer on the AR Summary as at month end date (or to the Supplier in the AP Summary). Which is different to other reports which are asking for a history of entries between a date range.
We please need to have access to this transactional currency information for AR and AP.
Up until now, I have been able to access this information using the older report version called "Accounts Payable" at month end date. Please do not stop this report until there is a substitute.

Submitting...
Michelle Rose commented · 27 July, 2022 09:24 · Report

I have a client who desperately needs to be able to do this, is this something that can be actioned soon, I may have to find another option rather then Xero for him, which will be frustrating as I have only just got him moved from reckon.

Can you please give an eta on when this will be done, or even its being actioned at all

Submitting...
Helen Chandler commented · 21 July, 2022 22:13 · Report

Absolutely critical for preparing payment lists for suppliers and sending remittances. Will not be moving any more multi currency clients to Xero from Sage until this basic requirement is sorted.

Submitting...
Giri Giridharan commented · 18 July, 2022 16:16 · Report

I fail to understand why Xero cannot create a report that can be run in different currencies. Surely it cannot be that hard?

Submitting...
Jo McFetrich commented · 12 July, 2022 21:06 · Report

For a business with invoices in Euros and GBP , in order to run an effective credit control department it is crucial that we can run a detailed aged debt report by invoice in local currency. The current work arounds create rounding differences which then don't agree to the customer statements or recent invoices reports. Please can Xero Support create this report urgently?

Submitting...