Doing the deletions in the qif file was a good idea.

--
Michael Gordon
MVP
"Regis" <anonymous[at]discussions.microsoft.com> wrote in message
news:01b701c48cf9$fb6b38f0$3501280a[at]phx.gbl...
- quote -

I did eventually get to succesfully purge the "hidden"
transactions.

I did not delete any transactions but I went through the
exported .qif file looking for duplicate transactions
starting from the end of the file. I deleted all
transactions from that file leaving in only the duplicate
transactions (both) and re-imported the resulting .QIF
file using the "reconcile" bank account option. The
hidden transactions then appeared in my log and all I did
was delete them. It did the trick! (Note: It didn't work
if I didn't leave both transactions in, the hidden and
the non-hidden one. Not sure why, but I thought I'd
mention it for others who might have the same problem as
me)

My approach was a bit more tedious (less automated) but
it wasn't that hard either. It saved me from having to
delete hundreds of transactions....although your advice
to use MacroMaker is an excellent, if not better,
alternative.

Thanks for your help!!!

Regis


- quote -

I've found the hidden transaction by doing a payee search; have you tried
that?

--
Michael Gordon
MVP
"Regis" <anonymous[at]discussions.microsoft.com> wrote in message
news:0e8701c48bb6$d636c980$a601280a[at]phx.gbl...
- quote -

In microsoft.public.money, Regis wrote:

- quote -


If the balance at the bottom of your register does not give
different balance when the view is changed to show only unreconciled
transactions or in some other way, then I doubt that you have that
problem.

To delete transactions in step 3, Clear the Tools-> Options-> Editing
Confirmation Options boxes. Sort the cash transactions register by
increasing date. Select the bottom transaction and click these
keys in rotation: Delete, Enter, <cursorUpArrow> . Listen for the
audible sound. If the audible sound changes, look at the screen.
You might have to deal with a customized allocation transaction.
Continue. I was able to do about 50 per minute, but I needed to
switch hands after a while.

MacroMaker could be useful to save pressing the keys.
http://members.ij.net/anthonymathews/MacroMaker.htm
Not only could I program a single key to do the action, but I could
specify how many times it would repeat. So a single keystroke could
do 100 or 1000. Eventually it hits the top.

Great...

I may end up having to wait for the 2005 version.

The second method you suggested doesn't seem to do the
trick. I can't find duplicate transactions by searching
for the bad transactions, even though I know exactly what
to look for.

As for the first method, it seems way too daunting...
unless you can tell me of a quick way to delete ALL the
transactions. I happen to have many hundreds of
transactions in that account. Is there an easy way?

Thanks again for your help!
Regis



- quote -

Bingo! You're the lucky recipient of the 'hidden transaction" problem. There
are a couple of ways of dealing with it:
Here's the first way:
.. > '1. Make a copy of your Money data file.
- quote -

A second way: see if you can view the hidden transaction, either for a
search via payee or amount. If you see two identical transactions, one will
be the hidden one. Find out which one is the culprit and designate it as
void.

A third way: wait for Money 2005: conversion of your data to 05 will delete
the hidden transaction and prevent this from happening again.

--
Michael Gordon
MVP

"Regis" <anonymous[at]discussions.microsoft.com> wrote in message
news:0faf01c48b4f$f4ee1f20$3a01280a[at]phx.gbl...
- quote -

Michael, I need to amend my last reply.

I DID find the match. It took 2 transactions to get it.
One of the two is a transaction entered only in the cash
account, and the other is an investment transaction
(stock sell).

I tried deleting and reentering both transactions, but it
had no effect on the discrepancy.

This seems to imply the existence of some hidden record
somewhere. What can I do to resolve this problem,
especially now that I have isolated the "guilty parties".

For what it's worth, I tried "repairing" my file
(standard). No effect...

Thanks again in advance,
Regis

- quote -

Good point, but then shouldn't I see that future-dated
transaction in the transaction log? None visible there.

Regis


- quote -

Running Money 2004

The data is downloaded, yes. The amount does not appear
to correspond to a single transaction in the cash account
but there are many transactions in this account so I may
have missed it. I also used the account transactions
report to search for a match. None found that way either.

Regis

- quote -

What version of Money? Is the data downloaded? Does the amount of the
difference correspond to a transaction in the cash account?

--
Michael Gordon
MVP
"Regis" <anonymous[at]discussions.microsoft.com> wrote in message
news:5a7b01c48a80$c4d559e0$a301280a[at]phx.gbl...
- quote -

In microsoft.public.money, Regis wrote:

- quote -


If Today's balance differs from the Ending Balance,
that should indicate a future-dated transaction.


- quote -

I can't figure out how this happened but there is a
difference between the cash account cash balance and the
ending cash balance in the associated investment account.

I see no reason for the difference. Funds for all my
investment transactions look properly applied to the cash
account.

Any suggestion on fixing this problem? This is very
annoying as many reports are now inconsistent as a result.

Thanks in advance
Regis