Quickbooks consolidation of two entities using different currencies

Our primary business is in the US and we consolidate our financials into USD. We opened another branch in CAD and due to regulatory reasons, set it up as a separate entity. We have two separate Quickbooks files, one for our US operations in USD$ and one for our Canada operations in CAD$. We have an intercompany account that was set up so that the US company can "lend" money to the Canada company until they become profitable. We currently reconcile this intercompany account every month and take the difference (based completely on exchange rate differences) to OCI. We charge interest on the Intercompany account as well. Both the intercompany and Interest charged pieces are zeroed out in the consolidation process. My two questions are this: 1.) Is there a way to pull these QB files into one QB report and report both in USD$? I'm assuming we would need to enter a month end exchange rate and the average month exchange rate in order to convert these numbers, but is there a simple way to do this right from Quickbooks without messing around in Excel too much? 2.) What are the proper month-end accounting journal entries to account for exchange rate differences? I'm assuming that since we are not cashing out or paying off the intercompany balance that there are no realized gains/losses. But I'm unsure of if we can run the exchange rate differences through the OCI account or if we need to hit our Income Statement. Any help from the experts out there with experience with these multi-curency adjustments would be greatly appreciated.