Reports - Add original currency in the Aged Payables and Summary Payables reports
Kindly would like to suggest adding Original Currency in the Aged Payables and Aged Payable Summary. Would make our reporting preparation easier. Thank you!
Marilou Silvestre
shared this idea
Thanks for sharing and engaging with product ideas here. We appreciate the desire to run more reports in Xero in a different currency.
To confirm what is currently available in Xero for multi currency reporting - Right now the aged reports will run in the organisation's base currency. However, for any invoice or bill that has been created in a foreign currency you'll see an icon next to that line in your report which provides notation of the exchange rate details, and these will all be listed at the bottom of the report.
With the Payable and Receivable summary and detail reports you can add an 'Original currency' column along with other foreign exchange details.
It's also possible to add a filter to these reports to only show invoices of a particular status for example Awaiting payment.
I know this doesn't accomplish all that's being asked in this idea and while we don't have any plans for adding more currency options in the aged reports right now, we will continue to review the interest in this and share if there are any plans made. Thanks
-
Chris Fox
commented
I see this is done now, thank you!
-
David Rose
commented
Hi Ethan
more than just interest, it's ridiculous not being there. We have suppliers that bill us in US dollars and we pay them in US dollars, yet there's no where in Xero to see what we owe them in US dollars, only on UK sterling, which is no use to man nor beast.
I find it incredible that to use this (paid for feature) I have to get out a calculator before paying any supplier !!David
-
Billy Whitaker
commented
Currently, aged payable detailed and aged receivable detailed reports only show balances in GBP, despite multi currencies being used and invoices being raised and received/entered onto Xero in the foreign currency, these balances shown be reported in the foreign currency. Why allow multi currency to be used if the reports aren't able to be produced in the foreign currencies?
-
Lorna Fraser
commented
The supplier invoice reports currently have subtotal in currency other than GBP. The new reports will not feature this function. Therefore, this is not a new idea but is to try and ensure that the current functionality exists when the new style reports are rolled out and replace the old ones. Crazy that the new reports will do less than the current ones!!
-
Richard Muller
commented
Reports - Display Multicurrency Original Values
Allow Reports to display the original values for a chosen currency.
Currently when running a Multicurrency report, the value shown is derived from the chosen Currency being exchanged from the BASE currency of the package. So if a ZAR base package has a €2000 Invoice in it, with a €2000 payment to a Euro account…. The profit and loss report, when run in Euros, will show that (today) as roughly €2037 after the back and forth conversions.
It would be very nice to have a reporting function that allowed the original values to be displayed, specially if they happen to be in the same currency as that chosen for the report and also regardless of the base currency.
-
Chris Fox
commented
The old Supplier Invoice Report which is due to be turned off in July displayed the totals for the gross and outstanding balance columns in the original currency. This doesn't appear to be possible in the new version of the report, even when it is grouped or filtered by original currency so that items with the same currency appear together.
Can this be added before July please, or failing that, keep the old version of the report in place until it has been done?