locked
Credit Card with a negative bank balance RRS feed

  • Question

  • Using Money 2006, I've finished reconciling my credit card account and my account list now shows a negative bank balance for my credit card account and a zero adjusted balance.  I have no unreconciled transactions for my credit card in Money.

    If I click on the account name, the top of the left column says:"Downloaded 08/31/2008 at 5:17 PM  Balance: ($1,238.75)".  This doesn't seem to be causing any numerical problems but it would be nice to get rid of it.

    Sunday, August 8, 2010 9:40 PM

All replies

  • When you delete a statement from the Account List, Money clears the
    downloaded balance amounts from the associated account.  Here is a
    5-step 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
    D08/08/2010
    T-1.00
    PRemove Balance
    MUsed to remove the balance
    ^
    ============end ClearBalance.QIF==========================

    2.  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.

    3. 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.

     

     

    Monday, August 9, 2010 1:20 AM
    Moderator
  • Thanks Cal,

    I followed your instructions exactly and the negative bank balance is still there.  But I think I saw a message that it will be cleared at the next transaction download so I will see after that and let you know.  Thanks for the help!

    John

    Monday, August 9, 2010 3:00 AM
  • You don't have a problem with the Balance colm or the "You Owe:" number, do you?

    Monday, August 9, 2010 3:03 AM
    Moderator
  • No, The balance is $0 and I owe nothing so it's not screwing up my financials that I know.  I just have an aversion to a negative balance anywhere except for proper credit card balances.  Things are still as originally reported.  Thanks for your help.
    Monday, August 9, 2010 9:36 PM