2017 Advanced. Looking for advice for the following scenario: Two companies in Sage 100, USA and EUR. USA is in dollars and EUR is in pounds.
USA receives an AP invoice from EUR for a service.
USA records the invoice in dollars and needs to pay EUR in pounds.
The accountant goes onto the bank web site and buys pounds and initiates a transfer to the EUR bank account.
Example: if the exchange rate is 1.36, $10,000 USD buys $7,352 pounds.
The accountant manually creates journal entries as follows:
USA books: Debit intercompany $10,000 and Credit cash $10,000
EUR books: Debit cash $7,352 Debit gain/loss on conversion $2,648 and Credit intercompany $10,000
They have hundreds of these transactions a month and it is a nightmare to keep the accounts reconciled. They are looking for a more efficient and automated process. Any ideas?