Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Bill wise payment in excel

Avdhoot (Finance Manager) (35 Points)

31 January 2014

How can i make the bill wise payment in excel sheet. pls guide me

Reply
Follow
Share

2 Replies

Vinoth (Assistant Manager Finance) (166 Points)
Replied 14 April 2014

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?

Upgrade to CAclubindia Pro. Subscribe Now!

Avdhoot (Finance Manager) (35 Points)
Replied 18 April 2014

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.