Finance Charges Calculation Formula – PART 1
Settings
- Tick “Finance Charge”
- Insert Number for Annual Interest Rate (%)
- Select “Due Date”
Calculation for January
= [(Jan Invoice Amount x Annual Interest Rate) x (Total Day of Jan – Due Date)] / 365
Calculation for February
= [(Feb Invoice Amount x Annual Interest Rate) x (Total Day of Feb – Due Date)] / 365
+ [(Jan Invoice Amount x Annual Interest Rate) x Total Day of Feb] / 365
Calculation for March
= [(Mar Invoice Amount x Annual Interest Rate) x (Total Day of Mar – Due Date)] / 365
+ [(Feb Invoice Amount x Annual Interest Rate) x Total Day of Mar] / 365
+ [(Jan Invoice Amount x Annual Interest Rate) x Total Day of Mar] / 365
Calculation for April
= [(Apr Invoice Amount x Annual Interest Rate) x (Total Day of Apr – Due Date)] / 365
+ [(Mar Invoice Amount x Annual Interest Rate) x Total Day of Apr] / 365
+ [(Feb Invoice Amount x Annual Interest Rate) x Total Day of Apr] / 365
+ [(Jan Invoice Amount x Annual Interest Rate) x Total Day of Apr] / 365
Finance Charges Calculation Formula – PART 2
Settings
- Tick “Finance Charge”
- Insert Number for Annual Interest Rate (%)
- Tick “Include Overdue Finance Charges When Calculate Finance Charges”
- Select “Due Date”
- Set 10 Days Term (Set at Debtor or Invoice)
Calculation for January
= [(Jan Invoice Amount x Annual Interest Rate) x (Total Day of Jan – Due Date - Term)] / 365
Calculation for February
= [(Feb Invoice Amount x Annual Interest Rate) x (Total Day of Feb – Due Date - Term)] / 365
+ [(Jan Invoice Amount x Annual Interest Rate) x Total Day of Feb] / 365
+ [(Jan Finance Charges x Annual Interest Rate) x (Total Day of Feb - Term)] / 365
Calculation for March
= [(Mar Invoice Amount x Annual Interest Rate) x (Total Day of Mar – Due Date - Term)] / 365
+ [(Feb Invoice Amount x Annual Interest Rate) x Total Day of Mar] / 365
+ [(Jan Invoice Amount x Annual Interest Rate) x Total Day of Mar] / 365
+ [(Feb Finance Charges x Annual Interest Rate) x (Total Day of Mar - Term)] / 365
+ [(Jan Finance Charges x Annual Interest Rate) x Total Day of Mar] / 365
Calculation for April
= [(Apr Invoice Amount x Annual Interest Rate) x (Total Day of Apr – Due Date - Term)] / 365
= [(Mar Invoice Amount x Annual Interest Rate) x Total Day of Apr] / 365
+ [(Feb Invoice Amount x Annual Interest Rate) x Total Day of Apr] / 365
+ [(Jan Invoice Amount x Annual Interest Rate) x Total Day of Apr] / 365
+ [(Mar Finance Charges x Annual Interest Rate) x (Total Day of Apr - Term)] / 365
+ [(Feb Finance Charges x Annual Interest Rate) x Total Day of Apr] / 365.
+ [(Jan Finance Charges x Annual Interest Rate) x Total Day of Apr] / 365
Please download from the attachment, Thank you :)
Download link HERE
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article