When entering transactions such as vendor invoices, you may want to enter a vendor invoice in Canadian Dollar (CAD) for a project in Euro (EUR). In that case, the Net amount on each vendor invoice line will be assumed to be in CAD, the transaction currency, and the Billable Gross Amount will be assumed to be in EUR, the project currency. If no project is entered on a line, the Billable Gross is in home currency.
In Workamajig, the net and gross are as follows:
- Vendor Invoices: Net in transaction currency, billable Gross in project currency
- Purchase Orders: Net in transaction currency, billable Gross in project currency
- Expense Receipts: Net in transaction currency, billable Gross in project currency
- Miscellaneous Costs: Net in project currency, billable Gross in project currency
- Time Entries: Net in project currency, billable Gross in project currency
On the Add a Vendor Invoice screen, you can select a currency for the Invoice. Otherwise, the currency will default from the Vendor record. The AP Account must be in the same currency as the currency of the invoice. On the Details, the exchange rate will be automatically populated. The system pulls it from the currency exchange rate table. The exchange rate is a function of the GL Company, the Invoiced Date and the currency. If at any time, you change any of these 3 parameters, the system will get a new exchange rate. If there is no available rate for the day, the most recent before or on the Invoice date will be pulled. If there is no exchange rate, it will be set to 1. You can change manually and update your exchange rate table by pressing the 'Update Rate History' label. This label will be visible only if there is no exchange rate for the Invoice date.
Once expenses or orders are entered, the currency drop-down will be disabled.
When you enter an expense, the system will display the currencies for each amount. If the currency is blank, this means that the home currency is used. On the example above, the Canadian dollar is used. If the project has a different foreign currency, you will be asked to confirm the exchange rate for that currency. The system will calculate Net and billable Gross for that currency, in this example, the Euro.
Project Cost = (40 CAD * .9) / 1.34 = 26.87 EUR
Project Gross = (46 CAD * .9) /1.34 = 30.90 EUR
The Project Cost is used in the project profitability reports, and the Project Gross will be used as a billed amount when you enter a client invoice in EUR
The Purchase Order screen has the same behavior than the Vendor Invoice screen.
The Media screens do not support multi-currency transactions, at this time.
The new Expense Report screen has the same behavior as the Vendor Invoice screen.
When you enter miscellaneous costs, the currency for the net and the gross is the currency on the project. The exchange rate is used to report in home currency.
Currently, the exchange rates are pulled from the currency exchange rate table.
NON BANK TO BANK TRANSFERS
The currency can be selected when adding a new Journal Entry. Or, depending on the type of Journal Entry, the currency is set on the line level. You can transfer from any Foreign currency account to any HC accounts and the conversion will be automatic to the Home Currency. The Exchange Rate will be based upon the Journal Entry Date.
If the Home Currency is USD and I want to transfer 100 EUR from my EUR Bank Account to the (HC) COGS - Production expense account.
- Select the EUR currency in the Header of the Journal Entry. Then enter both detail lines in Euros.
- Bank Account - Eur 100
- COGS - Prod - 100
The system will convert the Euros into the Home Currency Value.
- 100 Euros will be credited from the Euros Bank account.
- 113.30 will be debited to the USD (HC) COGS account.
- Based upon the Exchange rate of 1.1333
BANK TO BANK TRANSFERS
If transferring between GL Accounts (Bank to Bank) with different currencies, you must enter the value of that currency. The debit and credits column will not "match".
If I want to deposit 10,000 Euro's in my Euro checking account, transferred from my USD account.
My JE would be:
- USD checking Debit: $12,821 (this is the value of 10,000 Euros at a rate of 1.281)
- Euro checking Credit: 10,000
I transferred 10,000 Euros into my Euro checking account, but it took $12,821 USD.
The Posting Detail will show the debits and credits in more detail.