Your rate sheet defines how Glide pre-qualifies applicants and builds recommended offers for each loan product.

Rate Sheet Structure

Rate sheets have 4 sections to configure:

1. Credit tiers

2. Criteria

3. Terms and Rates

4. Min and Max Values

Special Cases

Vehicle Rate Sheets

Vehicle rate sheets support different terms and rates for new vs used vehicles

Credit Card and Personal Line of Credit Rate Sheets

Credit card rate sheets will not have term lengths

How to configure your rate sheets

Download the Template

1. From the Glide dashboard, click on Configure then Loan Types, then select the loan type you want to configure.

2. Download the rate sheet template by clicking Add/Update Rate Sheet then Upload Rate Sheet then Download Template in the drawer that appears. This will download an Excel file to your desktop

3. Open the Excel file (note: uploading the file to Google Drive and editing there will also work)

   1. The Excel file contains one tab per rate sheet. Each file can support one or more sheets that can be mapped to categories. For example, 1 file for all Vehicle loans with 3 sheets named Car, Boat, and Motorcycle.

      

   2. Editing an existing tab in the Excel file will update that corresponding rate sheet.

   3. To add a new rate sheet, add a new tab to the Excel file. The tab's name is the rate sheet name.

4. If you have already configured a rate sheet previously, the file will show your current state. Otherwise, you will see blank/zero values. For this guide, we will assume you are working on a brand new rate sheet

Enter your configurations

1. Review/edit the tiers in row 3

   1. To remove a tier, you can delete the column it is in

   2. To add a tier, either insert a column where desired or add it to the right of the last column

   3. To edit a tier range, simply edit the cell. Example: Change 620-679 to 620-699

2. Configure your criteria. See below for more information on how criteria work and the available options

   1. Select criteria to use (e.g. Debt to Income Ratio)

      1. To add a criteria, insert a row below or above the current criteria list (labeled as Variable in the template)

      2. To remove a criteria, delete the associated row

      3. To change a criteria, you can edit its name in column A. Example: Change Debt to Income Ratio to Monthly Income

   2. Select operators (e.g. is less than)

      1. In column B, select which operator to use with each criteria. See below for more information on available operators.

   3. Enter thresholds (e.g. 0.75)

      1. For each criteria a threshold will need to be entered for each credit tier

3. Configure your terms and rates

   1. Select terms to use

      1. To add a term, insert a row and enter in the term length in months in column A

      2. To remove a term, delete the row it is in

      3. To edit a term, update the cell value. Example: Change 12 to 24

   2. Enter rates

      1. For each term, enter a rate for each credit tier.

      2. Terms should be entered in decimal format. Example: For 8%, enter 0.08.

   3. For Vehicle Loans:

      1. Vehicle loans support a different rate for each term/credit tier for New vs Used vehicles. This is configured using the Condition value in column B

         

   4. For Credit Cards and Personal Lines of Credit

      1. Only configure 1 row of rates. The term length can be left as blank or 0

         

1. Configure Min/Max values

   1. For each credit tier, enter the minimum and maximum loan values

   2. Min/Max values determine both the amount the user can pre-qualify for and also the range of loan amounts they can apply for. It is possible to separate these into two different rages of values. See the Minimum and Maximum Amounts section for more information.

2. Upload the file

   1. Save/Export

      1. On Excel, save the file

      2. On Google Sheets, go to File -> Download -> Microsoft Excel (.xlsx)

   2. Upload

      1. Back on the dashboard, click Add/Update Rate Sheet then Upload Rate Sheet then Choose File in the drawer that appears.

      2. Select the file and then click Upload

How Glide uses the rate sheet

Credit tier

Glide assigns the applicant to a credit tier using the highest credit score among the primary applicant and any co-borrowers. Tiers are score ranges in the sheet, written as a closed range (e.g. 660-699) or an open range (e.g. 700+). If no tier matches the score, the default credit tier from your Loan Settings applies when one is configured; otherwise the applicant is not pre-qualified.

Criteria

Each criterion row is evaluated against the applicant using the threshold in the matched tier's column. Criteria work one of two ways:

Pass/fail criteria

• Definition: Hard criteria that the applicant must pass. Adjusting the loan terms will not change the result.

• Example: Monthly Income will always be the same even with different loan amounts or lengths.

• Treatment: Disqualify the applicant outright when they fail. Applicants can still apply for a loan but they will not be pre-qualified.

Cap criteria

• Definition: Applicants may pass or fail these criteria depending on the loan details.

• Example: An applicant may fail the Debt to Income Ratio criteria for a $10,000 loan but pass for a $3,000 loan.

• Treatment: Used to compute the largest loan amount the applicant can take while still satisfying the criterion.

Example Rate Sheet with Credit Tiers and Criteria

Offer amount

The qualifying amount is the largest loan amount that meets all cap criteria. The amount is limited by the tier's maximum pre-qualification amount and rounded down to the nearest $100.

Pre-Qualification

The applicant pre-qualifies when all of the following criteria are met:

1. The applicant meets all pass/fail criteria

2. The calculated Offer Amount is within the min/max pre-qualification amounts for the applicant’s credit tier

Supported Rate Sheet Criteria

Notes:

• "Rent" will only be used for users who are renters. Mortgage payments will not be used as they are already accounted for within existing monthly payments from the credit report.

• See our📄 Credit Report Attributes article for more information on the attributes.

Supported Operators

• is less than

• is less than or equal to

• is greater than

• is greater than or equal to

• is equal to

• is equal to

Minimum and Maximum Amounts

Rate sheets support 2 flavors of minimum and maximum amounts.

Pre-qualification and Application Combined

Use Minimum Amount and Maximum Amount .

These amounts will determine the max and min amounts that users are pre-qualified for AND the max and min amounts the user can apply for.

Pre-qualification and Application Separate

Use Pre-qualification minimum amount and Pre-qualification maximum amount for pre-qualification limits.

Use Selectable minimum amount and Selectable maximum amount for application limits.

The pre-qualification amounts will set the bounds within which a user can pre-qualify and the selectable amounts will set the bound of what the user can apply for.

Disabling pre-qualification for a product

Enter NA for every APR value on a sheet to turn off pre-qualification for that product. APR values on a given rate sheet must be all NA or all numeric — mixing values is not supported.

When pre-qualification is disabled for a product, users will still be able to select a loan amount and term length but will not be quoted an APR or estimated monthly payment.