Currency issue with reports
Hi.
I am bust demoing the trial version as I am looking for an
alternative to Quicken. All good so fat except when I run the
reports, the totals and certain other numbers come up in dollars
although I have set the base currency to Rands. This is a bit of a
problem because I was looking forward to some decent reporting
which I found lacking on Quicken. It took me hours to get all my
quicken info in and adjusted, cleaned up etc to match my actual
bank accounts and statements.HAve attached a screen shot. What can
I do??
N
-
MD_Screen_Shot.png
30.9 KB
MD_Screen_Shot.png
Comments are currently closed for this discussion. You can start a new one.
Support Staff 2 Posted by Scott Meehan on 15 Jul, 2012 03:24 PM
Hi N,
What is your base currency set to? This can be viewed by going to Tools -> Currencies.
Scott Meehan
Moneydance Support
3 Posted by nic on 15 Jul, 2012 03:46 PM
Hi.
It is set to South African Rands
Support Staff 4 Posted by Scott Meehan on 15 Jul, 2012 03:58 PM
Hi N,
Do you have any accounts or categories that are in USD?
Scott Meehan
Moneydance Support
5 Posted by nic on 15 Jul, 2012 04:46 PM
Not that i know of. I imported all my data from quicken and all accounts (current, savings and credit) were in Rands.
6 Posted by nic on 15 Jul, 2012 05:58 PM
All those transactions which arrived intact after the import are in Rands. Its only in the reports that there are (seemingly) random Dollar values.
Support Staff 7 Posted by Scott Meehan on 16 Jul, 2012 12:49 AM
Hi N,
Can you try setting up a new data file and seeing the reports are still coming up in the wrong currency? Sometimes importing from Quicken does strange things, so this may fix the issue.
First, export your current .md file into a QIF file by going to File -> Export, choosing the QIF format, All Accounts, All dates, and Rands as the currency. Then, create a new .md Moneydance data file by going to File -> New and ensuring that it's base currency is Rands. Then, import the QIF file you exported into the new data file via File -> Import, using the options "Import into: New Account" and "File Source: From another program", and test the reports and see if they are still coming up in USD.
Scott Meehan
Moneydance Support
8 Posted by nic on 16 Jul, 2012 04:07 PM
Hi Scott.
OK. THe good news. All Rands. Bad news is it has done something bizarre with my transactions, half of which are in yellow and for future dates as far as 2014. It seems like all the transactions are there, but all dates are scrambled.
PS N is for Nic by the way. Pleased to meet you :)
Support Staff 9 Posted by Scott Meehan on 17 Jul, 2012 01:46 PM
Hi Nic,
Nice to meet you too :)
I'm glad the report is working now and I may have a fix for the dates. You may have to specify a different Date Format in the import window, due to your locale. I would suggest trying to create yet another new file, then go through the QIF import process again and change the date format to what your locale would be. Hopefully then the dates will work correctly!
Scott Meehan
Moneydance Support
10 Posted by nic on 17 Jul, 2012 02:01 PM
Hi Scott.
I'm not sure what you mean by locale. I think I have been consistent with the date formats. Could check again. My original format was DDMMYY and I think I have stuck to this. Is there something else to consider?
Nic
Support Staff 11 Posted by Scott Meehan on 17 Jul, 2012 02:04 PM
Hi Nic,
If you originally tried DDMMYY, I would suggest YYMMDD since you had dates in the future.
Scott Meehan
Moneydance Support
12 Posted by nic on 17 Jul, 2012 02:56 PM
Scott, you're a wizard!
The MMDDYY did it. DDMMYY was even worse.
Had a couple of duplications on one account which I nailed quite quickly. My current account is still out be R300 odd, but I reckon I'll adjust my opening balance and cut my losses.
Thank you, sir
N
Support Staff 13 Posted by Scott Meehan on 17 Jul, 2012 10:25 PM
Hi Nic,
Glad to hear that it s working for you now! Please let us know if we can be of further assistance!
Scott Meehan
Moneydance Support
Scott Meehan closed this discussion on 17 Jul, 2012 10:25 PM.