This post has been closed and is not open for comments or answers.

Quicken vs. checkbook register

I have always mirrored my Quicken register with my checkbook register, so I can tell what my balance is.  When I pay a bill with my online bank for a future date, I enter it immediately into Quicken and my checkbook register to reflect my effective balance.  However, when I download transactions, the Quicken (entry) date does not match the date it cleared.  When I match the two, the cleared date overrides the entry date and Quicken moves the transaction.  My checkbook register no longer matches Quicken.  I chatted with Quicken support and she suggested I always use the cleared date in Quicken.  If I don't enter anything in Quicken until it clears per the download, how do I determine the logical balance if I have 10 uncleared checks?  Am I using download for the wrong purpose?  If so, what IS the purpose/usage of download?Thanks.Rich
    > I have always mirrored my Quicken register with my> checkbook register, so I can tell what my balance is.> When I pay a bill with my online bank for a future> date, I enter it immediately into Quicken and my> checkbook register to reflect my effective balance.> However, when I download transactions, the Quicken> (entry) date does not match the date it cleared.The Quicken "transaction" date does not match the downloaded "transaction" date because the downloaded transaction uses the "posting" date as a transaction date ... correct?> When I match the two, the cleared date overrides the> entry date and Quicken moves the transaction. When *you* "match the two"?  Are you saying that Quicken did not assign a Status of "Match" to the downloaded transaction so you had to do a "Manual Match"? The result you describe is different from what I experience_ what I download a transaction that is already in my Quicken register, and Quicken determines that the downloaded transaction is a "Match", when I Accept the downloaded transaction the pre-existing register transaction retains its transaction date ... as it should.Downloaded "Match" transactions do modify register transactions in an important way_ they update the register transaction's "Posting date", which is a hidden field in every non-investment account transaction (it may be in investment account transactions too, I just don't know how to see it there).Since Quicken already has the ability to save the posting date separately from the transaction date, there should be even less reason to have to make the transaction date equal the posting date.> My> checkbook register no longer matches Quicken.  I> chatted with Quicken support and she suggested I> always use the cleared date in Quicken.  That would not be my advice.  But then again, I don't understand how/why you are getting the results you describe.> If I don't> enter anything in Quicken until it clears per the> download, how do I determine the logical balance if I> have 10 uncleared checks?  > Am I using download for> the wrong purpose?  I don't think so, although some people have reported that they do not manually enter transactions they expect to download.--John PollardPlease post questions in the forums, not via email.
      > The Quicken "transaction" date does not match the> downloaded "transaction" date because the downloaded> transaction uses the "posting" date as a transaction> date ... correct?You are correct.  The downloaded transactions use the "posting" date as the transaction date.  This is no surprise.> When *you* "match the two"?  Are you saying that> Quicken did not assign a Status of "Match" to the> downloaded transaction so you had to do a "Manual> Match"? When I click on "Match" in the Download tab, the correct matching transaction is displayed in the popup window with the entry date.  I check the entry and click on Accept.  The date of the transaction in the Quicken register is indeed changed to the posted date and moved to that date within the Quicken register.> The result you describe is different from what I> experience_ what I download a transaction that is> already in my Quicken register, and Quicken> determines that the downloaded transaction is a> "Match", when I Accept the downloaded transaction the> pre-existing register transaction retains its> transaction date ... as it should.I agree.  That is exactly how I feel it SHOULD work.  I wonder if there is some setting/control that I have different from you.  However, I can't find anything that tells Quicken to perform the action of modifying the transaction date that I have described.  In my View option I have Sort by Date/order entered, but did not see anything in the Options/Register preferences/Register/Downloaded transactions that implied changing the date.  I assume the Rename rules apply only to the payee name and not the transaction date.> Downloaded "Match" transactions do modify register> transactions in an important way_ they update the> register transaction's "Posting date", which is a> hidden field in every non-investment account> transaction (it may be in investment account> transactions too, I just don't know how to see it> there).It would be nice if Quicken had the feature to display the "posting date" when the option is clicked.> Since Quicken already has the ability to save the> posting date separately from the transaction date,> there should be even less reason to have to make the> transaction date equal the posting date.I agree.  I am now thinking this is a bug.> That would not be my advice.  But then again, I don't> understand how/why you are getting the results you> describe.You gave me more information in one paragraph than I got with Quicken support chat in about an hour or so.> I don't think so, although some people have reported> that they do not manually enter transactions they> expect to download.I like the idea of manually entering transactions_ e.g., a check might not clear for a couple of months.John, my feeling is that my Quicken is not behaving as it should and there is some kind of bug.  This is the first time I have downloaded in Quicken in a long, long time.  When I tried it a couple of years ago, I didn't like how it worked, but I will use it if it works as you described.Thank you again for your time and effort!
        > > When *you* "match the two"?  Are you saying that> > Quicken did not assign a Status of "Match" to the> > downloaded transaction so you had to do a "Manual> > Match"? > When I click on "Match" in the Download tab, the> correct matching transaction is displayed in the> popup window with the entry date.  I check the entry> and click on Accept.  > The date of the transaction in> the Quicken register is indeed changed to the posted> date and moved to that date within the Quicken> register.I just did a test using Q2006 Premier R3 and this did not happen for me.  (I do not think this is a function of the "release", but I could be wrong.  If I am, I would suspect that others would be reporting the same problem.)> > The result you describe is different from what I> > experience_ what I download a transaction that is> > already in my Quicken register, and Quicken> > determines that the downloaded transaction is a> > "Match", when I Accept the downloaded transaction> > the> > pre-existing register transaction retains its> > transaction date ... as it should.> I agree.  That is exactly how I feel it SHOULD work.> I wonder if there is some setting/control that I> I have different from you.  None that I know of.> However, I can't find> anything that tells Quicken to perform the action of> modifying the transaction date that I have described.> In my View option I have Sort by Date/order entered,> , but did not see anything in the Options/Register> preferences/Register/Downloaded transactions that> implied changing the date. Well, that is interesting.  Perhaps that is the problem.  I believe "Date entered" is the date the transaction was entered into Quicken (the date your operating system says is the "current date" at the time you key in the transaction) ... I am almost certain that it is not the same as the "transaction" date or the "posting date".  Perhaps you should try resequencing your register transactions by "transaction date" and double-checking their "transaction" date.  > I assume the Rename rules> apply only to the payee name and not the transaction> date.I would make the same assumption, but it would be worth attempting to check this out (none of my test downloads included any renamed payees.) > > Downloaded "Match" transactions do modify register> > transactions in an important way_ they update the> > register transaction's "Posting date", which is a> > hidden field in every non-investment account> > transaction (it may be in investment account> > transactions too, I just don't know how to see it> > there).> > It would be nice if Quicken had the feature to> display the "posting date" when the option is> clicked.> > > Since Quicken already has the ability to save the> > posting date separately from the transaction date,> > there should be even less reason to have to make> > the> > transaction date equal the posting date.> I agree.  I am now thinking this is a bug.Let's see.> > That would not be my advice.  But then again, > > I don't> > understand how/why you are getting the results > > you describe.> You gave me more information in one paragraph than I> got with Quicken support chat in about an hour or> so.> > > I don't think so, although some people have> reported> > that they do not manually enter transactions > > they expect to download.> I like the idea of manually entering transactions_> e.g., a check might not clear for a couple of> months.> > John, my feeling is that my Quicken is not behaving> as it should and there is some kind of bug.  This is> the first time I have downloaded in Quicken in a> long, long time.  When I tried it a couple of years> ago, I didn't like how it worked, but I will use it> if it works as you described.--John PollardPlease post questions in the forums, not via email.Message was edited by         jepollard     at {1}