Reports / ABL Reports / Management Reports / BBC Trend Report
BBC Trend Report
The BBC Trend report analyzes different BBC Values for a defined period of time. This report generates BBC data for the defined start and end date.
Navigation: Menu → Reports → Abl Reports → Management Reports → BBC Trend Report
To generate a BBC Trend report, perform these steps:
1. Go to Reports → ABL Reports → Management Reports → BBC Trend Report. A BBC Trend Report dialog box appears.
2. Enter the field values.
3. Click on the button. The report is generated. Click the PDF and/or XLSX formats to download the respective formats.
Refer to the screenshot:
Fields and Descriptions
Fields |
Descriptions |
BBC Date |
Enter the BBC approval date. |
Display Past Comments |
Select this to view all comments in all the reports. |
Display BBC Comments |
Select this to view comments related to the particular BBC for the selected date. |
Refer to the screenshot:
In BBC Trend Report, field values other than Credit line & line limit with reserves are blank for skipped BBCs.
Refer to the screenshot:
BB Suppressed Availability
If Total Available For Advance is greater than Approved Line Less Reserves value, the BB Suppressed Availability will be calculated as Total Available For Advance - Approved Line Less Reserves; otherwise the BB Suppressed Availability value will be “0.00”.
Total Suppressed Availability
Total Suppressed Availability is calculated as,
Total Suppressed Availability = A/R Suppressed Availability + Inventory Suppressed Availability + Other Collateral Suppressed Availability.
The calculation on Suppressed Availabilities is based on the Report Preference settings done under Basic Parameters page. Hence whenever settings are updated in report preference, the Suppressed Availability calculation of all the history (approved) BBCs of that particular client needs to be updated with that latest settings.
You may generate the outputs in PDF and Excel format by clicking the and
icons respectively.
The BBC trend report shows the details based on the BBC frequency defined under Client Basic Details page.
If the selected frequency is Monthly, then the report shows 12 monthly current BBCs and previous BBCs details.
If the select frequency is Quarterly, then the report shows 4 current quarterly BBCs and 4 previous quarterly BBC details.
If the select frequency is Semi-Annually, then the report shows 2 semi-annual current BBCs and 2 previous semi-annual BBC details.
When skipping a period, the value for Net Collateral Available is zero.