[GNC] Set up GnuCash to track monthly net income considering taxes and pension fund contributions

[john]

That is an *excellent* tip! Care to add it to the wiki?

Regards,
John Ralls

> On Sep 25, 2021, at 7:06 AM, Robin Chattopadhyay <robinraymn at gmail.com> wrote:
> 
> You can achieve the ad-hoc nature of a templated transaction by setting the
> frequency of the scheduled transaction to 'Once'.
> 
> Set up your scheduled transaction, set the frequency to 'Once', run the
> scheduled transactions/Since Last Run option, fill in the variables, then
> proceed.
> 
> The next time you want to run that specific template, edit the scheduled
> transaction by changing the start date and running the scheduled
> transaction process again.
> 
> Robin
> 
> On Sat, Sep 25, 2021 at 5:12 AM Christopher Lam <christopher.lck at gmail.com>
> wrote:
> 
>> The only mechanism that really exists to have "templated arbitrary
>> formulas" is to use the periodic Scheduled Transactions. It would be nice
>> to have them created ad-hoc (ie menu item Create Transaction from Template
>> which pops up a list of available templates)  instead of periodically...
>> 
>> On Sat, 25 Sep 2021, 5:34 pm Simone Gaiarin, <simgunz at gmail.com> wrote:
>> 
>>> Thanks for the reply Rich.
>>> 
>>> My main question is: is there a way to automate these calculations in
>>> GNUCash or for each transaction I need to compute and input each
>> component
>>> of the income by hand?
>>> I have read the GNUCash documentation but I was not able to figure out if
>>> this is possible or not.
>>> 
>>> On Sun, Sep 19, 2021 at 8:32 AM Simone Gaiarin <simgunz at gmail.com>
>> wrote:
>>> 
>>>> Hi all,
>>>> I need help in setting up GnuCash to achieve the following goal:
>>>> - Track my monthly net income (after taxes and pension fund
>> contribution)
>>>> 
>>>> Situation:
>>>> I give a service that I invoice per hour and the cost paid by the
>>> customer
>>>> consists of the following components:
>>>> 
>>>> x: Cash payment = y + p1
>>>> y: Service gross cost
>>>> p1: 1st pension fund contribution = 0,02 * y
>>>> 
>>>> On y I have to pay also:
>>>> t1: tax I have to pay = 0,05 * y
>>>> p2: 2nd pension fund contribution = 0,10 * (y - t1)
>>>> 
>>>> Accounts:
>>>> 
>>>> - Income
>>>> 
>>>> - Bank Account
>>>> 
>>>> - Tax
>>>> - Pension fund
>>>> 
>>>> Given that I pay out of my bank account the taxes twice a year and the
>>>> contribution to the pension fund twice a year, the 'Income chart'
>> report
>>>> does not give me a clear view of my net income over the month.
>>>> 
>>>> I tried to set up a tax table where I used some equivalent coefficients
>>> in
>>>> order to automatically assign t1 to Tax account and p1, p2 to the
>> Pension
>>>> fund account (rather difficult given that here the tax and pension fund
>>> are
>>>> computed in cascade), but I wonder if this is the correct strategy (the
>>>> Pension fund account goes negative instead of positive for example).
>>>> 
>>>> What is the correct way to proceed in order to obtain a monthly net
>>> income
>>>> chart considering the taxes and pension fund contribution percent over
>>> each
>>>> customer payment?
>>>> 
>>>> Thanks
>>>> 
>>>> 
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -----
>>> 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
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.