amortize and automatically enter payments for a loan that I make to a third party

lkeppeljunk's Avatar


09 Jun, 2021 07:23 PM

Is there a way to amortize a loan that I make to a family member that will automatically distribute a monthly payment that they make to me into interest income and principal amounts? I know a Loan Account can do that when I take out a loan from a bank, but what about when I am the Loaner? Currently I have an amortization schedule set up in Google Sheets, but I still have to enter each payment with splits between interest and principal manually.


  1. System closed this discussion on 08 Sep, 2021 07:30 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac