Feature Requests
Share ideas, discuss and vote on requests from other users in community

# Auto-calculate interest on overdue invoices.

Will Barraclough shared this idea 3 years ago
Under Consideration

I think it would be a great feature if the following were to be implemented:

Interest automatically calculated on overdue invoices at the end of every month based on predefined settings.

1. Example
2. Assuming interest is 4%, and is applicable after 60 days.

3. Invoice of £1000 is due January 31st 2017. Reminders are sent as defined in WHMCS settings. When 60 days have passed, the date will be April 1st 2017, and so on the 30th April (end of the month), the system calculates and applies the interest to that invoice, which in this case would be £13.20.

4. The calculation based on the assumptions of this example are

5. £1000 x 0.04 (4%) = £40
6. £40 / 365 (days in year) = 11p per day
7. 11p x 120 days overdue = £13.20

8. If the invoice is then not paid by the end of May, the system should calculate, on 31st May, the interest based on the original amount overdue, now for 151 days, and so the calculation would be:

9. £1000 x 0.04 (4%) = £40
10. £40 / 365 (days in year) = 11p per day
11. 11p x 151 days overdue = £16.61
12. Bare in mind it would have already added £13.20 of this to the invoice, and so would need to add £3.41 to make up the interest for May.

To accompany the above, it would be nice to see a button within the invoice view that calculates and adds the interest up until the current date so that if we need an up to date outstanding amount in the middle of the month, we can get it. 1

I like this idea -- the standard way of accepting overdue payments is actively complained about. Either the late fee is too expensive or noticeably too cheap. 1

Yes, the late fees should be much better.

Ideally we'ld set what % they are and from what day (with what amount as minimum) they start and let them recalculate every day.

That way they pay for each day they are late as this seems fairest and most correct