I have found that the worksheet has many flaws with multiple mortgages, paid off mortgages, mortgages that are transferred to a new lender the day after settlement, etc.  I developed my own Excel worksheet to do the calculation and then see if I can get the ProSeries worksheet to match.  If not, I use my Excel as I trust that more.