Re: Adjust balance is correct...but money say's its not? by Cal
Cal
Sun May 04 13:56:43 CDT 2008
In microsoft.public.money, twmonahan wrote:
>On the Account List page, I see a summary of my account... all are
>fine except one... my checking account.
>
>Money has a "Last Updated" date of 1/5/2004??? Presently NONE of my
>banks or accounts are internet accessible. Where it got this date from
>is beyond me? How can it think it connected to my bank when it
>never happened?
When you delete a statement from the Account List, Money clears the
downloaded balance amounts from the associated account. Here is a
way to do that:
1.Open a new Notepad file, and paste the following six lines
between the delimiter lines below into the file. Save the file as
"ClearBalance.QIF".
============begin ClearBalance.QIF==========================
!Type:Bank
D10/18/2007
T-1.00
PRemove Balance
MUsed to remove the balance
^
============end ClearBalance.QIF==========================
2. Change the date on the line that starts with 'D' to a date
later than the reported last download in the register. Today's
date should work. The date format depends on your Windows regional
settings.
3. Save the File->SaveAs the file "ClearBalance.QIF" in the same
folder as your *.mny file.
4. Open Money, and File->Import->Downloaded Statement. Select
ClearBalance.QIF and click Import. Money will ask which account
(or to make a new account). Select the account you wish to clear
the Downloaded Date from, and click Next, then OK.
5.Do not process the statement as you would a regular statement.
Instead go to the Account List and right-click where it says
"Transactions to read:1" for the account that you imported into.
Choose DeleteStatement.
You can re-use the ClearBalance.QIF file on all the accounts you
wish to clear.
>
>More so, it lists an incorrect "Bank Balance"... its $47 higher than
>the actual "Adj. Balance" (which is correct).
>
>Why does money believe it has an incorrect balance? I've always
>reconciled and balanced by hand. All my accounts are correct to the
>penny - yet money thinks I'm out by $47 from back in 2004?
>
>Is there a way to manual update the balance so it knows they are all
>correct? or can I somehow change erase this $47
>"recommendation"??? I tired letting it adjust my balance...but
>then it was out by $47... so I had to find that transaction back in
>2004 and delete it from the register.
If the problem is only the "Bank Balance" and not the "Ending
Balance", the above procedure should set things right.