How can I bulk duplicate tranactions

Mike or Penny Novack stepbystepfarm at mtdata.com
Thu Mar 13 09:41:31 EDT 2014


Benjamin Bergman wrote:

>I agree that I would rather be doing other things, but the membership is
>looking for a report with a breakdown of dues and donations each month. I
>will also be using gnucash for this year's books and tracking each member
>is necessary for making sure all dues are paid.
>On Mar 13, 2014 12:09 AM, "elvis" <elvis at dogonfire.com> wrote:
>
>  
>
I don't know what to tell you. Writing ad hoc programs to "fake" people 
sitting at their terminals entering tens of thousands of correction 
transactions is the sort of thing I did back in my working days. So if 
gnucash can import transactions form a file in .cvs format I am sure I 
(or some other pro) would be able to code the "transaction generating 
program" that would do this correctly. But there is no way you could 
afford the "consultant" fee for the work. You could always try the prof 
of a nearby the school to see of he'd like to give this to a class as a 
case problem.

But --- if, as you seem to think gnucash, cannot* import a split 
transaction here is a hint that might be enough for you to code it. Any 
split transaction can be thought of as two consecutive (un)split 
transactions and you can continue that breakdown till all are unsplit 
transactions. Be creative, even adding an account to the chart of that 
helps << example --- one side of the large splits will be the incoming 
check. So you create am account "payments for multiple things" and in 
the final sequence of  unsplit transactions (equivalent to the split you 
can't import) is the check against this account and the each subsequent 
one taking some of the amount there against the particular thing being 
paid for by the check>>.

Michael D Novack

* I'd have to take a hard look at that.  Suggestion ---- can you get 
gnucash to export transactions? Including some that are splits? What do 
they look like. You could try creating a test set of books containing a 
single split transaction and the export to .cvs and then try importing 
that to another set of test books .


More information about the gnucash-user mailing list