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 1 month 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.