Skip to content
Contact Support
  • There are no suggestions because the search field is empty.

How to import loans from an Excel file?

The Import Loan Assistant will help you import loans into the loan servicing module from an Excel file saved as comma delimited (csv) or tab delimited (txt).

NOTE: 

  • A CSV (comma delimited) file consists of a header record containing a description for each field, followed by one or more loan records consisting of fields separated by a literal comma. All records must have an identical sequence of fields and each record must be terminated by a line break.
  • A TXT (tab delimited) file consists of a header record containing a description for each field, followed by one or more loan records consisting of fields separated by a tab-character. All records must have an identical sequence of fields and each record must be terminated by a line break.

To import the loan file:

  • Click on running Loan Servicing in the left panel of The Mortgage Office®.
  • Scroll down to Tasks & Reports and click on it.
  • At the bottom of the page on the right, locate Import: From File. 
  • Click on blank Excel box with X Loans. This will bring up the loan import assistant Import Loan Assistant.
  • You will see the following options: 
    • Import Profile. This file contains a previously created field mapping between available fields and your import file. Enter the full path and file name or use to browse and navigate to the location where the import profile resides and select it. Import profiles can be great time-savers if your import file's format does not change.

TIP: The Import Profile is always verified and will be rejected if found to be different from the import file.

TIP: You may leave this field blank if you are creating a new mapping or the first time using this assistant. Once you've created a field mapping you will have a chance to save it.

TIP: You may create any number of import profiles.

    • File to Import. Enter the full path and file name or use to browse and navigate to the location where the file resides and select it. To learn more read How to Create the Import File.
    • File Format. From the drop-down menu select the file type that matches the format used in Microsoft Excel to create the file. The choices are .CSV and .TXT.
  • Once you've selected a file, double-click on it and press NEXT in blue box.
    • The next page will bring up the Import Loan Assistant, which lists Field Mappings, a grid composed of two columns.
    • The first column of the grid (LOAN FIELD NAME) is populated with all the available loan fields.
    • Each row of the second column (MAP TO IMPORT FIELD) is populated with the field names found in the header record of your import file.
    • Use the drop-down list to map each one of your fields to the corresponding loan field.
    • For a detail description of the available fields and their acceptable values read Field Mappings.
  • Once you've chosen your fields, click NEXT in blue boxfor the next dialog box.
  • You will see the following message: "Congratulations! You've completed all the necessary steps and you're now ready to import the selected file to loan servicing. Please select from the options below and click the Import Loan Files button when ready.":
    • Create SmartView™ checkbox square-check-solid. Select this option to auto-create a SmartView™ populated with the imported vendors. If checked, you must enter a Display Name and a Category (or use the default values).

TIP: Categories are keywords or phrases that help you create logical groups. To learn more read How to Use the Categories Window.

    • Initially place loans on hold square-check-solid. Select this option to prevent others from processing transactions for any of these loans until you are done setting it up.
    • image-png-Jun-23-2023-06-15-47-1317-AM Save Import Profile. Click to save the field mappings as a reusable import profile. This Import file will be downloaded to your downloads folder.
    • print Print Field Mapping. Click to print a report showing the fields mapping.
    • validate circle with checkbox Validate Import File. This step is required before the Import Loan Files button is enabled. If any errors are found during the validation process a detailed report will be generated.

NOTE: You will not be able to import the file if one or more critical errors are found.

  • image-png-Jun-16-2023-08-59-19-7139-PM Import Loan Files. Click to start the import process.
  • After the import is complete, you will see the following message: "Congratulations! A total of x (out of x) loan records were successfully imported. You must review these records carefully and make any necessary changes before you enter any transactions."
  • Click black X Exit in the upper-right hand of the Import Loans Assistant dialog page when you are finished. You may also choose CANCEL or BACK button.

Copyright © Applied Business Software, Inc. All Rights Reserved.