Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #12  
Old 09-24-2006, 01:17 PM
sara
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

salam mamnon

--
دنستدارشكا
شمفا
"Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
news:Os8rGiF2GHA.1040[at]TK2MSFTNGP06.phx.gbl...
- quote -

> I'm pretty sure that I've been able to do something like splitting a
> transfer. Can't get to my data now, but I know I entered a split, in

which
> one of the transactions was a split. Money complained that the total of

the
> splits didn't match the transaction amount, but I ignored the complaint.

Not
> sure this is what you're looking for.
> --
> Michael Gordon
> MVP
> "Marilyn & Bob" <Privacy[at]nospam.please> wrote in message
> news:ewPfHpC2GHA.3588[at]TK2MSFTNGP06.phx.gbl...
> > Money 2006, Standard-- Advanced registers. Here's the scenario. I

owned
> > shares in Credit Suisse New York Municipal Bond Fund which has decided

to
> > go out of business and liquidate in October. So I closed my account,
> > making an ACH transfer to my Chase checking account, where I parked the
> > proceeds. There was one ACH transfer, say for $15,100.00, but there were
> > actually two transactions, a sale of all my shares for $15,000 and a
> > (tax-exempt) dividend payment of $100. I entered these as Sell and
> > Dividend transfers to my checking account. They showed up correctly in
> > both the Chase and CS registers. So far, so good.
> > > But then I downloaded my Chase data into Money and Money insisted on

> > matching the ACH amount of $15,100 to my $15,000 transfer and made the
> > number $15,100, while leaving the $100 transfer. It wouldn't let me
> > change it in my Checking Account, and if I tried to change the Total it

in
> > my Investment account to $15,000, it insisted on changing the Total back
> > to $15,100 and putting in $100 as Commission.
> > > Since the $15,000 and the $100 are totally different types of

transactions
> > for tax purposes, I need to keep them separate. I finally ended up by
> > deleting the contents of the Transfer To: line in the Credit Suisse
> > actions which removed the two items from the Chase Register and then
> > downloading the Chase info again. This left me with a correct set of
> > entries for the Credit Suisse account and a whopping $15,100 *income*
> > entry, which I split categorized under my new Income categories called
> > Xfer from Investment: Sell, and Xfer from Investment: Dividend-Tax
> > Exempt. Categorizing the transactions as income is wrong, but I don't
> > have any better ideas. Is there a better way?
> > --
> > Peace,
> > BobJ

>

  #11  
Old 09-15-2006, 11:58 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

As I said, I wasn't clear, I was writing about a different situation.

--
Michael Gordon
MVP


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:ud51GoR2GHA.3656[at]TK2MSFTNGP04.phx.gbl...
- quote -

> This case was looking for both a Sell and a Dividend as Transfers in a
> Split to one account. I don't know of a way to have two investment
> transactions (besides Buy Investment/CD) as the opposite sides of a single
> split. I thought you were suggesting there was a way.
> "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
> news:uImEyJQ2GHA.4588[at]TK2MSFTNGP04.phx.gbl...
> > I misspoke -- I meant to say I entered a split, in which one of the
> > transactions was a transfer (not a split). These were in situations where
> > a transfer was also a taxable event, so I needed to show both. Still want
> > more info?



  #10  
Old 09-15-2006, 10:55 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

This case was looking for both a Sell and a Dividend as Transfers in a Split
to one account. I don't know of a way to have two investment transactions
(besides Buy Investment/CD) as the opposite sides of a single split. I
thought you were suggesting there was a way.

"Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
news:uImEyJQ2GHA.4588[at]TK2MSFTNGP04.phx.gbl...
- quote -

> I misspoke -- I meant to say I entered a split, in which one of the
> transactions was a transfer (not a split). These were in situations where a
> transfer was also a taxable event, so I needed to show both. Still want
> more info?



  #9  
Old 09-15-2006, 08:06 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

I misspoke -- I meant to say I entered a split, in which one of the
transactions was a transfer (not a split). These were in situations where a
transfer was also a taxable event, so I needed to show both. Still want more
info?

--
Michael Gordon
MVP


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:u47hjlF2GHA.4932[at]TK2MSFTNGP02.phx.gbl...
- quote -

