I am hoping that someone may be able to point me to some reading or perhaps a ready built schema for a loan repayment schedule.

Here is what I am trying to do I want to be able to track loan repayments on a fixed term loan ie say 60 months with a 60 repayments of x pounds per month.

I need to be able to have the system flag up a overdue payments record the amount paid, and also be able to handle over and under payments as well as calaculate the repayment history ie % of payments on time late or early.

Anybody any idea where I can look.

Thanks