Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #13  
Old 03-14-2005, 06:13 AM
csmba
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

whoops, that was the small pic.. here is the big version:
http://imagevenue.com/img.php?loc=lo...66_MSMoney.JPG

"csmba" <csmba[at]NOWHERE.com> wrote in message
news:XMaZd.21532$OU1.19920[at]newssvr21.news.prodigy.com...
- quote -

> > I forget if we covered this, but make sure Help-> About lists version
> > 14.0.*.1105.

> 14.0.125.1105.
> > I check my reports"-> "tax related transactions-> customize-> Accounts
> > and see two entries for each investment account. However one has the
> > regular account name, and the other has about the first 15 or 16
> > characters of the account name and either (Cash) or (Contributions)
> > at the end. It would appear that yours does not do that, and I don't
> > know why.

> no they don't. here is a screen shoot:
> http://imagevenue.com/loc132/th_c66_MSMoney.JPG
> thanks for the help, I guess I am stuck with this double entery. whcih I
> still don't understand why is needed from the first place.



  #12  
Old 03-14-2005, 06:09 AM
csmba
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

- quote -

> I forget if we covered this, but make sure Help-> About lists version
> 14.0.*.1105.

14.0.125.1105.

- quote -

> I check my reports"-> "tax related transactions-> customize-> Accounts
> and see two entries for each investment account. However one has the
> regular account name, and the other has about the first 15 or 16
> characters of the account name and either (Cash) or (Contributions)
> at the end. It would appear that yours does not do that, and I don't
> know why.

no they don't. here is a screen shoot:
http://imagevenue.com/loc132/th_c66_MSMoney.JPG

thanks for the help, I guess I am stuck with this double entery. whcih I
still don't understand why is needed from the first place.


  #11  
Old 03-08-2005, 03:25 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

In microsoft.public.money, csmba_groups wrote:

- quote -

