Interest calculation on customer late payment

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: 181 times
Replies (1)

is there any expert to solve this query.?

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
24 August 2026
Semi-Qualified CA/CA Finalist - Tax, GST, Audit & Accounts

Bharat Shah & Associates

Mumbai

CA Inter

View Details
Company
14 August 2026
Semi Qualified

Goyanka & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 25 August 2026
CA Article's

Saini Pati Shah & Co LLP

Mumbai

CA Inter

View Details
Company
25 August 2026
Senior Accountant

MG Associates

New Delhi

CA Inter

View Details
Company
13 August 2026
Chartered Accountant (FP&A)

Client of Trellis Consulting

Gurgaon

CA

View Details
Company
18 August 2026
CA Semi Qualifies

Goyanka and Associates

New Delhi

CA Inter

View Details
Company
21 August 2026
Finance Manager

Resollect Technologies Pvt Ltd

Mumbai

CA

View Details