QIF import loses check numbers for credit card payments
Just setting up Mondeydance 2014 (not 2015 yet, as I'm working on an older version of Quicken and want them side by side).
I exported Quicken data as a single file, then imported to Moneydance. In my Moneydance check register, payments made to a credit card account lost their check number. How do I get Moneydance to import the check numbers? I suspect this is happening for any credit card set up as an account in Quicken.
I've also downloaded transactions from my bank. These have check numbers, but when I use the manual merge, the transaction loses the check number from the bank.
How can I get the downloaded transactions to hold onto their check numbers when merged? I don't think it will be practical for me to re-enter every missing check number.
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
1 Posted by Ben Spencer on 29 Mar, 2016 12:24 AM
Could you attach a sample of your QIF file showing a transaction that should have a check number to make sure that your version of Quicken is exporting the check numbers.
Ben Spencer
Infinite Kind Support
2 Posted by Winston Weinman... on 29 Mar, 2016 01:14 AM
I've got Quicken on a different computer from email, which complicates sending you a sample. Oddly, when I opened the QIF file it opened in Apple Script Editor. But I can scroll and search the QIF file.
I found one transaction, for a credit card that has a "N" number in the QIF record that corresponds to the check number in Quicken, where the check number did not transfer to Moneydance. But I also found what appears to be the same transaction in the QIF file without a check number. The first is the bank payment, and the second is the credit card credit. It appears that the check number is being exported in the record for the credit card, but not being exported in the record for the bank. But the check number does not show up in the Moneydance account for the credit card, although the payment and date do. I checked a few other credit card payments, and the same thing seems to be the case.
Any suggestions on fixing this? I know you don't have any control over what Quicken exports. This is Quicken 2004 for Mac. But it does appear that the check numbers are in the QIF file, just with the credit card record, not with the bank record, for that transaction.
Here's an example of how two listings look for a Discover Card payment. Amount, memo, and bank name altered:
D2/25//16
PDiscover Card
Mabcd
T123.45
A
A
A
A
A
A
N1234
L[Discover]
^
D2/25//16
PDiscover Card
Mabcd
T123.45
A
A
A
A
A
A
L[BankName]
^
- Winston
Ben Spencer wrote:
3 Posted by Ben Spencer on 29 Mar, 2016 01:21 AM
I suspect the fact that the check number is only on one side of the transaction is the issue.
Just as an experiment could you manually edit the QIF file such that that transaction has N1234 on both sides of the transfer and then import the QIF file into a new Moneydance dataset.
Ben Spencer
Infinite Kind Support
4 Posted by Winston Weinman... on 29 Mar, 2016 01:30 AM
Yes, but I need to know what to use to edit it. I don't think Apple Script Editor will save it in the right format. In Text Editor it comes in as a graphic. How do I edit the QIF file?
Ben Spencer wrote:
5 Posted by Ben Spencer on 29 Mar, 2016 01:34 AM
A QIF file is just a text file. Any text editor should be able to edit it. You can use the Apple Script Editor App to edit a text file if you like. Just be sure that when you save the file you keep the .QIF file extension and you set the "File format" to "Text".
Ben Spencer
Infinite Kind Support
6 Posted by Ben Spencer on 29 Mar, 2016 01:36 AM
Actually it looks like Apple Script editor forces you to name the file with the .applescript file extension. You can edit the file name in Finder after you save it to put the .QIF extension back on.
Ben Spencer
Infinite Kind Support
7 Posted by Winston Weinman... on 29 Mar, 2016 01:51 AM
OK, altered the Discover entry lacking a check number and reimported into a new Moneydance setup. The check number came in to the bank account ledger, but with square brackets around it, like this:
[4184]
Ben Spencer wrote:
8 Posted by Winston Weinman... on 29 Mar, 2016 01:54 AM
ps: I also just noticed that the memo line for all account (bank and credit card) records also comes in inside of square brackets.
Winston Weinmann wrote:
9 Posted by Ben Spencer on 29 Mar, 2016 02:12 AM
The square brackets indicates the presence of a value in that field on the other side of the transfer but not on the side you are looking at.
I don't want to waste any more of your time here, I really don't think there is anything you could do to get the check numbers to import from your QIF file. Every version of Quicken produces QIF files that are slightly different I think what you are getting is just an oddity of the Quicken 2004 QIF file.
Ben Spencer
Infinite Kind Support
10 Posted by Winston Weinman... on 29 Mar, 2016 02:21 AM
I do have a copy of Quicken 2006 which I could upgrade to, then try the export again. But I know they dropped QIF at some point.
And, I probably COULD do it in FileMaker Pro. I'm pretty good at getting data to jump through hoops. But it would take some time to set that up, and may not be worth it.
Ben Spencer wrote:
11 Posted by Ben Spencer on 29 Mar, 2016 02:25 AM
It might be worth a try with Quicken 2006. Intuit didn't remove QIF Export until 2015.
Ben Spencer
Infinite Kind Support
12 Posted by Winston Weinman... on 29 Mar, 2016 03:09 AM
Quicken 2006 gave the same result. Is there not a way to alter Moneydance's preferences to use the check number downloaded from the bank when two transactions are merged?
Ben Spencer wrote:
13 Posted by Winston Weinman... on 29 Mar, 2016 03:10 AM
ps: I see there is an option to use bank dates for merged transactions. Why not check numbers?
Winston Weinmann wrote:
System closed this discussion on 28 Jun, 2016 03:20 AM.