locked
Bank Balance RRS feed

  • Question

  • I have balanced my acoount and the end balance is correct; the bank balance however is incorrect: how can I change that?
    Sunday, July 12, 2020 12:05 PM

All replies

  • Michael Gorden posted a process to clear the downloaded balance
    from the Bank Balance column of the Account List.

    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
    D10/11/2019
    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.
    Sunday, July 12, 2020 3:31 PM
    Moderator
  • thanks. worked like a charm
    Monday, July 13, 2020 9:37 AM