Merge same transaction
jmburton2001
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?
Cal Learner-- MVP
Don't accept the transaction initially, and instead click Change to
match to the right transaction. Then Accept the transaction.
jmburton2001
jmburton2001
Steve
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
Cal Learner-- MVP
>I take it that this is impossible given that there have been no replies?
I suspect you won't read this either.
jmburton2001
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.
Steve
wrote on 06 Jan 2008 in group microsoft.public.money:
> 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.
> 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.
Cal Learner-- MVP
>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/microsoft.public.money/browse_thread/thread/fea5d358a8202968/9cfda27ac832c9e2
jmburton2001
replied to. I was just looking here for a reply. Thank you for your help!
jmburton2001
experienced the same phenomenon as you have. Looks like I've been handling it
(investment accounts) the same way myself!
Steve
wrote on 07 Jan 2008 in group microsoft.public.money:
> "Steve" wrote:
>
>> =?Utf-8?B?am1idXJ0b24yMDAx?=
>> <jmburt...@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.
Cal Learner-- MVP
>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.
Cal Learner-- MVP
>
>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.