Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to record a currency gain/loss on a Customer Payment against Invoice
We frequently record customer invoices that end up being paid in a foreign currency, so need to record a currency gain/loss when we receive the payment. Here's an example: \
- 1/31/2019 - Customer Invoice - £50,000, recorded in USD at the exchange rate on that date
- 3/15/2019 - Payment of £50,000 is made in GBP from Customer and deposited into a USD bank account, at the exchange rate on that date so there is a difference between USD amount on Customer Invoice and USD amount on Customer Payment record.
In Quickbooks we recorded the difference in a Currency Exchange Gain/Loss expense account, but we can't figure out how to do that with the limitations of the Customer Payment transaction type.
2