Money 2005 Deluxe account balance error/hidden transactions
psoberg
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
Cal Learner-- MVP
See
http://support.microsoft.com/default.aspx?scid=kb;en-us;838713&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.
psoberg
Cal Learner-- MVP wrote:
> See http://support.microsoft.com/default.aspx?scid=kb;en-us;838713&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.
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.
> 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.
I deleted everything, all 14 months worth of transactions.
> Keep an extra copy/backup in case you want to undo something.
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
Cal Learner-- MVP
>
>Should I have set the account balance in the .QIF file to something
>different, besides deleting the entry? What else can I do?
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.
psoberg
wrote:
> In microsoft.public.money, psoberg wrote:
>
> >Should I have set the account balance in the .QIF file to something
> >different, besides deleting the entry? What else can I do?
>
> You can delete that initial balance record.
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]
^
> 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.
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.
> 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.
I'll await your response on the balance data before I do anything
more.
Thanks for helping me, Cal.
Regards,
Pamela
Cal Learner-- MVP
>On Feb 14, 9:52 pm, Cal Learner-- MVP <via_newsgr...@please.tnx>
>wrote:
>> In microsoft.public.money, psoberg wrote:
>>
>> >Should I have set the account balance in the .QIF file to something
>> >different, besides deleting the entry? What else can I do?
>>
>> You can delete that initial balance record.
>
>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]
>^
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.
psoberg
wrote:
> >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]
> >^
>
> 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.
>
> >> You probably deleted something wrong if you got an error on import
> >> of the QIF file.
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
Cal Learner-- MVP
>n Feb 14, 11:02 pm, Cal Learner-- MVP <via_newsgr...@please.tnx>
>wrote:
>
>> >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]
>> >^
>>
>> 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.
>>
>> >> You probably deleted something wrong if you got an error on import
>> >> of the QIF file.
>
>Cal, you are a genius!! I deleted the lines you indicated, imported
>and had no error notices, and the adjusted balance is now accurate.
Great!
>Thank you ever so much for assisting me in this matter.
>
>PS - how can I get this entire thread emailed to me?
You can view the thread at
http://groups.google.com/group/microsoft.public.money/browse_thread/thread/4e8300605846e51f/e1d02f9eeb6de5fb