Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 12-07-2007, 06:25 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Balancing Investment Account -- How to reconcile investment transactions

I do.

I compare and/or enter transactions from transaction confirms for shares and
total amount. I mark transactions Cleared (Ctrl+M).

(For non-401k accounts): I compare share holdings from account statements to
either Account Summary share holdings or, sometimes, to Portfolio Standard
View as of date of statement views. I cross-check the share balances and put
a check mark on the statements. Once all is well (and anything like
distributions and interest off the statement that I hadn't noticed earlier
are entered) I mark all transactions to that point in the Investment Account
as Reconciled (Ctrl+Shift+M). (For non-retirement accounts): I balance the
Investment Cash Accounts to statements.

(For 401k accounts): I use the Account Summary Quick Update to get all to
good numbers and then mark all activity in cash/investment accounts to that
point as Reconciled. I treat the 401ks differently since: a) the volume of
transactions is just overwhelming and generally useless in individual
transactions (though I do try and enter those for market valued
investments), b) the Investments are not always market valued and managing
by share price and daily values is hard to impossible for these cases, and
c) the 401k Manager that insists on balancing 401k accounts has been broken
and/or just really odd for so long as to be a running joke amongst long time
users.

For the record and those who don't already know, I do not download
transaction data, OFX or otherwise.

"Loutrix" <spamyou[at]nospam.net> wrote in message
news:Gud6j.8636$pq.7771[at]newsfe24.lga...
- quote -

> Do users even bother doing this?


 
Old 12-07-2007, 05:38 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Balancing Investment Account -- How to reconcile investment transactions

In microsoft.public.money, Loutrix wrote:

- quote -

> With regard to balancing an investment account (common stock,
> non-retirement) against the monthly statement, I see the option on the cash
> account side to do so much akin to balancing out regular bank accounts.
> However, the investment transaction side does not have this option and after
> the transactions on the cash side are reconciled, there is no change to the
> status of each investment transaction listing the buys and sells of common
> stock.
> Is there an easy way to mark as reconciled these transactions or do you have
> to pick through each line item separately? Do users even bother doing this?


Users don't do this. Positions that are downloaded from the broker
do get compared to the account holdings during OFX statement
processing.

  #-1  
Old 12-07-2007, 02:17 PM
Loutrix
Guest
 
Posts: n/a
Default Balancing Investment Account -- How to reconcile investment transactions

With regard to balancing an investment account (common stock,
non-retirement) against the monthly statement, I see the option on the cash
account side to do so much akin to balancing out regular bank accounts.
However, the investment transaction side does not have this option and after
the transactions on the cash side are reconciled, there is no change to the
status of each investment transaction listing the buys and sells of common
stock.

Is there an easy way to mark as reconciled these transactions or do you have
to pick through each line item separately? Do users even bother doing this?

Thanks.

John


 

Tags
account, balancing, investment, reconcile, transactions
Similar Threads
Thread Forum Replies Last Post
Balancing an investment account
Paul L.: I regularly balance the cash transactions associated with my investments accounts. I noticed that when I look at the related investment...
Microsoft Money 3 01-22-2008 11:18 PM
Investment Account Cash Transactions
Erik Limpaecher: I have several dividend and sell transactions in my investment account. However, in the "Cash Transactions" register, some of these transactions,...
Microsoft Money 1 04-06-2007 03:17 PM
Fidelity Investment Account Transactions - The Core Account Myster
David: Hi All, I have recently moved all of my accounts to fidelity, and the first one has settled. THis account is a Roth IRA, and thanks to some...
Microsoft Money 21 07-28-2005 01:48 AM
balancing investment account
MFB: I am using Money 2003 Deluxe. I have an investment account at datek which has two portions one for cash and other investment. Let's call it...
Microsoft Money 1 01-30-2004 12:35 AM
BALANCING A INVESTMENT ACCOUNT
BOB: I can't figure out how to balance an investment account. ANy help?
Microsoft Money 1 11-23-2003 09:45 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 11:28 PM.