> **on the account list, each account appears once.
> **in account register, I see 2, as you say, one is "cash transactions"
> and on is "investment tran'". [however, I still fail to understand the
> sense behind these 2 accounts. all they do is double entry for each
> transaction (transfer from/transfer to]
> so until now it is all "fine" (fine because it is by design, not
> because it makes sense to me (-: ). however, there is still a problem:
> if I go to "reports"-> "tax related transactions-> customize-> select the
> "account" tab: in the list, I see every such investment account (ETrade
> reg, ETrade IRA...) twice. and with the exact same label. not "ETrade
> Sec Inv" and "Etrade Sec Cash" or something like that. just "Etrade
> Sec", twice, and "Etrade IRA" twice. what is the sense of that? first,
> even if it makes sense to run a report only on one "half" of the
> account (only inv or only cash) then there is no way to tell which is
> which. second, there is no sense in running the report only on one of
> the "half" accounts.


I check my reports"-> "tax related transactions-> customize-> Accounts
and see two entries for each investment account. However one has the
regular account name, and the other has about the first 15 or 16
characters of the account name and either (Cash) or (Contributions)
at the end. It would appear that yours does not do that, and I don't
know why.

You might try File-> RepairMoneyFile-> QuickFileRepair. I don't see
that probably making a difference, but it is worth a try.

In my case the accounts do not all have cash/contributions first or
last; it depends on the alphabetization order after the (Cash) or
(Contributions) has been added.

- quote -

> this "double" problem may exist in other lists, but for now I found it
> on the reports-> customization-> selection of which accounts to include.
> is this symptom makes sense to you?


I forget if we covered this, but make sure Help-> About lists version
14.0.*.1105.

  #10  
Old 03-04-2005, 06:10 AM
csmba_groups
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

**on the account list, each account appears once.
**in account register, I see 2, as you say, one is "cash transactions"
and on is "investment tran'". [however, I still fail to understand the
sense behind these 2 accounts. all they do is double entry for each
transaction (transfer from/transfer to]

so until now it is all "fine" (fine because it is by design, not
because it makes sense to me (-: ). however, there is still a problem:
if I go to "reports"-> "tax related transactions-> customize-> select the
"account" tab: in the list, I see every such investment account (ETrade
reg, ETrade IRA...) twice. and with the exact same label. not "ETrade
Sec Inv" and "Etrade Sec Cash" or something like that. just "Etrade
Sec", twice, and "Etrade IRA" twice. what is the sense of that? first,
even if it makes sense to run a report only on one "half" of the
account (only inv or only cash) then there is no way to tell which is
which. second, there is no sense in running the report only on one of
the "half" accounts.

this "double" problem may exist in other lists, but for now I found it
on the reports-> customization-> selection of which accounts to include.
is this symptom makes sense to you?

  #9  
Old 03-03-2005, 06:04 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

I wish Money handled it better also. For what it's worth, last time I
looked, Quicken had the same problem.

--
Michael Gordon
MVP


<h.guelman[at]gmail.com> wrote in message
news:1109709265.799685.130530[at]z14g2000cwz.googlegroups.com...
- quote -

> thanks. while I fail to understand why MS makes interest and dividend
> behave differently (as far as I understand it, it is either tax exempt
> or not), your answer at least explains this behavior well. thanks.
> do you have a comment on my second problem? I fail to understand why
> all my ETrade transactions are kind of a transfer to and transfer from
> 2 different ETrade accounts. well, maybe the word is not accounts,
> there are 2 register views. that is not really a problem, it only
> bothers me because in many comboBoxes such as when selecting accounts
> for reports I see two of everything... which really I should be seeing
> one ETrade account, not 2 (2 IRA-ETrade, 2 regular ETRade etc.
> regards.



  #8  
Old 03-01-2005, 08:19 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

In microsoft.public.money, csmba wrote:

- quote -

> do you have a comment on my second problem? I fail to understand why
> all my ETrade transactions are kind of a transfer to and transfer from
> 2 different ETrade accounts. well, maybe the word is not accounts,
> there are 2 register views.


Let's figure out what is happening. On the Account List, do you see
2 IRA-ETrade and 2 regular ETrade, or just one each?

- quote -

> that is not really a problem, it only
> bothers me because in many comboBoxes such as when selecting accounts
> for reports I see two of everything... which really I should be seeing
> one ETrade account, not 2 (2 IRA-ETrade, 2 regular ETRade etc.


If just one each in the Account List, it is normal to have an
Investment Transactions register and a Cash Transactions register
for an investment account. It is possible to not have that cash
transactions register, but I would not recommend that choice.

  #7  
Old 03-01-2005, 07:57 PM
csmba
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

thanks. while I fail to understand why MS makes interest and dividend
behave differently (as far as I understand it, it is either tax exempt
or not), your answer at least explains this behavior well. thanks.

do you have a comment on my second problem? I fail to understand why
all my ETrade transactions are kind of a transfer to and transfer from
2 different ETrade accounts. well, maybe the word is not accounts,
there are 2 register views. that is not really a problem, it only
bothers me because in many comboBoxes such as when selecting accounts
for reports I see two of everything... which really I should be seeing
one ETrade account, not 2 (2 IRA-ETrade, 2 regular ETRade etc.

regards.


  #6  
Old 03-01-2005, 07:34 PM
h.guelman@gmail.com
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

thanks. while I fail to understand why MS makes interest and dividend
behave differently (as far as I understand it, it is either tax exempt
or not), your answer at least explains this behavior well. thanks.

do you have a comment on my second problem? I fail to understand why
all my ETrade transactions are kind of a transfer to and transfer from
2 different ETrade accounts. well, maybe the word is not accounts,
there are 2 register views. that is not really a problem, it only
bothers me because in many comboBoxes such as when selecting accounts
for reports I see two of everything... which really I should be seeing
one ETrade account, not 2 (2 IRA-ETrade, 2 regular ETRade etc.

regards.

  #5  
Old 02-20-2005, 04:35 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

The problem is that closed-end mutual funds (which many bond funds are) are
really stocks (they're listed as such on the NYSE and AMEX). Therefore
brokers, when they download data on them, identify them as stocks.
Therefore, their earnings come through to Money as dividends, not interest.
And Money can't handle tax-exempt dividends (last I looked, neither could
Quicken and, to go back many years, neither did Managing Your Money). You
noticed that there's no item for dividends, tax-exempt as there is for
interest. Therefore, Money ignores the fact that you've marked the security
as tax-exempt. The only way I can think of to deal with this is to change
the category of the tranasaction to Other Income; you can then specify
Investment Income: Tax-Exempt Interest.

--
Michael Gordon
MVP


"csmba" <csmba[at]discussions.microsoft.com> wrote in message
news:6BB8A264-BA8E-417A-80DC-F0C36CCABD5B[at]microsoft.com...
- quote -

> > I think that the proceeds from the tax-exempt bond should be
> > Interest rather than Dividends.

> Well, I use auto-sync with ETrade, and that is how it records it. it is
> strange to me that I have this problem. am I the only person using money
> 2005
> with Etrade and happens to have a tax exempt bond fund?



  #4  
Old 02-15-2005, 05:37 PM
csmba
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

- quote -

> What I am guessing is that the "sink" should be the Etrade Cash
> Transactions account. In the Etrade Investment account, is "Track
> cash transactions" checked? If not, I would check that. I am not
> sure what your next steps would be. Removing the "sink" from online
> download would seem to be part of it.

well, on my online settings there is only one account "etrade" to set. I
don't really understand how MSMoney allows this 2 accoutns with the same name
anyway. and they are not behaving like 2 seperate accounts... sometimes I see
only one etrade, and in other palces two (such as comboboxes, and the fact
that one has a trasfer to the other). I also see 2 accounts when I customize
reports (selecting which accounts to include, I see double etrade)...

there is no MS person that has a clue how to solve this and why it happened?
I did not have this problem on MS 2004. I did have one problem of seeing
double accounts for my IRA-etrade, and I did "merge" which is a feature in
Money and it seemed to solve it. but now I have this double accounts....
  #3  
Old 02-15-2005, 05:33 PM
csmba
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

- quote -

> What I am guessing is that the "sink" should be the Etrade Cash
> Transactions account. In the Etrade Investment account, is "Track
> cash transactions" checked? If not, I would check that. I am not
> sure what your next steps would be. Removing the "sink" from online
> download would seem to be part of it.


well, when I come to set up online download settings, there is only ONE
Etrade account... I think my track cash transactions is checked... (will
repost if not)
  #2  
Old 02-15-2005, 05:27 PM
csmba
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

- quote -

> I think that the proceeds from the tax-exempt bond should be
> Interest rather than Dividends.

Well, I use auto-sync with ETrade, and that is how it records it. it is
strange to me that I have this problem. am I the only person using money 2005
with Etrade and happens to have a tax exempt bond fund?
  #1  
Old 02-15-2005, 03:36 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

In microsoft.public.money, csmba wrote:

- quote -

> 1) TAX: the capital gains report works fine. but then I wanted to see that
> my 1099 makes sense for the dividends... so I used the tax related
> transactions report to see all the dividends... well, first I saw NO dividend
> from my bond founds (or any other investment). I did see the
> dividends/interest from categories such as "Div Income" and "interest Inc".
> after about 30 minuts, I found that in the settings-> tax settings-> associate
> money categories with tax form lines I can force the category "investment
> income/dividends" to be marked as "include on tax reports" and I even matched
> it with a tax form and form line. I have no idea why this is not like that by
> defualt (maybe because I swithced from quicken 3 years ago?).
> after doing that, I can now see al the dividends from my bond found in the
> tax related reports. was that the right thing to do? in any case, the problem
> I have is that I have 2 different bond funds. one is normal and one is NOT
> TAXABLE (no federal and no state). I DID mark it as tax exempt (in the
> details page of teh fund) but it did nothing.
> how do I make the dividends of this fund not show on the tax related
> transactions?


I think that the proceeds from the tax-exempt bond should be
Interest rather than Dividends.


 
Old 02-15-2005, 03:35 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: tax exempt and double accounts problem

In microsoft.public.money, csmba wrote:

- quote -

> I used money 2004, and when oving now to 2005 I suddenly have my ETrade
> account (investment) shwo twice. the strange thing is that one account seems
> to be the master, and the other one is the "sink". all transactions in master
> are actually a transfer to or from the "sink". I saw no other problem with
> that (online sync works fine, reports are consistent etc'). the only symptom
> is really that I see "etrade" twice on all the combo boxes that I can select
> acocunts. and that the transactions (buy/sell/div) show as transfer to or
> from the other etrade account. any ideas what is going on?


What I am guessing is that the "sink" should be the Etrade Cash
Transactions account. In the Etrade Investment account, is "Track
cash transactions" checked? If not, I would check that. I am not
sure what your next steps would be. Removing the "sink" from online
download would seem to be part of it.



  #-1  
Old 02-15-2005, 07:49 AM
csmba
Guest
 
Posts: n/a
Default tax exempt and double accounts problem

hi. 2 different and unrelated questions...

1) TAX: the capital gains report works fine. but then I wanted to see that
my 1099 makes sense for the dividends... so I used the tax related
transactions report to see all the dividends... well, first I saw NO dividend
from my bond founds (or any other investment). I did see the
dividends/interest from categories such as "Div Income" and "interest Inc".
after about 30 minuts, I found that in the settings-> tax settings-> associate
money categories with tax form lines I can force the category "investment
income/dividends" to be marked as "include on tax reports" and I even matched
it with a tax form and form line. I have no idea why this is not like that by
defualt (maybe because I swithced from quicken 3 years ago?).

after doing that, I can now see al the dividends from my bond found in the
tax related reports. was that the right thing to do? in any case, the problem
I have is that I have 2 different bond funds. one is normal and one is NOT
TAXABLE (no federal and no state). I DID mark it as tax exempt (in the
details page of teh fund) but it did nothing.

how do I make the dividends of this fund not show on the tax related
transactions?

2) I used money 2004, and when oving now to 2005 I suddenly have my ETrade
account (investment) shwo twice. the strange thing is that one account seems
to be the master, and the other one is the "sink". all transactions in master
are actually a transfer to or from the "sink". I saw no other problem with
that (online sync works fine, reports are consistent etc'). the only symptom
is really that I see "etrade" twice on all the combo boxes that I can select
acocunts. and that the transactions (buy/sell/div) show as transfer to or
from the other etrade account. any ideas what is going on?

regards.
 

Tags
accounts, double, exempt, problem, tax
Similar Threads
Thread Forum Replies Last Post
Problem with Credit Card Accounts
Chad: See if anybody can get this one solved. I have a couple of credit card accounts entered into my debt planner. The planner accurately forecasts...
Microsoft Money 4 03-03-2004 02:24 PM
downloads and double double entries
Steve in Vancouver: I have a problem -- and I am the first to admit it may be with my concept or use of Money 2003. I am no accountant. Please bear with me when I...
Microsoft Money 2 12-16-2003 03:22 AM
Double Entry Problem w/ invoice and bank download
TechStudios7.com: I have an invoice that I receive payment for and automatically register it in my bank account. Then I log into my bank account after I deposit the...
Microsoft Money 1 09-11-2003 05:49 PM
Problem with Asset Accounts
Dale Holden: Hi I have created several asset accounts for different properties I own.I have also assigned which ever mortgage applies to each one. My question...
Microsoft Money 6 09-01-2003 01:19 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:13 AM.