This scenario is for when a Partial Payment is received LATE.
This scenario is the same as scenario 4 except the Partial Payment is Late and the Late Charge will be added on. The Normal Payment including Escrow should be $917.29, but the borrower only sent $500.00.
Click on the Record Payments worksheet.
In our example, the first payment is due March 1 2021.
We received this payment on March 18 2021. Enter 3/18/21 in Column B.
Note that you can now see the Amount Due in Column C as soon as the date is entered into Column B.
The Amount Due is shown as $965.63 (including $200 escrow). There is a Late Charge of $36.46 as the payment is Late.
In this example you receive $500.00 (including $200.00 escrow) but you DID NOT receive the FULL Normal Payment.
Enter $500.00 in Column E.
Since you only received a Partial Payment Amount, enter the Total to Apply in Column M which is $500.00.
You will note that the $200.00 escrow payment has been Applied to Escrow in Column N. If you are not escrowing, nothing will appear.
We have also added in the Check Number in Column H and the Cleared Date in Column I for clarity.
To see how your payment has been applied, scroll to the right to Columns S onwards.
From the $500.00 applied, Column V shows that there was only $263.54 to Apply to Interest and Principal. There is nothing in Column X for Principal as this is an Interest Only loan. The amount To Interest should have been $729.17 but because the full payment was not received, the amount left over after Escrow and the Late Charge is $263.54 and is shown in Column W.
Column AH shows that there was an under payment of $465.63 as the Full Payment was NOT received. Column AJ shows how much the payment should have been.
Get in touch if you’re having problems, need something specific or have questions about our spreadsheet.
Existing customers of Lender Software Pro v1.7.x claim a FREE upgrade to v2.0.x
Get started for FREE Today. Register and Download NOW!
Want to Upgrade from Lite to PRO?. Upgrade and Unlock for $79.99
Microsoft® Windows® and Microsoft® Excel® are registered trademarks of Microsoft Corporation in the United States and other countries. Mac® and macOS® are trademarks of Apple Inc., registered in the U.S. and other countries.