Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #11  
Old 01-07-2008, 03:35 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Merge same transaction

In microsoft.public.money, Steve wrote:

- quote -

> If your brokerage is like mine, the downloaded transactions are only
> partly useful. Every month I go through and change a bunch of
> dividend/purchase or dividend/add shares transactions into "Reinvest
> Dividend" transactions. The same thing for interest income. I'm not a
> tax accountant, so I can't say whether there's a difference, but it
> makes my registers lots shorter, and my accountant has never complained.
> All that said, I wind up manually marking transactions as reconciled. I
> seem to recall that the matching thing doesn't apply to investment
> accounts.


I don't bother marking the transactions in the investment
transactions as reconciled. If the cash balances out, there is a
good chance that there were no missing Buys and Sells. I do compare
the cash+sweep balances manually. It was easier when my broker did
download the MMF buys and sells. It made for a busy register, but
the expected cash balance was always zero if there were no unsettled
trades.

But the OFX position information in the download does get compared
to the holdings that Money sees in the registers. If there is
downloaded position that has a different quantity than Money
expects, it will tell you. I don't usually accept Money's offer to
make an adjusting transaction. The position information sometimes
leads or lags the corresponding transactions. After the difference
is there for a while, I track down the missing (or possibly
duplicated) transaction.

Regarding the sweep money market account, I agree with your method.
It is also the method I would use if entering data by hand. It's too
bad that Money doesn't have a way to associate the monthly dividends
for ABC MMF to the cash balance. As it is, the yield for ABC MMF
looks really good, with apparently little or no holdings, it pays a
non-zero dividend.
  #10  
Old 01-07-2008, 03:25 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Merge same transaction

In microsoft.public.money, jmburton2001 wrote:

- quote -

> Thank you Cal. I wasn't aware that there was a google group that you had
> replied to. I was just looking here for a reply. Thank you for your help!


It was not a google group. It was the Microsoft group. Google
archives the even semi-popular text groups. The postings get passed
around. It's a search engine thing. Fortunately for us all, Google
took over the DejaNews operations.
  #9  
Old 01-07-2008, 12:41 PM
Steve
Guest
 
Posts: n/a
Default Re: Merge same transaction

=?Utf-8?B?am1idXJ0b24yMDAx?= <jmburton2001[at]discussions.microsoft.comwrote on 07 Jan 2008 in group microsoft.public.money:

- quote -

> "Steve" wrote:
> > =?Utf-8?B?am1idXJ0b24yMDAx?=
> > <jmburton2001[at]discussions.microsoft.com> wrote on 06 Jan 2008 in
> > group microsoft.public.money:
> > > If your brokerage is like mine, the downloaded transactions are only

> > partly useful. Every month I go through and change a bunch of
> > dividend/purchase or dividend/add shares transactions into "Reinvest
> > Dividend" transactions. The same thing for interest income. I'm not
> > a tax accountant, so I can't say whether there's a difference, but
> > it makes my registers lots shorter, and my accountant has never
> > complained.
> > > All that said, I wind up manually marking transactions as

> > reconciled. I seem to recall that the matching thing doesn't apply
> > to investment accounts.

> Thanks Steve! You hit the nail right on the head here. It seems like
> I've experienced the same phenomenon as you have. Looks like I've
> been handling it (investment accounts) the same way myself!


Be sure to choose properly between long-term and short-term dividend
reinvestments. Otherwise your CPA will get incorrect tax information at
the end of the year.

--
Steve B.
New Life Home Improvement
  #8  
Old 01-07-2008, 12:25 PM
jmburton2001
Guest
 
Posts: n/a
Default Re: Merge same transaction

Thanks Steve! You hit the nail right on the head here. It seems like I've
experienced the same phenomenon as you have. Looks like I've been handling it
(investment accounts) the same way myself!

"Steve" wrote:

- quote -

> =?Utf-8?B?am1idXJ0b24yMDAx?= <jmburton2001[at]discussions.microsoft.com> wrote on 06 Jan 2008 in group microsoft.public.money:
> If your brokerage is like mine, the downloaded transactions are only
> partly useful. Every month I go through and change a bunch of
> dividend/purchase or dividend/add shares transactions into "Reinvest
> Dividend" transactions. The same thing for interest income. I'm not a
> tax accountant, so I can't say whether there's a difference, but it
> makes my registers lots shorter, and my accountant has never complained.
> All that said, I wind up manually marking transactions as reconciled. I
> seem to recall that the matching thing doesn't apply to investment
> accounts.


  #7  
