Previously I showed you how to add an equipment loan to QuickBooks Online.
In this tutorial, I’ll show you how to record payments to that loan.
Quick Instructions:
Check payment:
- In the upper left corner click +New
- Under VENDORS select Check
- Fill in the following:
- Payee: the bank you have your loan with
- Bank Account: the checking account the money is coming out of
- Payment date: date the payment was made
- Check no.: The check number or “ACH” if using an ACH payment
- Enter a line for your loan payment where CATEGORY is your loan and AMOUNT is how much was paid towards the principle
- Enter a line for your loan payment where CATEGORY is “Interest Expense” and AMOUNT is how much was paid towards the interest
- Click Save and Close
Adding a payment to the Bank Register:
- Click Accounting in the left-hand menu
- Select Chart of accounts
- Find your loan in the list of accounts
- Click View register on the right
- Click Add journal entry and add an entry for the interest:
- PAYEE: The bank you have your loan with
- ACCOUNT: Interest Expense
- INCREASE: Your interest amount
- Click Add journal entry and add an entry for the loan payment:
- PAYEE: The bank you have your loan with
- ACCOUNT: Checking account used to pay the loan
- DECREASE: Your check amount
Only use ONE of these methods for a payment! Whichever one works best for you.
Keep reading for full instructions with screenshots.
Paying a Loan with a Check
In this example, I’m going to show you how to add a loan payment using a check.
Click the +New button in the upper-left-hand corner. Under Vendors select Check.
For Payee enter the bank that you got your loan from.
In Bank Account, select the checking account from which this money is coming.
Enter the Payment date for the check.
Enter the check number in the Check no. field or ACH if you made an ACH payment.
In Category Details, you’re telling QuickBooks why you’re giving your bank this money. In this case, it’s a loan.
In my example, I’m making a payment of $500.
- $425 for the loan
- $75 for the interest
To do this, I’ll add two line items. One will have the CATEGORY of the loan I’m paying with an amount of $425.
The other will have a CATEGORY of Interest Expense in the amount of $75.
Here’s what it looks like:
You’ll fill in the amounts for your loan according to your loan documents. The principle will be the loan payment line.
Viewing a Loan Payment on the Balance Sheet
After making a loan payment, you’ll notice that on your balance, the fixed asset amount is the same.
While the Long-Term Liability loan has decreased by the amount paid.
Adding a Loan Payment to the Bank Register
Another way to add a payment to your loan would be as journal entries on the register.
To do this, navigate to the chart of accounts by clicking Accounting in the left-hand menu and then selecting Chart of accounts.
Find your loan in the list of accounts and click View register to the right.
Click Add journal entry and add an entry for your interest:
- PAYEE: The bank you have your loan with
- ACCOUNT: Interest Expense
- INCREASE: Your interest amount
Click Add journal entry again and add an entry for your loan payment:
- PAYEE: The bank you have your loan with
- ACCOUNT: Checking account used to pay the loan
- DECREASE: Your check amount
In this method, you’re telling QuickBooks that your loan was increased by an interest expense and decreased by a check payment.
Either method will decrease the ending balance for your loan by the same amount.
In my example, both methods decreased my loan amount by $425.
You now know how to record a payment to a loan in QuickBooks Online.
☕ If you found this helpful, you can say “thanks” by buying me a coffee…
https://www.buymeacoffee.com/gentlefrog
Below is a video if you prefer to watch me show you how to do this.
If you have any questions about recording loan payments in QuickBooks, click the green button below to schedule a free consultation.
2 Responses
This was so extremely helpful! Saved me so much time while having a good understanding of how it works!
This saved me a ton of time. Thank you!