If you have NOT received ANY payment: Enter date you want to send late notice in Column F of the Record Payments Sheet in the correct month Row. This date will usually be after the “grace period” and a Late Charge will automatically be added to the payment due. Enter the number of days to “pay up” in Cell H12.

If the borrower has sent a partial payment and you want to send a Late Notice for the difference: Enter the date in the Received Date in Column B of the Record Payments sheet which will be sufficient to accrue the interest for that month. Enter the number of days to “pay up” in Cell H12.

IMPORTANT: Make sure you have a date entered in either the Received Date (Column B) or a date in the Late Notice Date (Column F) late enough in the month to Accrue both the Interest and the Late Charge.

IMPORTANT: Note, that the late charge will not be added if a partial payment has been received by the Late Notice Date. If you WANT to charge a Late Fee, and are legally entitled to under the terms of your mortgage, then just change the Received Date to a date late enough to trigger the late charge.

Or, you can manually add a late fee into Column Q where the Late Charge can be overridden, remembering once you have overtyped this cell it cannot be recovered to its calculated value.

Create a Late Notice (Default Notice)


You can customize some of the text of the Notice of Default. Row 31 includes the following text to amend:

If you fail to cure your default, it will result in the acceleration of the sums secured by this mortgage, foreclosure by judicial proceeding and sale of the Property. You may have the right to assert in the foreclosure proceedings the non-existence of a default or other defence to acceleration and foreclosure.

Simply click in the cell to edit. Click on Row 31 in the far left bar and drag it up or down to change the row height.

To add a blank line, press the alt+enter keys together whilst editing the cell.