Payment schedule


This query is : Resolved 

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.

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.

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

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

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

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

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.

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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details