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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.