Year End Copy - Help

Jul 04, 2011 21 Replies

Good afternoon on the 4th!



I'm using Q 2011 and have been using Q for many years. I was wanting to do a year end copy, eliminating everything before 12/31/2009. In the past not problem, but Q now refuses to remove data before



12/31/2009. Now all you get is two files that are pretty much the same thing, current file and archived file. Does anyone know what is going on?

Thanks



Jess N Florida To email remove the underscore jessc snipped-for-privacy@mchsi.com


Jess wrote: :: Good afternoon on the 4th! :: :: I'm using Q 2011 and have been using Q for many years. I was wanting :: to do a year end copy, eliminating everything before 12/31/2009. In :: the past not problem, but Q now refuses to remove data before :: 12/31/2009. Now all you get is two files that are pretty much the :: same thing, current file and archived file. Does anyone know what is :: going on? :: :: Thanks :: :: Jess N Florida :: To email remove the underscore :: jessc snipped-for-privacy@mchsi.com

So I assume you selected the option to eliminate everything in your current file before the date you indicated, and entered the date in the dialog panel, right? Q will NOT delete a lot of entries regardless due to needing to keep them around for cost basis history, typically investment accounts. So you're sure that you did that and are looking at the file that was then created with some (but not all) entries eliminated?

Hi, Jess.

Why?

I don't mean to be impertinent, but have you not read the many discussions here about this topic? To repeat - in brief:

My own QDF file is over 50 MB and has data back to when I started using Quicken in 1990. When I need to look up something from 1995, it is immediately available. I don't have to try to find my 1995 file that I've archived SOMEWHERE, then try to load it (from a floppy disk?) before I can search for what I need. This 50 MB file loads as quickly and can be searched or used as quickly as when it was less than 1 MB some 20 years ago, so there is no time penalty for keeping the old data accessible. Disk space is so cheap nowadays that the 50 MB of space costs less than a penny, I'm sure (I haven't bothered to calculate the cost on this 1000 GB HDD that cost me less than $100), compared to the few dollars that I used to spend for a floppy diskette, so there's no cost penalty. And there have been many payoff times for me.

There are other arguments, Jess, but I won't belabor the point until you tell us WHY you want to remove your older data from your current file. Your reasons may be perfectly valid for you, but I can't see your point from what you've said so far.

RC

-- -- R. C. White, CPA San Marcos, TX snipped-for-privacy@grandecom.net Microsoft Windows MVP (2002-2010) Windows Live Mail 2011 (Build 15.4.3508.1109) in Win7 Ultimate x64 SP1

Good afternoon on the 4th!

I'm using Q 2011 and have been using Q for many years. I was wanting to do a year end copy, eliminating everything before 12/31/2009. In the past not problem, but Q now refuses to remove data before

12/31/2009. Now all you get is two files that are pretty much the same thing, current file and archived file. Does anyone know what is going on?

Thanks

Jess N Florida

Mr. White,

I don't want to be to disrespectful to you, but really why I want to do what I want to do with MY software is my business. The software I paid for is suppose to do as I am trying to do and I'm trying to find out why it isn't working.

I don't have a problem archiving my data then finding it IF I want to, I'm pretty good at putting my stuff where I can find it IF I need to. I can find all my banking data back to 1991 without a bit of trouble if I need too.

You do your thing the way you want and I'll do mine the way I want. You must be a liberal that wants to govern that everyone does things your way!

Like WOW!

To email remove the underscore jxc3 snipped-for-privacy@att.net

Yes, Andrew, I have followed all the rules as far as I can tell. I'm not worried about my investments, I'd just like to clear out past data from banking accounts and credit card accounts. Q use to do that without a hitch, but Q2011 seems to have a hiccup.

To email remove the underscore jxc3 snipped-for-privacy@att.net

Jess wrote in news: snipped-for-privacy@4ax.com:

I tried the year end copy once, many eons ago, and didn'tlike what happened. YMMV, but that's my experience.

Now, and with all due respect, Jess, you're wrong in 2 respects: Firstly, you will have to do things as Quicken allows you, whether or not you want to. I know it is at times frustrating, but it is like English - a framework for doing your work. For a long time already Quicken versions have limited what you delete with the year end copy (as I read here many times). The stated reason is that Quicken has decided that it or you may need certain information, and therefore it stays. Period. End of discussion, as per Q's thinking.

Secondly, RC is a long time expert contributor to these discussions and knows what he is talking about. Maybe he is longwinded (sorry RC!), but he is knowledgeable. That is why he deserves respect (IMNSHO).

Again, Quicken is like language - a framework with conventions and rules, which may or may not work the way you like it. As with all computer programs, you work within their rules, not yours.

