Credit Control Account discrepancy - Foreign Currency After manually entering the discrepany by way of a journal, I thought that the problem had been fixed, but when doing a Historical Creditor Report https://******.quickfile.co.uk/reports/historicalinvoices?&type=sup the invoice was still appearing even though showing “PAID”. QuickFile had identified the 1p discrepancy.
Journal entry deleted, and a seperate Invoice for the first payment (deposit) raised and allocated to “Prepayments” and the other Invoice updated with an additional line with the “Prepayments” credited back. This enabled the two payments to equal the two invoices and so the discrepancy disappeared and the paid invoice no longer reported on the Historical Creditor Report.
Another paid invoice appeared in the Historical Creditor Report, this was for a single transaction, but again a 1p discrepancy in Creditor Control. Invoice 233,00€ @ 1.130190 = £206.16) but the payment was 233.00€ @ 1.130245 = £206.15. The use of four decimel place exchange rate 1.1302 does not allow for the invoice to be raised to match the payment.
The payment has been entered to match the invoice and an additional line in the bank account to reconcile the bank balance has been entered “Currency Gain/Loss for purchase #QF02924” and TAGGED to “Something else not on this list” and allocated to N/L used for the purchase. So another paid invoice that was reported in Historical Creditor Report no longer reported.