Journal entry not using transaction-level exchange rate

I have accounts with a single supplier in two different currencies, USD and ZWL. I have a USD credit, but need to pay a ZWL invoice from them. They’ve transferred the funds across on their side and told me the exchange rate they used, which is slightly different from the exchange rate I have in my settings.

I created a journal entry in USD crediting the accounts payable of their USD account and debiting the accounts payable of their ZWL account. In the optional field for the ZWL amount, I entered the amount determined by the exchange rate the supplier used.

If I check my list of suppliers, both the USD and ZWL accounts appear to be balanced, with nothing owing or owed on either. Drilling down on the hyphens in the Accounts payable column shows a list of the expected transactions. However, in my summary page under Accounts payable is an amount equal to the difference on the transaction total calculated using their exchange rate compared to mine. I have reproduced the issue with a test business.

I wondered if I should allocate the difference to a “Foreign Exchange Adjustments” account as suggested by @Brucanna here, but since the accounts appear to be balanced in the supplier list I think this will just cause them to be unbalanced. Is this expected behaviour, or a bug? How should I clear the amount showing under Accounts payable?

Here are the transactions for Supplier A (ZWL):

The transactions for Supplier A (USD):

The journal entry edit screen:

The Accounts payable screen as seen when drilled down from the summary page:

And the entries showing when I drill down on the -ZWL$ 100.00 from the Accounts payable screen above:

In this test scenario above I had my exchange rate in the settings set to USD$1 = ZWL$15. For the journal entry I used USD$1 = ZWL$16. So the ZWL$100 under accounts payable seems to come from the difference between USD$100 calculated at the two different rates.

(I’m using Windows desktop verion 19.10.12.)

@GrahamvdR - it would appear that Manager has a conflict with data source handling.

First you have Supplier A (ZWL) transactions via the Suppliers tab drill down

Second you have Supplier A (ZWL) transactions via Summary > Accounts Payable drill down

The Suppliers tab drill down is showing the Journal Entry transaction as it was entered
0000000%20Bug%204

Whereas the Summary > Accounts Payable drill down is showing the same Journal Entry transaction as per the Settings exchange rate - USD$1 = ZWL$15 -hence you have 1,500 v’s 1,600.

I think your solution is to change the exchange rate for Oct 8 to USD$1 = ZWL$16
It’s not something which can be fixed with another transaction…

Meanwhile, I will list this as a bug.

1 Like

Thanks @Brucanna. Yes, you’ve distilled the problem nicely.

I agree that changing the exchange rate for that day seems like the only option for now. Thankfully I don’t think I have other transactions that’ll be affected.

Thanks. It certainly looks like a bug to me.

In the current multi-currency implementation, there is a minor limitation. Manager will ignore supplementary amount when entered on the last line of journal entry. The solution is to simply reorder journal entry line items. The latest version (19.11.88) will hide supplementary amount field for the last line item to make the limitation more obvious but eventually I’d like to make some improvements to overall multi-currency implementation so this won’t be necessary.

2 Likes

Thanks @lubos. Swapping the order of the line items in the journal entry fixed it. I’m glad it was that easy. I look forward to your planned future improvements.

In the latest version (20.06.45), the supplementary amount is no longer hidden on the last line of journal entry because new versions of Manager don’t have this limitation anymore.

1 Like