--- title: What are the funding field mappings? description: Below is a detailed explanation of the available Funding Field Mappings and their respective acceptable values. --- [Skip to content](https://help.themortgageoffice.com/knowledge/what-are-the-funding-field-mappings#main-content) [![TMO-LO~1](https://help.themortgageoffice.com/hs-fs/hubfs/TMO-LO~1.png?width=200&height=65&name=TMO-LO~1.png)](https://www.themortgageoffice.com/) - [Platform](https://www.themortgageoffice.com/products/) Show submenu for Platform - [Loan Servicing](https://www.themortgageoffice.com/products/loan-servicing-software/) - [Loan Origination](https://www.themortgageoffice.com/products/loan-origination-software/) - [Fund Management](https://www.themortgageoffice.com/products/fund-management-software/) - [Knowledge Hub](https://www.themortgageoffice.com/knowledge-hub/) Show submenu for Knowledge Hub - [Blog](https://www.themortgageoffice.com/blog/) - [Resources](https://www.themortgageoffice.com/resources/) - [Webinars](https://www.themortgageoffice.com/resources/?_resource_types=on-demand-webinars) - [Seminars](https://www.themortgageoffice.com/seminars/) - [FAQs](https://www.themortgageoffice.com/frequently-asked-questions/) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes) Open main navigation Close main navigation - [Platform](https://www.themortgageoffice.com/products/) Show submenu for Platform - [Loan Servicing](https://www.themortgageoffice.com/products/loan-servicing-software/) - [Loan Origination](https://www.themortgageoffice.com/products/loan-origination-software/) - [Fund Management](https://www.themortgageoffice.com/products/fund-management-software/) - [Knowledge Hub](https://www.themortgageoffice.com/knowledge-hub/) Show submenu for Knowledge Hub - [Blog](https://www.themortgageoffice.com/blog/) - [Resources](https://www.themortgageoffice.com/resources/) - [Webinars](https://www.themortgageoffice.com/resources/?_resource_types=on-demand-webinars) - [Seminars](https://www.themortgageoffice.com/seminars/) - [FAQs](https://www.themortgageoffice.com/frequently-asked-questions/) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes) - [Contact Support](https://help.themortgageoffice.com/knowledge/kb-tickets/new) [Contact Support](https://help.themortgageoffice.com/knowledge/kb-tickets/new?hsLang=en) How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://help.themortgageoffice.com/knowledge?hsLang=en) 2. [Importing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en) 3. [Field Mappings](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#field-mappings) October 9, 2026 # What are the funding field mappings? ## Below is a detailed explanation of the available Funding Field Mappings and their respective acceptable values. Click [here](https://help.themortgageoffice.com/knowledge/importing-funding-from-an-excel-file?hsLang=en) to how to import fundings from Excel using the field mappings below.  ### Funding field mappings: | **Field Name:** | **Description:** | | --- | --- | | **Loan Account** | Enter the **loan** account **number** to which this funding applies to. (Maximum of 10 alpha-numeric characters including "-" and ".") TIP: The loan account is required. | | **Lender\_Account** | Enter the **lender** account **number** to which this funding applies to. (Maximum of 10 alpha-numeric characters including "-" and ".") TIP: The loan account is required. | | **TransDate** | Enter the **date** of the funding. Default is today's date. | | **Reference** | Enter a **reference** number. (Maximum of 10 characters) | | **Amount** | Enter the total **amount** of the funding. | | **BrokerFee\_Pct** | Enter the annualized rate to **use against** the lender's portion of the loan's principal balance. EXAMPLE: For example, 1.000% fee for a lender owning a $10,000 investment on a monthly loan is calculated as follows: Servicing Fee = $10,000 x .01 / 12 = $8.33 | | **BrokerFee\_Flat** | Enter an **additional** flat dollar amount to be charge as a servicing fee. | | **BrokerFee\_Min** | Enter a dollar amount as the **minimum** servicing fee this lender will pay. TIP: To charge a flat servicing fee of $5.00, enter zero for the two previous fields and $5.00 as a Minimum fee. | | **Vendor\_Account** | Enter the **vendor** account number to which additional servicing fees are paid. (Maximum of 10 alpha-numeric characters including "-" and ".") | | **VendorFee\_Pct** | Enter the annualized rate to **use against** the lender's portion of the loan's principal balance. EXAMPLE: For example, 1.000% fee for a lender owning a $10,000 investment on a monthly loan is calculated as follows: Servicing Fee = $10,000 x .01 / 12 = $8.33 | | **VendorFee\_Flat** | Enter an **additional** flat dollar amount to be charge as a servicing fee. | | **VendorFee\_Min** | Enter a dollar amount as the **minimum** servicing fee this lender will pay. TIP: To charge a flat servicing fee of $5.00, enter zero for the two previous fields and $5.00 as a Minimum fee. | | **EffRateType** | This value is used to determine how the EffRateValue is used to **arrive** at the lender's effective rate. Acceptable values are: 0 = Sold Rate. The lender's effective rate is the loan Sold Rate as entered in the Terms window. 1 = Rate Modifier. The lender's effective rate is the loan Sold Rate plus the EffRateValue. 2 = Fix Rate.  The lender's effective rate is the  EffRateValue. | | **EffRateValue** | Enter a numeric value which is used to calculate the lender's **effective** rate based on the EffRateType selected. | | **PennyError** | Enter 1 to adjust this lender if a r**ounding adjustment** is necessary during payment distribution; otherwise enter 0. TIP: When loans are funded by more than one lenders, there may come a time when the amount of the payment cannot be distributed completely due to rounding errors. For example, if you have a $9,000.00 loan which is funded equally by three lenders ($3,000.00 each), then each lender owns a third of the loan. The problem arises, if the borrower makes a $100.00 payment. Two lenders will receive $33.33, and the one with this option selected will receive $33.34. TIP: Only one lender at a time can have this option selected. | | **GSTUse** | Enter 1 to **charge** goods and services tax (GST) on the total servicing fees paid by this lender. TIP: This option is only available if you have selected Canada in [Tools\>Options\>User Preferences\>Regional](https://help.themortgageoffice.com/knowledge/user-preferences-regional?hsLang=en). TIP: You must also enter the tax rate and GST vendor account in [Tools\>Options\>Loan Servicing](https://help.themortgageoffice.com/knowledge/loan-servicing-options-general?hsLang=en). |   - [Getting Started](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#general) - [Basic Information](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#basic-information) - [New Company Setup](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#new-company-setup) - [User & Group Security](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#general) - [Users](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#users) - [Groups](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#groups) - [Single Sign-On (SSO)](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#single-sign-on-sso) - [Loan Origination](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#main-content) - [Loan Files](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#loan-files) - [SmartViews](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#smartviews) - [System Administration](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#system-administration) - [Lenders](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#lenders) - [Lightning Docs](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#lightning-docs) - [Integrations](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#integrations) - [Borrowers](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#borrowers) - [DossDocs](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#dossdocs) - [Loan Servicing](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#general) - [Loan Files](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-files) - [Borrowers](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#borrowers) - [Terms](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#terms) - [Funding](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#funding) - [Properties](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#properties) - [History](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#history) - [Attachments](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#attachments) - [Lenders](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#lenders) - [Vendors](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#vendors) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#tasks-reports) - [Loan Charges](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-charges) - [Commercial Loans](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#commercial-loans) - [Lines of Credit/HELOC](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#lines-of-credit-heloc) - [Construction Loans](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#construction-loans) - [Adjustable Rate Mortgages (ARM)](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#adjustable-rate-mortgages-arm) - [Graduated Terms Mortgages (GTM)](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#graduated-terms-mortgages-gtm) - [Escrow Administration](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#escrow-administration) - [SmartViews](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#smartviews) - [Accounting System Integration](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#accounting-system-integration) - [Custom Letters and Notices](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#custom-letters-and-notices) - [Loan Templates](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-templates) - [Data Exports](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#data-exports) - [Trust Accounting](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#main-content) - [Trust Accounts](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#trust-accounts) - [Register](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#register) - [Clients](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#clients) - [Payees](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#payees) - [Payers](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#payers) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#tasks-reports) - [Collateralized Mortgage Obligations](https://help.themortgageoffice.com/knowledge/collateralized-mortgage-obligations?hsLang=en#main-content) - [Holders](https://help.themortgageoffice.com/knowledge/collateralized-mortgage-obligations?hsLang=en#holders) - [Mortgage Pool Servicing](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#main-content) - [Mortgage Pools](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#mortgage-pools) - [Partners](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#partners) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#tasks-reports) - [SmartViews](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#smartviews) - [ACH Express](https://help.themortgageoffice.com/knowledge/ach-express?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/ach-express?hsLang=en#general) - [Online Portals](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#general) - [Online Payments](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#online-payments) - [Borrowers](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#borrowers) - [Lenders](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#lenders) - [Partners](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#partners) - [Investment Offerings](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#investment-offerings) - [Messages](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#messages) - [Tax Forms Management & Printing](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#general) - [Tax Forms](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#tax-forms) - [Consumer Credit Reporting (Metro-2)](https://help.themortgageoffice.com/knowledge/consumer-credit-reporting-metro-2?hsLang=en#main-content) - [Metro-2 Fundamentals](https://help.themortgageoffice.com/knowledge/consumer-credit-reporting-metro-2?hsLang=en#metro-2-fundamentals) - [Custom Letters, Notices and Mailing Labels](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#main-content) - [Custom Letters](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#custom-letters) - [Custom Notices](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#custom-notices) - [Custom (User Defined) Fields](https://help.themortgageoffice.com/knowledge/custom-user-defined-fields?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/custom-user-defined-fields?hsLang=en#general) - [Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/options?hsLang=en#general) - [User Preferences Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#user-preferences-options) - [Loan Servicing Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#loan-servicing-options) - [Importing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#main-content) - [To Loan Servicing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#to-loan-servicing) - [From an Excel file](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#from-an-excel-file) - [Field Mappings](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#field-mappings) - [Online](https://help.themortgageoffice.com/knowledge/online?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/online?hsLang=en#general) - [Text Messages](https://help.themortgageoffice.com/knowledge/text-messages?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/text-messages?hsLang=en#general) - [Pulse](https://help.themortgageoffice.com/knowledge/pulse?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/pulse?hsLang=en#general) - [Insurance Tracking](https://help.themortgageoffice.com/knowledge/insurance-tracking?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/insurance-tracking?hsLang=en#general) - [API Docs](https://help.themortgageoffice.com/knowledge/api-docs?hsLang=en) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes?hsLang=en) - [Desktop](https://help.themortgageoffice.com/knowledge/desktop?hsLang=en) - [Onboarding](https://help.themortgageoffice.com/knowledge/onboarding?hsLang=en#main-content) - [Loan Origination](https://help.themortgageoffice.com/knowledge/onboarding?hsLang=en#loan-origination) [![Chill listening crop-3](https://help.themortgageoffice.com/hs-fs/hubfs/TMO-LO~1.jpg?width=125&height=55&name=TMO-LO~1.jpg "Chill listening crop-3")](https://www.themortgageoffice.com/) 7755 Center Ave, Suite 800 Huntington Beach, CA 92647 [mailto:support@themortgagoffice.com](mailto:support@themortgagoffice.com) Copyright © 2025, The Mortgage Office®