Foreign Exchange Transaction Journal Entries

SUGGESTED

Dear Team,

We're facing an issue with journal entries related to foreign exchange transactions. Let me present the issue:

The transaction

We're selling USD 12,000 to one of our business partners (note that this is not our bank, but only one of our business partners), and in return receiving EUR 10,000.

The question

What will be the journal entry transaction for those 2 transactions (will be done through our bank account). Particularly:

Transaction # 1:

Dr: account X (USD what account?)

Cr: our bank account (USD 12,000)

Transaction # 2:

Dr: our bank account (EUR 10,000)

Cr: account X (EUR what account?)

The issue is that at the end of the day we need to clear the forex exchange balances for given business partner, and this is where we get stuck. If we could create an additional journal entry in the Sage X3 by debiting the above-mentioned X account in EUR and crediting the above-mentioned X account in USD, it would have solved the issue. But we can't find such a module in the Sage X3. Urgent help on this would be highly appreciated.

Thank You very much in advance.

Parents Reply Children
  • 0 in reply to Martins de Almeida

    Dear Martins,

    Thank You very much for Your response. I didn't quite understand Your point. Our issue is currently that in the "Lines" tab of the "Journal entry" sub-module, we are not allowed to create a journal entry with two different currencies, since the Sage only expects one currency for all the lines. Could You please elaborate on this a bit more? Maybe we should do it via another module. Thank You very much in advance.

  • 0 in reply to Babken

    Hello,

    To create a journal entry with two different currencies you need two diferent ledgers, that's something you define in the beginning of your SAGE X3 configuration... But you still can do later. Check this video: https://youtu.be/AoF_RwYwjy4

    By ledger SAGE X3 means a way to have different chart of accounts, or different currency for the same company. By having a second ledger with a different currency means that you can post in main ledger with main currency and in the second ledger with the second currency, and this way handle the exchange rate variation.

    You can check this configuration in parameters-organizational sctructure, next to comapnies, chart of accounts, sites...

    This is the way we learned, and have configured for our customers, if you find another please revert.

    ALERT: You should do this only if you know what you are doing!!! Cheers.