[GNC] How to re-import exported transactions?

[Geert Janssens]

Op donderdag 30 januari 2025 23:01:10 Midden-Europese standaardtijd schreef Jeroen 
Bruijning via gnucash-user:
> I am trying to import CSV transactions that I have previously exported from
> GnuCash. In the import dialog I have to match columns with field names like
> Date, Description, Amount, etc. I have done this before with CSV files from
> another source, and that worked fine.
> 
> In this case, matching is a puzzle to me. Not clear what all columns mean
> and how they are supposed to be matched - column names do not always match
> the names in the drop down box where I am supposed to define the mapping.
> 
> But one choice I seem to have, is to load settings called “GnuCash Export
> Format” (I am using 5.10). It seems to me that this should do the required
> matching automatically. But nothing seems to happen.
> 
> Am I mistaken and is Gnucash Export Format for another purpose? Or else,
> what can I do to make it work?
> 
> Thanks!


Hi,

There are a few gotchas when re-importing exported transactions.

1. The importer expects the exported transactions to be exported in multi-split mode. If 
you chose the simplified export, gnucash can't reimport it as not all data is available.

2. The "GnuCash Export Format" has two versions, as the format did change at some 
point. Be sure to pick the one that matches the version of gnucash you used to export.

3. The preset *should* select the proper columns, but it will not set date and currency 
formats automatically. The export file is locale dependent to accommodate importing in 
other applications in all parts of the world, but unfortunately the import is more prudent 
and expects you to set these yourself to be correct.

If you did all that and still have issues, it would be helpful to give some more detailed 
description of the error messages the importer throws at you.

Regards,

Geert