[GNC] Issues Importing CSVs

Brad Morrison bradmorrison at sonic.net
Tue Feb 4 10:55:47 EST 2025


Hi Paul/GNUCash users, 

First off, some basics: 

What operating system are you using? 

What version of GNUCash are you using?
https://www.gnucash.org/download.phtml - the current version is 5.10 

https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - covers
some of the importing & exporting basics, have you looked through it
already? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison 

On 2025-02-04 07:11, Paul Kroitor wrote:

> 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?
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.


More information about the gnucash-user mailing list