Bill wise payment in excel

Billwise details to be kept in excel

1. Due date wise it is to be sorted

2. Select the bill list upto today for making payment

3. Update the excel with paid details

4. Update excel with purchase everyday/every month

What exactly you need?

Sir,

I want the excel report which will give me the bill wise status for make payment, for example if our suppiler has give us 21 days credit (but we made payment in round up payment not excat of bill amount) the report will be show me the report as basis of FIFO what excat amount will be paid to supplier. Can u guide me.