How do I manually zero a Bank Balance?


S

Steve

I last performed an online download for one of my credit card accounts in FEB
08. In MAR 08, I paid the entire balance and closed the account. The bank cut
off my online access when the account was closed, so I am unable to perform
another online download which would reflect payment in full and zero the
balance. As far as I can tell, I am stuck with an incorrect nonzero Bank
Balance for this card forever. Short of deleting the account, is there a way
to manually zero a balance created by online update?
 
Ad

Advertisements

C

Cal Learner-- MVP

I last performed an online download for one of my credit card accounts in FEB
08. In MAR 08, I paid the entire balance and closed the account. The bank cut
off my online access when the account was closed, so I am unable to perform
another online download which would reflect payment in full and zero the
balance. As far as I can tell, I am stuck with an incorrect nonzero Bank
Balance for this card forever. Short of deleting the account, is there a way
to manually zero a balance created by online update?
Either adjust the opening balance for the account, or add a single
compenstating transaction to adjust the balance to zero.
 
S

Steve

OK, the compensation transaction brings the "adjusted balance" to zero, but
the nonzero "Bank Balance" is totally unaffected by changes in opening
balance or compensating transactions. These two balances appear side-by-side
 
C

Cal Learner-- MVP

OK, the compensation transaction brings the "adjusted balance" to zero, but
the nonzero "Bank Balance" is totally unaffected by changes in opening
balance or compensating transactions. These two balances appear side-by-side
on "Account List" under "Banking"
The "Bank Balance" is a downloaded figure.

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
D3/10/2008
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.
 
E

Eric Engelbrektsson

Cal,
This was a great response and it worked like a charm! Many thanks.
 
S

Steve B

HI.... I tried this technique once on an earlier account, and it worked
great. By I tried again with a different account, and Money will not let me
delete the statement. It simply says "This operation cannot be performed."

Does anyone have any idea how to correct this or work around it? Thanks.
 
Ad

Advertisements

C

Cal Learner-- MVP

In microsoft.public.money, Steve B <Steve
HI.... I tried this technique once on an earlier account, and it worked
great. By I tried again with a different account, and Money will not let me
delete the statement. It simply says "This operation cannot be performed."
I would try to make a repaired version of your file with
File->StandardFileRepair level 2.
 
S

Steve B

Hmm. No luck with that. I think it's something specific about the settings on
that account, because the clear balance trick seems to work on all the other
accounts. Not sure what's doing it.
 
S

Steve B

FYI, I tried another solution -- downloaded an actual statement from another
bank, applied to the account I was having trouble with, and then deleted
that. (Instead of using the ClearBalance.QIF file.)

That actually worked and I was able to remove the bank balance on the
offending account. Thanks for the help anyway.....
 
Ad

Advertisements

M

Marcelo Kalil

THANK YOU!!!!

Cal Learner-- MVP said:
The "Bank Balance" is a downloaded figure.

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
D3/10/2008
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top