Can I run a report in US$ that is not converted to CAD$

SUGGESTED

Hi, I am trying to figure out if it is possible to run a report to show Deposits exclusively into my US$ account for Reconciliation purposes. 

Every time I do this it auto converts the amounts to CAD $ based on my exchange rate entered. 

This is causing problems when trying to match amounts CAD$ converted amounts through Invoices as they are in US$ amounts.

Can someone shed some light on how to do this and show me what I am missing to do this.

Thanks.

  • 0
    SUGGESTED

    Hi  ,

    Thanks for reaching out. I understand you want to run reports in USD without them being converted to CAD. There is a feature in the Sage 50 Canadian edition that allows you to view transaction balances in the currency of each account, which should help you with reconciling your USD accounts.

    Here’s how to do it:

    1. Open the Transactions by Account/General Ledger Report.
    2. Click on Options, then Modify Report.
    3. In the Show Accounts with field, select 'Balances in the currency of each account'.

    Remember to exit history mode to view reports in both CAD and foreign currency. However, please note that Sage 50 does not allow transactions to go directly from one foreign currency to another, which might be why you're seeing automatic conversions.

    For more detailed instructions on handling foreign currency transactions, you might find the following articles useful:

    If you follow these steps and still encounter difficulties, please don't hesitate to reach out for further assistance. If this helps, please mark it as verified :)

    Warm Regards,
    Erzsi