Home Page link  

Download of Bank Transactions

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Download of Bank Transactions PatJennings 04-12-2007
Posted by John Pollard on April 12, 2007, 6:47 pm
Please log in for more thread options
PatJennings wrote:
> Between the time of my last message and your response, I
> accepted the transactions - which I then had to modify,
> restoring the original dates that I wrote the checks and
> restoring the payees. This is significant in that by
> keeping the downloaded transaction as downloaded, my
> yearly history is out of kilter: December payments
> clearing in January, and complete and utter loss of the
> original payee.

> For example replacing "12/13/2006" and
> "US Treasury" with "!/31/2007" and "check # 6287 Ref #
> 020100263" in the payee field serves no meaningful
> purpose.

In over six years of using Quicken, doing zillions of downloads
(many for testing) to Quicken versions Q2000, Q2001, Q2002,
Q2004, Q2005, Q2006 and Q2007; I have *never* Accepted a
downloaded transaction, with a "Match" status, that altered the
transaction date of the existing register transaction it
matched. If that happened to you, I have no explanation, and no
suggestion (except possibly a corrupted install, or a corrupted
data fileset).

> Compound that by having to search the returned
> checks for the accurate information and reenter it is
> folly.

I don't know what this means; but my suggestion was only to
accept one transaction and see what happened. You could have
noted the values in the existing transaction before you clicked
Accept, and not experienced any "folly".

> Then, items beyond (in time) that have been
> downloaded and for which I have not performed a statement
> reconciliation are appearing in the register as "R". How
> is that happening? To clarify, I am reconciling
> February's bank statement. Items in March are marked
> "R". I have not as of yet reconciled March's statement.

Well, now it sounds like you have elected to reconcile to the
"online balance", and possibly do an "automatic reconcile". I
would personally never do either. And since I never have, I can
not tell you much about the results you should expect if you do
so.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup





Posted by L on April 13, 2007, 1:32 pm
Please log in for more thread options
> Between the time of my last message and your response, I accepted the >
> transactions - which I then had to modify, restoring the original dates
> that I wrote the checks and restoring the payees.

You accepted all the downloaded transactions as new entries??

> This is significant in that by keeping the downloaded transaction as
> downloaded, my yearly history is out of kilter: December payments clearing
> in January, and complete and utter loss of the original payee. For
> example replacing "12/13/2006" and "US Treasury" with "!/31/2007" and
> "check # 6287 Ref # 020100263" in the payee field serves no meaningful
> purpose. Compound that by having to search the returned checks for the
> accurate information and reenter it is folly.

I've been using Quicken for over a decade.

In all that time accepting a downloaded transaction has NEVER changed an
existing entry in my register.

NEVER

If I write a check to "US Treasury" on 12/31, and enter it into my register,
it remains unchanged unless and until I modify it. At the time I download
transactions from the bank, they either

-- match automatically (sometimes an issue if I, for example, withdraw $20
cash on a day a $20 written check cleared, as Quicken wants to match the $20
amounts)

-- need to be matched manually (if, for example, the reference numbers do
not match)

-- need to be edited or deleted.

In any of the above cases, it is the downloaded transactions that are being
modified.. NOT the ones already in my register.

Quicken DOES NOT replace payee names, memo fields etc. to existing
transactions.


> Then, items beyond (in time) that have been downloaded and for which I
> have not performed a statement reconciliation are appearing in the
> register as "R". > How is that happening?

There is an option to auto reconcile after downloading transactions, to the
online balance. You have that option turned on.

> To clarify, I am reconciling February's bank statement. Items in March
> are marked "R". I have not as of yet reconciled March's statement.

Check the reconciliation options for the account. If you want STATEMENT
reconcile, you must choose to reconcile to your statements each month, and
NOT to your online balance.
>
> What am I doing wrong? Thanks for your assistance.
>



Posted by PatJennings on April 13, 2007, 2:46 pm
Please log in for more thread options
Ok.
Thanks John and L for your assistance.

After further review, I believe I was in error in my earlier remarks. I'll
need to check after another check clears my account. Here's what I think
has been happening:
It is just recently that my bank has provided download capability. Prior to
that I had entered all transactions manually - either through checks I was
printing or writing by hand and from ATM activities.
I think I may have been confusing the "by hand" and "printed" check
activities. So, that will remain a thing to verify with new checks.
Now, as to the Automatic Reconciliation: I had not heard of that option
being available until this discussion I went into Help and read about it.
Then I proceeded to verify the setting on my account. Auto reconcile is not
active, and I would have to say, has never been so. Yet, my register shows
the R symbol on transactions that I have not reconciled - as of yet.
Perhaps I'll be able to discover a logical explanation. I must be
overlooking or misunderstanding something. I'll get it sooner or later.
Sincerely,
Pat

