Skip to content
← Reports & tax

Enter your idea

Reports & tax: Reporting

Categories

(thinking…)

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!

77 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Marilou Silvestre shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
submitted  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

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

Show previous admin responses (1)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Richard King commented  ·   ·  Report

    XERO - can you please let everyone know when, if ,and how we can get a report showing originating currency for payable and receivable reports??
    So annoying you are not helping...

  • Nimita Bhanderi commented  ·   ·  Report

    Hi Xero, Please could we have an update as since 2023 there has been request for this report.

  • Vanessa Rheeder commented  ·   ·  Report

    Please provide status update on this - dont want to have to export and do a work-around

  • Anne Cumiskey commented  ·   ·  Report

    This is a Critical report needed for both aged debtors and creditors. Xero software is not viable if we have customers and suppliers who are multicurrency and we cannot pull up an aged report in their respective currencies, especially if there are many entries to reconcile.

  • Accounts Expertunity Pty Ltd commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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.

  • David Rose commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

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

2