|
Posted by R. C. White on January 24, 2007, 9:29 pm
Please log in for more thread options Hi, Ed.
> rename the account to OldCheckingAccount and import that. This way,
> when I search for all transactions paid to my phone company, I'll look
> at my current checking account as well as OldCHeckingAccount. Does that
> make sense??
Yes, it makes sense. But I don't think it will work as well as you hope. I
think a better strategy would be to leave the old transactions out of your
new Quicken file. Leave all the old data (OldCheckingAccount, as well as
any other Accounts in that file) where they are: in a separate Quicken
file. You might rename that file something like EdOld (holding EdOld.QDF
plus related EdOld.* files, of course). When you need to research old
transactions, click File | Open and browse to EdOld.qdf and click on it.
When you are done looking back, just File | Open your EdNew.qdf file and
click. You will never have the two files open at the same time, so you
won't be able to get a 5-year report covering 2002-2006, for example, but
you can see the two separate parts and add them together.
Presumably, you won't want to actually make any entries in the EdOld file.
It's only for historical reference. However, you might want to dig into it
and see if you can spot what is causing the error in the closing balance (as
of October 2005) in that checking account. It could be a weird transaction
that also is messing up the listing of your check numbers. Fixing one or
more errors could fix both problems. Once the EdOld file is "clean", you
could either import it into your EdNew file, or you could export from both
EdOld and EdNew and import them both into a new EdNOW file. ;<)
Good luck - and let us know if you learn what caused the old file to go
awry.
RC
--
R. C. White, CPA
San Marcos, TX
(Retired. No longer licensed to practice public accounting.)
rc@grandecom.net
Microsoft Windows MVP
(Currently running Vista Ultimate x64)
> Ok... Thanks for the details about the little triangles about the
> columns to sort. I'm a little beyond that. The issue I was having,
> is that when I ordered my checking account entries by Check number, I'd
> get something like this: 10,11,12,19, 20, 21, ATM, ATM, ATM, ATM,
> 16, 17, 18, , , , , 13, 14, 15. That's just plain wrong.
> I had data dating back to 1999 and a tool is useless if you can't rely
> on it. I paid for tech support on this several times... tried
> "cleaning" the data... exporting and re-importing... nothing seemed to
> work... so, I started a new "file". By this, I mean that I upgraded to
> Q2006Pro and did not point it to my old file. I therefore only have
> transactions dating back to when I upgraded... sometime back in 2005.
> I am now using Q2007Pro.
>
> What I miss is being able to search for transactions prior to my
> "migration". It would be nice to be able to search for all payments
> to my phone company, as per your example below.
>
> My fear is that importing the data may imported whatever data
> corruption was present in the first place. Second, as I tried to
> explain, if I point Quicken to the old QDF file I "was" using, and look
> at my main checking account's ballance on the last transaction in the
> register, is not equal to (by a long shot) the opening balance of the
> first transacftion in my new QDF. I don't really care to reconcile
> stuff that's year's old. I could go into the old QDF and apply an
> adjustment transactions to bring the two in-line I guess... or I could
> rename the account to OldCheckingAccount and import that. This way,
> when I search for all transactions paid to my phone company, I'll look
> at my current checking account as well as OldCHeckingAccount. Does that
> make sense??
>
> THis is not that big a deal... but I appreciate your responses !
>
> -Ed
>
>
>> Hi, Andrew.
>>
>> Thanks for catching that. I didn't word it very well. You are right:
>> Categories continue indefinitely, just like Accounts. That's why I can
>> look
>> up today what I paid for my telephone bill back in 1998. And I can
>> easily
>> get a total of all my telephone expenses for all the years that I've been
>> using Quicken, just by adjusting the dates in my report.
>>
>> My accounting mindset was at work, I suppose. In pen-and-paper
>> accounting,
>> we "close" the income and expense accounts each year by making "closing"
>> entries to reduce all their balances to zero. We put the net income (or
>> loss) into the Capital Account, which does carry over to the next year,
>> just
>> like the Asset and Liability Accounts. Then the income and expense
>> accounts
>> start over from zero for the new year.
>>
>> Quicken doesn't actually zero out the Categories at year-end. But, by
>> default, it shows only the current year-to-date when we ask for an income
>> statement report, which produces the same result. If we want a different
>> result, we can Customize the report, or just change the period to be
>> included.
>>
>> I hope this didn't confuse Ed, the OP - or any other reader.
>>
>> RC
>>
>>
>> > R. C. White wrote:
>>
>> >> ... "categories" accumulate until the end of a year, then start over
>> >> for
>> >> the next year. .
>>
>> > R.C. - What does THAT mean? Haven't a clue what you mean by that. My
>> > categories (eg: SEWER, TELEPHONE, CHESSCLUBDUES, etc.) are entities
>> > that
>> > have numeric values assigned as I categorize expenses to them, and if I
>> > run a report over multiple years, they certainly don't 'start over'. I
>> > must be missing something?
>>
>> > --
>> > -------------------------------------------------------------
>> > Regards -
>>
>> > - Andrew
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap