Balance Calculation

Hi,

Attached file has payment updates.
Help me to calculate the balance after each payment made.

Thanking you in advance.

Thank you for your response,

Column D is the total amount payable for the product. Column E is the advance he paid. Balance is in the Column F which he will pay in installments; he gives the cheque in advance.

Each time the cheque gets cleared, the status will update to "Cleared". Then it will deduct from his balance payment and will show the Total Paid in column L and the balance in Column M.

Please find the original file for your better understanding.
I need to generate customerwise report when we input Customer name. based on the data.
If anything simple way, please help.

Shaj