Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
JoshBeall
Level 2

How can I track the due dates for principal repayments on a loan?

I have a loan that has principal repayments due at certain fixed dates. This loan is setup as a current liability account in QuickBooks, and when I make payments against the loan, I record a check (made payable to the lender), with the liability account for this loan as the category. This works fine.

 

However, I would like to be able to enter a bill so I can track the due dates for my principal repayments--I haven't been able to figure out the "right way" to do this.

 

If I enter a bill as normal and use the liability account for this loan as the category, then it records a debit to the liability account and a credit to accounts payable, which makes it look like the loan balance has decreased--when, in fact, no payment has been made. This can be particularly troublesome if it's a large repayment that's due--on the balance sheet any loans for which I've entered these bills for balloon payments (i.e., the final payment of the entire principal balance), those loans will appear with a $0 balance, and the actual balances will be added to the "Accounts Payable" balance. This is misleading because the loans are not paid off, and the due date for some of these bills could be months in the future. Still, I would like to be able to quickly see these due dates in QuickBooks, if that's possible.

 

So, in summary: All I really want to do is keep track of when the principal repayment is due, not create a phantom transfer to accounts payable. What is the recommended way for tracking due dates on principal repayments for liability accounts?

2 Comments 2
Giovann_G
Moderator

How can I track the due dates for principal repayments on a loan?

It's great to see you here in the Community, JoshBeall.

 

I understand how important it is for you to track the due dates for your principal loan repayments. Creating a bill isn't possible when tracking the loan repayment in QuickBooks.

 

You're right when you record the payment against the loan using check. Review the following article for more information in handling your loan and payments: Set up a loan in QuickBooks Online.

 

I suggest to check with your accountant for other options in tracking principal loan repayment. They can best assist you in ensuring the accuracy of your books.

 

For further "How do I" instructions, please visit our Help Articles page.

 

We're a couple of clicks away if you have further questions. Have a great day.

Rainflurry
Level 15

How can I track the due dates for principal repayments on a loan?

@JoshBeall 

 

Yeah, as you've discovered, creating bills doesn't work because entering a bill increases A/P and reduces whatever account is selected under the category.  QB Online does not have a dedicated solution for this. 

 

However, a good workaround is to create a purchase order for each payment.  That way, you can track the due dates using the Open PO List report.  POs are non-posting transactions so they do not affect your financial statements.  Also, when a specific payment is due, you can convert the PO to a bill and pay it.  That will remove the payment from the Open PO List report.     

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us