Enter your idea

We need this Receivables or Payables Aging Details report in Foreign currency as during the Audit, the Auditor will request. We are using Xero reports and export to excel and manually manage it from there. It is very time consuming especially if there are lots of foreign currencies customers.

This should be available as a matter of course, as it's essential for businesses that invoice in >1 currency. A Euro balance is meaningless to a customer who is invoiced in Sterling.

Hi, I'm 100% with Sandra and Clair.
We sell services into multiple countries from Australia. Our team in the US require aged debtors reports to follow up with the US clients. We have set up Tracking options to report P&L and BS reports in foreign currecies - so whats the problem in follwoing thru to the Aged debtors reports??? Filter the region for the US and report on the Aged Debtors in the US currency!!! is it that hard??

This is a critical feature of a multi currency Accounting package. I do not understand why you have shut down the previous thread without actually delivering the requested reports.
We pay an exorbitant monthly fee to a third party to produce monthly fx reports to prop up Xero's inadequacies. I agree with Clair's comment - I wouldn't be recommending Xero for companies that deal in FX.

This looks like it has very few votes, but this is only because you closed a previous thread with many votes that was asking for exactly the same thing. If you put the two together you will see that there is strong demand for this
Until it is resolved I am advising people who invoice in foreign currency to NOT use xero

Ability to run an aged payables and receivables report showing the invoices in the currency they were uploaded in, either in one report or separately.

Purpose: Because some organisation make their sales and purchases in a different currencies, so it’s beneficial for them to run these reports showing what is is they are owed and what is owed in the currency it was bought in.

9/10 we, and most businesses, will pay and be paid in the currency the invoice is in.

Aged reports in original currency - it is so important to be able to see the original currency on the aged debtors and aged creditor reports.

I have a client who uses different currencies. It would be a great help if we can run the Aged Receivables and Payables Detailed report showing the original currencies and not the converted amount. The report can be grouped to each currency and have a total balance per currency.

Ideally need the account payable detail and receivable reports to be shown in multi currency. So if we owe in Euro , it is shown in Euros and not the conversion rate. And have the same option for accounts receivable. Currently having to amend these reports each time I run them which is time consuming.

Kindly please add to show local and foreign currency in the Aged payable summary, details , and supplier bill activity. Applied the same to receivable.
This is definitely a must for our reporting. Thank you.

would it be possible to have Aged Receivables Summary/Detail in Currency and Base like the picture attached

I see this is done now, thank you!

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

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?

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!!

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.

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?