On 8/16/2026 12:22 PM, Patrick James via gnucash-user wrote:ou
For various reasons, new users have struggled with the CSV import of
transactions. I looked back at the various questions, and while there is no
single magic solution, I decided to write a Guided CSV Import. The strategy is
to start with known CSV data, as published on the Wiki page, a clean GnuCash
file and import the data both non-multi-split and multi-split.
If someone is struggling with a first CSV import, this guided tour will probably answer the questions of where things are going wrong.
https://wiki.gnucash.org/wiki/Guided_CSV_Import
Might I add a perhaps useful tip? The csv format ONLY specifies that the
fields of each record will be delineated by commas. It does NOT specify
the order of the fields of each record. Therefore ......
FIRST do an export of transactions to csv. Almost all applications
export records with fields in the order they expect when importing. If
you know (from gnucash) what the amounts/dates/accounts/etc. of the
transactions you exported you can look at the records in the file you
exported to learn what the order of fields is.
THEN look at the file you want to import/ Same order? Different order?
If different you will need to reorder the data.
Michael D Novack
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.