Skip to content
← Reports & tax

Enter your idea

Reports & tax: Reporting

Categories

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!

97 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
  • Li Gyn Hia commented  ·   ·  Report

    I have accounts receivable in different currencies. In the AR aging report, is it not possible to display them in their original currencies instead of converting everything to the home currency. This is very important when auditing the financial account. Auditor will require to test the currency exchange for AP and AR.

  • Jacobo Bentata commented  ·   ·  Report

    We need more flexibility operating with different currencies.

  • Julia Hudson commented  ·   ·  Report

    Cannot believe we are still waiting for this when we pay for Xero foreign currency and the FC aspect is very poor

  • Kirstie Crocker commented  ·   ·  Report

    This is vital for our business reporting. We have bank accounts in multiple currencies so need to match these for payables and receivables not the NZD equivalent.

  • Sandra van Kool commented  ·   ·  Report

    This idea has been proposed so many years, I'm surprised Xero continue to ignore it.
    For those users that are new to Xero - there used to be a report within the Customer / Supplier that allowed you to export their data in original currency - but Xero got rid of that a year or so ago.
    How xero get away with calling the program 'multicurrency' without these reports, or the ability to raise fx journals - I don't know.
    Xero truly is a program for hairdressers and tradesmen, per their TV ads. They have really dumbed down their product over the past few years.
    A shame, it used to be failry decent.

  • Sam Haworth commented  ·   ·  Report

    Aged Receivables / Payables Detail Report - once exported to Excel, can the FX columns just come out at the start of the columns before <1 month or have one currency column to note which currency the invoice is?

  • Jo-Anne Blake commented  ·   ·  Report

    Agree, seeing the invoice's true currency on a download would be helpful for cash planning

  • Shamaine, Yee Hun Lee commented  ·   ·  Report

    Hi Xero team, most of the accounting system today can support the Receivable and Payable aging in original currency and reporting currency. Since AR and AP module able to book in the both currency, there must be a way Xero also be able to do at the reporting for aging. Really hope this can be consider and added in. Thanks.

  • 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

  • Kathryn Curtis commented  ·   ·  Report

    Ability to see aged debtors' balance in the currency the invoice was generated in, not just in your base currency, otherwise, it is difficult to calculate how much a customer owes. The same is true when you view the balance for a contact. It shows the issuing currency for each entry, but the total is only shown in the base currency, which is not helpful if you need to inform someone of the balance outstanding.

  • 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.

2