Old 01-07-2008, 12:23 PM
jmburton2001
Guest
 
Posts: n/a
Default Re: Merge same transaction

Thank you Cal. I wasn't aware that there was a google group that you had
replied to. I was just looking here for a reply. Thank you for your help!

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, jmburton2001 wrote:
> > Thank you Cal and Steve for your replies. Steve's replies work well in the
> > regular account registers. Does this apply to the investment registers as
> > well? On another note, is there a way to merge transactions after they've
> > been accepted?
> > > Cal, you're an MVP and your replies are much sought after. I understand that

> > you've most likely become jaded and aggravated with people on this board and
> > if my reply seemed to strike a nerve with you, I apologize.
> > > I assure you that I am waiting for your reply and will read it after it's

> > posted.

> You can review the thread at
> http://groups.google.com/group/micro...fda27ac832c9e2
> > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, jmburton2001 wrote:
> > > > > > I take it that this is impossible given that there have been no replies?
> > > > > I suspect you won't read this either.

> >
  #6  
Old 01-06-2008, 05:17 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Merge same transaction

In microsoft.public.money, jmburton2001 wrote:

- quote -

> Thank you Cal and Steve for your replies. Steve's replies work well in the
> regular account registers. Does this apply to the investment registers as
> well? On another note, is there a way to merge transactions after they've
> been accepted?
> Cal, you're an MVP and your replies are much sought after. I understand that
> you've most likely become jaded and aggravated with people on this board and
> if my reply seemed to strike a nerve with you, I apologize.
> I assure you that I am waiting for your reply and will read it after it's
> posted.


You can review the thread at
http://groups.google.com/group/micro...fda27ac832c9e2


- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, jmburton2001 wrote:
> > > > I take it that this is impossible given that there have been no replies?
> > > I suspect you won't read this either.

>
  #5  
Old 01-06-2008, 04:25 PM
Steve
Guest
 
Posts: n/a
Default Re: Merge same transaction

=?Utf-8?B?am1idXJ0b24yMDAx?= <jmburton2001[at]discussions.microsoft.comwrote on 06 Jan 2008 in group microsoft.public.money:

- quote -

> Steve's replies work well in the regular account registers. Does this
> apply to the investment registers as well?


If your brokerage is like mine, the downloaded transactions are only
partly useful. Every month I go through and change a bunch of
dividend/purchase or dividend/add shares transactions into "Reinvest
Dividend" transactions. The same thing for interest income. I'm not a
tax accountant, so I can't say whether there's a difference, but it
makes my registers lots shorter, and my accountant has never complained.

All that said, I wind up manually marking transactions as reconciled. I
seem to recall that the matching thing doesn't apply to investment
accounts.

- quote -

> On another note, is there a way to merge transactions after they've
> been accepted?


No. You have to delete the accepted transaction, re-sync with the
financial institution, download the transaction again, and accept it
properly. I _think_ that if you delete the unmerged downloaded
transaction, it will just get downloaded again at the next sync.

--
Steve B.
New Life Home Improvement
  #4  
Old 01-06-2008, 02:38 PM
jmburton2001
Guest
 
Posts: n/a
Default Re: Merge same transaction

Thank you Cal and Steve for your replies. Steve's replies work well in the
regular account registers. Does this apply to the investment registers as
well? On another note, is there a way to merge transactions after they've
been accepted?

Cal, you're an MVP and your replies are much sought after. I understand that
you've most likely become jaded and aggravated with people on this board and
if my reply seemed to strike a nerve with you, I apologize.

I assure you that I am waiting for your reply and will read it after it's
posted.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, jmburton2001 wrote:
> > I take it that this is impossible given that there have been no replies?

> I suspect you won't read this either.

  #3  
Old 01-05-2008, 03:09 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Merge same transaction

In microsoft.public.money, jmburton2001 wrote:

- quote -

> I take it that this is impossible given that there have been no replies?

I suspect you won't read this either.
  #2  
Old 01-05-2008, 12:33 PM
Steve
Guest
 
Posts: n/a
Default RE: Merge same transaction

