This scenario is for a Normal Payment received ON TIME and for the Correct Amount.
Click on the Record Payments worksheet.
In our example, the first payment is due March 1 2021.
We received this payment on March 8 2021. Enter 3/8/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 $929.17 which includes $200 to escrow and is the normal payment amount and the amount you received.
Enter $929.17 in Column E.
Now enter the Total to Apply this month in Column M which is $929.17.
You can also enter the Check Number in Column H and the Cleared Date in Column I.
You will note that the $200 escrow payment has been Applied to Escrow in Column N and the Total in Escrow is shown in Column O.
You have now entered your payment!
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.