Receivable Over View

Dear all, 

Our current receivable has many terms such as advance payments / 30-45-60-120 days deferred.

We are maintaining it in an excel sheet but I am afraid some receivable might be missed.

 

What I am looking for is a sheet where I enter the customer invoice value and by when what percentage of that value will I receive. It will auto-populates in a calendar view.

Is there such a template for it.

Thanks in Advance