This typed vs printed DTI field map standardizes cross-checks for consumer loan application processing teams. It eliminates manual calculation errors that can delay application status updates, reduce funding hold times, and avoid unnecessary follow-up requests with applicants for additional debt verification documentation. Teams can use this framework for both personal loan and structured settlement-backed loan applications where monthly debt and income inputs are entered manually before system calculation. All guidance here is for administrative use only, and you should confirm all reconciliation steps with your licensed loan processing supervisor or contracted servicer before finalizing any application file.
Settlement Desk
Typed DTI column mapping for manually entered monthly debt values
This mapping applies to all fields you input directly into the loan origination system (LOS) before any auto-calculation runs. First, populate the typed column with all recurring monthly debt obligations reported on the applicant’s credit report, including mortgage payments, auto loan payments, student loan payments, revolving credit minimum payments, and personal loan payments. Next, add any additional monthly debt disclosed by the applicant that does not appear on the credit report, like court-ordered child support, structured settlement payment obligations, or private student loan deferments that will resume within the next 12 months. Each typed entry must include a reference number linking to the supporting document’s index number, so cross-referencing during audit is streamlined: for example, if a car payment is listed on page 2 of the credit report, the typed entry will have a note [CR-PG2] next to the value to indicate the source. Front-end DTI typed values are limited to housing-related monthly costs: rent, mortgage payment, property taxes, homeowners insurance, and HOA dues. Back-end DTI typed values include all monthly debt plus housing costs, alongside verified gross monthly income, which must be sourced from either 30 days of consecutive pay stubs, 2 years of W2 forms, or a signed payment confirmation from the annuity issuer for structured settlement income, all dated within 30 days of the application submission date. Illustrative example: If an applicant reports $1,800 monthly mortgage, $350 car payment, $250 student loan payment, and $120 child support, those four values are entered individually into the typed column before system calculation.
Auto-printed form cross-reference for system-calculated DTI output values
Once you run the LOS DTI calculation function, the system will generate a printed or exported PDF output page with auto-calculated values. First, confirm that all manually entered debt and income values are correctly pulled into the system’s sum of monthly debt and total gross income line items. Next, confirm that the system’s gross monthly income value matches the typed gross income you entered from supporting documents, not an outdated value from a previous application or a third-party credit report income estimate that is not verified. The system may apply standard adjustments to certain debt values per lending guidelines: for example, revolving credit lines may be calculated at 1% of the outstanding balance if no minimum payment is listed, even if the typed minimum payment is lower. The auto-printed form will have separate line items for front-end DTI percentage, back-end DTI percentage, total monthly debt sum, and total gross monthly income used for calculation, as well as the source of each income value used for calculation. Illustrative example: If you entered $6,500 in gross monthly structured settlement income, the auto-printed form should list $6,500 as the gross income value, not a $5,800 estimated income pulled from the credit report. If the system pulls an incorrect income value, this is flagged as a discrepancy and added to the tracking box. All line item to the typed entries first before flagging discrepancies to avoid unnecessary administrative work.
Discrepancy tracking box documentation for mismatched DTI value pairs
All mismatches between typed and auto-printed values are logged in the standardized discrepancy tracking box, which is linked directly to the application file. Each discrepancy is assigned a unique alphanumeric ID to simplify audit trails, and all entries are dated and initialed by the team member who identified the mismatch. The tracking box uses the following structure:
| Discrepancy ID | Typed Value (User Entered) | Auto-Printed Value | Root Cause Category | Flag Status |
|---|---|---|---|---|
| DISC-DTI-2024-001 | 22% Front-end | 24% Front-end | System applied updated county property tax assessment synced to LOS | Pending Review |
| DISC-DTI-2024-002 | 36% Back-end | 39% Back-end | System applied 1% minimum payment rule to $12,000 revolving credit line with no listed minimum reported | Resolved |
| DISC-DTI-2024-003 | 31% Back-end | 28% Back-end | User entry error: $180 monthly medical bill entered twice in debt sum | Resolved |
| DISC-DTI-2024-004 | 21% Front-end | 27% Front-end | System included monthly HOA dues not manually entered by user from applicant disclosure | Pending Correction |
Pending discrepancies must be resolved within 3 business days of identification to avoid delaying the application’s underwriting timeline. If a discrepancy cannot be resolved within that time frame, a notification must be sent to the applicant explaining the delay and requesting any additional documentation needed to resolve the mismatch. No application can be sent to underwriting until all DTI discrepancies are marked as resolved and documented in the file. Root cause categories are standardized to reduce repeat errors: user entry error, system guideline adjustment, missing supporting document, system sync error, applicant update. If a discrepancy is due to a system guideline adjustment that is consistent with lending policies, no correction to the typed values is needed, but a note must be added explaining the adjustment for the applicant’s records. If the discrepancy is due to user error, the typed value must be corrected, and the system calculation re-run to generate a new printed form.
Verification note filing steps for resolved DTI value inconsistency cases
Once a discrepancy is marked as resolved, follow these steps in order to document the resolution for audit purposes. First, print a copy of both the original typed entry screen capture and the corrected typed entry (if applicable) and attach it to the discrepancy tracking box entry. Second, attach a copy of the supporting documentation that confirms the correct value: for example, a copy of the credit report line item showing the minimum payment, a copy of the property tax assessment, or a copy of the structured settlement payment confirmation from the annuity issuer. Third, add a 1-2 sentence note to the application file explaining the resolution: for example, “Back-end DTI discrepancy resolved: system applied 1% minimum payment rule to $12,000 revolving credit line per lending guideline 3.2.1, no correction to user entry required. Fourth, have the resolution note signed or initialed by the processing team lead, and add the date of resolution to the file index. If the discrepancy requires notifying the applicant of a change to their estimated DTI, a written notification must be sent to the applicant within 1 business day of resolution, outlining the change and the reason for the adjustment. A copy of this notification must be attached to the verification note and stored in the application file. Settlement Desk processing teams use these same filing steps for structured settlement-backed loan applications to ensure compliance with state lending requirements. All verification notes must be written in clear, plain language that can be understood by auditors, underwriters, and applicants if requested.
Field map folder storage protocols for completed DTI reconciliation files
Once all DTI discrepancies are resolved and verification notes are filed, the completed typed vs printed DTI field map is stored according to these protocols. First, the field map is saved as a PDF with the file naming convention: [Application ID]-[YYYYMMDD]-DTI-Reconciliation.pdf, where Application ID is the unique LOS application number, and YYYYMMDD is the date of reconciliation. Second, physical copies of the field map are stored in the front of the application file’s income verification section, so auditors can access it immediately without searching through the full file. Third, digital copies are stored in the shared LOS drive folder for your team, with access restricted to authorized processing staff only, so no external parties can access sensitive applicant financial information. If your team uses cloud storage for digital files, ensure that the folder is encrypted and access is limited to only staff who require access to process loan applications, per federal data privacy requirements. Do not store completed DTI reconciliation files on personal devices or unsecure shared drives, as this can lead to data breaches and non-compliance with consumer financial protection regulations. Fourth, all completed DTI reconciliation files are retained for a minimum of 7 years per federal lending record retention requirements, after which they can be securely shredded or deleted per your company’s data disposal policy. If you are unsure of your team’s storage protocols, confirm with your file management supervisor or contracted servicer before filing.
Before processing your next loan application, pull the last 3 DTI reconciliation files to confirm your team is following the mapping and filing steps outlined on this page.
