Hi,

You haven't mentioned if the company books are in 'Historical Entry' mode, or not.

Assuming they're not, If you go to the Maintenance menu and choose Integrity Check, is there any problem, or does it show 'Data OK' at the bottom?

Have you ever posted a Prepayment? These go into the Current Liability section for Accounts Receivable, so the Accounts Receivable amount won't equal the final total of the aged receivable list. (there is a breakdown)

Are you running the Aged Receivable list, or the Aged Overdue Receivable list?

Are you running the Trial Balance vs A/R reports as of the exact same date?

If you run a detail report showing the foreign currency, do the numbers look right?

It's necessary to do (manual) period end adjustments to the Home Currency balance of any foreign currency bank account, but not a linked Receivable or Payable account (except for Permanent Impairments at year end, but that's another story)

If your AR on the trial balance is only showing as 28,525 with a CND equivalent of 203,525 it sounds like one or more entries has been posted with an incorrect foreign exchange rate. Your US equivalent should be close to the current Bank of Canada exchange rate, say .75 US to the CND dollar in March 2017. The exchange based on the 2 AR values given is more like 0.14 US to the CND dollar, which would also explain why your FX balance is negative and probably quite large.