Record incoming Note payments so that principal is reduced
In general, this would be similar to you paying your mortgage, where the transaction is a split
- principal amount transfers to the mortgage account register, e.g. [XYZ Mortgage]
- interest is categorized to an interest expense category, e.g. Mortgage:Interest
only in your case, the deposit is a split
- principal amount transfers to the Lender Loan account register, e.g. [John Doe Loan] thus reducing the balance
- interest is categorized to an interest income category of your choosing
Here's an example how such a transaction would look like in my Checking account register:1
It did not reduce the principal. I'm new to Quicken, fresh off QBs. Maybe I set up my opening balance incorrectly. Under Payee I had 'opening balance', under category I had 'loan name'.0
I answered my own question by reversing the opening entry. Thank you for your help.0
The loan account register should be an Asset account.
If the loan already existed when you started using Quicken, your Opening Balance transaction should be a positive amount showing how much you are still owed.
If you're starting a new loan, the Opening Balance begins with $0.00 and the next transaction records the check you give to the borrower. In your Checking account this check is categorized as a transfer to the [loan account name].
To make the deposit reduce the outstanding loan balance, you need to categorize the transaction as transfer from Checking to the Loan account. In Quicken that's done by setting the Category to the loan account register name, surrounded by [square brackets], e.g., [Lender Loan 2] in my example.
I also need to mention that you should set up a Scheduled Reminder with Split details similar to my example. This reminder record the monthly payments.
Before the deposit is due to arrive, record this scheduled reminder in your Checking account. When you download transactions from the bank containing the deposit, Quicken will match the downloaded deposit to the already existing register transaction.
How to create a Lender loan (Money I lend someone)
Are you new to Quicken for Windows?
Please read this for more information, some videos and a list of resources to help familiarize yourself with Quicken:
Quicken Help! (Quicken for Windows)
If you're unsure on how to do something, you can find more information about a specific task, function, feature or report in Quicken Help.
To access Quicken Help simply press the F1 key from anywhere in Quicken (or click Help in the Menu bar, then click Quicken Help).
Once Help has started, use the Search tab to search using keywords, e.g., "buy security".
Some Quicken view screens may have a blue (or yellow) button with a question mark. Click it to get view - specific help.
A browser-based version is available here: https://help.quicken.com/display/WIN/Quicken+Windows+Help1
Thank you very much.0