Showing results for 
Search instead for 
Did you mean: 
NEW Connect to DBS IDEAL direct bank feeds Click here
JD 4207
Level 1

Creating and tracking 12 month loans



Need some help please. 


We give loans to clients which are paid back over 12 months.


I need help to allocate the loan correctly and then to allocate the repayment - capital plus interest correctly. 


Can i then also somehow create a running statement for clients to show their outstanding balance? 


Any advice would be much appreciated. 



2 Comments 2
QuickBooks Team

Creating and tracking 12 month loans

Good day, JD 4207. I have all the steps you'll need to allocate the loan and repayments correctly, along with running statements for clients.


The first step to start recording a loan for a client is to determine its purpose. If the loan requires a written check and serves other purposes apart from closing open invoices, follow the steps below:


  1. Go to Settings and select Chart of accounts.
  2. Click New, then set the Account Type to Non-Current Assets with the detail type Other Non-Current Assets since the loan will be paid back over 12 months or after the current financial year.
  3. On the Detail Type dropdown, select Loans to Others.
  4. Add a recognisable name like "Customer Loan-Lastname".
  5. Save and Close without entering an opening balance.


Next, let's issue a check for the loan:


  1. Click + New, then pick Cheque.
  2. Pick the account used to fund the loan for the Bank Account.
  3. In the Category details section, specify the account used to track the loan as the offsetting account.
  4. Enter the amount, then Save and close.


When allocating the repayment of capital plus interest, create a Bank deposit where you input the principal amount on the first line and utilize the Interest Income account on the second line. For detailed instructions, refer to this article and proceed to Step 3 under Option 2: Record customer payments.


Additionally, you definitely can create a statement for your clients. Since you'd like to show their outstanding balance, consider sending a Balance Forward. Here's a reference for your guide: Create and send customer statements in QuickBooks Online.


Furthermore, save this link to learn how to document uncollectible money owed: Write off bad debt in QuickBooks Online.


Know that I'm committed to ensuring you record the loan accurately. Let me know if you have other inquiries. I'll be here to support you.

JD 4207
Level 1

Creating and tracking 12 month loans

Thanks for the help. 


We have connected quickbooks to banking so our loan paid out is in the banking feeds. 


You mentioned i need to create a new Cheque manually but what then happens to the bank feed transaction? Do i need to exclude it?