amend transactions programmatically

[Jannick Asmus]

Tarlika,

On 30.04.2008 00:26, Tarlika Elisabeth Schmitz wrote:
> On Tue, 29 Apr 2008 17:18:42 -0400
> Derek Atkins <warlord at MIT.EDU> wrote:
> 
>> Hi,
>>
>> Quoting Tarlika Elisabeth Schmitz <gnucash at numerixtechnology.de>:
>>
>>> I have hundreds of split transactions, which I would like to
>>> "unsplit":
>>>
>>> 1 split transaction: net interest + tax = gross interest
>>>
>>> =>
>>>
>>> 1 debit gross interest
>>> 2 credit tax
>> You're not showing the full transaction here, only half.  What's the
>> other half look like?   How did these transactions get created?  And
>> why do you want to turn them into multiple transactions?
> 
> see
> https://lists.gnucash.org/pipermail/gnucash-user/2008-April/024985.html
> 
> I have:
> Assets:Bank:Account
> Income:Interest
> Liability:Tax
> 
> At the moment, I am recoding gross interest - tax deduction as a split
> resulting in net interest in Assets:Bank:Account.
> 
> With this set-up, I cannot produce the Transaction Report I need (see
> thread above). I want to be able to list the total gross interest per
> bank account for a fiscal year, and likewise the total tax deducted per
> bank account.
> 
> As far as I can see, I would be able to achieve this if I changed the
> way I record interest to:
> 
> t1 - gross interest: Assets:Bank:Account <=> Income:Interest
> t2 - tax deduction: Assets:Bank:Account <=> Liability:Tax
> 
> 
>>> I have looked at the XML data file. One should be able to do the
>>> change programmatically. The only problem I can see is the id
>>> string.

Do you need it within GC or would be some routine in Excel fine with you?

I am asking this, since I do my gross/tax/net transactions as splits as 
well and I need to export all my transactions out of GC for my tax 
accountant. She - or rather her program - expects my data on a gross 
basis, such that I had to eliminate all the tax splits. If some 
(relative to GC) external solution would be helpful for you, just give 
me a shout.

I hope that I could make my question clear. Please do not hesitate to 
ask if there is anything unclear or you have more questions on this.

>> You could write a small program to do it, either in C or Scheme,
>> using the GnuCash API.  The pseudo-code would look something like:
>> ...
> 
> Thanks for the tip.
> 
> 
> --
> 
> 
> Best Regards,
> 
> Tarlika Elisabeth Schmitz

Best wishes,
J.