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!
-
Accounts Expertunity Pty Ltd commented
I would like to see the ability to add the foreign currency amount in the Aged Receivables detail report (as a column option). Currently adding this info manually into the Excel version.
-
Priscillia Chan commented
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.
-
Ciaran Doyle commented
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.
-
Mark Hardy commented
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?? -
Sandra van Kool commented
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. -
Clair Chapman commented
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 -
Rachael Salter Coleman commented
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.
-
Frances Kay commented
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.
-
Arabelle Brinas commented
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.
-
Claire Mawhinney commented
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.
-
Casey Sun commented
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. -
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?