Daily Compounded Interest Calculator for overdue invoices

I need an Excel tool to calculate daily compounded interest on outstanding business accounts. The tool should be able to work with full transaction histories. Some invoices will have partial payments to be applied until fully paid

Requirements:
- Input: Full transaction history (dates, balances, rates)
- Output: Daily interest amounts

Ideal Skills:
- Proficiency in Excel
- Knowledge of compound interest calculations