tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/111552-reporting-with-correct-currencyInfinite Kind: Discussion 2021-08-05T17:10:19Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/491812382021-05-06T15:43:26Z2021-05-06T15:43:26ZReporting with correct currency<div><p>Hi, I have been trying to do a report of all my expenditure broken down by exactly what I have spent it on over the years but am struggling.</p>
<p>As far as I can see there are two ways to see this, either a "Transaction Filter" report - but with this it reports the money in the currency used rather than the Sterling equivalent which is no use because that is obviously not accurate.</p>
<p>Or an "Income And Expenses Detailed" which will correctly bring through the Sterling figure but does not include the Tags field so it is not accuarate enough about what I have spent money on.</p>
<p>Can you please tell me which report I shou;ld use.</p>
<p>Thank you.</p></div>marktag:infinitekind.tenderapp.com,2009-01-14:Comment/491812382021-05-06T15:55:32Z2021-05-06T15:55:32ZReporting with correct currency<div><p>If all else fails, and if you are on MD2021 then after installing MD2021.1 preview 3066, you can download and install my extract_data extension and this will allow you to extract to CSV to load into Excel..</p>
<p><a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/491812382021-05-06T16:48:02Z2021-05-06T16:48:02ZReporting with correct currency<div><p>Thanks Stuart, that would be fine as that is where the data is heading ultimately.</p>
<p>I wasn't aware of MD2021, I'll look now as I am only on 2019.</p></div>marktag:infinitekind.tenderapp.com,2009-01-14:Comment/491812382021-05-06T17:01:19Z2021-05-06T17:01:19ZReporting with correct currency<div><p>Check your license version before you upgrade. You can also run extract_data as a script in Moneybot on 2019.</p></div>Stuart Beesley (Mr Toolbox)