The new version of the calculator complete the features of the first tool.It calculates the amount of delay penalties according to the due date of each invoice and the payment date if it is filled or the current date if it is not.
The tool also includes fixed collection fee compensation of € xx owed for each invoice overdue.
Finally, it gives the amount of late payment penalties by invoice, the total penalties and the total of the fixed cost plus penalties.
Excel is still as simple to use and lets face several situations, for example, calculation of delay penalties on a batch of invoices paid (late) at different dates.
See the tool and read the tutorial about late payement penalties.