Allocate invoice payment clearance dates to partially paid invoices Automatically

Hii,
Pls help, i have table showing the customers invoices and the partial payments made against them and i want to allocate the accurate final paid date for the every invoice calculating the sum of partial payment made against the invoices

I have done the same task manually in below attached table and i want to automate the same using some conditional formula or VBA