Prepayment - Multi-currency
Ability to create a prepayment in a currency other than the organisations base currency
Purpose: Having a multi-currency prepayment option in Xero will make users’ who are dealing with customers that pay prepaid foreign currency accounts to their business easier.
-
Dan Terrett commented
Prepayments are basic bookkeeping and fundamental to the accruals basis of accountancy. It's astonishing to me that I can't record a prepayment in Xero in a currency other than our base currency. This isn't a nice to have, it's absolute basics.
-
Jeff Cross commented
This is such a no brainer. I cant understand how any company dealing internationally can stay with Xero whilst this remains unfixed. I have to putthrough payments as overpayments just so that the whole international currency thing will work. This was way easier in MYOB and at $5 per month I would consider gfoing back as Xero offers very little improvement if any.
-
Rose Conway commented
Too many customers need this function and the work arounds are too time consuming. This needs to implemented now. Thank you.
-
Chris Moody commented
Also the ability to mark a selection of invoices or bills as paid in your non-base currency. A simple feature that 10 years later is still not possible.
I am moving to a system called iPlicit. -
Juan Cruz Troncoso commented
This idea dates back to 2013, and Xero has done absolutely nothing about it in more than 11 years. It really amazes me that Xero has not implemented a multi-currency prepayment flow, but there is one for overpayment. It does not make any sense to me at all. Every day, Xero convinces me that I should stop using their software. I am definitely not adding new customers to Xero.
-
Rishabh Srivastava commented
Its very important function and a must for companies dealing in multi-currency. Please add the service.
-
Fergus Chamberlain commented
A much-needed addition to your service, please.
-
Allegra Joly commented
Highly essential for businesses dealing with multi-currency transactions. Would simplify so much for us!
-
Pavel Khaustov commented
This is a must have for international businesses.
-
Idris Olufowobi commented
It's ridiculous to see that Xero does not allow multi-currency prepayment booking without it creating fx difference in the prepayment GL when it is to be recognized in the relevant reporting period that the transaction relates. This is needs to be sorted as soon as possible, please.
-
Matt P commented
There is some advice on a work-around here:
https://central.xero.com/s/question/0D53m00009LQ0DnCAL/prepayments-in-a-foreign-currency
...but it seems to attempt to properly calculate currency gain/loss by changing the credit note date to match the invoice date when the prepayment credit is actually applied. As far as I understand this only works when folks are prepaying on an invoice by invoice basis where the prepayments closely align with individual invoices. If you have one prepayment applied to many invoices I guess you would need to manually create a ton of credit notes (one per prepayment+invoice-credit combo) in order to get the currency gain/loss calculated correctly.
In my experience many European and US companies run prepaid accounts where many invoices over time may be credited off a single prepayment. Annoying but they won't switch to invoiced billing until you hit a certain scale.
Would be really great if this feature gets implemented soon as it will save a ton of work. We are making changes to which vendors we work with because of the complexity on the Xero end...not a great sign. Maybe the days of Xero being ahead of the curve for SMEs are over.
-
Chris Moody commented
Two possible resolutions. We take prepayments in Euros which is not our base currency, which is GBP.
We do it by issuing a credit note to the client, and removing the allocation against the invoice. When they pay the invoice they now have a credit balance, against which we credit future invoices.
Clunky but it works. It does give you a negative accounts payable and receivable, but we’re used to that.
Alternatively move to a system called Iplicit. More expensive but much more powerful.
-
Sherry Kagan Segal commented
Hello Xero Support,
We are looking to pass sales receipts as prepayment transactions from our Travel Booking System to Xero Accounting using the Xero API Endpoint https://api.xero.com/api.xro/2.0/BankTransactions
The base currency in our Xero organisation is USD, however we take prepayment receipt transactions from our customers in both USD and ILS (Israeli New Shekel). We then need to allocate them against USD sales invoice transactions generated in our booking system and passed to Xero using the https://api.xero.com/api.xro/2.0/InvoicesOur understanding is that Xero:
1. Does not allow prepayment transactions to be generated via the API if they are in a foreign currency and only allows them in the Xero base currency.
2. Does not allow payment transactions (prepayment or overpayment) to be allocated against a sales invoice in a different currency to the payment itself, e.g. allocating a payment in ILS to a sales invoice is USD, or vice versa.Please can you advise how Xero recommends we should handle this scenario and whether it is on your product roadmap to resolve?
-
Christopher Holmes commented
Really shocked to see Xero doesn't natively support this!
-
Gareth Lawrence commented
+1 an absolutely must have
-
Matthew McGuire commented
Hard to beleive an accounting software doesn't do this. This is basic bookkeeping. Not just being able to record it in fx currency but not having the deposit or prepayment track on the customers account.
-
Oksana Kovalenko commented
Please implement this feature. Otherwise, overpayments go to creditors, whereas I need to see them in debtors. Thanks.
-
Salonee Verma commented
This would be very useful. the amount of time wasted in work arounds due to an inadequate FX system in Xero (prepayments, accrued income, doubtful debts, etc etc) is ridiculous. Journal entries, payments, receipts, adjustments etc should all be possible in FX currencies. Adjusting everything every month is so unnecessary!!!
-
Sophie Carroll commented
Foreign currency prepayment is critical for our international customers, who prepay for our services.
-
Oliver Slacke commented
How this isn't a feature I don't know. This is critical for our international customers and suppliers.