How can I bulk duplicate tranactions

[Benjamin Bergman]

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:

> On 13/03/14 14:09, Benjamin Bergman wrote:
>
>> I have been tasked with creating a set of books for the previous
>> calendar year for my organization. The majority of our transactions
>> are the collection of member dues into our "Income:Member Dues"
>> account. This happens every month and we have about 60 members, so
>> that would be over 700 transactions to create by hand.
>>
>> What I thought I could do is export the transactions for one member's
>> account into a CSV (this part seems to work well enough), open it in a
>> text editor and do a search-and-replace for the member name, then
>> import the set of transactions for the new user. Unfortunately, I
>> could not seem to get gnucash to import its own transaction CSV file.
>> It seems to want a transaction on each line, not broken into splits.
>> dropping the split info means I need to reassign the transactions to
>> the proper account, so I might as well just create each transaction
>> manually.
>>
>> So, is there a better way to create a bunch of identical transactions,
>> one per month for the previous year, from a number of different
>> accounts all into one income account?
>>
>
> Is Gnucash the right tool to be keeping track of your membership dues?
>
> If it was me, and if I understand it correctly to be historical data I
> would do exactly one transaction.
>
> Revenue:Membership Dues  ---     Yearly Fees All Members     $xxx
>
> Assets:Bank Account  ---  Yearly fees all Members $xxx
>
>
>
> Done.
>
> I used to be crazy about stuff like this until I realised time playing
> with my kids is more important than book entries no ones looks at. YPMV
>
> Cheers
>
> Lawrence
>
>
>
>> Thanks in advance.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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 at gnucash.org
> 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.
>