=?Utf-8?B?am1idXJ0b24yMDAx?= <jmburton2001[at]discussions.microsoft.comwrote on 05 Jan 2008 in group microsoft.public.money:

- quote -

> "jmburton2001" wrote:
> > I've had transactions that I've placed in my register with detailed
> > info in the memo area only to have the same exact transaction
> > download with no info and unrecognized as the same transaction.
> > Traditionally I've copied and pasted the info into the downloaded
> > transaction and then deleted my transaction. This is a real PAIN...
> > Is there a way to tell Money that these two separate transactions
> > are the SAME transaction and then have it merge them?
> > > It works exactly as intended when Money recognizes the transaction

> > that's already in the register and then merges them beautifully. How
> > do I get that same result when it doesn't recognize the transaction?

> I take it that this is impossible given that there have been no
> replies?


When the unrecognized transaction appears it will be bolded. Select the
transaction and click the "Change" button. A window will appear that
lists all the transactions in your account. Check the box next to the
transaction that matches, and click the button to accept.

You just told Money which transaction is the correct one. Now you can
click the "Accept" button.

--
Steve B.
New Life Home Improvement
  #1  
Old 01-05-2008, 11:30 AM
jmburton2001
Guest
 
Posts: n/a
Default RE: Merge same transaction

I take it that this is impossible given that there have been no replies?

"jmburton2001" wrote:

- quote -

> I've had transactions that I've placed in my register with detailed info in
> the memo area only to have the same exact transaction download with no info
> and unrecognized as the same transaction. Traditionally I've copied and
> pasted the info into the downloaded transaction and then deleted my
> transaction. This is a real PAIN... Is there a way to tell Money that these
> two separate transactions are the SAME transaction and then have it merge
> them?
> It works exactly as intended when Money recognizes the transaction that's
> already in the register and then merges them beautifully. How do I get that
> same result when it doesn't recognize the transaction?

 
Old 01-04-2008, 03:04 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Merge same transaction

In microsoft.public.money, jmburton2001 wrote:

- quote -

> I've had transactions that I've placed in my register with detailed info in
> the memo area only to have the same exact transaction download with no info
> and unrecognized as the same transaction. Traditionally I've copied and
> pasted the info into the downloaded transaction and then deleted my
> transaction. This is a real PAIN... Is there a way to tell Money that these
> two separate transactions are the SAME transaction and then have it merge
> them?
> It works exactly as intended when Money recognizes the transaction that's
> already in the register and then merges them beautifully. How do I get that
> same result when it doesn't recognize the transaction?


Don't accept the transaction initially, and instead click Change to
match to the right transaction. Then Accept the transaction.
  #-1  
Old 01-04-2008, 02:19 PM
jmburton2001
Guest
 
Posts: n/a
Default Merge same transaction

I've had transactions that I've placed in my register with detailed info in
the memo area only to have the same exact transaction download with no info
and unrecognized as the same transaction. Traditionally I've copied and
pasted the info into the downloaded transaction and then deleted my
transaction. This is a real PAIN... Is there a way to tell Money that these
two separate transactions are the SAME transaction and then have it merge
them?

It works exactly as intended when Money recognizes the transaction that's
already in the register and then merges them beautifully. How do I get that
same result when it doesn't recognize the transaction?
 

Tags
merge, transaction
Similar Threads
Thread Forum Replies Last Post
Merge 2 accounts
bobhat@hotmail.com: Would like to be able to merge my wife's checking account and my account into one checking account. We have moved all our financial checking...
Microsoft Money 1 07-31-2005 10:49 PM
Undo Merge?
Carlos: MSM 05 chose for me when I tried to merge accounts and it picked the wrong one to merge with. How can I undo this?
Microsoft Money 1 01-27-2005 03:54 AM
Merge Two Transactions
Spencer: How do I merge two transactions? I just recently downloaded Money 2005 and setup all these reocurring bills. When I download my statements from...
Microsoft Money 5 10-14-2004 02:19 PM
Merge Files
Shankar Krishnan: I have been using money since money 98 and My current version is 2003 Delux. I have been creating seperate money files for each year. Is there a way...
Microsoft Money 1 11-13-2003 03:21 PM
Merge
Shellie: Does anyone know how to stop or reverse the automatic merge with you download from the bank. We withdraw the same about every two weeks and it...
Microsoft Money 1 10-30-2003 04:03 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 12:09 AM.