What to Track? How to Calculate?

Is improving your AR worth it?

KPI Calculators V2.png

AR and Collections

KPI Calculators

What gets measured, gets improved! This is true for almost everything that keeps the cash registers ringing.  When it comes to Managing AR and Collections, what are the top KPIs that one can measure? Here are a few easy to use calculators for you.

Also find a link to a nifty ROI calculator. That helps you to figure out if improving your Receivables and Collections process  is worth spending your precious budgets or not.

Top KPIs that need your attention

DSO

Make this yours. Add images, text and links, or connect data from your collection.

CEI

Make this yours. Add images, text and links, or connect data from your collection.

 Avg Delinquency

Make this yours. Add images, text and links, or connect data from your collection.

Turnover Ratio

Make this yours. Add images, text and links, or connect data from your collection.

Outstanding Balance


Money that has not yet been paid and is still owed to company. Outstanding = ΣDebit Balance - ΣCredit Balance as on date




Overdue Amount


A sum of money which should already have been paid but has not been. Overdue = ΣDebit Balance which are overdue as on date




Net Overdue Amount


A total sum of money which should already have been paid but has not been. Net overdue = ΣDebit Balance(overdue) - ΣCredit Balance




Unutilised Credits


A refund of unutilised input tax credit at the end of any tax period. Unutilised Credits = ΣCredit Balance for selected period/date range





Other Metrics of Interest

Outstanding Balance


Money that has not yet been paid and is still owed to company. Outstanding = ΣDebit Balance - ΣCredit Balance as on date




Overdue Amount


A sum of money which should already have been paid but has not been. Overdue = ΣDebit Balance which are overdue as on date




Net Overdue Amount


A total sum of money which should already have been paid but has not been. Net overdue = ΣDebit Balance(overdue) - ΣCredit Balance




Unutilised Credits


A refund of unutilised input tax credit at the end of any tax period. Unutilised Credits = ΣCredit Balance for selected period/date range





Outstanding Balance


Money that has not yet been paid and is still owed to company. Outstanding = ΣDebit Balance - ΣCredit Balance as on date




Overdue Amount


A sum of money which should already have been paid but has not been. Overdue = ΣDebit Balance which are overdue as on date




Net Overdue Amount


A total sum of money which should already have been paid but has not been. Net overdue = ΣDebit Balance(overdue) - ΣCredit Balance




Unutilised Credits


A refund of unutilised input tax credit at the end of any tax period. Unutilised Credits = ΣCredit Balance for selected period/date range





Graphs of Interest

Collection Due vs Actual Graph


/*Definition*/ Collection Due = ΣDebit Balance due in a period Collection Actual = ΣCredit Payment Amount - ΣDebit Payment Amount in a period




Clearing Report


A report that denotes all activities from the time a commitment is made for a transaction until it is settled. Overdue = /*Formula*/ Current Due = /*Formula*/





Curious? Let's talk?

Give us your details and we'll get in touch with you on priority!