Payment schedule

This query is : Resolved

SURENDRA YERNAL (Querist)
Follow

27 May 2013 Sir,
Today I want to commit a payment to a vendor on a future date considering my anticipated receipts as well as payments. Is there is any excel template for such transactions ?

Thanks in advance.

P B Srivathsan

P B Srivathsan (Expert)
Follow

28 May 2013 Can you provide more inputs?

Is he vendor of capital goods?

is the vendor payment made in one lot or multiple and the frequency if it is multiple.

You want to use your net cash increase from time to time to pay your vendor, right?

any further information you could provide would be of help.

SURENDRA YERNAL

SURENDRA YERNAL (Querist)
Follow

29 May 2013 Sir,
Thanks for your reply. Vendor is a material supplier. His PO term is 30 days after material GRN and acceptance. The funds considered are the cash balance and bank balance through which the payment is to be made.

Case details :
Varient Enterprises supplies various types of materials i.e. rubber, plastic items to our company (as usual) on 15.05.2013. PO term is 30 days after Goods Receipt Note (GRN) and material acceptance (within 2 days after GRN). The payment of this supply is due on 17.06.2013. Hence i want to commit this vendor a payment of Rs.1.50 Lacs against this supplies. Considering my bank balance on 17.06.2013, how can i commit him the payment ?

Hope now the above details are clear. So please suggest a excel template/methodology of handling such commitments.

Thanks

Upgrade to CAclubindia Pro. Subscribe Now!

P B Srivathsan

P B Srivathsan (Expert)
Follow

29 May 2013 I have put together a simple spreadsheet. I shall upload it to the query soon.

P B Srivathsan

P B Srivathsan (Expert)
Follow

29 May 2013 I am not able to upload the excel here. So, opening the query again.

SURENDRA YERNAL

SURENDRA YERNAL (Querist)
Follow

29 May 2013 Sir,

I appreciate your efforts to help me.

Could please email me the excel sheet to : surendragyernal@gmail.com

Thanks
Surendra Yernal

SURENDRA YERNAL

SURENDRA YERNAL (Querist)
Follow

30 May 2013 Sir,
Many thanks for your excel file. It is really helpful for me. I appreciate your positive approach in solving my query.

Thanks & regards.

P B Srivathsan

P B Srivathsan (Expert)
Follow

30 May 2013 You are welcome.

Upgrade to CAclubindia Pro. Subscribe Now!