Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #11  
Old 10-18-2008, 05:49 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

In microsoft.public.money, jch wrote:

- quote -

> Thanks Cal.
> I just want to make sure we are talking about the same situation. I buy 500
> shares of Investment X at $10 each, but a year later one share is sold as an
> administrative fee. So I own 499 shares,

OK so far...

- quote -

> and my cost basis (the amount I
> paid) is $5000.


I agree you paid $5000. Does the IRS allow you to add that $10 back
onto to your basis for the remaining 499 shares, as you assume, or
does the IRS say that that $10 is a miscellaneous investment
expense? That is *my* question.

I expect you to get a 1099 for selling that $10 share. I expect you
to put an acquisition cost on those share on your schedule D, that
would be reducing your remaining basis.



- quote -

> When I remove the share, I am trying to not reduce the original basis
> ($5000), which I thought was a proper thing to do by tax law. That way, the
> cost basis represents the total amount of money I have contributed for the
> investment. Assuming this is appropriate, is there any combination of
> transactions that can accurately reflect this in MS Money?


That is your question, as I understand it. Money does not support
that in a direct way, as far as I know.


- quote -

> -Chris
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, jch wrote:
> > > > When I enter the Sell transaction, the value of the shares deducted for the
> > > investment fee apparently lowers the Cost basis.
> > > When you sell shares, the basis of the remaining shares is

> > unaffected.
> > > > > I thought the Cost basis
> > > was supposed to be the total amount paid for the investment, including
> > > commissions and fees. How do I remove the shares without lowering the Cost
> > > basis?
> > > If you remove the shares, what are you trying to not reduce the

> > basis of?
> > > I think you are trying to add the original basis of the shares that

> > were sold to the unsold shares. I would be interested in a reference
> > that says that is a proper thing to do by tax law. I am not saying
> > it is not permitted and appropriate. I actually would like to know
> > that is the right thing to do. I seem to remember reading something
> > along those lines, but I could not find it when I searched.
> > > If it is appropriate, it would be nice if Money would increase the

> > basis of the associated shares with an OtherExpense transactions. It
> > doesn't.
> > > > > T
> > > > > > > "Cal Learner-- MVP" wrote:
> > > > > > In microsoft.public.money, wchp wrote:
> > > > > > > > My funds are set up to auto re-invest all dividends, L, M, and S term cap
> > > > > gains and all fees are to be paid from the respective fund/account.
> > > > > This is listed as a negative transaction on the statements and reflects a
> > > > > negative adjustment to my share holdings.
> > > > > NOW how the heck do I enter a negative share transaction??
> > > > > Money will not let me.
> > > > > I dont want to "sell" them and transfer the money to an account as there is
> > > > > not an account and it is always 0$
> > > > > > > Do a Sell of the number of shares deducted for the investment fee.
> > > > Do another transaction. If the expense is associated with a single
> > > > fund, you can do an OtherExpense transaction in the Investment
> > > > Transactions register.
> > > > > > > Alternatively, do an expense transaction from the account that the
> > > > money goes to when you do a Sell.
> > > > > > > > > > > I am not able to find this in help, manual, google or here in the forums.
> > > > > Any thoughts would be helpful
> > > > > > >
  #10  
Old 10-18-2008, 05:15 PM
jch
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

Thanks Cal.

I just want to make sure we are talking about the same situation. I buy 500
shares of Investment X at $10 each, but a year later one share is sold as an
administrative fee. So I own 499 shares, and my cost basis (the amount I
paid) is $5000.

When I remove the share, I am trying to not reduce the original basis
($5000), which I thought was a proper thing to do by tax law. That way, the
cost basis represents the total amount of money I have contributed for the
investment. Assuming this is appropriate, is there any combination of
transactions that can accurately reflect this in MS Money?

-Chris

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, jch wrote:
> > When I enter the Sell transaction, the value of the shares deducted for the
> > investment fee apparently lowers the Cost basis.

> When you sell shares, the basis of the remaining shares is
> unaffected.
> > I thought the Cost basis
> > was supposed to be the total amount paid for the investment, including
> > commissions and fees. How do I remove the shares without lowering the Cost
> > basis?

