FWIW, I've had the same problem in one of my datasets and this method worked
for me. A warning though: a subsequent download recreated the problem (same
account, different transaction). I've stopped downloading from Merrill
Lynch.............

--
Michael Gordon
MVP
"Matt" <anonymous[at]discussions.microsoft.com> wrote in message
news:041501c3ce1a$1df14ad0$a001280a[at]phx.gbl...
- quote -

In microsoft.public.money, Matt wrote:

- quote -

Woohooooo!!!!!!!!!! Good to hear!

- quote -


Thanks for the info and the further analysis.

- quote -

----------------- No. See below.
- quote -


----------------- No. See below.
- quote -

apprised.

-------------------------
Cal:

First, I have been working on this problem for 5-6 weeks.
No other procedure I have tried has even indicated that a
problem exists. So I don't think, at this point, that a
simpler procedure will even identify the problem let alone
solve it.

Back to the solution. I did perform steps 8 and 9. The
problem was that Money would match the QIF-imported items
with the "real transactions" rather than the ghost
transactions (keep in mind that all my ghost transactions
ended up being copies of real transactions in my
register. Thus, I had basically double entries (real and
ghost) for some transactions).

What I ended up doing was deleting the real transactions
(in my original file) corresponding to each ghost
transaction. I did this between steps 8 and 9. When I
then did the import, Money matched the imported
transactions to the ghost transactions in my original file
and they magically appeared in my register. Everything
then worked fine.

If you are interested, each of the ghost transactions
corresponded to a downloaded transaction from my financial
institution. I cannot confirm this but I suspect that the
problem was initially introduced when I unmatched and re-
matched the suspect transactions in Money (e.g., if Money
originally matched a transaction incorrectly, I would
manually match it to another transaction in my register).
I will keep an eye out for this sort of thing in the
future and report any additional information I find.

Thanks again for all your help.

Matt

In microsoft.public.money, Matt wrote:


- quote -

Are you saying that when you import that the instructions are still
hidden? No, I don't think you are saying that.

Or are you saying they get imported and therefore become visible,
but you think that the hidden transactions are still there?

Here was the procedure for reference:

:1. Make a copy of your Money data file.
:2. Open that copy.
:3. Delete ALL transactions in the problem account
:4. Export that account as a QIF file
:5. Examine the QIF file in Notepad.
:6. If it is not empty and shows one or more transactions,
:then those are
:likely the culprits.
:7. Note the details of those transactions
:8. Open up your original file
:9. Import the QIF file
:10. This should reveal the hidden transactions. So you
:can now do with them
:as you wish (Delete, modify, etc).' - Mark

Did you do step 8 and 9?

- quote -

I only know about the info from the posting, and I was wondering if
a simpler method would work too. Keep us apprised.

- quote -

8&btnG=Google+Search&as_epq=&as_oq=&as_eq=google&a s_ugroup
=microsoft.public.money&as_usubject=%
22Account+list+balance+does+not+match+register+bal ance...h
elp...please%
22&as_uauthors=&as_umsgid=&lr=&as_drrb=q&as_qdr=&a s_mind=1
2&as_minm=5&as_miny=1981&as_maxd=28&as_maxm=12&as_ maxy=200
3&safe=images
- quote -


Cal:

Wow. Thanks for the information. I completed the delete
and export instructions from the thread you identified
and, sure enough, some ghost duplicate transactions
appeared that add up exactly to my reconciliation
difference.

However, I don't really follow the re-import instructions
from the thread. When I try to import the exported QIF
file to my original account, Money identifies matches for
each transaction and does not therefore reveal the hidden
transactions. Any ideas? I will continue to play with
this and see if I can solve it.

Again, thanks for the information. It is a little scary
that these ghost transactions can even exist. But at
least I know that I was not making an entry error.

Regards,

Matt

In microsoft.public.money, Matt wrote:

- quote -

So you are saying that when viewing the Cash Transactions register,
the bottom says the same value for Today's Balance and Ending
Balance. But when you go to the Investment Transactions register it
says Cash Balance is a different number.

I would suggest you read through this thread:
http://groups.google.com/groups?as_q...03&safe=images

Remember to have extra copies of your file.

I am having a terrible problem with balancing the cash
side of an investment account.

I have searched this newsgroup and have already tried the
various "file repair" options (i.e., msmoney -s, quick
and standard file repair, and salvage). I have even
exported the account and reimported it. However, none of
these attempts have fixed the problem (or even identified
that anything is wrong with the file).

Here is what I am experiencing:

I use a brokerage account as my checking account. I
download transactions periodically and reconcile the cash
side monthly against my paper statement. I have done
this for about a year without any problems.

Recently, however, I was unable to balance the account,
i.e., I end up with a difference of "X" when I balance.
Now I know that balancing errors are almost always user-
caused. However, I have examined this account in great
detail and not found any errors. These are the things I
noticed that I thought were strange:

1.)When I review the account, I notice that there is a
different between the cash and investment balances in
this account. This difference is equal to the
reconciliation difference ("X"). I do not know if this
is unusual.

2.) If I set my cash page view to show only unreconciled
transactions, my ending balance on the cash page will
then match the investment balance page (that is, the
balance will change by the "X").

3.) The Home Page and Account List page will only shown
the balance from the investment page of the account.
However, if I run a transaction report, it shows the
different balance from my cash page (that is, the reports
page will show a balance that is different that the
account list or home page by the amount "X").

4.) I have manually compared every transaction in my cash
page register against my paper statements and found no
errors.

Any information for troubleshooting this problem is
greatly appreciated.