Paul, It should be possible to use the GnuCash Export multiline format for both export and import but the debits and credits will be reversed and the account names will be different in the two sets of books.
For issue A I would think it would be possible to process the CSV file in either a spreadsheet with macros or scripted editor (awk or gawk are available in Windows) to make the necessary changes to allow import of the full records with appropriate name changes for the accounts to match the set of books being imported into. This will require setting up the mapping of the account names in the imported records to the internal accounts in the set of books you are importing into during initial imports of records but these assignments should take place automatically once initially assigned. This would avoid the skipping lines option and should import the transactions with more than two splits although you will need to consider whether all splits are relevant in the second set of accounts and modify the transactions with multiple splits accordingly. The above approach should also solve B as the memo fields of each split of the transaction will be preserved for import. David Cousens On Tue, 2025-02-04 at 10:11 -0500, 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@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. _______________________________________________ gnucash-user mailing list gnucash-user@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.
