Thank you for the reply.  This did not fix the issue.  To be more precise here is an example of what the problem is.

Trial Balance

A/R - Swiss Franc - 0 but it shows a credit of .56 

The accountants want the Swiss Franc A/R to show a zero balance in the debit and credit column.  Mine 0.56 credirt.  This is due to foreign exchanges rates when posting.

I show similar issues for A/P foreign currencies.

Hoping someone is familiar with this issue, and can provide a fix.

Have you checked your Customer Aging report to see if there are any foreign currency transactions that have not been finalised yet?  It is possible that there is an invoice for SF$100 @ 1.5  and a credit invoice posted with a different exchange rate.  If the credit has not yet been applied to the invoice, there may still be a CAD equivalent in the reports.

See the two images below.  The first image is the dialog to create the report in the second image.  The second image shows a Euro customer with no dollars owing but all three invoices are unpaid.  The cleanup would be to go to Receipts and pay the credit against the invoices.

Because in this sample file, I had unlinked the Accounts Receivable linked account while foreign currency transactions existed, the balance on the Trial balance for Euros on the same date as the Customer Aging was EU0.00.  However, after posting the credit invoice it was a credit of 6308.18.  Original invoices exchange rate was 1.1, credit was 1.2

Normally in CAD, if you pay one invoice against a credit of the same amount, then the entry is $0 and therefore there is no journal entry.  In this case, there is a journal entry of $525.68 (0.1 difference in the exchange rates).

The unpaid transactions may not be the issue but it is worth checking.  You will not see the outstanding invoices on the summary but you will on the detail report if they exist as unpaid and if you follow the steps below.  The cause may be that the Accounts Receivable Linked account was unlinked at one point.

Have you checked your Customer Aging report to see if there are any foreign currency transactions that have not been finalised yet?  It is possible that there is an invoice for SF$100 @ 1.5  and a credit invoice posted with a different exchange rate.  If the credit has not yet been applied to the invoice, there may still be a CAD equivalent in the reports.

See the two images below.  The first image is the dialog to create the report in the second image.  The second image shows a Euro customer with no dollars owing but all three invoices are unpaid.  The cleanup would be to go to Receipts and pay the credit against the invoices.

Because in this sample file, I had unlinked the Accounts Receivable linked account while foreign currency transactions existed, the balance on the Trial balance for Euros on the same date as the Customer Aging was EU0.00.  However, after posting the credit invoice it was a credit of 6308.18.  Original invoices exchange rate was 1.1, credit was 1.2

Normally in CAD, if you pay one invoice against a credit of the same amount, then the entry is $0 and therefore there is no journal entry.  In this case, there is a journal entry of $525.68 (0.1 difference in the exchange rates).

The unpaid transactions may not be the issue but it is worth checking.  You will not see the outstanding invoices on the summary but you will on the detail report if they exist as unpaid and if you follow the steps below.  The cause may be that the Accounts Receivable Linked account was unlinked at one point.

Thank you for your reply.

I have a few CHF clients I invoice in that currency.  All invoices and credits have been cleared.  I think this small value happens because I post invoices based on the BOC Rates per invoice date, then once Invoices are paid I will use a different rate which is based on the BOC Rates.