> If you remove the shares, what are you trying to not reduce the
> basis of?
> I think you are trying to add the original basis of the shares that
> were sold to the unsold shares. I would be interested in a reference
> that says that is a proper thing to do by tax law. I am not saying
> it is not permitted and appropriate. I actually would like to know
> that is the right thing to do. I seem to remember reading something
> along those lines, but I could not find it when I searched.
> If it is appropriate, it would be nice if Money would increase the
> basis of the associated shares with an OtherExpense transactions. It
> doesn't.
> T
> > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, wchp wrote:
> > > > > > My funds are set up to auto re-invest all dividends, L, M, and S term cap
> > > > gains and all fees are to be paid from the respective fund/account.
> > > > This is listed as a negative transaction on the statements and reflects a
> > > > negative adjustment to my share holdings.
> > > > NOW how the heck do I enter a negative share transaction??
> > > > Money will not let me.
> > > > I dont want to "sell" them and transfer the money to an account as there is
> > > > not an account and it is always 0$
> > > > > Do a Sell of the number of shares deducted for the investment fee.
> > > Do another transaction. If the expense is associated with a single
> > > fund, you can do an OtherExpense transaction in the Investment
> > > Transactions register.
> > > > > Alternatively, do an expense transaction from the account that the
> > > money goes to when you do a Sell.
> > > > > > > > I am not able to find this in help, manual, google or here in the forums.
> > > > Any thoughts would be helpful
> > > >
  #9  
Old 10-16-2008, 04:58 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

In microsoft.public.money, jch wrote:

- quote -

> When I enter the Sell transaction, the value of the shares deducted for the
> investment fee apparently lowers the Cost basis.


When you sell shares, the basis of the remaining shares is
unaffected.


- quote -

> I thought the Cost basis
> was supposed to be the total amount paid for the investment, including
> commissions and fees. How do I remove the shares without lowering the Cost
> basis?


If you remove the shares, what are you trying to not reduce the
basis of?

I think you are trying to add the original basis of the shares that
were sold to the unsold shares. I would be interested in a reference
that says that is a proper thing to do by tax law. I am not saying
it is not permitted and appropriate. I actually would like to know
that is the right thing to do. I seem to remember reading something
along those lines, but I could not find it when I searched.

If it is appropriate, it would be nice if Money would increase the
basis of the associated shares with an OtherExpense transactions. It
doesn't.



T


- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, wchp wrote:
> > > > My funds are set up to auto re-invest all dividends, L, M, and S term cap
> > > gains and all fees are to be paid from the respective fund/account.
> > > This is listed as a negative transaction on the statements and reflects a
> > > negative adjustment to my share holdings.
> > > NOW how the heck do I enter a negative share transaction??
> > > Money will not let me.
> > > I dont want to "sell" them and transfer the money to an account as there is
> > > not an account and it is always 0$
> > > Do a Sell of the number of shares deducted for the investment fee.

> > Do another transaction. If the expense is associated with a single
> > fund, you can do an OtherExpense transaction in the Investment
> > Transactions register.
> > > Alternatively, do an expense transaction from the account that the

> > money goes to when you do a Sell.
> > > > > I am not able to find this in help, manual, google or here in the forums.
> > > Any thoughts would be helpful

> >
  #8  
Old 10-16-2008, 03:23 AM
jch
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

When I enter the Sell transaction, the value of the shares deducted for the
investment fee apparently lowers the Cost basis. I thought the Cost basis
was supposed to be the total amount paid for the investment, including
commissions and fees. How do I remove the shares without lowering the Cost
basis?

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, wchp wrote:
> > My funds are set up to auto re-invest all dividends, L, M, and S term cap
> > gains and all fees are to be paid from the respective fund/account.
> > This is listed as a negative transaction on the statements and reflects a
> > negative adjustment to my share holdings.
> > NOW how the heck do I enter a negative share transaction??
> > Money will not let me.
> > I dont want to "sell" them and transfer the money to an account as there is
> > not an account and it is always 0$

> Do a Sell of the number of shares deducted for the investment fee.
> Do another transaction. If the expense is associated with a single
> fund, you can do an OtherExpense transaction in the Investment
> Transactions register.
> Alternatively, do an expense transaction from the account that the
> money goes to when you do a Sell.
> > I am not able to find this in help, manual, google or here in the forums.
> > Any thoughts would be helpful

  #7  
Old 01-22-2005, 09:33 PM
wchp
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

This:
"Do a Sell of ABCDX for $10 total with no commission.
Do an OtherExpense transaction of ABCDX for $10 total."
Worked just fine.
What was confusing me was how to allocate the $ from the sale. I kept
wanting to do a "transfer to:" a cash account associated with that fund and
then charge the expense back against it with out having to create expense
accounts for each fund.
By just leaving the field blank it would appear that this happens with in
the account anyway.

That being said, your statement of "Perhaps you are suggesting a combination
transaction as ReinvestDividend is equivalent to a Dividend and a Buy."

Is exactly what I am suggesting. I dont care if it records it as two
transactions or accounts it as such, just that the function from a UI
standpoint matches what the fund statements are indicating:
Anual fee $10 -.xxx shares at $xx.xx price and -$10


  #6  