There are other finance programs out there, and perhaps another one is more to your liking.

Jess wrote: :: Yes, Andrew, I have followed all the rules as far as I can tell. :: I'm not worried about my investments, I'd just like to clear out :: past data from banking accounts and credit card accounts. Q use to :: do that without a hitch, but Q2011 seems to have a hiccup. :: :: :: On Mon, 4 Jul 2011 12:18:29 -0400, "Andrew" wrote: :: ::: Jess wrote: ::::: Good afternoon on the 4th! ::::: ::::: I'm using Q 2011 and have been using Q for many years. I was ::::: wanting to do a year end copy, eliminating everything before ::::: 12/31/2009. In the past not problem, but Q now refuses to ::::: remove data before 12/31/2009. Now all you get is two files that ::::: are pretty much the same thing, current file and archived file. ::::: Does anyone know what is going on? ::::: ::::: Thanks ::::: ::::: Jess N Florida ::::: To email remove the underscore ::::: jessc snipped-for-privacy@mchsi.com ::: ::: So I assume you selected the option to eliminate everything in your ::: current file before the date you indicated, and entered the date in ::: the dialog panel, right? ::: Q will NOT delete a lot of entries regardless due to needing to ::: keep them around for cost basis history, typically investment ::: accounts. So you're sure that you did that and are looking at the ::: file that was then created with some (but not all) entries ::: eliminated? :: To email remove the underscore :: jxc3 snipped-for-privacy@att.net

OK -well, I've run outta luck trying to figure it out. It's always worked for me, but admitedly I haven't tried it over the last few years since (as you might have seen in many threads here) the majority opinion is not to worry about doing any 'pruning'. I guess I'd try getting in touch with Intuit support directly...good luck on that end!

"Jess" wrote

Despite the fact that I have tested this numerous times in the past; virtually anytime someone posts the claim that Year End Copy doesn't work, I test it again ... and I always find that Quicken works as designed. As I did just now with Q2011 RPM R8 U.S.

If you carefully read (and think about) the text in the Year End Copy dialog, you'll note the process will not delete "unreconciled" transactions.

[And your reply to R.C. was uncalled for.]

You want to talk that way to people here trying to help you? Especially to someone like RC, who is among the most helpful and most polite people here?

Welcome to my killfile!

Hi, Jess.

Not at all. There was nothing in my post that said, "Do it my way." There were only questions to clarify why you want to use the year-end copy routine, and comments that many of us, through long experience, have found it useful to not delete older transactions. As I said, "Your reasons may be perfectly valid for you..."

Recognizing the difficulty of conveying tone of voice through Usenet, I started my post with a single-word question, then said, "I don't mean to be impertinent..." I'm sorry that it sounded like I was trying to be inquisitive or dictatorial; neither was intended. I have neither the time nor the instincts to tell others what to do. All I can do is share my experiences and make suggestions. (And, Han, as to "longwinded ", I plead guilty. )

RC

-- R. C. White, CPA San Marcos, TX (Retired. No longer licensed to practice public accounting.) snipped-for-privacy@grandecom.net Microsoft Windows MVP (2002-2010) (Using Quicken Deluxe 2011 R 8 and Windows Live Mail in Win7 x64)

Mr. White,

I don't want to be to disrespectful to you, but really why I want to do what I want to do with MY software is my business. The software I paid for is suppose to do as I am trying to do and I'm trying to find out why it isn't working.

I don't have a problem archiving my data then finding it IF I want to, I'm pretty good at putting my stuff where I can find it IF I need to. I can find all my banking data back to 1991 without a bit of trouble if I need too.

You do your thing the way you want and I'll do mine the way I want. You must be a liberal that wants to govern that everyone does things your way!

Like WOW!

I apologize to RC, may be I mistook his comments, since as he said more or less, they are typed words without voice!

With all the discussion and comments, it appears that Q will not do a wipe the past out even though it says it will. As I have said, I followed the rules, and I do understand about reconciled, which all of

2009 is, but so be it. I'll find a work around since there doesn't seem to be an answer.

Thanks for the comments.

I'll leave you all alone!

Jess

To email remove the underscore jxc3 snipped-for-privacy@att.net

