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 everyone, thanks for all your feedback and highlighting the need for multi-currency manual journals, and being able to see the FX rate directly in the journal.
We understand the needs in this space have close ties with this idea for being able to journal to bank accounts, and this is something we have intentions of doing deeper discovery around in the longer term. However, we want to be upfront that this work isn't roadmapped right now.
Though we appreciate not the straight forward approach that you’re after here - currently you can create the journal via a bill in the relevant foreign currency. Entering positive and negative lines for the debit and credit entries, which results in a 0.00 bill total once approved. The bill lines are converted to your organisation’s base currency using the bill’s FX rate, and the transaction won’t revalue.
As soon as there's movement surrounding this idea we'll share an update with all of you here.
-
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!
-
Anthony Bradshaw
commented
The Bank Revaluation account becomes Rubhish without them
-
Michael Law
commented
It is a painful exercise each month determining the GBP equivalents for the currency accounting journals that are required. I can't understand how you can have conceived of a system that allows the posting of bills and invoices in multiple currencies but then doesn't allow posting of journals in currency too!
-
Yuan Yuan Goh
commented
Hopes Xero IT teams can take the action as quickly as possible to allow manual journal in a foreign currency because this is a basic requirement for an accounting software.
-
Tom Fan
commented
Any progress allowing manual journal in a foreign currency?
-
Jingjuan Yao
commented
Please allow manual journal in a foreign currency
-
Lorraine Mears
commented
Is there any progress on this?
-
Suzanne Murphy
commented
I agree with everyone else on this request and have to add journal entries in another currency as an Accounts Payable Invoice to get the right value into Xero as this facility is not available - totally illogical to me.
-
Fannie Ang
commented
Please allow manual journal in a foreign currency. This is important and basic requirement for an accounting software.
-
Emily Perretti
commented
I agree. Not being able to manual journal in a foreign currency is tough for us.
-
Ciara Scanlan
commented
MJEs can currently only be posted in system base currency. Although we are Euro functional, we operate with other currencies, and need to be able to post entries in non-Euro currencies.
-
Alain Hollenthoner
commented
Time and again I'm surprised how seemingly basic requirements are not covered in Xero.