Home → Switching to Moneydance →

Incorrect import from Quicken qif file

• Edit

Marsha Draper

Jan 11, 2018 @ 10:16 PM

I am trying to convert my Quicken file to Moneydance, account by account. I am aware that Moneydance recommended a complete Quicken qif file, but I had legitimate reasons not to do that.

So far it has been working just fine for all my bank accounts and charge cards. However, transactions from my checking account to pay a mortgage, which are split into mortgage interest (a category) and principal (an account) were imported into Moneydance reversed. All the payments to principal were shown as Increases in the corresponding Moneydance file. I can't change the transactions individually because it would screw up the corresponding checking account transactions.

Any clues? This could mean Moneydance is not a viable option for me.

1. Support Staff 1 Posted by Ethan on Jan 11, 2018 @ 11:48 PM

   

   Can you clarify a bit what you mean by "all the payments to principal were shown as Increases in the corresponding Moneydance file?" This sounds like the way it should work, if I'm understanding what you are describing. If you had a mortgage of $100,000, that account would show as a $100,000 debt. Making a $1000 payment from your checking account would reduce your checking by that amount, and add that amount to your mortgage loan account, bringing its balance to $-99,000.

   Ethan
   Moneydance Support

   • Edit

2. 2 Posted by Marsha Draper on Jan 12, 2018 @ 01:42 AM

   
   
   
   
   

   -----Original Message-----
   From: Ethan <[email blocked]>
   To: marshadraper <[email blocked]>
   Sent: Thu, Jan 11, 2018 3:49 pm
   Subject: Re: Incorrect import from Quicken qif file [Switching to Moneydance #7551]
   
   
   Thank you for your response. You are correct, but Quicken does not show it that way, which is why I was perplexed. I was able to fix the situation by making the Opening Balance a negative number. That did not affect any other accounts. Now that you pointed that out, it seems that Moneydance is a better representation of the account.

   
   

   Is it possible to generate a report on a specific category?

   
   

   
   

   #AOLMsgPart_2_14a38288-c90d-4efc-adf5-a132a30975b2 td{color: black;} .aolReplacedBody pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background: #efefef; border: 1px solid #d6d6d6 } .aolReplacedBody blockquote { margin-left: 0; padding-left: 1em; border-left: 5px solid #ccc; }

   // Please reply above this line ================================================== From: Ethan (Support staff) Can you clarify a bit what you mean by "all the payments to principal were shown as Increases in the corresponding Moneydance file?" This sounds like the way it should work, if I'm understanding what you are describing. If you had a mortgage of $100,000, that account would show as a $100,000 debt. Making a $1000 payment from your checking account would reduce your checking by that amount, and add that amount to your mortgage loan account, bringing its balance to $-99,000. Ethan Moneydance Support On Thu, Jan 11 at 02:16 PM PST, Marsha Draper wrote: I am trying to convert my Quicken file to Moneydance, account by account. I am aware that Moneydance recommended a complete Quicken qif file, but I had legitimate reasons not to do that. So far it has been working just fine for all my bank accounts and charge cards. However, transactions from my checking account to pay a mortgage, which are split into mortgage interest (a category) and principal (an account) were imported into Moneydance reversed. All the payments to principal were shown as Increases in the corresponding Moneydance file. I can't change the transactions individually because it would screw up the corresponding checking account transactions. Any clues? This could mean Moneydance is not a viable option for me.

   Having trouble reading this? View this discussion online: Incorrect import from Quicken qif file. Reply with #ignore to stop receiving notifications for this discussion.

   • Edit

3. 3 Posted by Ian O on Jan 12, 2018 @ 12:26 PM

   

   Hi Marsha,

   Within Moneydance, you can navigate to Tools --> Graphs and Reports, then select the 'Income and Expense' report.
   Within the report settings window, you'll see a window at the bottom of the screen which likely shown 'All Income' and 'All Expense'. To the right of this window, you'll see a button displaying 'Show: By Individual'. Select this to view all of your income and expense items.
   You can select 'None' to de-select all items and then choose the specific expense categories you need to report on. Select the other report settings and then 'Generate' to view the required data.

   Ian O
   Infinite Kind Support

   • Edit

4. System closed this discussion on Apr 13, 2018 @ 12:30 PM.