Manual Journals - Journal in foreign currency and see FX rate on journal
Ability to process a manual journal in foreign currency and to pull the exchange rate on the date of the journal.
Purpose: It’s beneficial for organisations who are dealing and operate with multiple currencies
Hi community, first off thank you for contributing and detailing why posting manual journals in a foreign currency is of interest to you all.
We appreciate our customers would like to see more capability in accounting for and dealing in foreign currencies across Xero.
In it's current form Manual Journals are a part of Xero that require some upgrade to uplift technology in order to provide capability for ideas like this to be considered. We have intentions of bringing attention to this over the coming year, however getting this done first is necessary before we can even think about adding newer functionality like journaling in another currency to the mix.
To set the expectation here, there is no work planned over 2023 for this feature. We know it's of high interest and when we're in a place to reassess we will share with you here.
-
Salonee Verma commented
Please add this feature
-
Jason Antill commented
Simple example we have a USD intercompany loan in an AUD base currency file.
We take up accurals for interest.
I'm guessing my work around is to setup a Bank Loan in US$ -
Sonya-Rose Bremnes commented
Shocked this has been an "idea" since April 2014.... 9 years almost to the day. I can't imagine this is that difficult to code?! Yet would make a HUGE difference in being able to post both individual and recurring entries using the current spot FX rate. I have switched clients from QBO to Xero specifically for the better overall multicurrency functionality and reporting, however this is a glaring FX problem that seems to be continually ignored.
-
Alain Hollenthoner commented
Same here. Started looking at Odoo and other alternatives. The speed of development in Xero is clearly subpar.
-
Mike Harding commented
I occasionally come back to this post to see if there's been any progress here but it's depressing to observe that since the issue was first raised we have got through a global pandemic, economic recessions, 4 British PM's, one POTUS, a semi-global conflict and countless other milestones - good & bad. Xero, this really is ****. Thankfully, despite all of the above, we have grown as a business and we can soon afford to invest into a proper accounting system and will be waving goodbye anytime soon
-
Jacky Walker commented
The ability to add manual journals in foreign currency is a feature our business needs desperately
-
Andrew Wawrzyniak commented
Totally agree as well. This is a CRITICAL missing feature clients (and their accountants) desperately need, most people have to deal with multi currency these days. Also - message to Xero senior management - as a Chartered Accountant this is one of the main reasons I would recommend a client use Quickbooks over Xero. Maybe meditate on that will you?
-
Sandra van Kool commented
Desperately need ability to enter fx journals. Xero partner left us with an fx conversion balance in the GL I cannot clear. I also cannot extract AP or AR reports in USD.
Totally agree with posted comments below.
Please do not market Xero as multi currency with limited fx functionality and reporting. -
Julie Krassay commented
Further to Brad Reynolds comment, manual journals are essential but it would be even better if Xero could add in functionality to allow balance sheet general ledger accounts to be recorded in foreign currency, which are auto revalued at each month end, and where the opening balance reports in foreign currency on GL reports - same as Accounts Payable, Accounts Receivable and Bank Accounts.
We operate in Argentina and have a long term GST receivable (IVA or VAT) in pesos and also an intercompany loan receivable/payable in USD, both of which need to be manually revalued into AUD at the end of each month. Work arounds are to raise AR customer invoices for the GST & loan receivable (but this looks strange in AR), and to raise supplier bills for the loan payable (but this ends up in AP). Or to track FX transactions in a spreadsheet, add the FX, opening balance to get the closing FX balance then revalue each month end. -
Brad Reynolds commented
So, according to your Xero article here:
we should be having a "beautiful, seamless experience in multi-currency reporting".
So, why is it, then that, FOUR YEARS after that article was written and NINE (YES, NINE!) YEARS after someone first asked for it, we are still waiting?
Stop spending time on staff meetings and focus groups to work out what shade of teal a button should be or if that button should be a bit more to the left or the right and spend it, instead, on things that actually matter to the people who are paying you to care.
-
Julie Hepburn commented
Crickets from Xero.
Is someone working on this? -
Anthony Bradshaw commented
That is very critical but also some detail to back up the Bank revaluation account
-
Sarah Little commented
This is very important and beneficial for our company.
-
Jena Scott commented
This is a very important function for an account supporting foreign currencies. Can't believe this is not available as it is a function in Quickbooks.
-
Emily Perretti commented
@Christian that doesn't actually solve the problem we are having. Our issue is that if you have a euro invoice then you pay it in euros the next day, it creates an FX difference because it forces it to convert into GBP (or whatever your default currency is).
-
Christian DeAngelis commented
There is a simple work around for this. Just create an invoice or bill to "accounting manual journal" as a contact and put in your journal entry so that the total equals zero. You can choose any currency this way. We use this for all of our accrual adjustments with our contracts not in the base currency.
-
Pierre Coeffe commented
How hard could that be??
-
David Waterfield commented
Just do it. Stop faffing around. Universally applicable in any country.
-
Jay Houghton commented
this is a basic requirement of any accounting system, if Xero can't do the basics why trust it with anything?
-
Pippa Strong commented
foreign currency journals required please!