Hello,
I have previously set up invoicing templates for clients and am very competent in setting calculations in excel. The most recent client I have set this up for had progress payment requirements, e.g. 10% for deposit, 40% upon installation, 40% on implementation and 10% on final commissioning. This was easy to set up and saved approximately 10 hours a week for the client when completing invoicing at the end of each week.