The previous calendar month totals for principal, interest, escrow and fees come from the TRANS2 file and are captured as indicated below.  
 
Principal last month
Tran code 22/All tran types = add PRINCP (principal amount)
Tran code 23/ Tran type not 60 or 61 = add PRINCP
Tran code 23/ Tran type 61 = subtract TRAMTP (Transaction amount)
Tran code 24/ Tran type 85 = add PRINCP
Tran code 25/ Tran type 95 = subtract PRINCP 
(Type 60 is fine payment and 61 is escrow payment.  Type 85 is credit/post payment and type 95 is debit/reverse payment.)

Interest last month
Tran code 22/All tran types = add  INTAMT (Interest amount)
Tran code 24 /Tran type 85 = add INTAMT
Tran code 25/Tran type 95 =  subtract INTAMT
(Type 85 is credit/post payment and type 95 is debit/reverse payment.)

Escrow last month
Tran code 23/Tran type 61 = add TRAMTP 
Note: Since we do not have specific tran codes for escrow adjustments, these amounts are not included if applicable.  
(Type 61 is escrow payment.)
 
Fees last month
Tran code 23/Tran type 60 = add TRAMTP
Note: Since we do not have specific tran codes for fee adjustments, these amount are not included if applicable.
 
 
  • Note:  Tran code 22 is Loan Payments, Tran Code 23 is Loan Disbursements, Tran Code 24 is Loan Error Correction Credits, and Tran Code 25 is Loan Error Correction Debits. 

Year-to-Date Totals
The mortgage statement history file (MTGSTMHST) accumulates the principal, interest, escrow and fee information each month to determine the YTD totals.  
 
 
  • Note:  If a transaction has been suppressed on the statement (via Tool #918 "Update Trans Desc & IRA/HSA Post Codes" or Tool #31 "Reverse Tran/Adjust Drawer (Same Day)") then it is not included in either “This Period” or “Year-to-Date” totals.