Currency gain/loss 1p out due to exchange rate

Hi @Silverfrost, here’s how I fixed exchange rate discrepancies Another look at "Creditor Control Account discrepancy - Foreign Currency"

This is a workaround, as an additional line is added to the relevant bank account but it is the tidiest way that I have come up with so far. The additional line is added as "Currency Gain/Loss for purchase #QF0??? (or Sales INV)” and TAGGED to “Something else not on this list” and allocated to N/L used for the purchase/sale. The alteration keeps the nominals with correct figures, but also removes these discrepancies from appearing from https://******.quickfile.co.uk/reports/historicalinvoices (or from type=sup)

As you have reiterated there is a problem using only a four decimal point for exchanges (when a sale/purchase is over about 230,00€ this problem occurs).

Hope you find this of help, the method keeps the Debtor/Creditor Controls in sync and removes paid invoices with an exchange rate difference.

2 Likes