Downloaded Balance Not Available


K

KevD

My financial institutions only provide account transactions in QIF so I have
written some code in XL to take the transactions in a sheet and create an OFX
file for import to Money v14 (don't know what year that is!). The problem
that I have is that some Money accounts do not update the Downloaded Date &
Balance from my OFX file, but the infomation is valid as other Money accounts
have no probs with the numbers.

I am an experience Money user and developer, so understand all the technical
stuff.

Thanks for your help
 
Ad

Advertisements

C

Cal Learner-- MVP

My financial institutions only provide account transactions in QIF so I have
written some code in XL to take the transactions in a sheet and create an OFX
file for import to Money v14 (don't know what year that is!). The problem
that I have is that some Money accounts do not update the Downloaded Date &
Balance from my OFX file, but the infomation is valid as other Money accounts
have no probs with the numbers.

I am an experience Money user and developer, so understand all the technical
stuff.
I think you may be asking how to have an account not represent a
Bank/Downloaded balance for an institution that no longer provides
such info.

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/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