Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 09-10-2007, 01:36 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money Not Handling Like Transactions the Right Way

In microsoft.public.money, Stuart wrote:

- quote -

> - I believe this problem is within MS Money, and how it is perceiving two
> like transactions
> when it downloads transaction from my checking account. Following germane:
> - This is not QIF statements, it is the automatic downloading of
> transactions from my bank.
> I provide MS Money the username and password, and it downloads the
> transactions. SOP.
> - The monthly transfers are from my checking account to T. Rowe Price via
> monthly debit
> set up long ago.
> - Both individual transactions show up properly when I access my checking
> account via my bank
> website
> - Both transactions show up properly when I look at my checking account via
> Yodlee web access.
> If I am not mistaken, MS Money uses uses Yodlee as an intermediary for
> downloading data from
> my bank (NFCU).


Based on
http://www.microsoft.com/money/banko...BrokeragesOnly
I don't expect that to be the case. You may have the more rare case
that the OFX file has the problem.



- quote -

> - Both transactions show up properly in their individual TRP accounts when
> I look at them in
> MS Money and on line.
> - Only one transaction shows up in my checking account register in Money.
> It seems that when I do an update and where the two transactions are
> downloaded, it is misidentifying
> the two transactions as duplicates, in an automatic manner. Is there
> something in Money that allows
> this, that I might have mistakingly enabled?
> tks SRM


You could test this out by capturing the log file, which is an OFX
file.

http://support.microsoft.com/kb/911941/en-us

If you rename the file to *.ofx and if it is OFX version 2, you
could look at the file with IE. (with OFX version 1, you will need
to use a text editor, and it will be harder to follow.) Records that
start with '<DT' are dates. Each transaction must have a *unique*
<FITID> record. I am suspicious that they duplicated the <FITIDwhen creating the OFX file.



  #2  
Old 09-09-2007, 10:06 PM
Art McClinton
Guest
 
Posts: n/a
Default Re: Money Not Handling Like Transactions the Right Way

It certainly is worth opening an incident with Microsoft to see what they
say.

"Stuart" <usnavy1610[at]gmail.com> wrote in message
news:46e430c0$0$6469$4c368faf[at]roadrunner.com...
- quote -

> Art,
> Tks. I just looked at my checking account on MoneyCentral (created by MS
> Money), and both transactions
> (on the same date) are there. Interesting to me that I have this problem
> in MS Money, but not in MoneyCentral.
> Stu
> "Art McClinton" <art.mcclinton[at]cox.net> wrote in message
> news:ZEVEi.94117$GO6.76824[at]newsfe21.lga...
> > Yodlee uses QIF as the interface to Money. I have seen this on a credit
> > card where I had 2 oil changes in the same day and Money only picked up
> > one of them even though both were on the web site and the download was
> > likewise Yodlee to Money.
> > > I have never hunted the QIF file itself to see if it is within Money or

> > Yodlee. I have either paid a penny more for the second oil change or
> > gotten them on separate days.
> > > "Stuart" <usnavy1610[at]gmail.com> wrote in message

> > news:46e42103$0$11064$4c368faf[at]roadrunner.com...
> > > Carl, tks for your reply.
> > > - I believe this problem is within MS Money, and how it is perceiving
> > > two like transactions
> > > when it downloads transaction from my checking account. Following
> > > germane:
> > > - This is not QIF statements, it is the automatic downloading of
> > > transactions from my bank.
> > > I provide MS Money the username and password, and it downloads the
> > > transactions. SOP.
> > > - The monthly transfers are from my checking account to T. Rowe Price
> > > via monthly debit
> > > set up long ago.
> > > - Both individual transactions show up properly when I access my
> > > checking account via my bank
> > > website
> > > - Both transactions show up properly when I look at my checking account
> > > via Yodlee web access.
> > > If I am not mistaken, MS Money uses uses Yodlee as an intermediary for
> > > downloading data from
> > > my bank (NFCU).
> > > - Both transactions show up properly in their individual TRP accounts
> > > when I look at them in
> > > MS Money and on line.
> > > - Only one transaction shows up in my checking account register in
> > > Money.
> > > It seems that when I do an update and where the two transactions are
> > > downloaded, it is misidentifying
> > > the two transactions as duplicates, in an automatic manner. Is there
> > > something in Money that allows
> > > this, that I might have mistakingly enabled?
> > > tks SRM
> > > > > From: "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> > > Subject: Re: Money Not Handling Like Transactions the Right Way
> > > Date: Sunday, September 09, 2007 10:36 AM
> > > > > In microsoft.public.money, SRM wrote:
> > > > > > I have EIRAs for my two kids at T. Rowe Price. From my checking
> > > > account, I
> > > > transfer the same amount, on the same
> > > > day of each month, to each EIRA. However, when I download from checking
> > > > account into Money, it is recognizing the
> > > > two events as duplicates and only shows one in my register.
> > > > > Is this direct with T. Rowe Price without going thru a web site?
> > > That would be the best option if it is available to you.
> > > > > It sounds as if you are using a QIF statement. If for that kind of
> > > account, QIF is the only option, that can be a problem. If you could
> > > restrict the QIF file to only include dates that you had not yet
> > > downloaded for, you could try importing as a recovered account. That
> > > would turn off the duplicate checking.
> > > > > Of course it would be nice if Money did not assume that two
> > > transactions in the same QIF file were duplicates of the same
> > > transaction.
> > > > > What could work for you is to schedule the two transfers in Money
> > > and have them put into the register on a particular date. That way
> > > both would be there, even if you have not yet downloaded.
> > > > > > > > > > > > > > > Any help to resolve this would be appreciated.
> > > > > >


  #1  
