How to design a data sheet to calculate the function of fines?

super_gem

Similar liquidated damages (calculated based on expiration time)

So, how to store records, calculations and queries that can be easily implemented?

Some of the currently designed accounts have the following fields:
uid item subject period total received ...

The receivables and received are in it ~

unkmass

There should also be date information, such as the payment date, the time of the fine ...

super_gem

Back upstairs, some ~ period is equivalent to the date, the expiration time is set in another table ...

However, how to calculate is not a problem. The problem is how to store the penalties so that you can easily perform functions such as query and calculation ...

Do you have any good ideas?