Foreign trader customer and supplier balances
I am looking at a set of data (on the 2011 version) where for one customer and one supplier balance there is mismatch in the balances - they should both be zero and are zero in their own currencies (GBP) but in base currency (USD) they have small credit balances.
These are due to revaluation transactions and whenever I have seen these before I have always been able to get rid of them by deleting the a payment or receipt and re-entering it at a slightly different exchange rate but this doesn't work in version 2011 and upwards because the revaluations don't necessarily get deleted.
Has anyone come across this before and have a different solution other than getting the data fixed?
Similar
I use version 11 and have foreign currency transactions.
I have seen similar however, has been due to the balance not been cleared at the bank ie:
Customer receipt posted as 'on-account' and not actually matched against the invoice. Matching against the invoice clears the balance.
Regards
Heather.
Currency translation gains or losses
I suggest the same as Pat's;
They can be written off to translation gains or losses by putting appropriate entries through the supplier or customer accounts. This can be done at the same time as putting payments/receipts through to avoid differences remaining on the accounts.
-
Comments: 3
-
Comments: 4
-
Comments: 6
-
Comments: 4
-
Comments: 3
-
Comments: 6
-
Comments: 3
-
Comments: 13
-
Comments: 2
-
Comments: 1




Thinking logically
Couldn't you post an invoice/credit note, both coded to exchange variances in the P&L, with different exchange rates calculated to compensate that balance on the account. The net balance from the account would then be moved to variances.
i.e. credit (negative supplier rather than TB) balance of €10, post £100 invoice @ €1 to £1, makes a balance of £100 or €90, then a £100 credit @ €0.9 to £1, makes a balance of £0 or €0.
Cheers
Pat