In Qoyod, you can record a manual journal entry in a foreign currency: choose the currency and enter the amounts in it, and Qoyod calculates the equivalent in your organization’s base currency. The general ledger always stores the final amounts in the base currency.
Path in Qoyod
Accounting › Manual journal entries › Create entry
Steps
- Make sure the currency is added with its exchange rate under Settings, then the foreign currencies page, and that Allow Foreign Currency In Manual Journal Entries is checked under Settings, then General Settings, then Manual Journal Entries Settings.
- From the side menu, open Accounting, then the manual journal entries list, then create an entry.
- Choose the entry currency. The exchange rate fills in from the exchange rates already set up in Qoyod, and you can change it.
- Add the entry lines and enter each amount in the debit or credit in foreign currency column. Qoyod calculates the local currency columns.
- Save the entry, or save with deferral if the entry is deferred and choose the currency the automatic entries are based on.
Fields
- Currency: the entry currency. One entry takes one foreign currency only.
- Exchange rate: fills in when you choose the currency, and you can change it. The rate you set applies to every line of the entry.
- Amount columns: each line has four columns, debit and credit in local currency (LCY) and debit and credit in foreign currency (FC). You enter the FC amount and Qoyod calculates the LCY column. For illustration: if your base currency is the riyal and the US dollar rate is 3.75, an amount of 1,000 USD shows as 3,750 in the LCY column.
- Saving with deferral: the deferral schedule shows the deferral amount in local currency and in foreign currency. You choose local currency or foreign currency, and the automatic entries are created from the amounts in the currency you choose.
Special cases
The currency and exchange rate do not appear on the manual entry page
First check that the foreign currency checkbox is on in Manual Journal Entries Settings. Also check that your role has the foreign currencies permission, under Settings, then Users, then role management. If you are not an admin, ask your account admin.
I have transactions in two foreign currencies
One entry takes one foreign currency only. Record the transactions for each currency in a separate entry.
Notes
- The feature covers G/L account lines only. Customer payment and vendor payment lines are not supported yet.
- The general ledger stores the final amounts in your organization’s base currency.
- The feature is available on all plans.
- To show or hide the foreign currency fields on the entry page, see How to Toggle Foreign Currency in Manual Journal Entries.
- To add foreign currencies and set their exchange rates, see Multi-Currency Support for Foreign Currencies.
- To save an entry with deferral using deferral templates, see How to Record and Allocate Prepaid Expenses in Qoyod.
- For what changed in this update, see the release note Record Manual Journal Entries in a Foreign Currency.