Hello Community,
I'm experiencing a conceptual issue when posting unrealized gain entries at the end of each month. Let me explain the entries I should be recording and how the system is operating in this case.
ADJUSTING ENTRIES OUTSIDE Odoo
January Adjustment Entry: 31/Jan
| Account | Debit | Credit |
|---|---|---|
| Bank Account | 100 | |
| Foreign Exchange Gain | 100 |
February Adjustment Entry: 28/Feb
| Account | Debit | Credit |
|---|---|---|
| Bank Account | 12 | |
| Foreign Exchange Loss | 12 |
Note: By the end of February, there is a decrease of 12 in the bank account for this concept and an increase of 12 in expenses due to the foreign exchange loss.
ADJUSTING ENTRIES WITHIN Odoo
January Adjustment Entry: 31/Jan
| Account | Debit | Credit |
|---|---|---|
| Bank Account | 100 | |
| Foreign Exchange Gain | 100 |
January Reversal Entry: 1/Feb
| Account | Debit | Credit |
|---|---|---|
| Bank Account | 100 | |
| Foreign Exchange Gain | 100 |
February Adjustment Entry: 28/Feb
| Account | Debit | Credit |
|---|---|---|
| Bank Account | 88 | |
| Foreign Exchange Gain | 88 |
Note: At the end of February, the system reports a decrease of 12 in the bank account for this concept ([88-100=-12]), but it reports the foreign exchange loss incorrectly under the foreign exchange gain account, with a decrease of 12. Instead, the foreign exchange loss account should have increased by 12.
I understand that the system does this because the cumulative total from January 1st to February 28th reflects a net gain; however, if we only analyze February, it's a loss.
In my company, we have these accounts separated and need them to be accounted for individually. How can I achieve this in Odoo?
