Receivables Metrics Formulae 

The metrics bar statistics and data columns in Receivables modules display important aggregated data associated with account receivables summary and financial activities.
The following table displays the formula used to calculate various metrics and data columns in Receivables.

Receivables View Metrics 

Receivables Top Metrics (In Company's Currency) Description/Formulae
Total Outstanding Total outstanding is the amount that customers owe to the company as on date. It is calculated by deducting the total credit amounts from the total debit amount.


Calculation: Total Outstanding = [(Total Debit amount as on date) - (Total Credit amount as on date)].
Open Invoice/Debits The total amount from all the invoices and debit entries such as debit notes that are recorded but not yet paid by the customers.


Calculation: Amount in Open Invoice/Debits = Total balance from outstanding invoices that is NOT yet paid by the customers.
Unutilised Credits Unutilized credit is the total amount that is not adjusted against the customer's invoice.


Calculation:Unutilised Credit = Total amount that is NOT adjusted against customer's invoices as on date.
Overdue The amount which has not been paid by the customers on a payment due date.


Calculation: Overdue = Total amount due post the completion of payment period.

AR Master Reports 

AR Master Report Aggregated Columns(In Company's Base Currency) Description/Formulae
Outstanding The total amount that customers owe to the company as on date.


Calculation: Total Outstanding = [(Total Debit amount as on date) - (Total Credit amount as on date)].
Overdue Amount The amount which has not been paid by the customers on due date.


Calculation: Total amount due post the completion of payment period.
Net Overdue Amount The total amount from open/overdue invoices, debit notes, and amount from debit entries.


Calculation: Net overdue amount= Total debit balance(overdue) - Total credit balance.
Opening Balance Total balance that is brought forward at the beginning of the accounting period from the previous financial period.


Calculation: Opening balance= [(Total debit amount as on opening date) - (Total credit amount as on the opening date)].
Debit Amount Total debit amount in AR that customer's owes to the company.


Calculation: Debit Amount= Total amount debited during the period.
Credit Amount Total credit amount in AR that a company owes to the customers.


Calculation:Credit Amount = Total amount credited during the period.
Total Sales Sales in AR is the amount generated from selling goods or services to the customers.


Calculation: Total Sales = Billed amount - Refund amount during the specific period.
Received Total amount received from the customers during a specific period.


Calcultation: Received = Total debit - refund amount during the specific period.
Closing balance Total balance in AR at the end of a particular chosen accounting period.


Calculation: Closing Balance = Credit balance - Debit balance as of the closing date.
Daily Sales Outstanding(DSO) A DSO trend in analytics measures the average number of days it takes businesses to collect payment for products and services sold.


Calculation: Total closing balance divided by total sales for the period x N ,where N= Number of days in the period.
Open Debits The total amount from all the invoices that are recorded but not yet paid by the customers.


Calculation: Open Debits = Total debit balance as on date.
Unutilised Credits Unutilized credit is the total credit amount that is not adjusted against the customer's invoice.


Calculation: Unutilised Credit = Total unadjusted credit amount as on date.
Unaccounted Payment Unaccounted payment indicates the payment which are not reconciled with invoices.


Calculation: Unaccounted Payment = Total payment amount that is NOT reconciled for the specific period.
Adjustment Calculation: Total credit balance during the specific period except payments and credit notes.
Ageing(For example, 1-30)(as on date) The ageing represents the length of time for which the invoices have been outstanding.


Calculation: Total amount from overdue invoices with ageing period between 1-30 days.
Net Ageing(as on date) Net Ageing is the overall amount from outstanding invoices during the current and previous ageing period.


Calculation: Net Ageing = [(Total debit amount(overdue) as on date) - (Total credit(overdue) as on date)].

Email/SMS Template Variables 

Template Variables (In Customer's Currency) Description/Formulae
{{totalOutstandingAmount}} Total outstanding is the amount that customers owe to the company as on date. It is calculated by deducting the total credit amounts from the total debit amount.


Calculation: Total Outstanding = [(Total Debit amount as on date) - (Total Credit amount as on date)].
{{overdueAmount}} The amount which has not been paid by the customer on payment due date.


Calculation:Overdue amount = Total amount due post the completion of payment period.
{{netOverdueAmount}} The Net amount from open/overdue invoices, debit notes, and amount from debit entries.


Calculation: Net overdue amount = Total debit balance(overdue) - Total credit balance.

{{balanceAmount}} Total balance amount from invoices which are overdue and NOT yet paid by the customer.


Calculation: Balance amount = Total of debit balance as on date.
{{unaccountedPayment}} Unaccounted payment indicates the total amount which has not been tracked and collected from customer.


Calculation: Unaccounted Payment = Total payment amount that is NOT reconciled for the specific period.
{{ageingSummary}} The ageing summary represents the overall length of time during which the invoices has been outstanding.


Calculation: Total amount from outstanding invoices during the ageing period.
{{netAgeingSummary}} Net Ageing summary is overall amount calculated based on the {{ageingSummary}}.


Calculation: Net ageing summary = Total debit balance(overdue) - Total credit balance as on date.

Self-Serve Client Portal Metrics 

Self Serve Client Portal Top Metrics(In Customer's Currency) Description/Formulae
Outstanding(as on date) Total amount that customer owes to the company as on date.


Calculation: [(Total debit amount as on date)- (Total credit amount as on date)].
Open Invoice/Debits The total amount from all the invoices that are recorded but not yet paid by the customers.


Calculation: Amount in Open Invoice/Debits= Total balance from outstanding invoices that is NOT yet paid by the customer.
Unutilised Credits Unutilized credit is the total amount that is not adjusted against the customer's invoice.


Calculation: Unutilised Credit = Total amount that is NOT adjusted against customer's invoices as on date.
Unaccounted Payment Unaccounted payment indicates the total amount which has not been tracked and collected from customer.


Calculation: Unaccounted Payment = Total payment amount not deducted against customer's invoices.
Overdue Amount(as on date) The amount which has not been paid by the customer on a payment due date.


Calculation: Overdue amount = Total amount due post the completion of payment period.
Net overdue Amount(as on date) Total amount required to be paid by the customer based on the billing date.


Calculation: Net Overdue amount = [(Total debit balance(overdue)as on date) - Total credit balance as on date)].
Was this article helpful?
Loading…