[GNC] QIF File Format

David Cousens davidcousens at bigpond.com
Thu Sep 12 04:06:16 EDT 2019


Charlie 

If the QIF export does not work, you could import the CSV directly.  If you
create a Gnucash account for the
Westpac Cash management account you could ignore column A in your data and
create Asset, and Expense and Income accounts corresponding to the entries
in the Split column the Date, Num and Description columns would match the
corresponding headers in the CSV Import wizard, the Amount column would
match to the  Deposit header and the Split column to the transfer account
header.

You could construct a list of the required accounts by sorting the Split
column in a spread sheet to identify the duplicates and extract the unique
identifiers as your account names for the Asset, Expense and Income accounts
you will require and create them before importing with the names used in the
Split column.  If the names match up then GnuCash will import to the correct
accounts. If you later want to change the account names these are easily
edited.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


More information about the gnucash-user mailing list