Docs
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 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.
|
| 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.
|
| Unutilised Credits | Unutilized credit is the total amount that is not adjusted against the customer's invoice.
|
| Overdue | The amount which has not been paid by the customers on a payment due date.
|
| 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.
|
| Overdue Amount | The amount which has not been paid by the customers on due date.
|
| Net Overdue Amount | The total amount from open/overdue invoices, debit notes, and amount from debit entries.
|
| Opening Balance | Total balance that is brought forward at the beginning of the accounting period from the previous financial period.
|
| Debit Amount | Total debit amount in AR that customer's owes to the company.
|
| Credit Amount | Total credit amount in AR that a company owes to the customers.
|
| Total Sales | Sales in AR is the amount generated from selling goods or services to the customers.
|
| Received | Total amount received from the customers during a specific period.
|
| Closing balance | Total balance in AR at the end of a particular chosen accounting period.
|
| 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.
|
| Open Debits | The total amount from all the invoices that are recorded but not yet paid by the customers.
|
| Unutilised Credits | Unutilized credit is the total credit amount that is not adjusted against the customer's invoice.
|
| Unaccounted Payment | Unaccounted payment indicates the payment which are not reconciled with invoices.
|
| 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.
|
| Net Ageing(as on date) | Net Ageing is the overall amount from outstanding invoices during the current and previous ageing period.
|
| 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.
|
| {{overdueAmount}} | The amount which has not been paid by the customer on payment due date.
|
| {{netOverdueAmount}} | The Net amount from open/overdue invoices, debit notes, and amount from debit entries.
|
| {{balanceAmount}} | Total balance amount from invoices which are overdue and NOT yet paid by the customer.
|
| {{unaccountedPayment}} | Unaccounted payment indicates the total amount which has not been tracked and collected from customer.
|
| {{ageingSummary}} | The ageing summary represents the overall length of time during which the invoices has been outstanding.
|
| {{netAgeingSummary}} | Net Ageing summary is overall amount calculated based on the {{ageingSummary}}.
|
| 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.
|
| Open Invoice/Debits | The total amount from all the invoices that are recorded but not yet paid by the customers.
|
| Unutilised Credits | Unutilized credit is the total amount that is not adjusted against the customer's invoice.
|
| Unaccounted Payment | Unaccounted payment indicates the total amount which has not been tracked and collected from customer.
|
| Overdue Amount(as on date) | The amount which has not been paid by the customer on a payment due date.
|
| Net overdue Amount(as on date) | Total amount required to be paid by the customer based on the billing date.
|
