[GNC] Issues Importing CSVs

Paul Kroitor paul at kroitor.ca
Tue Feb 4 10:11:16 EST 2025


I regularly have to transfer large batches of transactions from one set 
of existing books into another. Basically party A pays dozens of 
expenses for party B, then rebills B quarterly a lump sum total.

I have established a standard process for this (by exporting then 
importing CSVs) but I have encountered two gotchas and wonder if anyone 
has any bright ideas.

A. When importing, I tick "skip alternate lines" so that I only get the 
expense side of each transaction (the other side being the monotonous 
rebill account). This works perfectly EXCEPT that where there is a split 
transaction in the source, there are three lines in the CSV and thus the 
even/odd cadence gets out of whack.

B. With some experimentation I have got all the fields mapped properly 
through the process EXCEPT that the memo field only gets imported into 
one of the two sides in the created transaction. I tend to put the same 
memo in both the debit and credit sides of these transactions, but after 
the transfer process only one of these two memo texts survives. I have 
to run thru the destination register account and copy/paste all the memos.

Does anyone know a way to avoid either problem?




More information about the gnucash-user mailing list