Interest calculation on customer late payment

687 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: 174 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
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details