Old 09-09-2007, 05:43 PM
Stuart
Guest
 
Posts: n/a
Default Re: Money Not Handling Like Transactions the Right Way

Art,

Tks. I just looked at my checking account on MoneyCentral (created by MS
Money), and both transactions
(on the same date) are there. Interesting to me that I have this problem in
MS Money, but not in MoneyCentral.

Stu

"Art McClinton" <art.mcclinton[at]cox.net> wrote in message
news:ZEVEi.94117$GO6.76824[at]newsfe21.lga...
- quote -

> Yodlee uses QIF as the interface to Money. I have seen this on a credit
> card where I had 2 oil changes in the same day and Money only picked up
> one of them even though both were on the web site and the download was
> likewise Yodlee to Money.
> I have never hunted the QIF file itself to see if it is within Money or
> Yodlee. I have either paid a penny more for the second oil change or
> gotten them on separate days.
> "Stuart" <usnavy1610[at]gmail.com> wrote in message
> news:46e42103$0$11064$4c368faf[at]roadrunner.com...
> > Carl, tks for your reply.
> > - I believe this problem is within MS Money, and how it is perceiving two
> > like transactions
> > when it downloads transaction from my checking account. Following
> > germane:
> > - This is not QIF statements, it is the automatic downloading of
> > transactions from my bank.
> > I provide MS Money the username and password, and it downloads the
> > transactions. SOP.
> > - The monthly transfers are from my checking account to T. Rowe Price via
> > monthly debit
> > set up long ago.
> > - Both individual transactions show up properly when I access my checking
> > account via my bank
> > website
> > - Both transactions show up properly when I look at my checking account
> > via Yodlee web access.
> > If I am not mistaken, MS Money uses uses Yodlee as an intermediary for
> > downloading data from
> > my bank (NFCU).
> > - Both transactions show up properly in their individual TRP accounts
> > when I look at them in
> > MS Money and on line.
> > - Only one transaction shows up in my checking account register in Money.
> > It seems that when I do an update and where the two transactions are
> > downloaded, it is misidentifying
> > the two transactions as duplicates, in an automatic manner. Is there
> > something in Money that allows
> > this, that I might have mistakingly enabled?
> > tks SRM
> > > From: "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> > Subject: Re: Money Not Handling Like Transactions the Right Way

> > Date: Sunday, September 09, 2007 10:36 AM
> > > In microsoft.public.money, SRM wrote:
> > > > I have EIRAs for my two kids at T. Rowe Price. From my checking account,
> > > I
> > > transfer the same amount, on the same
> > > day of each month, to each EIRA. However, when I download from checking
> > > account into Money, it is recognizing the
> > > two events as duplicates and only shows one in my register.
> > > Is this direct with T. Rowe Price without going thru a web site?

> > That would be the best option if it is available to you.
> > > It sounds as if you are using a QIF statement. If for that kind of

> > account, QIF is the only option, that can be a problem. If you could
> > restrict the QIF file to only include dates that you had not yet
> > downloaded for, you could try importing as a recovered account. That
> > would turn off the duplicate checking.
> > > Of course it would be nice if Money did not assume that two

> > transactions in the same QIF file were duplicates of the same
> > transaction.
> > > What could work for you is to schedule the two transfers in Money

> > and have them put into the register on a particular date. That way
> > both would be there, even if you have not yet downloaded.
> > > > > > > > > Any help to resolve this would be appreciated.

> >


 
Old 09-09-2007, 05:00 PM
Art McClinton
Guest
 
Posts: n/a
Default Re: Money Not Handling Like Transactions the Right Way

Yodlee uses QIF as the interface to Money. I have seen this on a credit
card where I had 2 oil changes in the same day and Money only picked up one
of them even though both were on the web site and the download was likewise
Yodlee to Money.

I have never hunted the QIF file itself to see if it is within Money or
Yodlee. I have either paid a penny more for the second oil change or gotten
them on separate days.

"Stuart" <usnavy1610[at]gmail.com> wrote in message
news:46e42103$0$11064$4c368faf[at]roadrunner.com...
- quote -

> Carl, tks for your reply.
> - I believe this problem is within MS Money, and how it is perceiving two
> like transactions
> when it downloads transaction from my checking account. Following
> germane:
> - This is not QIF statements, it is the automatic downloading of
> transactions from my bank.
> I provide MS Money the username and password, and it downloads the
> transactions. SOP.
> - The monthly transfers are from my checking account to T. Rowe Price via
> monthly debit
> set up long ago.
> - Both individual transactions show up properly when I access my checking
> account via my bank
> website
> - Both transactions show up properly when I look at my checking account
> via Yodlee web access.
> If I am not mistaken, MS Money uses uses Yodlee as an intermediary for
> downloading data from
> my bank (NFCU).
> - Both transactions show up properly in their individual TRP accounts when
> I look at them in
> MS Money and on line.
> - Only one transaction shows up in my checking account register in Money.
> It seems that when I do an update and where the two transactions are
> downloaded, it is misidentifying
> the two transactions as duplicates, in an automatic manner. Is there
> something in Money that allows
> this, that I might have mistakingly enabled?
> tks SRM
> From: "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> Subject: Re: Money Not Handling Like Transactions the Right Way
> Date: Sunday, September 09, 2007 10:36 AM
> In microsoft.public.money, SRM wrote:
> > I have EIRAs for my two kids at T. Rowe Price. From my checking account,
> > I
> > transfer the same amount, on the same
> > day of each month, to each EIRA. However, when I download from checking
> > account into Money, it is recognizing the
> > two events as duplicates and only shows one in my register.

> Is this direct with T. Rowe Price without going thru a web site?
> That would be the best option if it is available to you.
> It sounds as if you are using a QIF statement. If for that kind of
> account, QIF is the only option, that can be a problem. If you could
> restrict the QIF file to only include dates that you had not yet
> downloaded for, you could try importing as a recovered account. That
> would turn off the duplicate checking.
> Of course it would be nice if Money did not assume that two
> transactions in the same QIF file were duplicates of the same
> transaction.
> What could work for you is to schedule the two transfers in Money
> and have them put into the register on a particular date. That way
> both would be there, even if you have not yet downloaded.
> > > Any help to resolve this would be appreciated.



  #-1  
Old 09-09-2007, 04:36 PM
Stuart
Guest
 
Posts: n/a
Default Re: Money Not Handling Like Transactions the Right Way

Carl, tks for your reply.
- I believe this problem is within MS Money, and how it is perceiving two
like transactions
when it downloads transaction from my checking account. Following germane:
- This is not QIF statements, it is the automatic downloading of
transactions from my bank.
I provide MS Money the username and password, and it downloads the
transactions. SOP.
- The monthly transfers are from my checking account to T. Rowe Price via
monthly debit
set up long ago.
- Both individual transactions show up properly when I access my checking
account via my bank
website
- Both transactions show up properly when I look at my checking account via
Yodlee web access.
If I am not mistaken, MS Money uses uses Yodlee as an intermediary for
downloading data from
my bank (NFCU).
- Both transactions show up properly in their individual TRP accounts when
I look at them in
MS Money and on line.
- Only one transaction shows up in my checking account register in Money.
It seems that when I do an update and where the two transactions are
downloaded, it is misidentifying
the two transactions as duplicates, in an automatic manner. Is there
something in Money that allows
this, that I might have mistakingly enabled?
tks SRM

From: "Cal Learner-- MVP" <via_newsgroup[at]please.tnxSubject: Re: Money Not Handling Like Transactions the Right Way
Date: Sunday, September 09, 2007 10:36 AM

In microsoft.public.money, SRM wrote:

- quote -

> I have EIRAs for my two kids at T. Rowe Price. From my checking account, I
> transfer the same amount, on the same
> day of each month, to each EIRA. However, when I download from checking
> account into Money, it is recognizing the
> two events as duplicates and only shows one in my register.


Is this direct with T. Rowe Price without going thru a web site?
That would be the best option if it is available to you.

It sounds as if you are using a QIF statement. If for that kind of
account, QIF is the only option, that can be a problem. If you could
restrict the QIF file to only include dates that you had not yet
downloaded for, you could try importing as a recovered account. That
would turn off the duplicate checking.

Of course it would be nice if Money did not assume that two
transactions in the same QIF file were duplicates of the same
transaction.

What could work for you is to schedule the two transfers in Money
and have them put into the register on a particular date. That way
both would be there, even if you have not yet downloaded.




- quote -

> Any help to resolve this would be appreciated.


 

Tags
handling, money, transactions
Similar Threads
Thread Forum Replies Last Post
Money Not Handling Like Transactions the Right Way
SRM: I have EIRAs for my two kids at T. Rowe Price. From my checking account, I transfer the same amount, on the same day of each month, to each EIRA....
Microsoft Money 1 09-09-2007 03:36 PM
Handling Transfers in Money 2004
Jim: have numerous downloaded transactions in my checking account within Money 2004 all of which are downloaded with the Pay To field as "ACH...
Microsoft Money 3 10-06-2004 10:25 PM
Money 2003 401k Handling
Rich F: From pat posts I've read on this newsgroup, it would seem that Money's handling of 401k accounts is somewhat dorked up. Here's my problem: I've...
Microsoft Money 3 10-19-2003 06:58 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 12:46 AM.