SCENARIO 1: Correct Payment received on time


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.

Entering a payment received on time and the correct amount

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!

Payment received on time and the correct amount applied

Let Us Help

Get in touch if you’re having problems, need something specific or have questions about our spreadsheet.

Claim FREE upgrade

Existing customers of Lender Software Pro v1.7.x claim a FREE upgrade to v2.0.x

© 2023 Testament Research, Inc.

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.

By continuing to browse or by clicking 'Dismiss' you agree to the storing of cookies on your device to enhance your site experience and for analytical purposes. To learn more about how we use cookies, please see our Cookies Policy and Privacy Policy.