How to add interest up to today's date?

John Bibby johnbibbyjohnbibby at gmail.com
Sun Mar 11 09:55:33 EDT 2012


I am surprised if it cannot be automated - as any spreadsheet programme
could calculate it using the parameter

Today'sDate - LastBalanceDate

or similar.

With GnuCash I have no conception of where I should store the rate of
interest, yet it is about the most important parameter for tracking cash
investments.

Thanks for any further help.

JOHN B

On 11 March 2012 13:18, David Carlson <carlson.dl at sbcglobal.net> wrote:

> On 3/11/2012 3:56 AM, John Bibby wrote:
> > It seems a rather simple piece of functionality: I just want the option
> to
> > add a notional value  B * R * T where B was the previous balance, R is
> the
> > rate of interest, and T is the time elapsed.
> >
> > I agree that some people may not use this & might regard it as
> > "theoretical" (like John Layman) rather than "actual" -but it is the
> amount
> > that would be added if I went to close the account today - so it is
> actual
> > enough for me!
> >
> > At present however, I do not even know how I should store the rate of
> > interest in Gnucash.
> >
> > Any advice/comments please?
> >
> > JOHN BIBBY
> >
> >
> >
> > On 10 March 2012 19:25, John Layman <john.layman at laymanandlayman.com>
> wrote:
> >
> >> Furthermore, while interest accrues day by day, it isn't actually added
> to
> >> an account until a certain point in time.  Since the purpose of GnuCash
> is
> >> to track the actual value of an account (rather than some theoretical
> >> value)
> >> it wouldn't make sense to show accrued interest other than in a separate
> >> accrual account.
> >>
> >> -----Original Message-----
> >> From: gnucash-user-bounces+john.layman=laymanandlayman.com at gnucash.org
> >> [mailto:gnucash-user-bounces+john.layman=
> laymanandlayman.com at gnucash.org]
> >> On
> >> Behalf Of David Carlson
> >> Sent: Friday, March 09, 2012 8:19 PM
> >> To: gnucash-user at gnucash.org
> >> Subject: Re: How to add interest up to today's date?
> >>
> >> On 3/9/2012 12:29 PM, Shokster wrote:
> >>> I too am keen to see this question answered!
> >>>
> >>> --
> >>> View this message in context:
> >>> http://gnucash.1415818.n4.nabble.com/How-to-add-interest-up-to-today-s
> >>> -date-tp4456467p4460262.html Sent from the GnuCash - User mailing list
> >>> archive at Nabble.com.
> >>> _______________________________________________
> >>> 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.
> >>>
> >>
> >> There are almost as many different ways to calculate interest as there
> are
> >> lenders who charge interest.  Which method would you propose to use?
> >>
> >>
>
> Then create a scheduled transaction to repeat over your interval T, and
> when it comes up, look in your register at the balance, and calculate
> the number.  If there is a way automate finding B, I do not know about
> that.
>
> David
>
>
> _______________________________________________
> 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.
>


More information about the gnucash-user mailing list