Jess wrote: :: I apologize to RC, may be I mistook his comments, since as he said :: more or less, they are typed words without voice! :: :: :: With all the discussion and comments, it appears that Q will not do a :: wipe the past out even though it says it will. As I have said, I :: followed the rules, and I do understand about reconciled, which all :: of 2009 is, but so be it. I'll find a work around since there :: doesn't seem to be an answer. :: :: Thanks for the comments. :: :: I'll leave you all alone! :: :: Jess :: :: :: :: :: On Tue, 5 Jul 2011 13:13:14 -0500, "R. C. White" :: wrote: :: ::: Hi, Jess. ::: :::: You do your thing the way you want and I'll do mine the way I want. ::: ::: Agreed. ::: :::: You must be a liberal that wants to govern that everyone does :::: things your way! ::: ::: Not at all. There was nothing in my post that said, "Do it my ::: way." There were only questions to clarify why you want to use the ::: year-end copy routine, and comments that many of us, through long ::: experience, have found it useful to not delete older transactions. ::: As I said, "Your reasons may be perfectly valid for you..." ::: ::: Recognizing the difficulty of conveying tone of voice through ::: Usenet, I started my post with a single-word question, then said, ::: "I don't mean to be impertinent..." I'm sorry that it sounded like ::: I was trying to be inquisitive or dictatorial; neither was ::: intended. I have neither the time nor the instincts to tell others ::: what to do. All I can do is share my experiences and make ::: suggestions. (And, Han, as to "longwinded ", I plead guilty. ) ::: ::: RC :: To email remove the underscore :: jxc3 snipped-for-privacy@att.net

Jess - one last though, I think that after one has checked the box that says to remove all your transaction entries prior to whatever the date is, and Q does it's pruning thing, it will ask you whether you wish to use the copy that was made, or the updated version that just contains the 'pruned' entries. (Q will adjust the opening balance in the accounts of the new version to account for all of the individual transactions that have been removed in each account that it can do so in.)

Make sure you're using that one!

To be absolutely clear, the point that John Pollard made about reconciled transactions (I should have remembered) is that if the transaction is NOT reconciled (i.e.: it does NOT have a 'R' in the CLR ('cleared') column) meaning you have not reconciled that transaction against the paper or electronic version of your bank statement. Quicken will not 'prune' such transactions since they are still 'open'. But you said all of your 2009 transactions do have the 'R' in that column.

So ensure you're looking at the version of your Q file that is AFTER the removal!

"R. C. White" wrote in news:LZudncvWJdfZyY7TnZ2dnUVZ snipped-for-privacy@posted.grandecom:

I knew you'd take it the right way. Sometimes someone long-winded is boring,sometimes entertaining, sometimes (you) didactic, and that's a compliment. But nit everyine sees it that way, unfortunately.

Hi, Jess.

No need to apologize, but since you did, it is accepted.

And no need to go away. Your question prompted a discussion from which we all learned a bit - and that's why we're here: to help and to learn. That's the beauty of Usenet and that's why it's a shame that Microsoft no longer uses it. Here, we all learn from each other. Today I am the student, tomorrow the teacher - and the next day I learn some more. ;

"R. C. White" wrote in news:1PKdnY3FrqrtWo7TnZ2dnUVZ snipped-for-privacy@posted.grandecom:

I second those statements

FWIW, I third those statements!

"R. C. White" wrote in news:1PKdnY3FrqrtWo7TnZ2dnUVZ snipped-for-privacy@posted.grandecom:

I second those statements

Has anyone been able to download transactions from Wells Fargo Bank using Quicken 2011 in the last month?

every day with Q2011 Premier

Your very fortunate and perhaps lucky too. I've been working with both Quicken and Wells Fargo for several weeks now and have had no luck downloading. I've been downloading for years with very few problems but ever since Wells Fargo converted their Wachovia customers to Wells Fargo things have not worked.

Wells Fargo Support says its a Quicken problem. Quicken says its a Wells Fargo problem. Me? Oh, I'm just a customer that's caught in the middle.

Part of the problem seems to be related to having multiple accounts at Wells Fargo where the first 20 or 30 characters of the account name are basically the same but the last few characters are different. Quickens barfs and can't handle this. I've gone onto Wells Fargo and given these accounts unique nicknames but that hasn't helped matters.

For an outfit that sunsets you every three years Quicken should provide a little better support starting with American support centers. Trying to translate the various Indian dialects is difficult to say the least.

This if very frustrating.

I have no problem downloading from WF, with the exception of my CD account. It said that it was downloading, but I noticed that there were no transaction since April. since it is only a few interest payments, I added them manually.

Take a look at the OFX log file. I was able to decipher it, and tell Wells Fargo Advisors about the problem they have with several securities. They were mis-coding them as debt securities (bonds). This caused the shares to mismatch between Quicken and the FI. I sent them a note with excerpts from the OFXLOG file, and an explanation of the problem. They will be making a correction based on that complaint. They know that they are having problems since the merger, and have a department addressing them.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required