I just "succeeded" in recreating my data file using a QIF export/import

  • 0
  • 2
  • Article
  • Updated 5 months ago
I thought I would post this while it is fresh in my mind.
I have data going back to 1996 and up until now I have never been successful in recreating my data file through a QIF export/import.

There are fundamentally a couple of things that stop this from being successful.
The major one is that Quicken's handling of transfers is terrible.
The secondary one is that there are some security transactions that the QIF format just doesn't support.  The main one is that it can't keep track of "security lots".  And as such it can never do things like options correctly.  And of course there isn't any support for things like the ESPP wizard actions/hidden data.  It also doesn't support investment transaction that involve a "banking split".

Well my days of employee stock options and ESPPs are behind me, and I don't trade options.
So my biggest obstacle was the transfers.

I was thinking lately about the fact the Quicken Essentials didn't actually link transfers, and that Quicken Mac still allows this.  And in fact that as long as you have offsetting transactions in each register that is really all that is needed for it to come out OK.  Sure you can't do the jump to the other account action, and in reports/budgets you are doing something that requires filtering by transfers then you aren't going to be able to do that.  But I haven't really cared about that so I thought about it and decided that I could just export the QIF file, and then for every transfer change them to [Account I'm In].  Another possible is using categories like AccountA_Out, and AccountA_In.  With that some filtering could still be done.  But for my test case I just made them transfers to the same account (balance adjustments).

I wrote a small Perl program to do that for me.

With this change every transaction import is now new.

I create a new data file, canceled out of creating the first account.
And I went into the category list and deleted them all.
And then did the import selecting everything except for "special handling of transfers".

And this worked quite well.
I ran into just a few of problem.
One is that I had to run validate and repair a few times until it called the file "clean".
Some of this had to do with the category list and other minor things.
It cleaned it up with no real problems.

One problem I could have avoided if I hadn't started this during the day while the price of securities were changing (or by not updating my main data file).  What happened is that since the importing of the prices through QIF are considered "manual" they overrode any kind of update for the day.  I ended up deleting today's prices and updating to get it correct, but I could have just waited to tomorrow too.

The another problem I ran into was one of my long close brokerage accounts wasn't zero.
I found two duplicate transactions, I have no idea why these showed up.  But I just deleted them.

The last problem involved my employee stock option account.  For whatever reason it said I had 4 shares left.  So I did a remove, only to find that it had put in some kind extremely big negative amount at point, which I saw on my net worth graph.

I played around with the date and noticed that anything before that date got zero on the net worth graph.  So in the end I removed the 4 shares on the day of the first transaction in my data file, and everything looks fine now.

I'm sure if I looked at the details in say the accounts like the stock options account I would find something "not quite right".  And certainly if someone was not using first in first out the capital gains wouldn't be right.  But overall it all looks good to me, and now finally can recreate my data file if I want to.  I will probably play with this some more and make sure there isn't any big gotchas, before I actually commit to recreating my data file.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of mshiggins

mshiggins, SuperUser

  • 407,986 Points 100k badge 2x thumb
I am surprised you had any doubts. QIF is not hard once you know how it works, but it can be tedious getting everything just right.
Photo of mshiggins

mshiggins, SuperUser

  • 407,986 Points 100k badge 2x thumb
I've always imported one account at a time and prepped the QIFs to remove one side of the transfer.

You can't QIF ESPPs or employee stock options. You also can't QIF reminders.
Photo of mshiggins

mshiggins, SuperUser

  • 407,986 Points 100k badge 2x thumb
Oh and you can't QIF Date Acquired if different than transaction date for Add Shares.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Sounds like a LOT of work, and I don't like my paychecks being split into 5 transactions.

My ESPPs and employee stock options actually came over fine.
Mind you I'm just talking about getting their value right at any given date for the net worth graph.  Not all the tax details and such, which I don't care about since they are long closed accounts.

One export of the QIF file.
One import of the QIF file.
Go to each account with a red flag and select Accept All.
Go into the Hidden Accounts dialogs and set those flags.
Fix up the things I mentioned above.

What I haven't done left would be to recreate the reminders, report, and connect for downloading transaction/removing downloaded transactions (wouldn't even try to match them).
Photo of mshiggins

mshiggins, SuperUser

  • 407,986 Points 100k badge 2x thumb
What are you talking about? I've never had any issues with my paychecks when importing via QIF.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
It isn't paychecks exactly, it could be any split transaction that has transfers in it.

