How to apply interest to balance in accounts

  • Thread starter Thread starter stanleypatkan
  • Start date Start date
S

stanleypatkan

I have several accounts in a database. At the end of a quarter an interest
rate is applied to the balance of each account which is then listed as an
earning. My question is should this be done as part of a query or should a
special program be written that requests the percent rate and then each table
be read and updated.
 
Hi Patricia

Usually an interest payment would just be recoded as another (credit)
transaction on the account. That is presumably not a problem as you must
already have a means of recording credit and debit transactions.

The problem is ascertaining the balance on which to perform the interest
calculation. Usually the balance used to calculate interest is either:
1. balance at end of period or
2. minimum balance during period or
3. average balance during period

Option #1 is easy - just a sum of all the credits and debits up to the date
on which the interest is calculated.

The other two are trickier. Post back if you need to use one of them.
 
Back
Top