Enter your idea

We appreciate the depth of feeling from everyone regarding running Xero’s aged reports in foreign currency.

Following retirement of our old reports on 31 July ( https://central.xero.com/s/article/Retiring-old-versions-of-reports-in-Xero ) , we’ll be looking at adding new features and being able to run the aged reports in a different currency will certainly be in consideration.

To help with your foreign currency needs now we have recently released some common format reports in the Payable and Receivable Invoice reports. you’ll find these alongside the new Aged Receivables Summary and Aged Payables Summary reports within the left hand side panel under ‘Related reports’.

Payable Invoice Summary – Approved and paid and Receivable Invoice Summary – Approved, sent and paid

• These reports list every outstanding payable or receivable item. By configuring the start date to include all outstanding items, and excluding prepayments (under the More button), you’ll have a list where the total balance due matches your Aged report. You’ll be able to see the original currency of every item and the amounts in source and base currency.

Supplier Invoice Activity and Customer Invoice Activity

• Use these reports to see all activity for a customer or supplier for a chosen date range. Add the Original Currency column to see which currency the item was issued in.

After you’ve configured the reports the way you want them, remember to save them as Custom ( https://central.xero.com/s/article/Create-reusable-custom-report-layouts ). You can  also favourite a custom report ( https://central.xero.com/s/article/Access-and-browse-reports#Markareportasafavourite ) so it’s available in the Accounting menu dropdown, to help you navigate to your most used reports quickly.

Currently, we’re working on adding notes to the aged reports showing the exchange rates used to convert to base currency. This work is underway but won’t be finished before 31 July – In the meantime, if required you can add your own note to the report using the Insert content button ( https://central.xero.com/s/article/Add-text-blocks-and-notes-to-reports?userregion=true#Addanote ). Rates used on this report are taken from the Currencies screen under Settings. We have another idea centered around this ( https://productideas.xero.com/forums/939198-for-small-businesses/suggestions/45418840-aged-payable-receivable-report-foreign-currency ) that we’ll be keeping  you updated through. Thanks

Understand all the enthusiasm and interest in being able to see the currency the business deals in included in more of Xero’s reports.

As many will be across, we’re working hard to make sure you have all the functionality you need in new reports, before older versions are retired on 31 July 2023 – See more on this in Xero Central ( https://central.xero.com/s/article/Retiring-old-versions-of-reports-in-Xero )

This being the main priority and focus for our reporting product teams, immediate developments for additional features like what’s being asked here aren’t in the pipeline at present.

Some of our new reports already convert foreign currency amounts to your base currency and do the appropriate revaluations and gain/loss calculations for financial reporting. The Account Transactions report also lets you view transactions in their original currency amounts, and coming soon – we’re developing the Receivable and Payable Invoice reports to view, sort and filter transactions by their original currency.

We’re continuing to stay on the beat of all the feedback about reports across product ideas, and will have more opportunity to review new developments when older reports have been retired.