When you select the import option of "special treatment for transfers" what Quicken does is delete the "from" side of every transfer.  The reason this is done is because Quicken's transfer matching stinks.  So this avoid behavior avoids that by only having one side of the transfer entered during QIF importing (the "to" side of the transfer).

The problem I have with this is they should have picked the "to" side to delete.
For instance you have a paycheck and you have a transfer in it to your 401K account, and maybe one to a flexible spending account.  That kind of thing.

What it is going to do is delete the transfers out of that split transaction.
So how do these transfers get put back in?
When you import the transactions for "to" account it will create the transfers back to the first/paycheck account.  But in doing so you will have the original split transaction, plus one for each transfer that was in that account.  Pretty messy.

If you don't select the "special treatment for transfers" it will leave both sides of the transfer in and the split/paycheck transaction will not get split up, but you have the problem of dealing with matching up the transfers.  Something that Quicken if very poor at handling.

But I can tell you even with using the "special treatment for transfers" option and ignoring the messy splitting up of split transactions with my data file I have run into other problems.

Now clearly if I was to go one transaction at a time and work at it, I might have had better success, but I don't have the patience to go through over 20 years of transactions.  If Accept All can't be used, I don't want to use it.

And I don't thing most people do unless they are pretty desperate.
And I didn't really find importing one account at a time to be any better.

A long time ago I created a program to export each account into a separate QIF file (automated the pressing of the buttons).

And then try importing them one at a time.  And like I said I didn't see any real difference between that and just importing all the transactions at the same time, with maybe the exception of importing the investment accounts because with those the transactions don't even let you accept transactions, they go right into the account.

From what I have seen you have to have an exceptionally simple data file or be willing to basically look at every single transaction.

I don't have that kind of patience.
Photo of gmalis1

gmalis1

  • 162,070 Points 100k badge 2x thumb
Care to explain to us non-techie Quicken users the reasoning for creating a .qif file for export?

Also, how did you handle closed and hidden accounts?  Do you un-hide them?

If this is a "bomb shelter" approach to Quicken's subscription policy, I'll just move on to another software and start fresh from there.  
Photo of mshiggins

mshiggins, SuperUser

  • 407,902 Points 100k badge 2x thumb
What is wrong with your ESPP and stock option accounts? I've had the same accounts since 1999 and they are still working fine.
Photo of mshiggins

mshiggins, SuperUser

  • 407,902 Points 100k badge 2x thumb
Also Notes and Flags don't QIF.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
On the ESPP and stock option accounts.  What I was referring to is at one point they got corrupted.  Basically the "wizards" wouldn't do the right things in those accounts any more.  I had long since just started new accounts for them, and the old accounts are just for the history up to that point.  But I have also long since left that job, so even the replacement accounts are only for the history now.

But for the stock option accounts, if a person has accounts that are active, and they are thinking that they can use QIF to move them to another account they are in for a surprise.  The main problem is that stock options are very dependent on their "lot".  Without knowing which lot of the security you can't calculate the cost basis and such.
The QIF format has grants and vest and such, but no way to export/import what lot any given share is in.  But on top of that and this where the ESPP comes in there is "hidden" information in both of them that the wizards create to maintain things like the discounts and other tax ramifications.

When these kind of accounts are finally closed, and all the sells and expires and such are in, then basic QIF information is enough to capture the current value of the security/account at that point.  But not when it is active.
 
On the Flags and Notes, True, but I have never used those.  :-)
(Edited)
Photo of mistertheplague

mistertheplague

  • 6,320 Points 5k badge 2x thumb
BTW for people that want to go to another application, but don't want leave their history behind, a QIF export is the way they go.  And in general the other applications are much better at import QIF files than Quicken is.  
Of possible technical interest in this area: QIF imports from Quicken to MS Money which include Memorized Payees always seem to fail outright (i.e., Money terminates the entire import with one of several error messages), even though Money also memorizes payees.

Money generally ignores the account name at the top of a Quicken QIF file and prompts you to manually direct which Money account the import should go in.

Account List import is hit or miss, meaning some transfers register accurately in Money, others don't. I have no idea why this happens, but it creates the potential nightmare of trying to figure out which transfers imported and which didn't.

If you don't know better (like I didn't when I first did this), you'll try to import another QIF, compounding your misery. If you're especially stupid (like I was), you'll then delete the offending account in Money, thinking it will delete both ends of each transfer transaction and that you'll be able to start over. It/you won't. 