Old 01-14-2005, 03:57 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

In microsoft.public.money, wchp wrote:

- quote -

> I am not sure what you mean by "Do a Sell of the number of shares deducted
> for the investment fee.
> Do another transaction. If the expense is associated with a single fund,
> you can do an OtherExpense transaction in the Investment Transactions
> register."
> Would you be willing to do a how to, step by step?


Do a Sell of ABCDX for $10 total with no commission.

Do an OtherExpense transaction of ABCDX for $10 total.

- quote -

> Fred's responce below would address what I am looking to see, and that is
> the fee cost going against earnings, but this then creates another issue.
> Does the way you are sugesting to do this show up as reduction in earnings
> and propperly account for those fees for IRS purposes?


I this will make the performance analysis of indicate a lower ABCDX
performance than it would have had.

I believe that this will cause your schedule D to show a $10 sell
with an acquisition cost dependent on your basis. I believe that is
what US law calls for. I think that the transaction will be reported
by your mutual fund on 1099-B.


- quote -

> Need to get a sugestion in to the Money folks to add a "Fee" transaction
> type that allows for the entry of negative shares.


I don't know what you are suggesting. Perhaps you are suggesting a
combination transaction as ReinvestDividend is equivalent to a
Dividend and a Buy. I guess that could be useful to have, but I
think that if you download, it would come down as two transactions
anyway. I don't think there is a transaction like that described in
the OFX specifications.

You are indeed doing a sell that should show up on your schedule D
if the account is taxable (and you are in the US). If you are
talking about a tax-deferred account, the same method would be best,
I think. However there there is no tax reporting consequence.


  #5  
Old 01-14-2005, 03:21 PM
wchp
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

Cal,
I am not sure what you mean by "Do a Sell of the number of shares deducted
for the investment fee.
Do another transaction. If the expense is associated with a single fund,
you can do an OtherExpense transaction in the Investment Transactions
register."

Would you be willing to do a how to, step by step?

Fred's responce below would address what I am looking to see, and that is
the fee cost going against earnings, but this then creates another issue.
Does the way you are sugesting to do this show up as reduction in earnings
and propperly account for those fees for IRS purposes?

Need to get a sugestion in to the Money folks to add a "Fee" transaction
type that allows for the entry of negative shares.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, wchp wrote:
> > My funds are set up to auto re-invest all dividends, L, M, and S term cap
> > gains and all fees are to be paid from the respective fund/account.
> > This is listed as a negative transaction on the statements and reflects a
> > negative adjustment to my share holdings.
> > NOW how the heck do I enter a negative share transaction??
> > Money will not let me.
> > I dont want to "sell" them and transfer the money to an account as there is
> > not an account and it is always 0$

> Do a Sell of the number of shares deducted for the investment fee.
> Do another transaction. If the expense is associated with a single
> fund, you can do an OtherExpense transaction in the Investment
> Transactions register.
> Alternatively, do an expense transaction from the account that the
> money goes to when you do a Sell.
> > I am not able to find this in help, manual, google or here in the forums.
> > Any thoughts would be helpful

  #4  
Old 01-14-2005, 03:18 AM
Fred Todt at RoadRunner
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

Thanks for the tip and the link, Cal. I'd better clean up my handling of
fees. Hmmm, I hope the I*R*S auditors aren't monitoring this thread. ;-)

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

> In microsoft.public.money, "Fred Todt" <ftodt AT yahoo DOT com> wrote:
> > Here's how I do it with Money 2003 Deluxe:
> > > Enter a sell transaction, and put the $ amt of the sale in the Commission

> > field, leaving the Total field blank, so the net $ effect of the

transaction
> > is $0.
> > > Is this bad accounting practice? Will it come back to haunt me when I

try
> > to sell shares and/or compute capital gains? Does it mess up investment
> > performance calculations?

> It is not according to law in the US. In the US, the sale should be
> reported as a sale. The fee should be a miscellaneous deduction and
> therefore subject to a 2% threshold, and even then, only usable if
> you itemize.
> http://www.irs.gov/publications/p529/ar02.html#d0e1501
> Doesn't seem fair, does it?



  #3  
Old 01-13-2005, 07:22 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

In microsoft.public.money, "Fred Todt" <ftodt AT yahoo DOT comwrote:

- quote -

> Here's how I do it with Money 2003 Deluxe:
> Enter a sell transaction, and put the $ amt of the sale in the Commission
> field, leaving the Total field blank, so the net $ effect of the transaction
> is $0.
> Is this bad accounting practice? Will it come back to haunt me when I try
> to sell shares and/or compute capital gains? Does it mess up investment
> performance calculations?


It is not according to law in the US. In the US, the sale should be
reported as a sale. The fee should be a miscellaneous deduction and
therefore subject to a 2% threshold, and even then, only usable if
you itemize.

http://www.irs.gov/publications/p529/ar02.html#d0e1501

Doesn't seem fair, does it?


  #2  
Old 01-13-2005, 06:38 PM
Fred Todt
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

Here's how I do it with Money 2003 Deluxe:

Enter a sell transaction, and put the $ amt of the sale in the Commission
field, leaving the Total field blank, so the net $ effect of the transaction
is $0.

Is this bad accounting practice? Will it come back to haunt me when I try
to sell shares and/or compute capital gains? Does it mess up investment
performance calculations?

TIA,
Fred

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

> In microsoft.public.money, wchp wrote:
> > My funds are set up to auto re-invest all dividends, L, M, and S term cap
> > gains and all fees are to be paid from the respective fund/account.
> > This is listed as a negative transaction on the statements and reflects a
> > negative adjustment to my share holdings.
> > NOW how the heck do I enter a negative share transaction??
> > Money will not let me.
> > I dont want to "sell" them and transfer the money to an account as there

is
> > not an account and it is always 0$

> Do a Sell of the number of shares deducted for the investment fee.
> Do another transaction. If the expense is associated with a single
> fund, you can do an OtherExpense transaction in the Investment
> Transactions register.
> Alternatively, do an expense transaction from the account that the
> money goes to when you do a Sell.
> > I am not able to find this in help, manual, google or here in the forums.
> > Any thoughts would be helpful



  #1  
Old 01-12-2005, 02:52 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

In microsoft.public.money, wchp wrote:

- quote -

> My funds are set up to auto re-invest all dividends, L, M, and S term cap
> gains and all fees are to be paid from the respective fund/account.
> This is listed as a negative transaction on the statements and reflects a
> negative adjustment to my share holdings.
> NOW how the heck do I enter a negative share transaction??
> Money will not let me.
> I dont want to "sell" them and transfer the money to an account as there is
> not an account and it is always 0$


Do a Sell of the number of shares deducted for the investment fee.
Do another transaction. If the expense is associated with a single
fund, you can do an OtherExpense transaction in the Investment
Transactions register.

Alternatively, do an expense transaction from the account that the
money goes to when you do a Sell.


- quote -

> I am not able to find this in help, manual, google or here in the forums.
> Any thoughts would be helpful


 
Old 01-12-2005, 02:51 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Anual Fund Fee's as a negative share transaction?

In microsoft.public.money, wchp wrote:

- quote -

> My funds are set up to auto re-invest all dividends, L, M, and S term cap
> gains and all fees are to be paid from the respective fund/account.
> This is listed as a negative transaction on the statements and reflects a
> negative adjustment to my share holdings.
> NOW how the heck do I enter a negative share transaction??
> Money will not let me.
> I dont want to "sell" them and transfer the money to an account as there is
> not an account and it is always 0$


Do a Sell of the number of shares deducted for the investment fee.
Do another transaction. If the expense is associated with a single
fund, you can do an OtherExpense transaction in the Investment
Transactions register.

Alternatively, do an expense transaction from the account that the
money goes to when you do a Sell.


- quote -

> I am not able to find this in help, manual, google or here in the forums.
> Any thoughts would be helpful


  #-1  
Old 01-12-2005, 02:23 AM
wchp
Guest
 
Posts: n/a
Default Entering Anual Fund Fee's as a negative share transaction?

My funds are set up to auto re-invest all dividends, L, M, and S term cap
gains and all fees are to be paid from the respective fund/account.
This is listed as a negative transaction on the statements and reflects a
negative adjustment to my share holdings.
NOW how the heck do I enter a negative share transaction??
Money will not let me.
I dont want to "sell" them and transfer the money to an account as there is
not an account and it is always 0$
I am not able to find this in help, manual, google or here in the forums.
Any thoughts would be helpful
 

Tags
anual, entering, fee, fund, negative, share, transaction
Similar Threads
Thread Forum Replies Last Post
Money 2002 - recording a 1 for 5 share transaction
nyalabead: Hi there, I'm running Money 2002 and am trying to record a 1 for 5 share transaction - can anyone please help?
Microsoft Money 1 12-22-2004 09:42 AM
Sound when entering transaction into account
Norm: I just upgraded to Money 2004 from Money V5. Is it possible to change the lame "ding" sound when entering a transaction to the satisfying...
Microsoft Money 10 06-24-2004 04:27 AM
How to enter a demerger share transaction in Money 2003
Cara: Hi, I would like to know how to enter a demerger share transaction in Money 2003 standard. Thank you very much!
Microsoft Money 1 04-02-2004 02:54 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 05:47 AM.