>> Between the time of my last message and your response, I accepted the >
>> transactions - which I then had to modify, restoring the original dates
>> that I wrote the checks and restoring the payees.
>
> You accepted all the downloaded transactions as new entries??
>
>> This is significant in that by keeping the downloaded transaction as
>> downloaded, my yearly history is out of kilter: December payments
>> clearing in January, and complete and utter loss of the original payee.
>> For example replacing "12/13/2006" and "US Treasury" with "!/31/2007" and
>> "check # 6287 Ref # 020100263" in the payee field serves no meaningful
>> purpose. Compound that by having to search the returned checks for the
>> accurate information and reenter it is folly.
>
> I've been using Quicken for over a decade.
>
> In all that time accepting a downloaded transaction has NEVER changed an
> existing entry in my register.
>
> NEVER
>
> If I write a check to "US Treasury" on 12/31, and enter it into my
> register, it remains unchanged unless and until I modify it. At the time I
> download transactions from the bank, they either
>
> -- match automatically (sometimes an issue if I, for example, withdraw $20
> cash on a day a $20 written check cleared, as Quicken wants to match the
> $20 amounts)
>
> -- need to be matched manually (if, for example, the reference numbers do
> not match)
>
> -- need to be edited or deleted.
>
> In any of the above cases, it is the downloaded transactions that are
> being modified.. NOT the ones already in my register.
>
> Quicken DOES NOT replace payee names, memo fields etc. to existing
> transactions.
>
>
>> Then, items beyond (in time) that have been downloaded and for which I
>> have not performed a statement reconciliation are appearing in the
>> register as "R". > How is that happening?
>
> There is an option to auto reconcile after downloading transactions, to
> the online balance. You have that option turned on.
>
>> To clarify, I am reconciling February's bank statement. Items in March
>> are marked "R". I have not as of yet reconciled March's statement.
>
> Check the reconciliation options for the account. If you want STATEMENT
> reconcile, you must choose to reconcile to your statements each month, and
> NOT to your online balance.
>>
>> What am I doing wrong? Thanks for your assistance.
>>
>
>



Posted by John Pollard on April 13, 2007, 3:35 pm
Please log in for more thread options
PatJennings wrote:
> Now, as to the Automatic Reconciliation: I had not heard
> of that option being available until this discussion I
> went into Help and read about it. Then I proceeded to
> verify the setting on my account.

> Auto reconcile is not active,

How about "Reconcile to" an "Online balance".

> and I would have to say, has never been so. Yet,
> my register shows the R symbol on transactions that I
> have not reconciled - as of yet.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup




Posted by PatJennings on April 13, 2007, 4:25 pm
Please log in for more thread options
No, it is set to paper statement, not the online balance option.

> PatJennings wrote:
>> Now, as to the Automatic Reconciliation: I had not heard
>> of that option being available until this discussion I
>> went into Help and read about it. Then I proceeded to
>> verify the setting on my account.
>
>> Auto reconcile is not active,
>
> How about "Reconcile to" an "Online balance".
>
>> and I would have to say, has never been so. Yet,
>> my register shows the R symbol on transactions that I
>> have not reconciled - as of yet.
>
> --
> John Pollard
> First initial underscore Last name at mchsi dot com
> Please reply to newsgroup
>
>
>



Similar ThreadsPosted
Download Historical Bank Transactions January 20, 2008, 2:51 pm
Problem with Download from Bank November 1, 2007, 10:03 pm
bank download fails after rev 4 November 16, 2007, 3:29 pm
Odd bank download behavior September 11, 2008, 6:50 pm
Bank Downloads via one step download February 22, 2007, 2:15 pm
Countrywide Bank + Quicken download February 10, 2008, 11:07 am
Bank Doesn't Show In Download List May 24, 2008, 11:07 am
Downloaded Bank transactions September 12, 2006, 7:58 pm
Bank Downloads of previous transactions February 28, 2007, 8:18 pm
Wrong link to my bank for transactions May 18, 2007, 6:38 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap