Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #17  
Old 08-01-2008, 03:45 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: How does money get its data?

"Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
news:%23BGR1dd8IHA.3736[at]TK2MSFTNGP06.phx.gbl...
- quote -

> Regarding the screen scraping, how would this get changed? Is this
> with MS or another service?
> I uploaded a screenshot of how the account looks here
> http://img373.imageshack.us/img373/3...board02ca3.jpg
> What has apparently happened is that before the update, they listed
> the date, payee and amount. After the credit union updated their
> website, they added the extra info on the line "POS Debit Visa Check
> Card ####" I take it this is what is causing the issue? The credit
> union won't revise the page if this is what is causing it, this is the
> only think we can figure that has changed. .
> Regarding the analyzing the log file on why the qif file does not show
> the payee, I can't find anything on it. Money won't import a qfx file
> for me, complains they are corrupted, so I may be stuck going back to
> quicken and that stinks.
> Thx... frustrating, I like money.


It's a 3rd party, Yodlee. If you report the problem to tech support they
may be able to pass it on to Yodlee. Yodlee would be interested in
fixing it. If it's truly a screen layout change problem, it will affect
all of their customers, not just Money users.
--
Chris Cowles
Gainesville, FL


  #16  
Old 07-30-2008, 08:37 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How does money get its data?

In microsoft.public.money, Ron wrote:

- quote -

> I couldn't find anything reference earlier about analyzing the lof file for
> import issues related to "POS DEBIT" so if anyone can report a link or
> instructions, it would be appreciated. Thank you again.


Regarding this one aspect, I suggest you add "POS DEBIT"
to
Banking-> AccountTools-> Categories&Payees-> Payees-> GoToPayeeRulesManager

While you are at it, it is usually a good idea to select
Tools-> Settings-> OnlineServices-> ReplacePayeeNames....

You may want to set
Tools-> Settings-> OnlineServices-> AddADescriptionToTheMemoField
  #15  
Old 07-30-2008, 08:22 PM
Ken
Guest
 
Posts: n/a
Default Re: How does money get its data?

Hi Ron,

If credit won't change, then use your NotePad Editor to make required
changes before importing into Money.

As an example,

Your can use NotePads Find and Replace feature to remove all unwanted text,
it happens in a blink of an eye when 'Replace All' is selected.


What I would do is open money, then choose File, on it's menu choose Export.

Export your account then close money.

Open exported account with NotePad.

Observe how it looks.


Now go to your credit company and download their .QIF to your desktop.

Open it with NotePad, observe what needs to change, suspect a simple find
text to remove then 'Replace All' will correct it in a blink of the eye.

Ken

"Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
news:%23Q%23DMrd8IHA.1196[at]TK2MSFTNGP05.phx.gbl...
|
| "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
| news:O9YSwmd8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
| | > "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
| > news:%23BGR1dd8IHA.3736[at]TK2MSFTNGP06.phx.gbl...
| > | > | > | > > Regarding the screen scraping, how would this get changed? Is this
with
| > > MS or another service?
| > | | > Is it Yodlee?
| | |
| Found it, it's Yodlee. I signed up for an account and it reports the same
| thing as money. So if the credit won't change, what are the chance yodlee
| will? Since it doesn't work on their site properly either, one would hope
| they would address it.
|
|

  #14  
Old 07-30-2008, 12:43 PM
John Pollard
Guest
 
Posts: n/a
Default Re: How does money get its data?

Ron wrote:
- quote -

> Regarding the analyzing the log file on why the qif file does
> not
> show the payee, I can't find anything on it.


> Money won't import a
> qfx file for me, complains they are corrupted,


Rename the qfx file: append ".OFX" to the existing name. Then
import.

- quote -

> so I may be stuck going back to quicken and that stinks.

Virtually every financial institution I have creates payee names
like the ones you're seeing. I don't think Quicken will treat
them any differently.

But even if you can't "import" the QFX file from NFCU, you can
open it and view its contents with Notepad. You can see for
yourself what the OFX/QFX payee names look like.

--

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


  #13  
Old 07-30-2008, 12:25 AM
Ron
Guest
 
