Bank statement accounting for multiple currencies

System currency is $CAD. Sale is in $USD. Payment is made in $USD by check on date1 and entered in the system using a spot rate on that day. The payment is allocated against the invoice.

On date2, the payment is deposited in a $CAD account at a different rate.

The bank reconciliation creates a few problems.

Problem 1. The statement "create from" uses the bank currency ($CAD) evaluated on the date1 rather than the conversion rate at date2. The FACTS end up in the system currency rather than the source currency.

Problem 2. The manual entry does not set the statement line currency to the source currency. It can be set to $USD but the statement difference assumes all statement amounts are in the bank account currency. This creates an error in the statement difference and the ending bank balance.

Problem 3. The accounting facts created in the statement do not adjust the bank in-transit account for the realized gain/loss on the transaction. The error is the difference in exchange rate between date1 and date2.

See the attached image of the account info for the set of transactions. Note the checking in-transfer account transactions which would leave a balance in that account following the bank statement/reconciliation.

The FACTs created for the statement line should check the FACTs of the payments and ensure the transit accounts balance, with appropriate entries for realized gain on the transaction.

Mike