The Security List in a Quicken QIF isn't ignored by Money on import, but Money will prompt you to manually match each security named in the Quicken QIF with a security in your Money file, and if one hasn't been pre-populated in Money, Money will make you create the security at import before you can continue.

Transactions and Categories come over fine (more or less), but Quicken categories will be added to your Money Category list, creating an ungodly mess, because Money's Category List and Quicken's Category List are just similar enough (Bills vs. Bills & Utilities) to make spotting the imposters difficult. Weirdly, some Expense categories in Quicken get put in Income in Money, but not vice versa. Money doesn't have subcategories of subcategories so your Quicken sub-subs (sub-squared?) will appear in Money separated with a hashtag, i.e.: Category>subcategory#subsquared.

Memos and Tags (called "classes" in Money) always import without a hitch, correctly placed in their respective register fields. Hallelujah. 
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Actually one reason I put in the "in general" is because MS Money wasn't on my list of applications that are "much better".  I had tried importing into MS Money before and failed miserably.  I was really thinking more of the "little players".  Both MS Money and Quicken basically didn't really care that much about this kind of thing, but it is very importing to the "little players" if they are going to have any hope of getting any business from the "big two".

In my opinion, in some ways both Microsoft and Intuit purposely didn't make it easy, so that people couldn't jump between the two.  Not being able to change easily between the two was one of the biggest reasons the two groups tended to capture their customers "for life".
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Here are a few more things to be aware of.
  1. The QIF format has a very limited amount of account types.  That means for any account that is a "special account type", you need to create those kind of accounts in Quicken before doing the QIF import.  There are very few cases where you will be able to change the account type after it is created.  For instance both traditional and Roth IRAs will be created as brokerage accounts, and will not be marked tax deferred.  For the traditional IRA it is probably just fine to just change the tax deferred status, but for the Roth IRA they are treated special in the Life Time Planner, so those should be created before the QIF import.  I didn't both with trying to have linked cash accounts (linked to investment account) be right, but they would certainly fall into this category if you want them to work as linked accounts.   And haven't tested any of the special business accounts, but I'm sure there are the same kind of problems there.
  2. Categories that created by the QIF process will be marked for tax related or not, but they will not have the proper tax lines associated with them.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
BTW I thought I would mention something strange I see.  Opening my original data file takes about 9 seconds.  The new QIF created data file takes about 17 seconds.  Once open I don't see much difference in performance.  Not really a big deal, but it is pretty strange.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Very.  Not only can I repeat the timings over and over by restarting both data files, I have actually done the whole export/import process a second time, and it still does the same thing.
Photo of Rocket J Squirrel

Rocket J Squirrel, SuperUser

  • 66,832 Points 50k badge 2x thumb
Perhaps File > Copy might clean out some cruft?
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
I tried it, but it didn't make any difference.
I also did Validate & Repair and that didn't make any difference either.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
I tried a different experiment.  I imported my QIF file into Quicken 2010, which have running on a Windows XP virtual machine (just because it was the easiest place to install it).

The data file loads in 3 second into Quicken 2010.
Then took that data file to my main machine, and had Quicken 2017 convert it.
And it still takes about 17 seconds to load.

I might have to try deleting some accounts or something to see if I can see what offends Quicken 2017 so much about it.  I'm guess it has to do with the account that have the employee stock options in them.  But that is a wild guess, and really should be true since I'm not even opening those accounts.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Well I found it.  Removing the tax related flag from all the categories got me back to the normal loading speed.  I didn't try just setting them to right tax lines because it was just faster to remove the flag.

I then just started adding the tax flag back on a lot of categories and that didn't slow it down.

So the QIF import is some how corrupting the category data.
I think it has to do with (or at least manifests itself) with the fact that the QIF data does have the tax line information on it.  When the QIF is imported (even into Quicken 2010) the category tax related flag is set, but the tax line isn't.
So right there points to some kind of problem where the QIF import doesn't understand how to get the tax line set right.

BTW I tried deleting account, the price list, rebuilding the lot information, setting the account options like hiding on the account bar, I even did a Year End Copy which reduced the data file size in half, and all those kinds of things, but nothing else affected the speed of loading the data.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
I decided that instead of a program to change transfers to categories I would try do "Special handling for transfers" correctly.  In other words what this option on the QIF import does is remove one side of the transfer so that there isn't any need for matching transfers.  But the way Quicken does this is by removing the "from side", as in it removes the transfer out of split transactions, which results in all the split with transfers being broken up into multiple transactions.

So I have written a program to remove the "to side" of transfers so that the split transactions will stay intact.

