This issue occurs because the foreign currency details are not recorded in the bank ledger.
When you receive a customer payment:
The Debtor (customer) ledger records the foreign currency exchange
But the Bank ledger may only record the amount in local currency
Since the Bank Reconciliation Report uses the Bank Ledger, it shows 0.00 for foreign currency.
Follow these steps to correctly record foreign currency in the bank ledger:
Go to Journal.
Open the Transaction file maintenance.
Click create transaction.
Click Add.
Enter Bank (Debit)
Select Bank Ledger (e.g., 3011/000)
Enter amount
Press F9 to add foreign exchange rate
Click Save
Enter Debtor (Credit)
Select Debtor Ledger (e,g., 3000/C01)
Enter amount (local currency)
Click Save
Click Accept.
Important:
Always press F9 in the Bank Ledger to include foreign currency
This ensures the report shows the correct amount