Currency on Reports

paul's Avatar

paul

07 Feb, 2024 05:31 PM

I have four AustralianDollar Accounts and one British Pound account. I found that reports use the currency of the category so the GBP account reported in Australian dollars (also the default currency), The internet revealed that the report used the currency defined on the categoryso I spent a long time setting up a set of categories for GBP. Now I find that reports on only the GBP account report the transactions using GBP but the totals for each category are in Australian dollars. Is there a way to make the reports total properly in the currency of the account being reported on? Or, since Moneydance seems incapable of totalling in anything other than the default currency, is the only way to have Moneydance report different currencies properly to set up separate files for accounts in different currencies?

  1. 1 Posted by Bryce on 13 Feb, 2024 01:07 AM

    Bryce's Avatar

    I also have this problem - is there any solution?
    My base currency is set to AUD, but I want to do a report on some GBP accounts in GBP. I've tried changing the base currency (temporarily) to GBP and restarting MoneyDance, but this doesn't work.

  2. 2 Posted by Stuart Beesley ... on 13 Feb, 2024 05:49 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Reports tend to obey the currency of the specific account/category. When multiple things are selected to total that mix currencies, then they tend to report as per above, and then grand total in the base currency.

    If your reports are fairly constant you could set up some custom rows in the custom balances extension, and choose the displayed currency.

  3. 3 Posted by paul on 13 Feb, 2024 11:05 AM

    paul's Avatar

    Thank you Stuart, but the issue is totals on the reports. The particular one I am interested in is the Transaction Filter. Every single category on the report is £ but the totals are in AU$. I want totals in £. The extension looks useful but I don't want a balance in the summary for every category group - I just want totals on the reports in the currency of the categories on the report when they are all the same currency.

  4. 4 Posted by Stuart Beesley ... on 13 Feb, 2024 11:56 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    👍 I would expect the transaction filter, when grouping (which creates a running total), to report the running total(s) in the base currency...

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Screenshot_2024-02-07_173016.png 13 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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

Recent Discussions

01 Mar, 2024 10:51 AM
01 Mar, 2024 09:28 AM
01 Mar, 2024 05:41 AM
29 Feb, 2024 10:36 PM
29 Feb, 2024 09:19 PM