ABL / BBC Review Manual-Input / Receivable Aging
Receivable Aging
The Receivable Aging page displays the system-defined and manually entered ineligibles and their values in each collateral. Even after manual entry, the ineligibles can be mapped and uploaded to this page. In the Receivable Aging page, the ineligibles mapped are updated accordingly with ineligible values in each collateral.
The Receivable Aging page shows the summary of the Accounts Receivable data for the BBC Period.
Users may manually enter the receivable aging information as required by clicking the button.
The Receivable Aging Total value gets updated on the Receivables Rollforward page.
Users can also view the details of the manually added ineligible amount and reasons for the receivables for the selected BBC date.
Types of BBC Data
Table of Contents |
Navigation: ABL → BBC Review Manual Input → Receivable Aging
Refer to the Screenshot:
Fields and Descriptions
Fields |
Descriptions |
Collateral Name |
Specifies the collateral name of the BBC data. |
Future |
Specifies the future value of the collateral. |
Current |
Specifies the current value of the collateral. |
Over 30 |
Specifies collateral value for over 30 days. |
Over 60 |
Specifies collateral value for over 60 days. |
Over 90 |
Specifies collateral value for over 90 days. |
Over 120 |
Specifies collateral value for over 120 days. |
Over 150 |
Specifies collateral value for over 150 days. |
BBC Date |
Specifies the BBC Date. |
Retention |
Specifies the retention value. |
AR Adjustment |
Specifies the adjusted account receivables. |
Ineligible Reason |
Specifies the manually entered ineligible reason. |
Ineligible Amount |
Specifies the manually entered ineligible amount. |
Cync Ineligible Amount |
Updates the Cync Ineligible amount (manual and system defined). |
Client Ineligible Amount |
Updates the Client ineligible amount (manual and system defined). |
Based on the ineligibles recorded, the total of those ineligibles is displayed with the collateral name “All” under the Receivable Aging page.
The ineligibles that are mapped and uploaded is carried forward up to next BBC until the user manually deletes that ineligible.
Refer to the screenshot:
If the file is uploaded with ineligibles mapping, where the mapped ineligible value is 'Blank' in the uploaded file, the system validates whether the particular ineligible is already existing as a manually entered ineligible in The Receivable Aging page of that collateral. If yes, the existing ineligible value will be overwritten to "0.00". If No, the ineligible value will not be recorded under the Receivable Aging page of that collateral after uploading the file.
If the file is uploaded with ineligibles mapping where the mapped ineligible value is 0.00 in the uploaded file, the ineligible value will be recorded in the Receivable Aging page of that collateral with the actual value (0.00).
If the file is uploaded with ineligibles mapping where the mapped ineligible value is non-numeric in the uploaded file, then the system shows a validation message as “Ineligible (Ineligible Reason) is a non-numeric value”.
This option allows the adjustment of the account receivables when the uploaded AR file does not match the client's BBC. You can adjust AR by clicking the button.
The total AR is calculated as follows;
Total Account Receivable = AR Adjustment + Total Receivables.
This value is independent of Manual BBC and the value has no dependency on Receivable Rollforward and aging overwrite options. The value is considered as eligible value and is not considered while calculating ineligible.
The entered adjustment AR details can be viewed under Receivable Rollforward, BBC Availability and management reports.
This displays the ineligible amount for receivables. The system calculates the ineligible amount based on the parameters set under the client basic parameters page. The same ineligibles will be posted to the BBC Availability page.
The system calculated ineligibles cannot be modified or deleted. For more information related to ineligible calculations refer to Client Ineligible calculations.pdf
To manually add the ineligible amount and reason, perform these steps:
1. In the Collateral Name field, select the collateral to add the ineligibility details.
2. Click on the button. A new row is highlighted.
3. Select the ineligibility reason and enter the ineligible amount. You can simultaneously add multiple client ineligibles records if required.
4. Click the button.
5. Click the button to simultaneously edit multiple ineligible records.
The system will not delete manually added ineligible reasons even if the Manual BBC checkbox is checked OFF under BBC Review Data page. The manually added ineligible reasons are carry forwarded to the next BBC based on the option selected under Basic ParametersBasic Parameters page.
If the Reason_With_Values is selected under Bring Forward Manual Ineligible option, then the system imports or carry forwards the defined ineligible reasons with values from current BBC to next BBC.
For example, Consider current BBC Date: 03/03/2018. You can manually enter the Ineligible values as follows:
Reasons Values
Aged Credit Item 2500
Concentration % 1500
Contra 1000
If next BBC date is 03/04/2018, then the defined ineligible reasons with values are carry forwarded to the next BBC which can be viewed under BBC AvailabilityBBC Availability page.
Refer to screenshot below:
Refer to the screenshot below:
If the Reason_With_No_Values is selected under Bring Forward Manual Ineligible option, then the system import or carry forwards the defined ineligible reasons with zero values from current BBC to next BBC. For example, Consider current BBC Date: 03/04/2018 and enter the ineligible values and save.
Reasons Values
Aged Credit Item 2500
Concentration % 1500
Contra 1000
If next BBC date is 03/05/2018, then the defined ineligible reasons with zero values are carry forwarded to the next BBC which can be viewed under BBC AvailabilityBBC Availability page.
Refer to screenshot below:
If Never is selected under Bring Forward Manual Ineligible option, the manually entered ineligible reasons are not carry forwarded to next BBC.
Ineligible reasons may include
Exceed credit Limit reason based
on the configuration under Basic
Parameters.
Exceeds
credit limit is not applicable for those customers who are primarily
considered as “ineligible customer” or “cross aged %”.
If a user tries to edit manually-entered or system-defined Ineligible Amount or Ineligible Reason fields without selecting the collateral name, then the system notifies you to select the collateral name.
Refer to the screenshot: