Purchase orders tracking

Hello, Good Morning.

I am tracking my customer purchase orders in excel sheet, if I miss to check the balance for next month invoicing, I can’t bill that month hours to my customers. Most of the times I am failing to check this, resulting last minute follow-up with customer.

I want to automate this process, if some alerts get from system that will save my lot of time. My company is not in the position to invest on some tracking tool

Kindly check the attached file and help me.

Regards
Sagar

Hi, thank you very much for your immediate reply, my wish is if the mail comes to me that will help a lot and that can be forwarded to my sales team, we can check manually for smaller customers with few purchse orders, if it is more than 100 POs for one customer difficult to track

so help us with some macro

Regards
Sagar