what is a viable approach to importing transactions from prior months into an existing account without messing it up?

313 views
Hi,

You may have experience from testing and supporting the QFX files which are
produced by CSV2QFX to answer my question... (I realize this is probably a
question for Quicken but the chances of getting a response from them on how
to properly apply the CSV2QFX tool is nil):

Using live update in Quicken, you create a new account and via webconnect
the Quicken software grabs the past 90 days of transactions and
automatically balances the account.

My bank stores the entire past year but only supports download of csv
files. So CSV2QFX looks like a viable tool to harvest the first nine months
of 2012 data.

So I tried an experiment:

pull and convert one csv file... Quicken imports to a new account and
balances the account to zero.  So far so good.

pull and convert a second csv file, and import that into the account I just
created... Quicken imports the transactions but does not balance, resulting
in weird ending balance.

So my question is: what is a viable approach to importing transactions from
prior months into an existing account without messing it up?

Do you have any recommendations on how to do this using CSV2QFX to import
multiple csv files?

thanks,

.. Ed
asked Dec 29, 2013 by anonymous

1 Answer

Ed,

Importing QFX into a new account results in the balance set from the QFX file. Another import will not use the balance from the QFX file, just import transactions.

CSV2QFX puts the balance as total sum of all transactions on the file to have QFX file complete, since there is no balance info.

The main purpose of importing QFX file is to have transactions imported, not the balances.

You may also try CSV2QIF at http://www.propersoft.net/CSV2QIF/

CSV2QIF creates importable QIF files for all account types. QIF format does not carry the balance, only the transactions.
answered Dec 29, 2013 by sergiy
Welcome to Propersoft Q&A, where you can ask questions and receive answers from other members of the community.

Ask conversion expert:

I have:

I need to convert to or import into: