Skip to content
← For accountants & bookkeepers

Enter your idea

'Payable Invoice Detail report - add totals/subtotals for original currency columns' has been merged into this 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!

60 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
  • Ryan McGivern commented  ·   ·  Report

    I find that really surprising and disappointing as it makes your current set of reports completely unusable as a company billing in multiple currencies I need to be able to report on my aged debtors in the original currencies with no unrealised gains or losses from currency exchanges, if this is the case and there is no work arounds for this Xero is not fit for purpose as a multi currency accountancy software package. Can you advise is there even any addons that can be used to achieve this. As I can see from your product ideas page that this has been raised as a product idea multiple times since 2022 so 3 years on and there is no solution to this problem meaning you are using these product ideas to make it seem like you are working a solution when in reality yous are not. Do yous have a future road. map or anything showing when yous might consider these product ideas?

  • Alun Jones commented  ·   ·  Report

    Very impotrant to be able to send reports in original currency. It will only confuse the customer if we invoice in one currency and then chase in another.

  • 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

← Previous 1