This scenario is for when the Correct Payment is received but is LATE and EXCLUDES the Late Charge.
For this scenario the Payment is expected to increase by the Late Charge Amount as the payment is Late.
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 and NOT the usual payment amount which is $929.17 (including $200 escrow). This is because a Late Charge has been added as the payment date of the 18th of the month is late as the grace period is 10 days, meaning that any date from the 11th of the month would be automatically late.
In this example you received the normal monthly payment of $929.17 (including $200 escrow) but you DID NOT receive the Late Charge which is $36.46. The total expected was $965.63.
Enter $929.17 in Column E.
Since you only received the normal Payment Amount, now enter the Total to Apply in Column M which is $929.17.
You will note that the $200 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 $929.17 applied, Columns S and T show that £36.46 was applied to the Late Charge and Column W shows that $692.71 was applied to Interest. 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 Late Charge was NOT received the amount to interest is reduced by the Late Charge amount.
Column AH shows that there was an under payment of $36.46 as the Late Charge was NOT added to the payment. 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.