Overview
Abrigo is used for business financing.
For loan pricing questions or navigation assistance, e-mail _Abrigo Help.
Join the Weekly Abrigo Office Hours Call for recent updates and enhancements. E-mail Dan Fowler for zoom invite.
Click here for the Abrigo Users Guide.
4 Best Dashboards
As a loan officer or lending assistant, we recommend you create at least the four dashboards below to help you keep organized in Abrigo.
My To-Do List
This dashboard will show all workflow steps in process that are assigned to you (waiting for you to do something on) and makes it easy to find them.
- Go to Workflow > View All Workflows.
- Click New Report.
- In the Filters, set as follows:
- Workflow Status: Open
- Step Status: Select both Pending and Outstanding
- Step Assignee: Select your name
- Note: if a lending assistant and you want to see what the loan officer has assigned, could select yourself and the loan officer.
- Click Run Report – this will display a graph and data table based on your selection.
- Click on Select Fields to Display.
- Choose which fields you'd like to see by clicking on them so they move into the Selected Fields box on the right.
- Fields you don't want to include, if they are in the Selected Fields box, click on them and they will move over to the Available fields box and not by in your view.
- Click Save and Close.
- Click Run Report and if you like what you see, click Save.
- Name your report My To-Do List.
- Mark as Private so only you can see the dashboard.
- Click Save and Close.
- Go to Relationship Summary > Dashboard.
- Click on Add a Widget in the upper right corner.
- In the pop-up, select My To-Do List in the drop-down and show as data table.
- If you prefer graphs, select Chart.
- If you prefer graphs, select Chart.
- Click Save.
My Workflows
By setting up this dashboard, you will be able to see all of the workflows in process that you are managing. So, as loan officer or lending assistant, you can see who has your loan, where it is, and what is happening to it as it moves along the process.
- Go to Workflow > View All Workflows.
- Click New Report.
- In the Filters, set as follows:
- Workflow Status: Open
- Loan-Level Officer drop-down: Select your name
- Click on Select Fields to Display.
- Choose which fields you'd like to see by clicking on them so they move into the Selected Fields box on the right.
- Fields you don't want to include, if they are in the Selected Fields box, click on them and they will move over to the Available fields box and not by in your view.
- Click Run Report and if you like what you see, click Save.
- Name your report My Workflows.
- Mark as Private so only you see it.
- Click Save and Close.
- Go to Relationship Summary > Dashboard.
- Click on Add a Widget in the upper right corner.
- In the pop-up, select My Workflows in the drop-down and show as data table.
- If you prefer graphs, select Chart.
- Click Save.
My Opportunities
This dashboard will provide a listing of all of your loan pipeline opportunities listed in Abrigo. This is good to have as the management team views them as well and it will make it easy for you to update as needed.
- Go to Reporting > List Views.
- In the Choose Category pop-up, choose Opportunities.
- Click New Report.
- In the Filters, set as follows:
- Stage: select Prospect, Application, and Workflow.
- This displays current open opportunities
- Assigned: Select your name in the drop-down.
- Stage: select Prospect, Application, and Workflow.
- Click on Select Fields to Display.
- Choose which fields you'd like to see by clicking on them so they move into the Selected Fields box on the right.
- Click Save and Close.
- Click Run Report.
- If you like what you see, click Save As:.
- Name your report My Workflows.
- Mark as Private so only you see it.
- Click Save and Close.
- Go to Relationship Summary > Dashboard.
- Click on Add a Widget in the upper right corner.
- In the pop-up, select My Opportunities in the drop-down and show as data table.
- If you prefer graphs, select Chart.
- Click Save.
My Past Due Clients
Hopefully this one will be a very short list! By setting up this dashboard, you will see a list of delinquent clients in your portfolio as of every morning (i.e., updated daily).
- Go to Reporting > List Views.
- In the Choose Category pop-up, choose Opportunities.
- Click New Report.
- In the Filters, set as follows:
- Loan Officer: select your name
- Days Currently Past Due: 30
- This will pick up past due and non-accrual clients as non-accrual clients are normally beyond 30 days past due.
ii. See step 15 below if you want separate reports for past due and non-accrual.
- This will pick up past due and non-accrual clients as non-accrual clients are normally beyond 30 days past due.
- Click on Select Fields to Display.
- Choose which fields you'd like to see by clicking on them so they move into the Selected Fields box on the right.
- Click Run Report.
- If you like what you see, click Save As:.
- Name your report My Past Due Clients.
- Mark as Private so only you see it.
- Click Save and Close.
- Go to Relationship Summary > Dashboard.
- Click on Add a Widget in the upper right corner.
- In the pop-up, select My Opportunities in the drop-down and show as data table.
- If you prefer graphs, select Chart.
- Click Save.
- If you want 2 separate dashboards for 1. Past due clients and 2. Non-accrual clients, follow the steps above with the following changes:
- In your past due report, set Non-Accrual to NO.
- This gives you past due loans only.
- This gives you past due loans only.
- Follow steps above beginning with Step 5.
- Save a copy of your past due report and name it Non-accruals.
- In your filters, delete the days past due and set non-accrual to Yes.
- Follow steps above beginning with Step 5.
- In your past due report, set Non-Accrual to NO.
Pipeline Input Guide
- Enter all consumer AND business loans as an Opportunity.
- When creating a new Opportunity name for the pipeline, briefly describe the project and loan type.
- Do not restate the clients name in the Opportunity description.
- When the loan amount is determined, separately enter New Money and the Amount (total new + renewal).
Stages | Description | Probability to Close |
---|---|---|
Prospect | Loan need indicated by client or prospect |
50% May be higher |
Application | Formal loan application process by client |
75% After COMPLETED application received |
Workflow | Credit approved/terms/conditions provided |
90% Client has committed to loan ongoing due diligence |
Closed Won | Loan closed, sent for booking |
100%
|
Closed Withdrawn | Client chose not to use CCB financing |
0% Probability |
Closed Denied | Credit application was declined by CCB |
0% Probability |
Closed Lost |
Client Completed the loan with another lender *Add comments, name of competitor, and why lost (rate, term, fees) |
0% Probability |
IMPORTANT NOTES:
- When titling Workflow and Loan names in Abrigo follow example below:
- Workflow Name: Borrower; Type/Description (OORE, ABL, Equipment) App # and date workflow started. For the type or description, be specific: Ford F150; condo office 1419 Whittier Drive
- Loan Name: Identifier like: “other office building purchase” and date.
- If a Renewal: Loan # - “ABL Renewal”- Date
- Update the Stages and Probability to close %s throughout the workflow process
- No Probabilities other than 50%, 75%, 90%, 100% and 0% should be used
- The Probability to Close is a required input field. You will be prompted to enter the % before saving.
- Add Estimated Closing Date