Posts: n/a
Default Re: How does money get its data?


"Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
news:O9YSwmd8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
- quote -

> "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
> news:%23BGR1dd8IHA.3736[at]TK2MSFTNGP06.phx.gbl...
> > > > > Regarding the screen scraping, how would this get changed? Is this with

> > MS or another service?
> > Is it Yodlee?


Found it, it's Yodlee. I signed up for an account and it reports the same
thing as money. So if the credit won't change, what are the chance yodlee
will? Since it doesn't work on their site properly either, one would hope
they would address it.


  #12  
Old 07-30-2008, 12:17 AM
Ron
Guest
 
Posts: n/a
Default Re: How does money get its data?


"Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
news:%23BGR1dd8IHA.3736[at]TK2MSFTNGP06.phx.gbl...
- quote -

> Regarding the screen scraping, how would this get changed? Is this with
> MS or another service?


Is it Yodlee?


  #11  
Old 07-30-2008, 12:01 AM
Ron
Guest
 
Posts: n/a
Default Re: How does money get its data?


"SteveB" <respond[at]online.newsgroup.invalid> wrote in message
news:xn0ft7konhg5t7003[at]msnews.microsoft.com...
- quote -

> Ron wrote:
> > > > "Chris Cowles" wrote:
> > > > "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
> > > news:Of3J8MG8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
> > > > > > > ... Before todays website update, when I downloaded transactions,
> > > > they would show up with regular payee names like Home Depot,
> > > > Seven Eleven, etc. As of today, each download is doubled with
> > > > one transaction showing the payee name as usual and a matching
> > > > transaction showing only "POS Debit Visa - Acct#last4" and you
> > > > have to watch for and delete them. This happens on every
> > > > VISA/Debit card transaction.
> > > > > > > I would like to call them and complain and ask them to fix it,
> > > > but is it really their issue? It will be an uphill climb as they
> > > > do not support either money or quicken, just imported files. How
> > > > is Money getting the file on the background downloads? Does the
> > > > windows live account actually log in and cull data or is the bank
> > > > providing some sort of file they can correct?
> > > > > I have a similar problem with Synovus bank in Florida. Pending
> > > transactions show up anonymously, then again with details. Because
> > > I know they'll be duplicated, my approach is to simply delete the
> > > anonymously named instance. It also helps to connect to the bank
> > > less frequently. The pending transactions will have converted to
> > > the actual info within a day or two, reducing the duplication.
> > > Thanks. Unfortunately for NFCU, the payee named transaction and the

> > POS Debit transaction both show up after the transaction has cleared.
> > I don't see any pending transactions in the download. On the NFCU
> > website for cleared transactions, I only see the payee named
> > transactions, but for some reason, Money+ is reproting both payee and
> > a generic POS Debit transaction. hence my confusion on how money is
> > getting the data when NFCU tells me they do not permit third party
> > downloads.

> Money uses their own third-party companies (I can't get the names to
> come out of my thick head right now, but someone else will be glad to
> supply them) to get the data. Those companies use your account name and
> password to log in to the web site the same way you do, display your
> account, the same way you do, copy the data into a file, reformat it,
> and feed it into Money. This is call "screen scraping".
> The screen scrapers obviously don't try to massage your data, just
> report what the bank shows on the web site. If the bank changes the web
> page, the screen scraper software has to be changed to match.
> It's best to use the direct connection, but most banks have dropped
> that feature because:
> * They have to pay for a server, bandwith, and programmers to provide
> it.
> * You no longer have an incentive to log on to their site so they can
> show you ads.
> If you're having trouble with the downloaded file, you can open it with
> a text editor. Search the history on this group for a recent discussion
> about how to analyze the file. It addressed your exact problem.
> There's probably a way to log the events as you import data on a direct
> connection, but I don't know what it is. Maybe one of the MVP guys here
> has better information.
> --
> Steve Bell
> New Life Home Improvement
> Arlington, TX


Regarding the screen scraping, how would this get changed? Is this with MS
or another service?

I uploaded a screenshot of how the account looks here
http://img373.imageshack.us/img373/3...board02ca3.jpg
What has apparently happened is that before the update, they listed the
date, payee and amount. After the credit union updated their website, they
added the extra info on the line "POS Debit Visa Check Card ####" I take it
this is what is causing the issue? The credit union won't revise the page
if this is what is causing it, this is the only think we can figure that has
changed. .

Regarding the analyzing the log file on why the qif file does not show the
payee, I can't find anything on it. Money won't import a qfx file for me,
complains they are corrupted, so I may be stuck going back to quicken and
that stinks.

Thx... frustrating, I like money.


  #10  
Old 07-29-2008, 02:08 AM
Ron
Guest
 
Posts: n/a
Default Re: How does money get its data?


"Chris Cowles" <spam_magnet[at]remove-me-bellsouth.net> wrote in message
news:1C019812-0ECE-47A4-A3A3-EA76E331CE45[at]microsoft.com...
- quote -

> "SteveB" <respond[at]online.newsgroup.invalid> wrote in message
> news:xn0ft7konhg5t7003[at]msnews.microsoft.com...
> > > It's best to use the direct connection, but most banks have dropped

> > that feature because:
> > * They have to pay for a server, bandwith, and programmers to provide
> > it.
> > * You no longer have an incentive to log on to their site so they can
> > show you ads.

> It's my impression that most credit unions don't do direct connect.
> --
> Chris Cowles
> Gainesville, FL

I spoke with the technical folks at NFCU today and they are willing to at
least look at the issue. First thing was that they do not support direct
connect, but at least I think I convinced them to try and make an attempt to
fix the unsupported third party downloads. If it's a lot of work, I'm sure
they will tell me to pound sand, but it's worth a try. They wanted
screenshots of the issue like this one
http://img509.imageshack.us/img509/2...board01za0.jpg where you can see
several examples.

I couldn't find anything reference earlier about analyzing the lof file for
import issues related to "POS DEBIT" so if anyone can report a link or
instructions, it would be appreciated. Thank you again.


  #9  
Old 07-29-2008, 02:06 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: How does money get its data?

"SteveB" <respond[at]online.newsgroup.invalid> wrote in message
news:xn0ft85lsrvict000[at]msnews.microsoft.com...
- quote -

> Chris Cowles wrote:
> > It's my impression that most credit unions don't do direct connect.

> I won't argue with you, but I *will* point out that I was using the
> colloquial definition of bank, meaning any business that keeps your
> money for you. I should have said "Financial Institution" to be more
> accurate.


I don't dispute your statement. The financial institution in the OP's
case is a credit union, which is why I made that point.
--
Chris Cowles
Gainesville, FL


  #8  
Old 07-29-2008, 01:59 AM
SteveB
Guest
 
Posts: n/a
Default Re: How does money get its data?

Chris Cowles wrote:

- quote -

> "SteveB" <respond[at]online.newsgroup.invalid> wrote in message
> news:xn0ft7konhg5t7003[at]msnews.microsoft.com...
> > > It's best to use the direct connection, but most banks have dropped

> > that feature because:
> > * They have to pay for a server, bandwith, and programmers to
> > provide it.
> > * You no longer have an incentive to log on to their site so they
> > can show you ads.

> It's my impression that most credit unions don't do direct connect.


I won't argue with you, but I *will* point out that I was using the
colloquial definition of bank, meaning any business that keeps your
money for you. I should have said "Financial Institution" to be more
accurate.

You can go here:
http://www.microsoft.com/money/bankonline.aspx#
to check whether an FI has a direct or third-party connection. Click on
an FI; if the description says "third party", it's not direct.

--
Steve Bell
New Life Home Improvement
Arlington, TX
  #7  
Old 07-29-2008, 01:43 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: How does money get its data?

"SteveB" <respond[at]online.newsgroup.invalid> wrote in message
news:xn0ft7konhg5t7003[at]msnews.microsoft.com...
- quote -

> It's best to use the direct connection, but most banks have dropped
> that feature because:
> * They have to pay for a server, bandwith, and programmers to provide
> it.
> * You no longer have an incentive to log on to their site so they can
> show you ads.


It's my impression that most credit unions don't do direct connect.
--
Chris Cowles
Gainesville, FL


  #6  
Old 07-28-2008, 04:24 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How does money get its data?

In microsoft.public.money, Ken wrote:

- quote -

> Re: Can Money import quicken files?
> With money open, choose File, on it's menu choose Import, read instructions
> in the Import dialog window.


The help item has to do with reading a whole Quicken file and making
a new Money file from it.

I think the person would want to File-> Import... Statement to read
in a .QIF or .QFX transaction file. If the QFX does not work as is,
try renaming it to *.ofx.


  #5  
Old 07-28-2008, 04:19 PM
Ken
Guest
 
Posts: n/a
Default Re: How does money get its data?

Re: Can Money import quicken files?

With money open, choose File, on it's menu choose Import, read instructions
in the Import dialog window.

Ken

"Ron" <Ron[at]discussions.microsoft.com> wrote in message
news:97E4AB27-73BC-4F36-A552-E552833EE8E9[at]microsoft.com...
|
|
| "Ken" wrote:
|
| > How to capture an OFX log file in Money
| > http://support.microsoft.com/kb/911941
| | | > "SteveB" <respond[at]online.newsgroup.invalid> wrote in message
| > news:xn0ft7konhg5t7003[at]msnews.microsoft.com...
| > | Ron wrote:
| > |
| > | | > | | > | > "Chris Cowles" wrote:
| > | | > | > > "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
| > | > > news:Of3J8MG8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
| > | > > | > | > > > ... Before todays website update, when I downloaded
transactions,
| > | > > > they would show up with regular payee names like Home Depot,
| > | > > > Seven Eleven, etc. As of today, each download is doubled with
| > | > > > one transaction showing the payee name as usual and a matching
| > | > > > transaction showing only "POS Debit Visa - Acct#last4" and you
| > | > > > have to watch for and delete them. This happens on every
| > | > > > VISA/Debit card transaction.
| > | > > | > | > > > I would like to call them and complain and ask them to fix it,
| > | > > > but is it really their issue? It will be an uphill climb as
they
| > | > > > do not support either money or quicken, just imported files.
How
| > | > > > is Money getting the file on the background downloads? Does the
| > | > > > windows live account actually log in and cull data or is the
bank
| > | > > > providing some sort of file they can correct?
| > | > | > | > > I have a similar problem with Synovus bank in Florida. Pending
| > | > > transactions show up anonymously, then again with details. Because
| > | > > I know they'll be duplicated, my approach is to simply delete the
| > | > > anonymously named instance. It also helps to connect to the bank
| > | > > less frequently. The pending transactions will have converted to
| > | > > the actual info within a day or two, reducing the duplication.
| > | | > | > Thanks. Unfortunately for NFCU, the payee named transaction and the
| > | > POS Debit transaction both show up after the transaction has
cleared.
| > | > I don't see any pending transactions in the download. On the NFCU
| > | > website for cleared transactions, I only see the payee named
| > | > transactions, but for some reason, Money+ is reproting both payee
and
| > | > a generic POS Debit transaction. hence my confusion on how money is
| > | > getting the data when NFCU tells me they do not permit third party
| > | > downloads.
| > |
| > | Money uses their own third-party companies (I can't get the names to
| > | come out of my thick head right now, but someone else will be glad to
| > | supply them) to get the data. Those companies use your account name
and
| > | password to log in to the web site the same way you do, display your
| > | account, the same way you do, copy the data into a file, reformat it,
| > | and feed it into Money. This is call "screen scraping".
| > |
| > | The screen scrapers obviously don't try to massage your data, just
| > | report what the bank shows on the web site. If the bank changes the
web
| > | page, the screen scraper software has to be changed to match.
| > |
| > | It's best to use the direct connection, but most banks have dropped
| > | that feature because:
| > | * They have to pay for a server, bandwith, and programmers to provide
| > | it.
| > | * You no longer have an incentive to log on to their site so they can
| > | show you ads.
| > |
| > | If you're having trouble with the downloaded file, you can open it
with
| > | a text editor. Search the history on this group for a recent
discussion
| > | about how to analyze the file. It addressed your exact problem.
| > |
| > | There's probably a way to log the events as you import data on a
direct
| > | connection, but I don't know what it is. Maybe one of the MVP guys
here
| > | has better information.
| > |
| > | --
| > | Steve Bell
| > | New Life Home Improvement
| > | Arlington, TX
| | |
| I did a search through MS's interface and couldn't find anything, I'll try
| my newsreader when I get home.
|
| Can Money import quicken files? Is it safe to say that if manual quicken
| imports show payee names in the register when moneys qif file does not,
that
| if money can import the quicken file, I could do that if the bank doesn't
| want to help with the background downloading?

  #4  
Old 07-28-2008, 03:32 PM
Ron
Guest
 
Posts: n/a
Default Re: How does money get its data?



"Ken" wrote:

- quote -

> How to capture an OFX log file in Money
> http://support.microsoft.com/kb/911941
> "SteveB" <respond[at]online.newsgroup.invalid> wrote in message
> news:xn0ft7konhg5t7003[at]msnews.microsoft.com...
> | Ron wrote:
> |
> | > | > | > "Chris Cowles" wrote:
> | > | > > "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
> | > > news:Of3J8MG8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
> | > > > | > > > ... Before todays website update, when I downloaded transactions,
> | > > > they would show up with regular payee names like Home Depot,
> | > > > Seven Eleven, etc. As of today, each download is doubled with
> | > > > one transaction showing the payee name as usual and a matching
> | > > > transaction showing only "POS Debit Visa - Acct#last4" and you
> | > > > have to watch for and delete them. This happens on every
> | > > > VISA/Debit card transaction.
> | > > > | > > > I would like to call them and complain and ask them to fix it,
> | > > > but is it really their issue? It will be an uphill climb as they
> | > > > do not support either money or quicken, just imported files. How
> | > > > is Money getting the file on the background downloads? Does the
> | > > > windows live account actually log in and cull data or is the bank
> | > > > providing some sort of file they can correct?
> | > > | > > I have a similar problem with Synovus bank in Florida. Pending
> | > > transactions show up anonymously, then again with details. Because
> | > > I know they'll be duplicated, my approach is to simply delete the
> | > > anonymously named instance. It also helps to connect to the bank
> | > > less frequently. The pending transactions will have converted to
> | > > the actual info within a day or two, reducing the duplication.
> | > | > Thanks. Unfortunately for NFCU, the payee named transaction and the
> | > POS Debit transaction both show up after the transaction has cleared.
> | > I don't see any pending transactions in the download. On the NFCU
> | > website for cleared transactions, I only see the payee named
> | > transactions, but for some reason, Money+ is reproting both payee and
> | > a generic POS Debit transaction. hence my confusion on how money is
> | > getting the data when NFCU tells me they do not permit third party
> | > downloads.
> |
> | Money uses their own third-party companies (I can't get the names to
> | come out of my thick head right now, but someone else will be glad to
> | supply them) to get the data. Those companies use your account name and
> | password to log in to the web site the same way you do, display your
> | account, the same way you do, copy the data into a file, reformat it,
> | and feed it into Money. This is call "screen scraping".
> |
> | The screen scrapers obviously don't try to massage your data, just
> | report what the bank shows on the web site. If the bank changes the web
> | page, the screen scraper software has to be changed to match.
> |
> | It's best to use the direct connection, but most banks have dropped
> | that feature because:
> | * They have to pay for a server, bandwith, and programmers to provide
> | it.
> | * You no longer have an incentive to log on to their site so they can
> | show you ads.
> |
> | If you're having trouble with the downloaded file, you can open it with
> | a text editor. Search the history on this group for a recent discussion
> | about how to analyze the file. It addressed your exact problem.
> |
> | There's probably a way to log the events as you import data on a direct
> | connection, but I don't know what it is. Maybe one of the MVP guys here
> | has better information.
> |
> | --
> | Steve Bell
> | New Life Home Improvement
> | Arlington, TX


