how to record a loan payable in quickbooks online

Learn to Record Loan Payable in QuickBooks Online

By Robert Walker
AD

Recording a loan payable in QuickBooks Online is a crucial step to keep your accounting books up-to-date and maintain a clear overview of your business' financial health. This process involves setting up the loan as a payable and tracking the repayment schedule. Let's dive into the detailed step-by-step process to record a loan payable in QuickBooks Online.

Before we begin, ensure you have QuickBooks Online access with appropriate permissions. If you're unsure, consult your accountant or QuickBooks support for assistance.

Setup the Loan Payable

Setting up the loan payable correctly sets the foundation for recording and managing your loan. Here's how you can do it in QuickBooks Online.

AD
How to Record a Loan in QuickBooks Online?
How to Record a Loan in QuickBooks Online?
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 Set Up a Loan in QuickBooks Online
How to Set Up a Loan in QuickBooks Online

Firstly, you'll need to create a new loan account if one doesn't exist. To do this, navigate to your Chart of Accounts, click 'New' in the upper-right corner, select 'Loan' under 'Add New', and fill in the necessary details like Account Name, Detail Type, and open the account.

Create the Payable Transaction

Once the loan account is set up, you can now create the payable transaction representing the date the loan was taken out.

How To Record Bank Deposits in QuickBooks Online
How To Record Bank Deposits in QuickBooks Online
QuickBooks Loan Manager Tutorial
QuickBooks Loan Manager Tutorial

Here's how: - Go to 'Create' in the upper-right corner and select 'Receive Money'. - Choose 'Bank Deposit' as the payment type since you're receiving funds. - Fill in the relevant fields such as Date, Account, and Payee (ensure it's the lender's name). - In the 'Detail' section, link the transaction to the loan account you created earlier. - Click 'Save' and then 'Close' to complete the transaction.

Record Loan Interest Expense

Loans typically incur interest, which is an essential expense to track. QuickBooks Online offers a dedicated feature for this – the 'Loan Interest' feature.

AD

Here's how to set it up: - Navigate to 'Settings' and then 'Accounting'. - Under the 'Advanced' tab, you'll find 'Loan Interest'. Click 'Manage'. - Add the loan details – Principal Amount, Interest Rate, and Term (in months). - Click 'Save' to create the loan interest schedule.

Track Loan Repayments

Regularly tracking loan repayments ensures you stay current with your lender and maintain accurate financial records.

QuickBooks Online simplifies this with its user-friendly interface.

AD

Schedule Repayments

Automating loan repayments saves you time and ensures consistency. Here's how to schedule repayments:

- In the 'Pay Bills' tab, click '+' to create a new bill. - Fill in the lender's details and the amount to be repaid. - Under 'Due Date,' click on the date when the repayment is due. It will automatically calculate the interest for you. - Click 'Save' to save the bill. Once saved, it appears under the 'Scheduled' tab. - To view the payment schedule, click on the arrow next to the bill under 'Scheduled' and select 'View Payment Schedule'.

Record Repayment Transactions

When the loan repayment date arrives, you'll need to record the transaction in QuickBooks Online.

AD

- Go to 'Create' and select 'Pay Bills'. - Choose the loan repayment bill from the list. - Review the details and click 'Pay' if everything is correct. - You'll see the 'Applied Payments' list, ensuring the correct amount is being paid. - Click 'Done' to finish the transaction.

Managing loan payables in QuickBooks Online becomes straightforward once you've mastered these steps. Stay on top of your business' financial health by keeping your loan payables up-to-date. As your business grows, consider exploring QuickBooks Online's advanced features to streamline your accounting processes even further.

AD