Multiple currency expense categories

Chris's Avatar

Chris

29 Oct, 2019 04:00 AM

How do I set up a multiple currency expense category if reporting currency is USD and Transaction Currencies are Euro, ZAR, CHF from various accounts?

  1. Support Staff 1 Posted by Maddy on 29 Oct, 2019 11:41 AM

    Maddy's Avatar

    Hi Chris,
    Thank you for contacting Moneydance support.

    In Moneydance it is only possible to assign one base currency to an account.
    In your case you will need to choose the currency that is most in use or that you generally use, as the base currency.
    To enter transactions with different currencies into the account, you will need to create categories that use the other currencies.

    For further details on creating categories, please refer to this article, "Create, edit or delete Categories "in the Knowledge Base.

    It might be useful to see "Create, Edit or Delete Currencies" available here, as well.

    3 - The steps for entering different currency transactions into E.g.: a Travel cash card:
    Enter transaction, assign the correct currency category, this will unlock the foreign amount area in the transaction and display the exchange rate, lastly save the transaction.

    Finally, you should install the Quotes and Exchange Rates extension. To do this, choose Extensions --> Manage Extensions.
    To update currency rates, you can use AlphaVantage or European Central Bank.

    I hope this information is helpful. Please let me know if you have further questions or need any assistance.

    --
    Maddy, Infinite Kind Support

  2. 2 Posted by dwg on 29 Oct, 2019 07:26 PM

    dwg's Avatar

    I'm a fellow user.

    Within an account or a category all transactions must be in the same currency, There is no way of differentiating between currencies on a individual transaction basis. There are two ways of dealing with this.

    Firstly you can provide an exchange rate for the transaction if it is in a different currency.

    Secondly you can create categories in selected currencies. When you have categories in different currencies the software when you create reports will convert the total of the category to the base currency using the echange rate on the date of the report.

  3. System closed this discussion on 28 Jan, 2020 07:30 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac