Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 03-08-2007, 07:18 PM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: Microsoft Money Premium or Small Business 2006

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > Be aware
that Fidelity Investments and Fidelity Netbenefits are
- quote -

> different in their downloads. In particular, Netbenefits, for some
> reason, does not use the real CUSIP in the OFX downloads. This is
> only a problem if you have the same security elsewhere. Money 2007
> has a way to deal with that dual CUSIP behavior that Money 2006 does
> not.


And Net Benefits does not officialy support Quicken 2007.
Today, I tried to update the transactions for my sister'a 403(b),
Download skipped 20 Feb 2007 transactions.


Called Fido, they are aware of the problem.


  #4  
Old 03-08-2007, 04:27 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Microsoft Money Premium or Small Business 2006

In microsoft.public.money, Howard Kaikow wrote:

- quote -

> Fidelity does produce a QIF file for 403(b), 401(k) accounts.

Be aware that Fidelity Investments and Fidelity Netbenefits are
different in their downloads. In particular, Netbenefits, for some
reason, does not use the real CUSIP in the OFX downloads. This is
only a problem if you have the same security elsewhere. Money 2007
has a way to deal with that dual CUSIP behavior that Money 2006 does
not.

  #3  
Old 03-08-2007, 03:51 PM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: Microsoft Money Premium or Small Business 2006

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:mhc0v2dcksrri5joud1p97s8qq0ernrag5[at]4ax.com...

Thanx.

Fidelity does produce a QIF file for 403(b), 401(k) accounts.


  #2  
Old 03-08-2007, 03:08 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Microsoft Money Premium or Small Business 2006

In microsoft.public.money, Howard Kaikow wrote:

- quote -

> "Cal Learner-- MVP" > wrote
> > How far back the transactions can go is a function of the
> > institution. I don't know how far they can go back with Fidelity
> > Investments. Fidelity does have reliable OFX servers.

> Fidelity only allows the loading of the most recent 90 days.
> I can download CSV files from Fideo that go back 18 months, but neither CSV
> nor QIF can be import into Quicken for an Investment account.
> It makes no sense to me that either Quicken or Money will not allow the
> importation of transaction files.
> It would be rather tedious to manually enter the transactions.


That OFX Converter referenced on
http://xl2qif.chez-alice.fr/links_en.php could be useful for you.


<snip> > Assuming you are in the US, yes, for mutual funds. There are two
- quote -

> > ways that Money provides an average basis of a fund in an account,
> > because the IRS gives you the same choices: single category, and
> > dual category (where the short- and long-term basis is averaged
> > separately).
> > > For stocks, specific identification is always used, with FIFO being

> > a default. That is also permitted for funds.

> Is LIFO also a default?
> Indeed, my ONLY justification for getting either Quicken or Money is for
> this tax calculation.
> But the calculations cannot be done without entering all transactions back
> to August 2005.
> Will Money 2006 accept the import of a Fidelity CSV file?


No. You would want to convert to OFX.


- quote -

> If so, what field names need to be used?
> Will Money 2006 accept the import of a QIF file?


Yes. In the case of an investment account, they are not imported as
statements, but as "new or recovered" accounts. By importing the
cash transactions and investment transactions as separate QIFs
simultaneously, Money can resolve the interaction. Similarly, if you
bring in bank accounts at the same time, then transfers between
accounts can be recognized as transfers.

- quote -

> If so, is there a way to convert a Fidelity CSV to a Money compatible QIF?

XL2QIF could be useful to you.
http://xl2qif.chez-alice.fr/xl2qif_en.php

Note that there is a glaring omission from QIF for investments-- the
symbol is not included. You would have to enter those yourself. OFX
normally does include the symbol.

- quote -

> Same questions for OFX file?

The converters, which are not Microsoft-supplied.

OFX.NET has specifications, if you want to get into that.
  #1  
Old 03-08-2007, 02:39 PM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: Microsoft Money Premium or Small Business 2006

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:sn90v2lngnoo8o76a705vvv5o4pn7gs2rg[at]4ax.com...
- quote -

> How far back the transactions can go is a function of the
> institution. I don't know how far they can go back with Fidelity
> Investments. Fidelity does have reliable OFX servers.


Fidelity only allows the loading of the most recent 90 days.
I can download CSV files from Fideo that go back 18 months, but neither CSV
nor QIF can be import into Quicken for an Investment account.

