Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 07-26-2007, 12:02 PM
raschulmanxx@verizon.net
Guest
 
Posts: n/a
Default Re: Changing cost basis of reconciled transactions

Cal and Dick, many thanks for the suggestions, which got me thinking
in a fresh way about workarounds. As your posts taken together
suggest, there's no one single "only this way will work" approach.

Instead of trying to kludge the existing trust account, I opted to
create a new second account -- the estate account -- and used an Add
Shares to manually populate it with the securities having a stepped-up
cost basis. This didn't prove as irksome as one might have supposed,
for most of the "buy" transactions were from before the date-of-death
and thus could be consolidated into a single transaction with
stepped-up basis.

Richard
[remove the two x's for email reply]
  #1  
Old 07-26-2007, 01:07 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Changing cost basis of reconciled transactions

In microsoft.public.money, Dick Watson wrote:

- quote -

> I'm thinking that the best bet is something like Sell/Buy transactions at
> the new cost basis. Since you always have to validate the outputs from Money
> anyway, this seems like the best way to get the most useful data going
> forward at the least impact in data fidelity now. I'd surely put memo
> entries in the transactions that describe this as the step-up transaction or
> Money reporting purposes. Others with more knowledge of the situation/tax
> law may have better answers.


I like that one.


- quote -

> <raschulmanxx[at]verizon.net> wrote in message
> news:l8ofa3he9f9mve69uqacvue9546o90vnp9[at]4ax.com...
> > To get to the point, is there anyway I can use Money 2004 to change
> > the cost basis without kaboshing the reconciled balances

I don't propose a worked out method, but here are some thoughts.
Make copies of the Money file(s) in case you want to undo something.


Do you want to continue the same file before and after death, or
would you be better with a different file for the estate. You could
have a new file, or you could create the estate version from a copy.
You still have to file an income tax return for both the person and
the estate. Whichever way you do it, you could start with the
existing file.
If you are dealing with a broker you can download from, consider
making a new file for the estate.Disable that account for online
access. Create the new account Close the file saying that you do not
want to transfer the content to another program. Set up the new
account for online transfer, and download Then download from he
broker into the new file. Let Money generate a bunch of AddShares
transactions.

The downside of this is that the dates would be recent, and any
sales from the inherited stock are considered long term. Instead of
a date of acquisition, you write a specified word. Maybe before
processing the download, you could change the date on the computer
as you wish. Then change it back after the AddShares are done.

Some other ideas come to mind. They involve generating or modifying
QIF files.

Note that you might find the AsOf setting of the Portfolio to be of
use in generating the list of investments. Suppose you then copied
and pasted that into a spreadsheet. You could potentially generate a
QIF file with some effort and expertise. If you don't have a lot of
positions to deal with, hand entry will probably be easier. You
could just update the prices by hand and get the rest during
download processing.





 
Old 07-26-2007, 12:38 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Changing cost basis of reconciled transactions

I'm thinking that the best bet is something like Sell/Buy transactions at
the new cost basis. Since you always have to validate the outputs from Money
anyway, this seems like the best way to get the most useful data going
forward at the least impact in data fidelity now. I'd surely put memo
entries in the transactions that describe this as the step-up transaction or
Money reporting purposes. Others with more knowledge of the situation/tax
law may have better answers.

<raschulmanxx[at]verizon.net> wrote in message
news:l8ofa3he9f9mve69uqacvue9546o90vnp9[at]4ax.com...
- quote -

> To get to the point, is there anyway I can use Money 2004 to change
> the cost basis without kaboshing the reconciled balances



  #-1  
Old 07-26-2007, 12:04 AM
raschulmanxx@verizon.net
Guest
 
Posts: n/a
Default Changing cost basis of reconciled transactions

I've been managing a trust in MS Money 2004 and it recently became an
estate with the death of the trust's originator. Under U.S. estate
law, the cost basis of securities gets stepped up to their respective
values at date of death or six months after date of death.

The problem I'm facing in MS Money is that if I try to change the cost
basis of the securities purchased prior to the date of death that have
already been reconciled -- most of the transactions -- the reconciled
balances for the account get totally clobbered.

What I wish MS had done to handle this situation is allow cost basis
to diverge from purchase price -- i.e., by providing two separate data
fields, with cost basis defaulting to purchase price under normal
circumstances but being modifiable in the case of cost-basis step-up.
(Even better would be a software module that would semi-automate this,
by changing the cost basis for all transactions for a given security
prior to the step-up date, based on the step-up price.)

To get to the point, is there anyway I can use Money 2004 to change
the cost basis without kaboshing the reconciled balances, and if Money
2004 can't do this, is there affordable software that can and also
accurately import Money 2004 data?

Thanks...

[For email, remove the two x'es in the reply-to address]
 

Tags
basis, changing, cost, reconciled, transactions
Similar Threads
Thread Forum Replies Last Post
Cash Transactions and Cost Basis
Roberta: Dividends I receive from mutual fund investments increase their market value instead of their cost basis. All dividends are automatically...
Microsoft Money 5 10-20-2006 04:25 AM
cost basis/avg cost per share
David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost...
Microsoft Money 2 03-03-2004 11:00 AM
cost basis/avg cost per share
David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost...
Microsoft Money 1 03-01-2004 11:26 AM
Cost Basis
KemC: Where do I look to find the calculated cost basis. I've selected "Average cost Basis (Double Category)" on the Details page. Don't know where to...
Microsoft Money 1 02-03-2004 03:56 AM
Re: cost basis
Cal Learner-- MVP: In microsoft.public.money, - Bobb - wrote: >Accounting aside, (since it's in my IRA account), any way to easily do this >? >I buy $25,000 of...
Microsoft Money 1 07-27-2003 02:38 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 01:16 AM.