Skip to main content

Cash Application: Recording Foreign Currency Transactions

Updated over a year ago

When the currency of the payment does not match the currency of the invoice you're applying the payment to, follow these steps in order to successfully post the payment.

In the example below, the payment was received in the bank account in USD, but the customer account and invoice is in EUR, so the payment will be updated to EUR before it is posted.

Step 1: Apply the invoice

Once the payment is applied to the invoice, you'll see Application Pending until the original payment information is updated.

Step 2: Update the Payment Amount, Currency, and Rate

In the gray box that opens, provide the updated payment amount, currency, and exchange rate for the payment. These are the amounts that will post to your ERP. In this case, because it was a payment in full on the invoice, and the bank reported that the original payment amount was 14.5 Euros, that information is entered into the appropriate fields. In some cases, the bank will provide the exchange rate. In other cases, you will need to calculate it. Then, click Update.

โš ๏ธ The amount in the Payment Amount / Posting Amount field is the amount that will sync to your ERP. Verify that this is the correct amount. This amount is not updated automatically based on the exchange rate that you enter.

At this point, the payment currency matches the invoice currency and your payment can be posted.

Note: in you rely on your ERP's default exchange rate rather than entering your own, erase the value from the Rate field and leave it blank. When the payment is posted in your ERP, the default exchange rate will be applied.

Optional Step 3: Review Payment Information

You can also complete these steps on the Payment Information tab by editing the Amount, Currency, and Rate.

Note: in cases where the original payment amount is less than the amount of the invoice, you will want to update the payment amount before applying the invoice to ensure that the invoice is fully applied.

Did this answer your question?