> I'd be curious how you did that as well.
> "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
> news:Os8rGiF2GHA.1040[at]TK2MSFTNGP06.phx.gbl...
> > I'm pretty sure that I've been able to do something like splitting a
> > transfer. Can't get to my data now, but I know I entered a split, in
> > which one of the transactions was a split. Money complained that the
> > total of the splits didn't match the transaction amount, but I ignored
> > the complaint. Not sure this is what you're looking for.



  #8  
Old 09-15-2006, 02:10 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

Yes, thanks for the suggestion. After mulling over the other possibilites,
this is what I eventually decided to do. It worked perfectly.
--
Peace,
BobJ

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

> In microsoft.public.money, Marilyn & Bob wrote:
> > There is no cash account as the fund was set up to reinvest dividends and
> > LT
> > and ST Capital gains so there was never any cash (until now).

> You can create one easily if it bothers you to have two separate
> transactions entered into the bank account.



  #7  
Old 09-15-2006, 02:08 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:O7lwBPE2GHA.328[at]TK2MSFTNGP06.phx.gbl...
- quote -

> several comments inline.
> (slightly off topic But I guess I'm confused: you did a Sell. The Sell
> was at some market quoted NAV for the shares, no? That NAV would have
> included your shares share of undistributed dividend or been ExDiv, no? Is
> there some special provision in this case--of the fund terminating--to
> give you the undistributed dividend in some non capital gain (i.e., not in
> an elevated per share NAV) form with some invented--not quoted--NAV? I've
> never had a similar case. I'm curious.

Yes I guess this was a special case. Note also that, upon announcing the
liquidation, CS indicated that they would not allow new purchases of shares
after August 31. They probably decided at the time they made that rule to
also separately set aside the unpaid dividends instead of adding them into
the shares. Since the dividends are tax-exempt, this benefits the
shareowners as it decreases the capital gains (or increases the capital
loss). I guess the IRS allows it for a terminating fund that does not have
a successor fund.
--
Peace,
BobJ



  #6  
Old 09-15-2006, 12:16 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

In microsoft.public.money, Marilyn & Bob wrote:

- quote -

> There is no cash account as the fund was set up to reinvest dividends and LT
> and ST Capital gains so there was never any cash (until now).


You can create one easily if it bothers you to have two separate
transactions entered into the bank account.

  #5  
Old 09-14-2006, 11:56 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

I'd be curious how you did that as well.

"Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
news:Os8rGiF2GHA.1040[at]TK2MSFTNGP06.phx.gbl...
- quote -

> I'm pretty sure that I've been able to do something like splitting a
> transfer. Can't get to my data now, but I know I entered a split, in
> which one of the transactions was a split. Money complained that the total
> of the splits didn't match the transaction amount, but I ignored the
> complaint. Not sure this is what you're looking for.



  #4  
Old 09-14-2006, 11:50 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

I'm pretty sure that I've been able to do something like splitting a
transfer. Can't get to my data now, but I know I entered a split, in which
one of the transactions was a split. Money complained that the total of the
splits didn't match the transaction amount, but I ignored the complaint. Not
sure this is what you're looking for.

--
Michael Gordon
MVP


"Marilyn & Bob" <Privacy[at]nospam.please> wrote in message
news:ewPfHpC2GHA.3588[at]TK2MSFTNGP06.phx.gbl...
- quote -

> Money 2006, Standard-- Advanced registers. Here's the scenario. I owned
> shares in Credit Suisse New York Municipal Bond Fund which has decided to
> go out of business and liquidate in October. So I closed my account,
> making an ACH transfer to my Chase checking account, where I parked the
> proceeds. There was one ACH transfer, say for $15,100.00, but there were
> actually two transactions, a sale of all my shares for $15,000 and a
> (tax-exempt) dividend payment of $100. I entered these as Sell and
> Dividend transfers to my checking account. They showed up correctly in
> both the Chase and CS registers. So far, so good.
> But then I downloaded my Chase data into Money and Money insisted on
> matching the ACH amount of $15,100 to my $15,000 transfer and made the
> number $15,100, while leaving the $100 transfer. It wouldn't let me
> change it in my Checking Account, and if I tried to change the Total it in
> my Investment account to $15,000, it insisted on changing the Total back
> to $15,100 and putting in $100 as Commission.
> Since the $15,000 and the $100 are totally different types of transactions
> for tax purposes, I need to keep them separate. I finally ended up by
> deleting the contents of the Transfer To: line in the Credit Suisse
> actions which removed the two items from the Chase Register and then
> downloading the Chase info again. This left me with a correct set of
> entries for the Credit Suisse account and a whopping $15,100 *income*
> entry, which I split categorized under my new Income categories called
> Xfer from Investment: Sell, and Xfer from Investment: Dividend-Tax
> Exempt. Categorizing the transactions as income is wrong, but I don't
> have any better ideas. Is there a better way?
> --
> Peace,
> BobJ



  #3  
Old 09-14-2006, 09:21 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

several comments inline.

"Marilyn & Bob" <Privacy[at]nospam.please> wrote in message
news:ukDhs1D2GHA.4796[at]TK2MSFTNGP06.phx.gbl...
- quote -

> There is no cash account as the fund was set up to reinvest dividends and
> LT and ST Capital gains so there was never any cash (until now). Dick,
> I'm still trying to mull the Reinvest Dividends idea in my head. It would
> have its own unwanted side effect of changing the number of shares sold
> (after the imaginary buy of shares of the imaginary Reinvest).


True.

(slightly off topic But I guess I'm confused: you did a Sell. The Sell was
at some market quoted NAV for the shares, no? That NAV would have included
your shares share of undistributed dividend or been ExDiv, no? Is there some
special provision in this case--of the fund terminating--to give you the
undistributed dividend in some non capital gain (i.e., not in an elevated
per share NAV) form with some invented--not quoted--NAV? I've never had a
similar case. I'm curious.

- quote -

> This means that what I have in Money would not match my paper statement,
> and worse, not match the 1099B that goes to the IRS.


Well, since the Money data is not going to the IRS, the only significant
issue is any Money-> tax software transport of the data. I'd put in a memo in
the Reinvest and/or the Sell that the number of shares sold in Money is off
relative to the statements/confirms/1099s because of this reason. Without an
ICA, I can't think of another choice that will meet your desire to have the
transfer line up with the downloaded data on the checking account side.

- quote -

> I just have to think which is the least worse compromise.

Yup.

- quote -

> BTW, while the Dividend is Income in the CS account, it should not be
> income to my checking account.


Income is income. In the case of the Reinvest Div/Sell, a report of
categories by account would put the Income transaction from Reinvest
Dividend in the Investment Account.


  #2  
Old 09-14-2006, 08:36 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

There is no cash account as the fund was set up to reinvest dividends and LT
and ST Capital gains so there was never any cash (until now). Dick, I'm
still trying to mull the Reinvest Dividends idea in my head. It would have
its own unwanted side effect of changing the number of shares sold (after
the imaginary buy of shares of the imaginary Reinvest). This means that
what I have in Money would not match my paper statement, and worse, not
match the 1099B that goes to the IRS. I just have to think which is the
least worse compromise.

BTW, while the Dividend is Income in the CS account, it should not be income
to my checking account.
--
Peace,
BobJ

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uTOpJ0C2GHA.4484[at]TK2MSFTNGP02.phx.gbl...
- quote -

> I'm sure I'm missing something here.
> If there is an Investment Cash Account (hereafter ICA) associated with the
> Investment Account (probably there isn't and that's what I'm missing) then
> why not Sell the $15k into the ICA then add the $100 Dividend from the
> Investment Account to the ICA, then transfer the $15.1k to checking and
> match that?
> Alternately, the no ICA case: enter the Dividend as a Reinvest Dividend of
> the $100 THEN do the $15.1k Sell transfer to Checking so there's a $15.1k
> Transfer to match that way. Since Money will recognize the $100 as
> Dividend, hence the income category associated with Dividend (it IS
> income, even if not taxable), and the tax treatment of the (tax-exempt)
> investment, and no gains on the $100 reinvested since it was promptly sold
> for the exact same $100, all should be good.
> "Marilyn & Bob" <Privacy[at]nospam.please> wrote in message
> news:ewPfHpC2GHA.3588[at]TK2MSFTNGP06.phx.gbl...
> > Money 2006, Standard-- Advanced registers. Here's the scenario. I owned
> > shares in Credit Suisse New York Municipal Bond Fund which has decided to
> > go out of business and liquidate in October. So I closed my account,
> > making an ACH transfer to my Chase checking account, where I parked the
> > proceeds. There was one ACH transfer, say for $15,100.00, but there were
> > actually two transactions, a sale of all my shares for $15,000 and a
> > (tax-exempt) dividend payment of $100. I entered these as Sell and
> > Dividend transfers to my checking account. They showed up correctly in
> > both the Chase and CS registers. So far, so good.
> > > But then I downloaded my Chase data into Money and Money insisted on

> > matching the ACH amount of $15,100 to my $15,000 transfer and made the
> > number $15,100, while leaving the $100 transfer. It wouldn't let me
> > change it in my Checking Account, and if I tried to change the Total it
> > in my Investment account to $15,000, it insisted on changing the Total
> > back to $15,100 and putting in $100 as Commission.
> > > Since the $15,000 and the $100 are totally different types of

> > transactions for tax purposes, I need to keep them separate. I finally
> > ended up by deleting the contents of the Transfer To: line in the Credit
> > Suisse actions which removed the two items from the Chase Register and
> > then downloading the Chase info again. This left me with a correct set
> > of entries for the Credit Suisse account and a whopping $15,100 *income*
> > entry, which I split categorized under my new Income categories called
> > Xfer from Investment: Sell, and Xfer from Investment: Dividend-Tax
> > Exempt. Categorizing the transactions as income is wrong, but I don't
> > have any better ideas. Is there a better way?



  #1  
Old 09-14-2006, 06:47 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

In microsoft.public.money, Marilyn & Bob wrote:

- quote -

> Money 2006, Standard-- Advanced registers. Here's the scenario. I owned
> shares in Credit Suisse New York Municipal Bond Fund which has decided to go
> out of business and liquidate in October. So I closed my account, making an
> ACH transfer to my Chase checking account, where I parked the proceeds.
> There was one ACH transfer, say for $15,100.00, but there were actually two
> transactions, a sale of all my shares for $15,000 and a (tax-exempt)
> dividend payment of $100. I entered these as Sell and Dividend transfers
> to my checking account. They showed up correctly in both the Chase and CS
> registers. So far, so good.
> But then I downloaded my Chase data into Money and Money insisted on
> matching the ACH amount of $15,100 to my $15,000 transfer and made the
> number $15,100, while leaving the $100 transfer. It wouldn't let me change
> it in my Checking Account, and if I tried to change the Total it in my
> Investment account to $15,000, it insisted on changing the Total back to
> $15,100 and putting in $100 as Commission.
> Since the $15,000 and the $100 are totally different types of transactions
> for tax purposes, I need to keep them separate. I finally ended up by
> deleting the contents of the Transfer To: line in the Credit Suisse actions
> which removed the two items from the Chase Register and then downloading the
> Chase info again. This left me with a correct set of entries for the Credit
> Suisse account and a whopping $15,100 *income* entry, which I split
> categorized under my new Income categories called Xfer from Investment:
> Sell, and Xfer from Investment: Dividend-Tax Exempt. Categorizing the
> transactions as income is wrong, but I don't have any better ideas. Is
> there a better way?


If I read correctly, the better way would be to have the $100 in
dividends deposited/transferred into the cash account #1. Then keep
the $15,100 transfer to Chase. I think that corresponds to reality.

 
Old 09-14-2006, 06:38 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Any way to split a transfer?

I'm sure I'm missing something here.

If there is an Investment Cash Account (hereafter ICA) associated with the
Investment Account (probably there isn't and that's what I'm missing) then
why not Sell the $15k into the ICA then add the $100 Dividend from the
Investment Account to the ICA, then transfer the $15.1k to checking and
match that?

Alternately, the no ICA case: enter the Dividend as a Reinvest Dividend of
the $100 THEN do the $15.1k Sell transfer to Checking so there's a $15.1k
Transfer to match that way. Since Money will recognize the $100 as Dividend,
hence the income category associated with Dividend (it IS income, even if
not taxable), and the tax treatment of the (tax-exempt) investment, and no
gains on the $100 reinvested since it was promptly sold for the exact same
$100, all should be good.

"Marilyn & Bob" <Privacy[at]nospam.please> wrote in message
news:ewPfHpC2GHA.3588[at]TK2MSFTNGP06.phx.gbl...
- quote -

> Money 2006, Standard-- Advanced registers. Here's the scenario. I owned
> shares in Credit Suisse New York Municipal Bond Fund which has decided to
> go out of business and liquidate in October. So I closed my account,
> making an ACH transfer to my Chase checking account, where I parked the
> proceeds. There was one ACH transfer, say for $15,100.00, but there were
> actually two transactions, a sale of all my shares for $15,000 and a
> (tax-exempt) dividend payment of $100. I entered these as Sell and
> Dividend transfers to my checking account. They showed up correctly in
> both the Chase and CS registers. So far, so good.
> But then I downloaded my Chase data into Money and Money insisted on
> matching the ACH amount of $15,100 to my $15,000 transfer and made the
> number $15,100, while leaving the $100 transfer. It wouldn't let me
> change it in my Checking Account, and if I tried to change the Total it in
> my Investment account to $15,000, it insisted on changing the Total back
> to $15,100 and putting in $100 as Commission.
> Since the $15,000 and the $100 are totally different types of transactions
> for tax purposes, I need to keep them separate. I finally ended up by
> deleting the contents of the Transfer To: line in the Credit Suisse
> actions which removed the two items from the Chase Register and then
> downloading the Chase info again. This left me with a correct set of
> entries for the Credit Suisse account and a whopping $15,100 *income*
> entry, which I split categorized under my new Income categories called
> Xfer from Investment: Sell, and Xfer from Investment: Dividend-Tax
> Exempt. Categorizing the transactions as income is wrong, but I don't
> have any better ideas. Is there a better way?



  #-1  
Old 09-14-2006, 06:18 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Any way to split a transfer?

Money 2006, Standard-- Advanced registers. Here's the scenario. I owned
shares in Credit Suisse New York Municipal Bond Fund which has decided to go
out of business and liquidate in October. So I closed my account, making an
ACH transfer to my Chase checking account, where I parked the proceeds.
There was one ACH transfer, say for $15,100.00, but there were actually two
transactions, a sale of all my shares for $15,000 and a (tax-exempt)
dividend payment of $100. I entered these as Sell and Dividend transfers
to my checking account. They showed up correctly in both the Chase and CS
registers. So far, so good.

But then I downloaded my Chase data into Money and Money insisted on
matching the ACH amount of $15,100 to my $15,000 transfer and made the
number $15,100, while leaving the $100 transfer. It wouldn't let me change
it in my Checking Account, and if I tried to change the Total it in my
Investment account to $15,000, it insisted on changing the Total back to
$15,100 and putting in $100 as Commission.

Since the $15,000 and the $100 are totally different types of transactions
for tax purposes, I need to keep them separate. I finally ended up by
deleting the contents of the Transfer To: line in the Credit Suisse actions
which removed the two items from the Chase Register and then downloading the
Chase info again. This left me with a correct set of entries for the Credit
Suisse account and a whopping $15,100 *income* entry, which I split
categorized under my new Income categories called Xfer from Investment:
Sell, and Xfer from Investment: Dividend-Tax Exempt. Categorizing the
transactions as income is wrong, but I don't have any better ideas. Is
there a better way?
--
Peace,
BobJ


 

Tags
split, transfer
Similar Threads
Thread Forum Replies Last Post
Split
Dick Jones: My monthly credit card bill expenses need to be split among the different categories of expenses on the card. I no longer can split the expense....
Microsoft Money 1 03-08-2005 03:18 AM
transfer and split?
Tom G: I am trying to a) transfer money from one account to another (from checking to money market), and b) split the transferred sum into 2 or more...
Microsoft Money 3 11-06-2004 05:24 PM
Split a transaction into withdrawal and transfer
NS: Hi I have a transaction for my home payment which consist of mortgage payment (Principle + Interest) and payment to an escrow account for paying...
Microsoft Money 1 10-09-2004 02:44 AM
Split transaction in a TRANSFER
: When using the TRANSFER option from one account to another, I do not find a way to split the transaction to different subaccounts. Am I...
Microsoft Money 1 09-02-2004 05:19 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 06:53 PM.