[GNC] scheduled transactions: simple or compound interest calculations in

Adrien Monteleone adrien.monteleone at lusfiber.net
Sun Oct 22 16:51:07 EDT 2023


See my reply in the thread titled "I need basic help" made today that 
gives an overview of Debits & Credits.

Your splits in that transaction should be something like:

Dr. Assets:Deposit Account (amount = cash + interest)
   Cr. Assets:Cash
   Cr. Income:Interest

(These are just general names, use whatever you like.)

You want to reflect the increase in the Deposit Account which is 
comprised of whatever source of funds (a decrease in Cash in the above 
example) and an increase in the Interest earned.

In this particular case, you are recording a shift in assets from one 
asset account to another, (Cash to Deposit Account) and also recording 
the realization of income and its transfer to one of those assets. (the 
Deposit Account)

Regards,
Adrien

On 10/22/23 3:36 PM, Name Same wrote:
> Hi Adrien,
> 
> Thanks for the reply, I figured out how to use the formula
> system with scheduled transactions with some trial-and-error.
> 
> I tried both a simple formula like 1000*4/100 for a recurring
> fixed 4% deposit, and a compounding formula, like:
> computeInterestIncrement( 1000.00 : 0.4 : 12 : i )
> which made me quite rich.
> 
> One thing I note is that in the transaction template, I had to show
> a debit action into the bank account, and a credit action from
> Income:interest to keep the sheet balanced. Is that the right thing to do?
> If I don't credit from income:interest, the interest deposited in the bank
> account shows under imbalance.



More information about the gnucash-user mailing list