Note Maker Worksheet: Accurate Loan Amortization and Reporting for Receivables and Payables

Note Maker Worksheet generates an amortizing receivable or payable loan for recording and uses principal, interest rate, term (1 to 720 months), escrow, and start date. Additionally, it calculates the payment with an amortization list. The main advantage of Note Maker is that it rounds each month to the nearest penny, thus eliminating rounding errors.

Receivable

Note Maker Worksheet generates an amortizing receivable loan for recording and uses principal, interest rate, term (1 to 720 months), escrow, and start date. Note Maker calculates the payment with an amortization list.

Payable

Note Maker Worksheet generates an amortizing payable loan for recording and uses principal, interest rate, term (1 to 720 months), escrow, and start date. Note Maker calculates the payment with an amortization list.

Each payment lays into the check writer worksheet when the payment is older than the cut-off date. It splits the payment into principal and interest to properly report interest paid on Form 1099.