Skip to content
← For accountants & bookkeepers

Enter your idea

For accountants & bookkeepers: Workpapers

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!

58 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
  • Mayur Shah commented  ·   ·  Report

    Extremely important to have this to be truly multi currency. ANd require this for Aged Receivables as well. There are multiple threads for this feature and Xero need to merge them to get a true picture of the demand for this.
    See thuis: AR and AP and other reports in Multi currency
    amongst others

  • Mayur Shah commented  ·   ·  Report

    It is essential for a company with the base currency of GBP (as UK Based Compoany) but invoicing mostly in USD to be able to produce reports such as AR and AP, and Trial Balance in USD, or any other currency. Our stautory accounts are also filed in USD, therefore we need the ability to produce these reports in USD. Please implement this urgently

  • Pauline Smith commented  ·   ·  Report

    This is super important missing feature for larger international clients.

  • Sandra van Kool commented  ·   ·  Report

    Welcome to the club - Xero multicurrency system is not really a true multi currency system. Xero are not interested in doing anything about it. Generally Xero close down the threads on this type of request and then new ones start up. That way they keep the votes down and not do anything about the problem.

  • 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

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

← Previous 1