I have a loan that I will be repaying in 1 year. I need to make 2 interest payments each for 5%. How do I record the future payments as Bills on QBO? to show in A/P

amr-ismail-trist · ‎September 12, 2021

ex: I have a loan for $1,000 that I need to pay back in 1 year. Also, I need to pay 10% interest on 2 installments. the first in 6 months the second with the total loan repayment. How can I show it on QBO as a bills so that it would show in my A/P and would remind me to pay them?

Jovychris_A · ‎September 13, 2021

Hi @amr-ismail-trist. I'm here to provide you more information on how to show future interest payments.

In relevant to my peer's response, you can add a new service item manually to show the interest rate at 5%. Then create a recurring bill transaction to show this in your A/P and remind you to pay them, including the interest payment.

Here's how:

Go to Settings and then select Recurring transactions.
Select Reminder List and then click New.
Choose Bill.
Enter Template name and Type as Reminder, remind 1 or 2 days before the transaction date.
Interval should be Monthly, and you can choose the last (for example) Monday of every 6 months.
Select the loan account in the Category Details and pick the interest payment item in the Item details.
Click Save template.

For additional details about creating a transaction and setting a reminder ahead of time, you can refer to this article: Create recurring transactions in Quickbooks Online.

I also suggest consulting your accountant for professional advice with recording this type of transaction.

If you have other questions in mind about recording loans in QuickBooks, feel free to reach us back. We're always here to help you. Stay safe!

View solution in original post

JessT · ‎September 12, 2021

Hi there, amr-ismail-trist.

Keeping your loan records accurate is really important so you won't miss any payment deadlines. I'll help by sharing the steps starting from setting up your loan account to creating bills. However, I highly suggest having this checked with an accounting professional since we'll be doing journal entries, and to make sure your books are accurate.

Set up a liability account.

Select Settings ⚙, then select Chart of Accounts.
Select New to create a new account.
From the Account Type ▼ dropdown, select Non-current liabilities. Note: If you plan to pay off the loan by the end of the current financial year, select Current liabilities instead.
From the Detail Type, select Notes Payable (or Loan Payable).
Give the account a relevant name, like Loan for the business, Loan account, etc.
Select Save and close.

Record the money you got from the loan. This step will increase the balance of the loan account and the asset account where you put the loan you got.

Click + New and select Journal entry.
On the first line, select the liability account you just created from the Account dropdown. Enter the loan amount in the Credits column.
On the second line, select the bank/asset account from the Account dropdown. Enter the same loan amount in the Debits column.
Click Save and close.

Record the bill you received. Every time you record a bill against the loan account, the loan balance decreases.

Click +New and select Bill.
Select the lending company in the Vendor field.
Enter the Terms, the Bill date, and the Bill no.
On the first line, select the loan account CATEGORY dropdown and enter the amount in the appropriate field.
On the second line, select an expense account to track the interest and enter the amount in the appropriate field.
Click Save and close.

Here's an article with a different way to record loan repayments for your additional reference: Set up a loan in QuickBooks Online.

Please don't hesitate to reach back out if you need more help tracking your loan. I'll be happy to assist you again. Take care!

amr-ismail-trist · ‎September 13, 2021

Thank you for your reply, but I am asking about how can I show future interest payments?

Jovychris_A · ‎September 13, 2021