how to set up a loan in quickbooks online

Effortlessly Set Up a Loan in QuickBooks Online: Step-by-Step Guide

By Daniel Walker
AD

Streamlining your business finances is easier than ever with QuickBooks Online, which offers a robust set of features to manage your cash flow efficiently. One such feature is the ability to set up loan accounts and track your loan balances, interest, and payments. Here's a step-by-step guide on how to set up a loan in QuickBooks Online.

Before diving into the process, ensure you have a basic understanding of how loans work in QuickBooks Online. Loans are considered liabilities and reduce your equity. They can be for various purposes, such as purchasing equipment, funding business expansion, or managing cash flow during slow periods. Let's get started!

Setting Up a Loan Account

Your first step is to create a loan account to track the liability. QuickBooks Online provides a simple interface to accomplish this task.

AD
How to Set Up a Loan in QuickBooks Online
How to Set Up a Loan in QuickBooks Online
How to Record a Loan in QuickBooks Online?
How to Record a Loan in QuickBooks Online?
an email form with the text how to set up a loan quickbooks tip on it
an email form with the text how to set up a loan quickbooks tip on it

1. Navigate to the left sidebar and click on "Settings" (the gear icon), then select "Account and Settings".

Creating a New Loan Account

2. In the "Accounts" tab, scroll down to the "Loans" section and click "New".

How To Record Loans & Loan Payments in Your Bookkeeping (Including Shopify Capital Loans)
How To Record Loans & Loan Payments in Your Bookkeeping (Including Shopify Capital Loans)
How to Setup your Loans in QuickBooks
How to Setup your Loans in QuickBooks

3. Enter the loan details such as Loan Name (e.g., Business Expansion Loan), Account Type (select 'Loan'), Detail Type (choose the appropriate type, e.g., 'Bank Loan'), and add a description if needed. Leave other fields as is, and click "Save and Close".

Entering Loan Details

4. Back in the "Account and Settings" menu, click on "Advanced" and then "Chart of Accounts" to ensure your new loan account is added to your chart of accounts.

AD

5. Once your new loan account is set up, it's time to record the initial loan transaction. Go to your "Banking" tab and select the appropriate bank account where the loan was deposited. Click on "New transaction" and enter the following details:

  • Date: The date when the loan amount was deposited into your bank account.
  • Account: Select the bank account where the loan was deposited.
  • Payment: Enter the loan amount (negative value, as it increases your liability).
  • мем 자리에 Loan Account: Select the loan account you created earlier.

6. Click "Save and close" to record the transaction. Now your loan account is set up and ready to be used.

Tracking Loan Payments

QuickBooks Online allows you to track loan payments automatically, updating your loan balance and interest accordingly. Here's how to set it up:

AD

1. Navigate to the loan account you created by going to the "Accounting" tab and selecting "Chart of Accounts". Then, click on the loan account under the 'Loan' category.

Setting up the Amortization Schedule

2. In the loan account details, scroll down to the 'Payment and Interest' section, then click on "Set up amortization schedule".

3. Enter the loan's details, such as the principal amount, interest rate, and term (length) of the loan. Click "Next".

AD

4. Choose the 'Payment method' (select 'Equal payments' if you have a fixed monthly payment). Click "Next".

5. Review the 'Loan details' and 'Payment details', and click "Finish". QuickBooks Online will now calculate your loan amortization schedule, tracking your loan balance, interest, and payments for you.

Recording Loan Payments

6. To record a loan payment, go to the "Banking" tab, select the appropriate bank account, and click on "New transaction".

7. Enter the following details for the loan payment:

  • Date: The date when the loan payment was made.
  • Account: Select the bank account that was used for the loan payment.
  • Payment: Enter the loan payment amount (positive value).
  • Memo: Enter 'Loan payment'.

8. Click on "Save and close". QuickBooks Online will automatically apply the payment to your loan account and update your loan balance and interest accordingly.

As you can see, setting up and managing loans in QuickBooks Online is a straightforward process that can help you maintain accurate financial records. By automating loan amortization and payments, you can focus on growing your business while QuickBooks handles the financial heavy lifting. Start streamlining your finances today, and remember to keep your records up-to-date for smoother bookkeeping and tax preparation.

AD