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

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.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

K.S. ANANTHARAJAN

Rohit Paranjape

jagadheswar goud

Gokula Krishna Murthy Rao

S D Kannan

Subscribe Now

Payment schedule

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA