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