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 Edit button 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:
Receivables Aging page

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.

NoteThe ineligibles that are mapped and uploaded is carried forward up to next BBC until the user manually deletes that ineligible.

Refer to the screenshot:Receivable Aging page.

NoteIf 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”.

AR Adjustment 

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 Edit 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.

Ineligible Amount

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 Plus button 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 theSave button button.  

5. Click the Edit multiple records button button to simultaneously edit multiple ineligible records.

NoteThe 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:
Warning - Select a collateral name for editing.