I have invoice issued in EUR, and payment made in USD from customer with different conversion rate than Xero’s. Make invoice payment creation module now does not have a conversion rate field where I can input the correct rate. Is there any work around or somehow I can send this feedback to the mods?
What is the problem & what have you tried?
I tried input the USD amount in the Amount field but it did not work, it expects me to put original EUR amount in. When I did that (input EUR amount), it created a payment transaction on Xero with an incorrect conversion rate, hence causing the USD account transaction not matched with what showing on the bank statement line.
Error messages or input/output bundles
A validation exception occurred (10, ValidationException) Payment amount exceeds the amount outstanding on this document
The Xero API does support setting a custom exchange rate when creating payments. You just need to bypass Make’s simplified module and hit the API directly.
Configure it like this:
{
“Invoice”: {
"InvoiceID": "{{YOUR_INVOICE_ID}}"
},
“Account”: {
"AccountID": "{{YOUR_BANK_ACCOUNT_ID}}"
},
“Amount”: 1000.00,
“CurrencyRate”: 1.0850,
“Date”: “2024-12-10”
}
To request this field be added to the native module:
Go to Help & Give Feedback in Make
Or post in the Ideas & Feature Requests category here in the community
Thank you for the tip, I will give feedback to Make and look into the API directly.
As an accountant who is learning to implement automation tools for my daily work, not having this feature built in the native module kind of giving me a hard time using Make.
As you’ve found out that this is currently not possible using the current module, please submit this suggestion to the Idea exchange, under App Improvement Ideas. However, do search for a similar request first (and also upvote), just in case it has already been suggested to avoid duplicates.
I struggled with this setup in Make because currency handling feels a bit hidden. Xero expects the invoice currency to be set first, otherwise payments default back to base currency. I remember fixing it by double-checking the invoice settings and passing the exact currency code in the payment step. Once both sides matched, conversion worked fine and balances finally lined up.
What is your goal?
What is the problem & what have you tried?
Error messages or input/output bundles
Screenshots (scenario flow, module settings, errors)
