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: 189 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
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
06 October 2026
Assistant Manager - Audit and Compliance

Ravi K Jain & Co

Noida

Others

View Details
Company
ARTICLESHIP 07 October 2026
Article Trainee/ CMA Trainee

RMA And Associates LLP

New Delhi

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
08 October 2026
Account Executive

Elite Taxation

New Delhi

CA Foundation

View Details
Company
ARTICLESHIP 08 October 2026
ARTICLE TRAINEE

S.B.G. & CO. CHARTERED ACCOUNTANTS

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details