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: 190 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
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
08 October 2026
SALES TELECALLER

HIRE NOVA

Lucknow

Graduate (Any)

View Details
Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

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

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details