Making Invoice or Statment

Hello Excel Champs !

I would like to make a Customer Statement which show the complete history for Payment dues, receipt and etc. All this data need to be shown in statement date wise.

Please advise what is the best way to do it or share any good layout ??

thanks i have chosen one invoice.. i have the following requirement, i hope its not too much to ask, please see the attached

1. i want to calculate rent automatically from the start date till current today (month wise breakup) with due date mentioned on it.
2. get payment detail from the other sheets named "receivable" , "toll" and "fines" against the car no and customer number.
3. Is possible to sort date wise data automatically

is there anyone out there who could help me