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.
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.
-
Clair Chapman commented
Can you please add a link to the new thread where this basic function has been requested again.
It is a basic requirement for a company with who bill in a foreign currency and needs to be a standard part of any foreign currency product.
I have been advising people who use foreign currency against changng to xero and will continue to do so until this is rectified -
Jean Tan Bee Chan commented
Hi,
actually, what i suggest is you can do both, for those want to hide the foreign Curr, they just filter and choose to show the local SGD currency. but for those want to see the foreign currency, they also can get the report.
we hppe can see the FX aged report soon.
thank you.. -
Jonathan Clayton commented
If the ForEx footer is unsatisfactory and you want an Aged Payables report that shows outstanding balances in their source currencies, the best alternative I've come across is to customise the 'Payable Invoice Details' report with the columns shown in the attached .pdf example, select a date range as far back as you can and filter by 'Status: Approved'. You can also 'Group by Contact' if you prefer.
Duplication will occur from the line entries per the itemised bills but these duplicates be filtered out after exporting. It's not perfect, but as a 'Custom' report, it will save you time on future A.Payable tasks.
-
Natasha Groenewald commented
Xero, is there any other way of contact you. You are ignoring our requests...
-
Stewart MacGregor commented
Xero, this is stopping multicurrency businesses doing business.
Just spoke to Virgin Bank and they cannot believe this was not part of your original brief when doing multicurrency.
The bank have refused your report as unacceptable for their needs and have suggested a change of software.
When a reporting function is losing you customers (11 years after initially suggested) do you not think it is time to move your client base forward.
-
Sandra van Kool commented
The 'solution' shows a complete lack of understanding of what a multicurrency accounting systems is, as well as the many, many comments requesting AP / AR reporting in the source currency.
Congratulations on adding icons though - that must have been a considerable stretch of resources.
The thing I find most incredulous, is the removal of FX reporting from a Contact's card. This was the one work around that was useful in a 'multicurrency' system that is completely useless. -
Natasha Groenewald commented
I have contacted Xero on Instagram and Facebook, also left comments on posts.
Please can we have a response... -
Cathy Blyth commented
The 'solution' is extremely disappointing. It shows a complete lack of understanding of this basic requirement for multi-currency businesses.
I agree with all the comments below, and can't imagine that anyone will find the icons helpful in any way. -
Carly Joachimides commented
Reporting: Aged Reports - I want the option to see the AR report in the original currencies the invoices are in. Not just the notes for the currency rates
-
Nick Holloway commented
This is just a stupid response to the original request. All it needs it a filter by currency and and add an option to show original currency. It's not as if the request is for something that there isn't already data for. Without this feature xero shouldn't be promoting itself as a multi currency product because this functionality is basic and simple.
-
Cathy Byrne commented
This doesn't fulfil the business requirement. Please look again at producing aged reports by currency
-
Yetunde Sogunle commented
It's incredulous that Xero's development team can't comprehend why businesses need Aged Reports that shows the actually billing currency that's owed! Businesses pay an invoice in the currency that is billed. Having an aged report showing the equivalent value in the organisation's base currency is useless when the business need to know how much USD, EUR, AUD, NZD, CAD, Rupees, or whatever currency they have to pay to settle invoices.
What's more bizarre is that Xero's Account Transaction reports provides separate columns that displays the original source currency code and source currency amount as well as the business's base currency code and base currency amount. How difficult is it for Xero's Technical/IT/Programming team to take the coding behind the account transaction reports and apply it to the Aged Reports? Totals for the different currencies can be obtained by customising the Aged Report to Group and Sort in currencies.
If Quickbooks, and other entry-level accounting systems can provide Aged Reports in different currencies, why can't Xero do this most basic and essential thing?
-
John` Temple commented
You have COMPLETELY MISSED THE POINT! You are going to have a lot of very unhappy clients if you don't manage to sort this basic requirement.
Many businesses run multiple currencies.
Probably time to be looking for a new accounting package, which is a shame as Xero has many good features.
-
Rob Needham commented
You have totally missed the point. What we need NOW is the ability to see in our aged debtors and creditors reports the amounts owing/owed IN THE CURRENCY THEY WILL: BE SETTLED IN.
This is such a basic requirement of any accounting function I cannot understand how you cannot have implemented it AS A PRIORITY.
Particularly as we have to pay extra for multi currency "functionality".
Currently it is like paying for a car with wheels but no tyres
SORT THIS !!!
-
Laura Hollands commented
The ability to run aged reports in a different currency is still incredibly important when as a company we have foreign bank accounts GBP EURO AND USD, so an easy look at an aged report can tell us how much is owed in GBP EURO and USD rather than having to do sums for each item that is shown in GBP by using the exchange rate from the report. All of your icons are the same colour so there is no differentiation between EURO or USD causing another complication to work out the foreign amount due from the exchange rate. I am sure that many (if not all) of the previous numerous requests from people who have been asking for these reports to show the actual amount owed in the correct currency will still be feeling the same way as me and wishing for the ability to run aged reports in a different currency to be added to your plans and not completely abandoned.
-
Alan Dawson commented
This offers no help what so ever. You have totally missed the point. We currently have over a thousand customers. It takes us hours every month to convert debtor reports for our reps so they can collect the correct amounts. Not good enough.
-
Kerry Bridle commented
I agree the addition you have added still doesn't help, I want to know that currency value not the Base value
-
Natasha Groenewald commented
So what you are saying is that after more than a year of requests and advising exactly what we require (a basic critical function) you are not willing/able to give us this functionality??
The solution provided is not adequate
Creating another discussion will just mean us having to wait another year for a reply and not having a solution
Just do what your customers are asking, PLEASE!
-
Leena Lukka commented
Hi the solution presented above is not sufficient for needs of businesses. It is integral that we be able to see the foreign balance outstanding when running aged reports. This is still integral and I'm sure you'll see the same amount of up-votes for a true solution here.
-
Jennifer Lim commented
Please implement this asap as really time consuming to make it manually.
Please make this a priority.