It makes no sense to me that either Quicken or Money will not allow the
importation of transaction files.
It would be rather tedious to manually enter the transactions.

- quote -

> Money 2006 should be able to convert Quicken 2005 files or earlier.

I'm currently using the trial version of Quicken 2007 Home and Business.

- quote -

> Are you sure that Windows 2000 was a supported platform for Money
> 2006? I don't know.


According to info at MST web site, yes.

- quote -

> > 2. Quicken has a feature that compares the benefits of using average cost
> > vs., actual cost for capital gains distributions.
> > Does Money 2006 have this capability?


> Assuming you are in the US, yes, for mutual funds. There are two
> ways that Money provides an average basis of a fund in an account,
> because the IRS gives you the same choices: single category, and
> dual category (where the short- and long-term basis is averaged
> separately).
> For stocks, specific identification is always used, with FIFO being
> a default. That is also permitted for funds.


Is LIFO also a default?

Indeed, my ONLY justification for getting either Quicken or Money is for
this tax calculation.
But the calculations cannot be done without entering all transactions back
to August 2005.

Will Money 2006 accept the import of a Fidelity CSV file?
If so, what field names need to be used?

Will Money 2006 accept the import of a QIF file?
If so, is there a way to convert a Fidelity CSV to a Money compatible QIF?

Same questions for OFX file?


 
Old 03-08-2007, 02:18 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Microsoft Money Premium or Small Business 2006

In microsoft.public.money, Howard Kaikow wrote:

- quote -

> Since I use Windows 2000, I cannot use the 2007 version.
> These questions are specific to the 2006 version for which I cannot find a
> trial download.
> These questions apply only to Investment accounts.
> 1. With Quicken, the most recent 90 days of transactions can be downloaded
> from Fidelity Investments, but there does not seem to be any way to download
> older transactions, or to import older transactions (Fidelity only creates
> CSV files).
> Can Money 2006 solve this problem?


How far back the transactions can go is a function of the
institution. I don't know how far they can go back with Fidelity
Investments. Fidelity does have reliable OFX servers.

Money 2006 should be able to convert Quicken 2005 files or earlier.

Are you sure that Windows 2000 was a supported platform for Money
2006? I don't know.

- quote -

> 2. Quicken has a feature that compares the benefits of using average cost
> vs., actual cost for capital gains distributions.
> Does Money 2006 have this capability?


Assuming you are in the US, yes, for mutual funds. There are two
ways that Money provides an average basis of a fund in an account,
because the IRS gives you the same choices: single category, and
dual category (where the short- and long-term basis is averaged
separately).

For stocks, specific identification is always used, with FIFO being
a default. That is also permitted for funds.
  #-1  
Old 03-08-2007, 02:08 PM
Howard Kaikow
Guest
 
Posts: n/a
Default Microsoft Money Premium or Small Business 2006

Since I use Windows 2000, I cannot use the 2007 version.
These questions are specific to the 2006 version for which I cannot find a
trial download.
These questions apply only to Investment accounts.

1. With Quicken, the most recent 90 days of transactions can be downloaded
from Fidelity Investments, but there does not seem to be any way to download
older transactions, or to import older transactions (Fidelity only creates
CSV files).

Can Money 2006 solve this problem?

2. Quicken has a feature that compares the benefits of using average cost
vs., actual cost for capital gains distributions.
Does Money 2006 have this capability?


 

Tags
2006, business, microsoft, money, premium, small
Similar Threads
Thread Forum Replies Last Post
Using Microsoft Money 2006 for Small Business
Merphie: I am looking for software to run my business finances and to work with my acountant for tax time. How does Money compare to something like Quick...
Microsoft Money 3 11-04-2005 06:11 AM
Microsoft Money 2004 Small Business
John: Can you print out 1099 forms for vendors with Microsoft Money 2004 Small Business and am i able to keep track or customer sales and appointments. I...
Microsoft Money 3 02-12-2004 07:16 PM
Which to buy ... Premium or Small Business
Charles L. Simpson: I currently have Microsoft Money Deluxe Business 2003 which I have two money files. One for my personal finances and another that I use for a...
Microsoft Money 2 07-18-2003 03:47 AM



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 09:21 PM.