I did a search through MS's interface and couldn't find anything, I'll try
my newsreader when I get home.

Can Money import quicken files? Is it safe to say that if manual quicken
imports show payee names in the register when moneys qif file does not, that
if money can import the quicken file, I could do that if the bank doesn't
want to help with the background downloading?
  #3  
Old 07-28-2008, 02:53 PM
Ken
Guest
 
Posts: n/a
Default Re: How does money get its data?

How to capture an OFX log file in Money
http://support.microsoft.com/kb/911941


"SteveB" <respond[at]online.newsgroup.invalid> wrote in message
news:xn0ft7konhg5t7003[at]msnews.microsoft.com...
| Ron wrote:
|
| | | > "Chris Cowles" wrote:
| | > > "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
| > > news:Of3J8MG8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
| > > | > > > ... Before todays website update, when I downloaded transactions,
| > > > they would show up with regular payee names like Home Depot,
| > > > Seven Eleven, etc. As of today, each download is doubled with
| > > > one transaction showing the payee name as usual and a matching
| > > > transaction showing only "POS Debit Visa - Acct#last4" and you
| > > > have to watch for and delete them. This happens on every
| > > > VISA/Debit card transaction.
| > > | > > > I would like to call them and complain and ask them to fix it,
| > > > but is it really their issue? It will be an uphill climb as they
| > > > do not support either money or quicken, just imported files. How
| > > > is Money getting the file on the background downloads? Does the
| > > > windows live account actually log in and cull data or is the bank
| > > > providing some sort of file they can correct?
| > | > > I have a similar problem with Synovus bank in Florida. Pending
| > > transactions show up anonymously, then again with details. Because
| > > I know they'll be duplicated, my approach is to simply delete the
| > > anonymously named instance. It also helps to connect to the bank
| > > less frequently. The pending transactions will have converted to
| > > the actual info within a day or two, reducing the duplication.
| | > Thanks. Unfortunately for NFCU, the payee named transaction and the
| > POS Debit transaction both show up after the transaction has cleared.
| > I don't see any pending transactions in the download. On the NFCU
| > website for cleared transactions, I only see the payee named
| > transactions, but for some reason, Money+ is reproting both payee and
| > a generic POS Debit transaction. hence my confusion on how money is
| > getting the data when NFCU tells me they do not permit third party
| > downloads.
|
| Money uses their own third-party companies (I can't get the names to
| come out of my thick head right now, but someone else will be glad to
| supply them) to get the data. Those companies use your account name and
| password to log in to the web site the same way you do, display your
| account, the same way you do, copy the data into a file, reformat it,
| and feed it into Money. This is call "screen scraping".
|
| The screen scrapers obviously don't try to massage your data, just
| report what the bank shows on the web site. If the bank changes the web
| page, the screen scraper software has to be changed to match.
|
| It's best to use the direct connection, but most banks have dropped
| that feature because:
| * They have to pay for a server, bandwith, and programmers to provide
| it.
| * You no longer have an incentive to log on to their site so they can
| show you ads.
|
| If you're having trouble with the downloaded file, you can open it with
| a text editor. Search the history on this group for a recent discussion
| about how to analyze the file. It addressed your exact problem.
|
| There's probably a way to log the events as you import data on a direct
| connection, but I don't know what it is. Maybe one of the MVP guys here
| has better information.
|
| --
| Steve Bell
| New Life Home Improvement
| Arlington, TX

  #2  
Old 07-28-2008, 12:43 PM
SteveB
Guest
 
Posts: n/a
Default Re: How does money get its data?

Ron wrote:

- quote -

> "Chris Cowles" wrote:
> > "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
> > news:Of3J8MG8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
> > > > > ... Before todays website update, when I downloaded transactions,
> > > they would show up with regular payee names like Home Depot,
> > > Seven Eleven, etc. As of today, each download is doubled with
> > > one transaction showing the payee name as usual and a matching
> > > transaction showing only "POS Debit Visa - Acct#last4" and you
> > > have to watch for and delete them. This happens on every
> > > VISA/Debit card transaction.
> > > > > I would like to call them and complain and ask them to fix it,
> > > but is it really their issue? It will be an uphill climb as they
> > > do not support either money or quicken, just imported files. How
> > > is Money getting the file on the background downloads? Does the
> > > windows live account actually log in and cull data or is the bank
> > > providing some sort of file they can correct?
> > > I have a similar problem with Synovus bank in Florida. Pending

