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.
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.
<tbody>
<tr>
<th class="cbDocsTh">AR Master Report Aggregated Columns(In Company's Base Currency)</th>
<th class="cbDocsTh">Description/Formulae</th>
</tr>
<tr>
<td class="cbDocsTd">Outstanding</td>
<td class="cbDocsTd">The total amount that customers owe to the company as on date.<p>
<br/><strong>Calculation:</strong> Total Outstanding = [(Total Debit amount as on date) - (Total
Credit amount as on date)].</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Overdue Amount</td>
<td class="cbDocsTd">The amount which has not been paid by the customers on due date.<p>
<br/><strong>Calculation:</strong> Total amount due post the completion of payment period.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Net Overdue Amount</td>
<td class="cbDocsTd">The total amount from open/overdue invoices, debit notes, and amount from debit
entries.<p><br/><strong>Calculation:</strong> Net overdue amount= Total debit balance(overdue) - Total
credit balance.</p>
</td>
</tr>
<tr>
<tr>
<td class="cbDocsTd">Opening Balance</td>
<td class="cbDocsTd">Total balance that is brought forward at the beginning of the accounting period from
the previous financial period. <p><br/><strong>Calculation:</strong> Opening balance= [(Total debit
amount as on opening date) - (Total credit amount as on the opening date)].</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Debit Amount</td>
<td class="cbDocsTd">Total debit amount in AR that customer's owes to the company.<p>
<br/></strong>Calculation:</strong> Debit Amount= Total amount debited during the period.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Credit Amount</td>
<td class="cbDocsTd"> Total credit amount in AR that a company owes to the customers.<p>
<br/><strong>Calculation:</strong>Credit Amount = Total amount credited during the period.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Total Sales</td>
<td class="cbDocsTd">Sales in AR is the amount generated from selling goods or services to the customers.<p>
<br/><strong>Calculation:</strong> Total Sales = Billed amount - Refund amount during the specific
period.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Received</td>
<td class="cbDocsTd">Total amount received from the customers during a specific period.<p>
<br/><strong>Calcultation:</strong> Received = Total debit - refund amount during the specific
period.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Closing balance</td>
<td class="cbDocsTd">Total balance in AR at the end of a particular chosen accounting period.<p>
<br/><strong>Calculation:</strong> Closing Balance = Credit balance - Debit balance as of the closing
date.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Daily Sales Outstanding(DSO)</td>
<td class="cbDocsTd">A DSO trend in analytics measures the average number of days it takes businesses to
collect payment for products and services sold.<p><br/><strong>Calculation:</strong> Total closing
balance divided by total sales for the period x N
,where N= Number of days in the period.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Open Debits</td>
<td class="cbDocsTd">The total amount from all the invoices that are recorded but not yet paid by the
customers.<p><br/><strong>Calculation:</strong> Open Debits = Total debit balance as on date.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Unutilised Credits</td>
<td class="cbDocsTd"> Unutilized credit is the total credit amount that is not adjusted against the
customer's invoice.<p><br/><strong>Calculation:</strong> Unutilised Credit = Total unadjusted credit
amount as on date.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Unaccounted Payment</td>
<td class="cbDocsTd">Unaccounted payment indicates the payment which are not reconciled with invoices.<p>
<br/><strong>Calculation:</strong> Unaccounted Payment = Total payment amount that is NOT reconciled
for the specific period.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Adjustment</td>
<td class="cbDocsTd"> <strong>Calculation:</strong> Total credit balance during the specific period except
payments and credit notes.</td>
</tr>
<tr>
<td class="cbDocsTd">Ageing(For example, 1-30)(as on date)</td>
<td class="cbDocsTd">The ageing represents the length of time for which the invoices have been outstanding.
<p><br/><strong>Calculation:</strong> Total amount from overdue invoices with ageing period between 1-30
days.</p>
</td>
</tr>
<tr>
<td class="cbDocsTd">Net Ageing(as on date)</td>
<td class="cbDocsTd">Net Ageing is the overall amount from outstanding invoices during the current and
previous ageing period.<p><br/><strong>Calculation:</strong> Net Ageing = [(Total debit amount(overdue)
as on date) - (Total credit(overdue) as on date)]. </p>
</td>
</tr>
</tbody>
| 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
|
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.
|
Was this article helpful?