In the process I ran into something that even though in some cases people might like, I'm sure no one thought was possible, and it means that basically other than "rough guessing in the same date range" no real matching of transfers can be done.

Here is a transaction that is a linked transfer, first in the checking account.

Now in the PayPal account:


Nothing strange until you look at the dates!

The way this created is that I imported a QIF file with the transaction on 12/17/2016, and with the category set as a transfer to my checking account.

On 12/19/2016 the transaction was downloaded into my checking account and matched to that transaction.  Notice it took on the posting date, instead of the date of the transaction that was already in the account.

When exported to QIF these two transactions aren't on the same date and as such I can't really identify them as the same transfer so that I can remove one of them.

So it looks like I'm back to my old method to make all this work and just change transfers to categories, and give up the linked transfers if I have to ever do a complete rebuild of my data.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
For anyone that wants it here is the program that will change transfers to a category named like xfrACCOUNT_NAME.
http://www.quicknperlwiz.com/changetransfers.html
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
BTW speaking of transfers.  When you have accounts that have different currencies and transfer between them, there is a popup for every transfer transaction asking you about the currency conversion rate.  That would be a serious problem for years of transactions.

I haven't tested it, but I would think that method for converting the transfers to individual transactions would solve that problem too, but only if a person took the proper step or creating the accounts that are not in the home currency, before doing the import.  I'm going to add this to that thread.

Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
I just thought I would mention that the 2018 release of Quicken has a feature that might benefit people in some cases.

Say you create an account and it isn't the right account type, and Quicken doesn't provide a way to change the account type to what you want.  If the account isn't an investment account the general procedure for fixing this would be to create a new account with the right type, and moving the transactions from the old account to the new one.

Before the 2018 release of Quicken it wasn't possible to move investment transactions between accounts, but with the 2018 release of Quicken it is now possible.  So, this is another tool that people can use.  The move transactions menu option is on the settings/gear icon for the account, or on the "right click" menu.
Photo of Beijing Mac

Beijing Mac

  • 3,256 Points 3k badge 2x thumb
could you also use a Cut & Paste of the transaction to move from one account to another?  or does that only work with a savings / checking / CC?  maybe I did not do that with investment account.

Photo of QPW

QPW

  • 370,960 Points 100k badge 2x thumb
Cut & Paste only works in the non investment accounts (actually called Copy, and Move on the menus).  And in fact because of a problem of it asking about every single reconciled transaction that gets moved,, the recommended method is to use the copy, and then delete after that.
Photo of QPW

QPW

  • 370,960 Points 100k badge 2x thumb
Note another way that people have dealt with the investment account being the wrong type is to create a new account and use the move securities function, which puts in transactions to remove the security in the old account, and transactions in the new account to add them.  But that method leave the old account/history and I also believe the cost basis isn't correct after the move.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
I got a bit of a surprise when I was looking at my transactions in the new data file yesterday night.
"Most" of the transfers were "linked".  Note I used my program to change all the transfers to categories like xfrAccountName in the QIF file.

In my haste to setup for the QIF import I forgot to turn off transfer detection.  It was in its default mode of being on, and not confirmed.

And so it was run for the QIF import and did a quite good job.  I said "most" above because transfer detection isn't applied to transactions that have a transfer in a split transaction.

Transfer detection works quite well in my data because I seldom have the same amount repeated around the same date.  Your results might vary.

BUT let me say this doesn't happen in the 2018 release of Quicken.
I did this conversion using Quicken 2013 (any version up to Quicken 2017 should do the same).

In the 2018 release of Quicken they have this bug/change in behavior for the QIF imports where the transaction go directly into the register with no processing.  That speeds up the process alot because you don't have to do Accept All in each account, but it also means that Transfer detection isn't run for QIF imports.
https://getsatisfaction.com/quickencommunity/topics/qif-importing-into-quicken-windows-2018-is-broken-in-the-r2-3-patch-update
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Last night I decided to take my newly created data file and activate the accounts for downloading.

Note the assumptions here are that I have all my accounts up to date and reconciled.  So unless there are any "real new" transactions, the main goal I had was to get the unique Ids recorded in the registers so that they wouldn't be imported again, and to basically get rid of the "overlapping" transactions.

For people that aren't using the automatic entry just deleting downloaded transactions can cause problems because then your old transactions will still show up on the manual match list.  But with the way the automatic entry transaction mode's manual match this isn't a problem, so I'm ignoring that problem.  For a discussion on this see this thread:
https://getsatisfaction.com/quickencommunity/topics/how-can-i-filter-or-remove-cleared-or-reconciled-items-from-the-manually-match-list