> > transactions show up anonymously, then again with details. Because
> > I know they'll be duplicated, my approach is to simply delete the
> > anonymously named instance. It also helps to connect to the bank
> > less frequently. The pending transactions will have converted to
> > the actual info within a day or two, reducing the duplication.

> Thanks. Unfortunately for NFCU, the payee named transaction and the
> POS Debit transaction both show up after the transaction has cleared.
> I don't see any pending transactions in the download. On the NFCU
> website for cleared transactions, I only see the payee named
> transactions, but for some reason, Money+ is reproting both payee and
> a generic POS Debit transaction. hence my confusion on how money is
> getting the data when NFCU tells me they do not permit third party
> downloads.


Money uses their own third-party companies (I can't get the names to
come out of my thick head right now, but someone else will be glad to
supply them) to get the data. Those companies use your account name and
password to log in to the web site the same way you do, display your
account, the same way you do, copy the data into a file, reformat it,
and feed it into Money. This is call "screen scraping".

The screen scrapers obviously don't try to massage your data, just
report what the bank shows on the web site. If the bank changes the web
page, the screen scraper software has to be changed to match.

It's best to use the direct connection, but most banks have dropped
that feature because:
* They have to pay for a server, bandwith, and programmers to provide
it.
* You no longer have an incentive to log on to their site so they can
show you ads.

If you're having trouble with the downloaded file, you can open it with
a text editor. Search the history on this group for a recent discussion
about how to analyze the file. It addressed your exact problem.

There's probably a way to log the events as you import data on a direct
connection, but I don't know what it is. Maybe one of the MVP guys here
has better information.

--
Steve Bell
New Life Home Improvement
Arlington, TX
  #1  
Old 07-28-2008, 12:27 PM
Ron
Guest
 
Posts: n/a
Default Re: How does money get its data?



"Chris Cowles" wrote:

- quote -

> "Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
> news:Of3J8MG8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
> > > ... Before todays website update, when I downloaded transactions, they

> > would show up with regular payee names like Home Depot, Seven Eleven,
> > etc. As of today, each download is doubled with one transaction
> > showing the payee name as usual and a matching transaction showing
> > only "POS Debit Visa - Acct#last4" and you have to watch for and
> > delete them. This happens on every VISA/Debit card transaction.
> > > I would like to call them and complain and ask them to fix it, but is

> > it really their issue? It will be an uphill climb as they do not
> > support either money or quicken, just imported files. How is Money
> > getting the file on the background downloads? Does the windows live
> > account actually log in and cull data or is the bank providing some
> > sort of file they can correct?

> I have a similar problem with Synovus bank in Florida. Pending
> transactions show up anonymously, then again with details. Because I
> know they'll be duplicated, my approach is to simply delete the
> anonymously named instance. It also helps to connect to the bank less
> frequently. The pending transactions will have converted to the actual
> info within a day or two, reducing the duplication.
> --
> Chris Cowles
> Gainesville, FL


Thanks. Unfortunately for NFCU, the payee named transaction and the POS
Debit transaction both show up after the transaction has cleared. I don't
see any pending transactions in the download. On the NFCU website for
cleared transactions, I only see the payee named transactions, but for some
reason, Money+ is reproting both payee and a generic POS Debit transaction.
hence my confusion on how money is getting the data when NFCU tells me they
do not permit third party downloads.
 
Old 07-28-2008, 11:22 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: How does money get its data?

"Ron" <ronDOTpat[at]REMOVEmchsiDOT.com> wrote in message
news:Of3J8MG8IHA.3724[at]TK2MSFTNGP03.phx.gbl...
- quote -

