Showing results for 
Search instead for 
Did you mean: 
Discover the updated GST rates in QuickBooks Online Singapore Find out more
Imran Opal
Level 1

Loan entry in QB

Hello, I borrowed a loan of $10000 from my customer and we agreed that I would pay $1000 every week. He deducted the amount from the invoice which I bill him weekly. The loan was paid on December 11th, 2023, and is divided into 10 installments. I am having trouble recording it in my QB online and adjusting my weekly payment as I used to simply match the received payment to my banking. However, after the deduction, I am not able to match the banking amount and billed amount. Can you please guide me on how to correctly record the loan and make the necessary adjustments to my weekly payments?

3 Comments 3
QuickBooks Team

Loan entry in QB

Thank you for stopping by the Community today, Imran, 


To provide you with the best assistance possible, I will need to gather more information about your concern. May I know if you've created a journal entry to track the loan or recorded a billable expense? Could you provide more details on how you adjusted the weekly payment?


Any details you can provide will help determine the next steps for troubleshooting and resolving the issue.


I'll be on the lookout for your response. Thank you in advance for your response, and have a great day, Imran.

Imran Opal
Level 1

Loan entry in QB

Yes, I have received the weekly payment, and from the banking section, it goes to A/R and then matches that amount to invoices simply.

1. Create Invoices  ( for the whole week, mostly 30 to 35 approx).

2. Send them to the customer.

3. Received the amount in the Bank (which is linked with QBO).

4. Go to invoices and click on received payment.

5. Select the invoices that are equal to the amount received from the customer.

6. Select the amount then click on save close or received.

But now the customer deducts $1000 as a loan installment from the weekly amount and pays the remaining amount through the bank.

I hope now you can understand my point of question.

QuickBooks Team

Loan entry in QB

Let's make sure to record your loan and be able to track it correctly, Imran.


You'll have to set up your liability account so you can accurately track your loan in QuickBooks Online (QBO). To do so, follow the steps provided below:


  1. Go to the Gear ⚙ icon and select Chart of accounts.
  2. Select New to create a new account.
  3. From the Account Type ▼ dropdown, choose Non-current liabilities. If you plan to pay off the loan by the end of the current financial year, select Current liabilities instead.
  4. From the Detail Type ▼ dropdown, choose  Bank loans or Long term borrowings.
  5. Provide an account with a relevant name.
  6. Choose when you want to start tracking your finances. In the Unpaid balance field, enter the amount in the account, and determine the as of date. Enter today's date if you want to start tracking immediately.
  7. Click Save and Close.


Once done, record the money you get from your loan affecting the Accounts Receivable (AR) and liability account. This will reduce the loan balance and will serve as credit or payment for the open invoice.  Here's how:


  1. Click the + New.
  2. Select Journal entry.
  3. On the first line, choose the liability account you just created from the Account dropdown. Enter the loan amount in the Credits column.
  4. On the second line, locate your bank account from the Account dropdown. Enter the same loan amount in the Debits column.
  5. When you're done, Hit Save and close.


After that, receive the payment to link the journal entry to your invoice. However, if you plan to use your loan money differently, you can reach out to your accountant to guide you further since the process is complex and requires more knowledge when it comes to accounting.


In addition, QuickBooks offers a variety of reports that you can use to cater to your business needs. Learn how to customise them to get the right information for your business: Customise Reports In QuickBooks Online.


If you have additional questions about recording loans, please don't hesitate to reach out to us so we can help you.