Loan Application "Dashboard"

Screen ID:

Screen Title:

Panel Number:

PENDG1-01

Applications by Status

4180

$images\4180g_shg.gif$

This screen appears when you use "Activitytracking" (F17) on the previous Work/View Application Status screen or by selecting Tool #472: Loan Queue Activity Tracking.

This screen includes XL panel sizing! View this screen in standard, large or extra large sizing. (This documents the standard size screen. Slight differences may apply to the larger sizes.) Learn more here.

Helpful Resources

Create full-color PDFs of the data on the screen – PDF Exports

Learn about downloading data to Excel or a comma-delimited file

Dashboard Tips – Questions to Ask When Comparing a Dashboard with Another Dashboard or Report

Screen Overview

This is a “Statistical Dashboard” for Loan Department Activity with an instant view of the lending team's output at any time during the month. This Dashboard is great for answering the following questions and more!

What is my total number of applications by delivery channel? (Use Delivery Channel (F12) to select the Delivery Channels to filter for.)
What are my total number of my pending, denied, closed and withdrawn applications each month?
What is the total dollar amount of my pending, denied, closed and withdrawn applications each month?
What is the number of days between application to approval, application to denial, application to close and application to withdrawn?

Today, organizations want an instant look at where they are throughout the month in relationship to their goals and where they hope to end up. In the past, you simply ran a report after the fact to see how you did. Today, we need to stay aware of how many days we have left to meet our goals, in order to affect how fast we're moving toward those goals. We need to make sure we inspire the right people in order to stay on track.

That's what this new Loan “Statistical Dashboard” is all about. This feature should help you get a team-wide awareness of where you are and where you are going.

Now leadership can pop in on the loan department any time they want. Data can be displayed for any time period and grouped by employee, loan category, branch, or delivery channel. At a glance the stats can point to the need to encourage an employee on an individual goal, counsel a branch leader on the team's goals, touch base with an indirect lender, or even work with the web team to try and increase the number of applications coming in through the Internet.

Understanding The Date Range and “Week X” Columns

The idea with this screen is to show how many applications were added to the pipeline during the chosen period. In this context the date range relates to the date on which the application record was created. So if an application was created during the time period specified at the top of the screen, it will be included in the analysis.

The Week 1, Week 2, etc., columns work like this: For the range of dates selected, Week 1 is always the last (most recent) week in that range. Week 2 would be the next most recent, and so on. Basically the system starts at the end of the range (the "To” date) and works backwards.

As an example, let's assume the following settings:

$images\1102intopicg_shg.gif$

For this scenario, apps would be broken down as follows:

Week 1	Week 2	Week 3	Remaining Weeks
Week of March 25-31 (the last week in March)	Week of March 18-24	Week of March 11-17	Week of March 1-10 (all remaining days back to the “From” date)

If today was actually March 31, you could say that “Week 1” means this past week, “Week 2” means the week before last, etc. The “Remaining Weeks” column will always include all remaining apps in the date range that do not fit within the other three columns.

CU*TIP: To display only today's applications, use Today (F1). Instead of showing applications by week, the screen will change to group apps by number of hours waiting in the queue today, based on the time stamped on the application when it was created. Use Today again to return to a range of dates.

Understanding the Stats

To group applications according to status (Pending, Denied, Booked), the system looks at the current status of the app as it sits in the pipeline now. For example, say you are analyzing applications created between March 1 and March 31. If an application was created on March 29 and as of today it is still sitting at a Pending status, the system will include this app in the “Pending” figures (under the “Week 1” column in this case). This would be true whether “today” is March 31 or April 15.

Among other things, the analysis answers the question, “How many of the applications that came in during the week of ________ are sitting at a pending (or denied, or booked) status today?

Downloading Data

Using Filters to Show Specific Applications

Use any of the following buttons to filter the list and show statistics for only certain applications.

NOTE: After using a filter use "All" (F5) to clear the filter.

Buttons

Button	Description
Today (F1)	Use this to display only today's applications. The screen will change slightly and instead of showing applications by week, it will break down apps by number of hours in the queue. Use F1 again to return to a range of dates.
Back up arrow (F3)	Use this to return to the previous screen. NOTE: The date range entered at the top of the screen will be retained and those apps will be displayed on the previous Work/View Application Status screen.
All (F5)	Use this to display all applications within the range specified at the top of the screen. This is helpful if you have used one of the other keys to display only a certain set of apps.
Category (F8)	Use this to access a screen that allows you to select one or more loan category codes to display only applications for these type(s) of loan. SEE ALSO: Filter and selection directions. (Use F5-All to return to the full list.)
Underwriter Code (F9)	Use this to access a screen that allows you to select one or more Underwriting Codes and display only applications that are sitting at that stage in your process. SEE ALSO: Filter and selection directions. (Use F5-All to return to the full list.)
Interviewer ID (F10)	Use this to access a screen that allows you to select one or more Employee IDs and display only applications where that ID was recorded as the Loan Interviewer (IDs that have interviewing checked in Employee special security). SEE ALSO: Filter and selection directions (Use F5-All to return to the full list.)
Underwriter ID (F11)	Use this to access a screen that allows you to select one or more Underwriters (IDs that have underwriting checked in Employee special security) and display only applications with this ID on the current Underwriting Code. SEE ALSO: Filter and selection directions. (Use F5-All to return to the full list.)
Delivery Channel (F12)	Use this to access a screen that allows you to select one or more Delivery Channel codes to display only applications that came in through that channel. This is great for monitoring the status of online banking applications. SEE ALSO: Filter and selection directions. (Use F5-All to return to the full list.)
Dealer # (F13)	For loans that have been coded with one of your credit union's configured Dealer/Indirect Lender IDs, use this to access a screen that allows you to select one or more a Dealer IDs to show only loans that originated from that dealer. SEE ALSO: Filter and selection directions. (The Dealer/Indirect ID can be entered on the Loan Request screen.)
Business Unit (F14)	Use this to access a screen that allows you to select one or more Business Units and display only applications that are sitting at that stage in your process. SEE ALSO: Filter and selection directions. (Use F5-All to return to the full list.)
Product Code (F15)	Use this to access a screen that allows you to select one or more Product Codes and display only applications that are sitting at that stage in your process. SEE ALSO: Filter and selection directions. (Use F5-All to return to the full list.) · NOTE: The Product code used will be the product code original to the application. This will not reflect any edits that may have been made.
Summary by Month (F17)	Takes you to the Loan Application Statistics screen where you can view what kind of loan applications you processed throughout the course of a year so that you can see trends in lending.
Counts by UW Code (F20)	Takes you to the Loan App Activity by Underwriting Code screen where you can view a breakdown of pending, booked, and denied loan applications by underwriting code.

Additional Video Resources

View more lending videos.

Visit the CU*BASE video library.