> ... Before todays website update, when I downloaded transactions, they
> would show up with regular payee names like Home Depot, Seven Eleven,
> etc. As of today, each download is doubled with one transaction
> showing the payee name as usual and a matching transaction showing
> only "POS Debit Visa - Acct#last4" and you have to watch for and
> delete them. This happens on every VISA/Debit card transaction.
> I would like to call them and complain and ask them to fix it, but is
> it really their issue? It will be an uphill climb as they do not
> support either money or quicken, just imported files. How is Money
> getting the file on the background downloads? Does the windows live
> account actually log in and cull data or is the bank providing some
> sort of file they can correct?


I have a similar problem with Synovus bank in Florida. Pending
transactions show up anonymously, then again with details. Because I
know they'll be duplicated, my approach is to simply delete the
anonymously named instance. It also helps to connect to the bank less
frequently. The pending transactions will have converted to the actual
info within a day or two, reducing the duplication.
--
Chris Cowles
Gainesville, FL


  #-1  
Old 07-28-2008, 03:37 AM
Ron
Guest
 
Posts: n/a
Default How does money get its data?


I bank with Navy Federal Credit Union and I am *trying* to adapt to MS Money
plus (demo right now) from scattered use of Quicken. I'd like to learn how
money gets my bank information so I can make an educated call/complaint to
the credit unions technical group about the data I am getting.

I am currently testing two mny files, one automated and one manual. Today
with NFCU, when I do their recommended manual method by signing on to the
website, selecting a date period then importing a QIF file, all the
transactions show up as "POS Debit Visa - Acct#last4" and no other
information. If I managed to enter the transaction from the receipt before
the download, I prompts me to match it. All is good except I don't always,
rarely actually, get receipts from my wife, nor do I often enter receipts as
soon as they happen. Having just entries for POS Debit Visa -
Acctlast4makes it very difficult to use Money to its fullest potential
unless I manually fix each and every transaction which is equally as
frustrating and each account is a seperate download to boot.

On the automated downloaded file, all was great up to today, for the most
part. However, today NFCU updated their online account portal so users can
now see pending transactions (authorizations) plus cleared transactions in
one browser window to explain to the user the difference between available
balance and current balance. Before todays website update, when I
downloaded transactions, they would show up with regular payee names like
Home Depot, Seven Eleven, etc. As of today, each download is doubled with
one transaction showing the payee name as usual and a matching transaction
showing only "POS Debit Visa - Acct#last4" and you have to watch for and
delete them. This happens on every VISA/Debit card transaction.

I would like to call them and complain and ask them to fix it, but is it
really their issue? It will be an uphill climb as they do not support
either money or quicken, just imported files. How is Money getting the file
on the background downloads? Does the windows live account actually log in
and cull data or is the bank providing some sort of file they can correct?

If I cannot get them to fix either the duplicated entries on the downloads
or the lack of payee names on the imports, money is useless to me and I
really like this program and would like to use it.

Thanks for any advice and help.


 

Tags
data, money
Similar Threads
Thread Forum Replies Last Post
Money Data
tmc: Can you access the Microsoft Money data with a report writer like Crystal Reports or Microsoft Access to create customized reports?
Microsoft Money 3 01-20-2006 05:15 PM
Money Data
Whiz: I am using Money 2002 (simply because later version don't offer anything new that I need) but I cannot find anyway or option that will allow me to...
Microsoft Money 2 09-12-2005 02:46 PM
How to convert MoneyDeluxeBusiness2004 Data to Money2005 Premium Data
Admin: I had Money 2004 Business edition, now I installed Money 2005 Premium, upon installation it converted the data from the Business edition and...
Microsoft Money 2 08-06-2004 02:33 PM
How well does MSM 2004 merge .ofx data with existing data?
Irwin: I gave up using downloaded .ofx files with Money Deluxe 2002. The auto import often screwed up manually entered data: it delete transactions...
Microsoft Money 1 02-02-2004 08:41 AM
MS Money Data On Mac
Ted Eimon: I have recently been put in charge of the accounting at a non-profit, which has kept their records on a PC using MS Money 99. Problem is, I use a...
Microsoft Money 3 01-28-2004 02:49 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 04:46 AM.