The process of setting up the account for downloading transactions and the removal of transactions in the non investment accounts went through without any real problem (only had a couple of real new transactions to deal with).  Note I'm using automatic entry mode since I find it much faster to deal with these.

When I got to the investment accounts is was a different story.

Some accounts nothing downloaded and so there was nothing to do.

But in a 401K account there were a bunch of automatic matches, and a couple of new transactions (there are no "real" new transactions in this account).

This wouldn't have been a problem except that Merrill Lynch downloads reinvested dividends as buys. So each month when these come in I change them to reinvesting dividends.

When these transactions were matched, Quicken changed these to buys.  Still not real problem, right?  Just unmatch them.  Nope I unmatched them and when Quicken split them back apart it changed my reinvestment transaction in the register to a buy.

So, I went to a backup and tried this again.  This time with automatic entry mode off, and then I just deleted the transactions in the Downloaded Transactions tab.  There wasn't that many of them so that worked.

Then I got to a Roth IRA account the had transactions most of which were matches, that I figured I would deal with the same way.  Nope!

As soon as I touch the first transaction Quicken pops up a dialog saying that the cash amount isn't correct and to type in the correct amount.  I do that and boom all the transactions are accepted into the register as if I had click Accept All.

So, automatic entry is no good for this account and so is non automatic entry.

Time to pull out the new trick!

Go to back before account was setup for downloading of transactions.
This time for that problem account instead of linking it to the existing account, create a new one.
Accept all the "garbage" transactions/adjustments into the register.
Delete everything in the register (using the banking transaction report trick).
Deleted all the placeholders.
Use the new move investment transaction function to move the transactions from the old account to the new one. Delete old account.

Now that account is setup for downloading and the unique Ids are recorded in it, and it has my correct transactions in it.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Oh forgot to mention one thing in the process.  There is a bug in the QIF import for investment accounts.  Even if all your transactions are marked as reconciled in the QIF file, Quicken will not mark all of the transactions it imports into an investment account as reconciled.

So to make sure that you know what transactions are what, be sure to run a reconcile on each investment account you are going to setup for automatic transaction downloaded to make sure all transactions are marked reconciled.  Having them marked reconciled makes it a lot easier to see what transactions are added in an given case.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Well I have used my converted data file some more and wanted to update the "gotchas".

First as implied above the tax line settings don't come through so to have the tax reporting correct you need to go through and reset every tax line on those categories (or at least the categories you use).  They will be marked as being tax related, but with no tax line.

Also there seems to be no way to edit the tax line on the built in categories.

Second since my process chances transfers into categories there is part where this has a pretty big negative impact.  A transfer to a 401K causes a hidden entry that is used for tax reporting, basically subtracting that amount from your wages, so that it isn't included in the amount taxed.

I made assigned the category created for that transfer to the wages tax line, which makes it subtract from the wages in the tax planner.  It isn't perfect, but I think it is good enough for me.  For others it won't be and they might have to change it to a real transfer and delete the transaction with the "transfer category" in the 401K account.

Also paychecks are turned into normal split transactions.  I have not tested this, but I do believe that means anyone using "Paycheck/Net Pay" in a budget will find that will not be working right.

The bottom line of all of this is that the process will leave you will a pretty big mess, and as such probably only would be done by someone that has a data file that is corrupted beyond fixing, and this is there only resort.  And maybe the better way would be just to abandon that data file, and start a new one or go to another product that is better at importing QIF files.
Photo of splasher

splasher, SuperUser

  • 606,732 Points 100k badge 2x thumb
Would it have helped if you had used the File Operations->Copy with a future date to create an empty file with all of the accounts and categories already in it?
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
OK, I have tried a quick pass at this the results are very promising.
I will work through it over the next few days to give more details, but I wanted to give a "first impression".

Now if someone is going to be able to use this really depends on what is corrupted in their data file, but they can try rebuilding those parts with the QIF import.

I used the copy operation.  The first thing I noticed is that Quicken put in an Opening Balance transaction in all my current accounts to get them to my current net worth value.  Since I was going to import all the transactions, I deleted each of these.

Next I ran Validate & Repair using both the Validate file and Rebuild investing lots options (but not the deleting of investing price history).  And sure enough it cleared out a lot of "QEL" entries.  I think the only things those would do is confuse Quicken on the QIF import (or just be junk laying around in my data file).

