Let’s walk through processing a billing and taking a cash receipt in a foreign currency. The flow of processing billings is very similar to a single currency environment:
Creating billing in a foreign Currency
- Billing currency is Euro
- Corporate Currency is Belize dollars
In this example we have create a bill for EUR 4,000. You will notice that there are 2 new fields on the right hand side for Currency Conversion Rate and Ledger Amount. This conversion rate is pulled from the “Dated Exchange Rates” table that was setup in the “Multi-Currency Configuration” knowledge article. The ledger amount is the converted amount from the foreign currency to the corporate/base currency, in this case Belize Dollars and this will be the amount posted to the GL.
If you are manually updating the exchange rate tables, it is best practice to update these tables before creating a billing. This way, the current exchange rate will be used. Also, a conversion rate can be entered directly into the billing, which will override the exchange rate tables.
Creating a Cash Receipt
Once the billing is posted, we need to receive a payment towards it. Follow the usual steps for a cash receipt, but make sure the currency is the same as billed.
Again, it is best practice to update the exchange rate tables before receiving a payment so the current exchange rates are being used. Also, a conversion rate can be entered directly into the cash receipt, which will override the exchange rate tables.
When applying the cash receipt to a billing, the currencies must match. Only billings in the currency recorded on the cash receipt will be shown. So in this case only open invoices in Euro will be available for cash application.
Understanding Realized Gain/Loss on Currency Exchange
A realized gain or loss on currency exchange happens when the currency exchange rate on the day the customer was billed is different then the day cash was collected from the customer.
Accounting Seed will automatically calculate and record realized gains or losses for you. These will be posted to the default “realized gain/loss on foreign currency” expense GL account.
For example, you will notice that the Billing Cash Receipt Transactions related list shows 3 lines. We billed at an exchange rate of .85, but received the cash receipt at an exchange rate of .95. This gives us a 495.35 difference, which will automatically post to the “realized gain/loss on foreign currency” expense GL account.