In microsoft.public.money, psoberg wrote:

- quote -

Great!

- quote -

You can view the thread at
http://groups.google.com/group/micro...d02f9eeb6de5fb

On Feb 14, 11:02 pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:

- quote -

Cal, you are a genius!! I deleted the lines you indicated, imported
and had no error notices, and the adjusted balance is now accurate.
Thank you ever so much for assisting me in this matter.

PS - how can I get this entire thread emailed to me?

Regards,
Pamela

In microsoft.public.money, psoberg wrote:

- quote -

Of that, delete everything except the "!Type:CCard" line.

So you will have the four records, but you don't need the opening
balance record.



- quote -

On Feb 14, 9:52 pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
- quote -

Okay, here is the balance record - which lines do I delete?

!Type:CCard
D4/24'2006
T-6,098.84
CX
POpening Balance
L[American Express - 27th]
^

- quote -

No, I don't think changing account settings will work. I have only
2006 - 2007 transactions in there, with a prior balance from the
archived data.

- quote -

I'll await your response on the balance data before I do anything
more.

Thanks for helping me, Cal.

Regards,
Pamela

In microsoft.public.money, psoberg wrote:

- quote -

You can delete that initial balance record.

You probably deleted something wrong if you got an error on import
of the QIF file.



You can change the initial balance in the account settings. If you
have all transactions, then the initial balance would be zero.

The first line in the file should be
!Type:xxxx

where xxxx represents the account type.

each record should start with a "D" (date) line,
and end with a line having only "^" on it.

Cal Learner-- MVP wrote:
- quote -

Thanks for replying. Okay, followed the steps and found the 4 hidden
transactions in the QIF file. Also found the erroneous balance in
that file; deleted that transaction. Imported file, had numerous
minor "not .qif file" type warnings, but continued on. I deleted the
4 "visible" transactions in the main money file, but the account
balance still shows the erroneous amount.

I retraced my steps, importing the .qif file again and noticed
something strange. The Adj. Balance amount "increased" when I added
in the 4 transactions by the ~$1550 error. After deleting the
transactions again, my balance reduced to the prior wrong amount.

- quote -

I deleted everything, all 14 months worth of transactions.

- quote -

Have multiple backups and not overwriting anything.

Should I have set the account balance in the .QIF file to something
different, besides deleting the entry? What else can I do?

Regards,
Pamela

In microsoft.public.money, psoberg wrote:

- quote -

See
http://support.microsoft.com/default...13&Product=mny

If the Money 2004 register gives different balance when
the view is changed to show only unreconciled transactions or
in some other way, then expect to make it to method 3.

You could shortcut step 3-5 by only deleting transactions in the
copy that correspond to the hidden transactions, and then deleting
all but the four corresponding records in the QIF file before
importing.

Keep an extra copy/backup in case you want to undo something.

To all,

As others who have posted before me, I have discovered an error in the
home page balance of my AMEX account and the register balance. The
transaction report showed 4 hidden transactions in 2006 (I haven't
archived '06 yet), all which were originally scheduled bill payments,
but did not allow me to edit/void them (amounts "grayed out.") I ran
multiple salvage/repair file actions, and the hidden transactions have
in fact disappeared. BUT, my home page balance and the register
balance still show the discrepancy. This same discrepancy shows when
I adjust my view in the register to "unreconciled transactions."

Since I don't have the hidden transactions appearing on the "Account
Transaction" report, how can I get the balances to agree?

Regards,
Pamela