Next I exported to a QIF file (everything selected just in case) from a "pre copy" data file.

I ran my program to change the transfers in the QIF to regular categories.

I then imported that QIF (only selecting transactions) into the copied data file from above.

This was the 2018 release of Quicken, so everything imported directly into the registers skipping any kind of transfer matching or accepting transactions into the register.

The results are "interesting".

First off the really good points.  Since this is a copy of the data file.
Accounts, categories (and tax lines), reminders, reports, and account level attachments, are all there.  And also hidden accounts are "hidden" and same for hidden categories.

A lot less work to fix!

All my current account totals are correct.

Now here is where it gets strange.

Some of my "hidden" long ago zeroed accounts are now not zero.

I had a little of this with a couple of accounts before when I did this in a brand new data file, but these are "larger" amounts and more accounts affected, but still not a large amount of accounts to fix.

I will be digging into those accounts and seeing if I can pin down why they are off, but frankly it could simply be long hidden problems.  Over the years I have "closed" accounts and created new ones because of "account corruption" so that might be part of it.

At this point I definitely think this is the best approach yet to keep as much information as possible and have the least amount of rework.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
P.S. I just thought of one big "problem" with this approach, and most likely why I didn't think of it before.  And that is if your goal is to go back to an older version of Quicken your options will be very limited.

If you are on Quicken 2018 you can go back as far as Quicken 2016, but no earlier.

That means for instance you will not be able to go back to a version of Quicken that doesn't have the Quicken Id.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Well I have tracked down a few of the problems in the accounts and about all I can do to "connect them" in different accounts is to say, when you copy the accounts "their problems follow you, and can resurface".

For instance in a credit card account I know that at one point I put in a transaction of $20, but then deleted it because I was trying to zero it before I found some more transactions needed to be imported.  The old data file doesn't show that transaction, the QIF file doesn't show that transaction, importing into a new data file/account doesn't show that transaction.  But importing into the "copied" data file/account that transaction appears.

In another account it seems for some period of time my paycheck transaction are all missing the split line with the gross pay.  The result being a split that is all negative.

Again if I import this into a new data file/account the split imports correctly.

I tested this with both Quicken 2017 and 2018 to make sure it wasn't just an import problem of Quicken 2018.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
Well I tried deleting all the transactions in one problem register and then importing just that account through the QIF import, and it worked.

So I decided to try do it for all my accounts, but as I was setting up to do this Quicken crashed.  And when I tried to open the data file again, it crashed again.

This is something that has been happening in my data file since Online Bills or whatnot corrupted it.  But in has not yet happened in full rebuilt data file.

So I think basically this problem "followed" to because the start of this process was a copy of a problem data file.
Photo of QPW

QPW

  • 371,060 Points 100k badge 2x thumb
More information on the bad tax lines in a brand new data file for hidden/builtin categories that the user can't edit later.

First off let me say that the tax lines are in the QIF export, it is the QIF import that is broken, and doesn't assign these tax lines.  Note that if you look at (with a text editor) TAX.SCD in C:\Program Files (x86)\Quicken you will find this entry:
Revision:       057
By:             ke
Date:           10/17/2007

Clearly it isn't just a matter of the tax lines changing or something.  That date also shows you how well the tax lines are being kept up to date.

So the problem can't be fixed by just changing something in the QIF file.

I noticed that when I created a new data file, the hidden categories weren't in it.
So the question is how do they get created?
And the answer is when an account of the right type is created.
For all the hidden/builtin categories in my data file, creating a 401K account caused them all to be created.  For home and business/rental you might need to create some combination of business accounts.

I changed my procedure to create the new data file, create a 401K, and then delete that account (because mine was a dummy one, but if you create one in your real file you can leave it), and then delete the non hidden categories, leaving the hidden/builtin categories.

The main problem here is basically the same problem with creating accounts through QIF.  If they are already there then nothing happens, but if they are created by QIF you will run into the limitations of what the QIF import will "properly" create.

Note if you aren't a long time user (somewhere around Quicken 2012) they changed the categories.  If you have been using their list and just pruning it back or adding to it, you might be able to skip the whole deleting of categories.

Another thought is to leave the list unchanged and fix things up after the import.
For instance instead of going in and fixing the tax lines one might reassign the category to the "new" category name that replaced it, thereby picking up the tax line it has on it.

Edit:
Note that if you have accounts already created in the data file when you go to delete categories, you have to make sure you do not select them (the transfer category like [Account]) or delete will not be available.
(Edited)