Finance Charges : Calculation Formula

Created by Faradyana Azman, Modified on Fri, 20 Nov, 2020 at 4:21 PM by Faradyana Azman

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article