Interest calculation on customer late payment

688 views 1 replies

Dear Sir/Madam

 

I want to Calculate interest on Customers Late Payement @ 2% Per Month.Grace Period is 30 Days.Can any one help me to do this in Excel. Please find the attached file.and Kindly help me to calculate interest.Payment must be adjusted with invoices on FIFO Basis.I will be grateful if anyone help me to solve this out.Please Mail me @ abhishekp12in @ gmail.com if Solution found.

 

Thanks

Abhishek Sinha

 


Attached File : 590204 940962 interest calculation.xlsx downloaded: 175 times
Replies (1)

is there any expert to solve this query.?


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 June 2026
Sr. Associate / Assistant Manager | TAS / FDD

Boutique Investment Bank & Transaction Advisory Firm

Gurgaon

CA

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details