Skip to main content
E
eastend1
March 17, 2023
Solved

How to record payoff of loan on client trade in

  • March 17, 2023
  • 3 replies
  • 0 views

Hello, 

 

I am trying to figure out the following transaction. Business is a boat dealership. Historically when clients trade in boats for new boats we 1) create a bill and input item purchased (traded in) at trade in value with negative offset going to Client Trade Liability account. This creates a zero bill. 2) when we are ready to invoice client for new boat we add in trade as a separate line item (negative). This reduces what they owe and also reduces taxes they owe. It also removes the liability. The system works well for keeping track of our liabilities and properly accounting for sales tax.  

 

Issue I have is client traded in boat for value of $150k. We needed to payoff the loan which was $100k to bank. I am having trouble using the above system because I am not sure where the $100k check should be logged to. We took possession of the boat and sold it weeks later. Just need a fresh set of eyes. Appreciate the help

Best answer by Rainflurry

@eastend1 

 

The negative offset for client trade liability (the amount the client will receive on trade) must match the purchase price we paid for their old boat.  Following your logic the client trade liability will be reduced by the equity (gap between trade value and amount owed on trade). 

 

Yes, that's correct.  Why would you book the entire liability to the client trade?  You only have a liability to your customer of $50K.  The remaining $100K is a liability to the lender.  From an accounting perspective, when you take in the trade, you debit the boat asset for $150K and credit the client trade liability for $50K and the lender liability for $100K.  That books $50K for that customer that can be applied against their new purchase and leaves the $100K balance as a liability that you need to close when you pay off the lender.   

3 replies

MariaSoledadG
MariaSoledadG
March 17, 2023

I'll show you how you can pay off the loan, eastend1.

 

In QuickBooks Online (QBO), you can set up a liability account to record the loan and its payment and be able to track what you owe. To do so, you can follow the steps below:

 

  1. Go to the Gear ⚙ icon, then select Chart of Accounts.
  2. Select New to create a new account.
  3. From the Account Type ▼ dropdown, select Long Term Liabilities. If you plan to pay off the loan by the end of the current fiscal year, select Other Current Liabilities instead.
  4. From the Detail Type ▼ dropdown ▼, select Notes Payable.
  5. Give the account a relevant name.
  6. Choose when you want to start tracking your finances. In the 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. Select Save and Close.

 

Once you want to make a payment towards the loan, you can record it against this account. To enter loan repayment. Here's how:

 

  1. Select + New.
  2. Select Check. Or if you're in the Business view, follow the steps to switch to Accountant view first. Then come back to these steps.
  3. Add a check number if you plan to send an actual check. If you use direct withdrawal or an EFT, enter Debit or EFT in the Check no. field.

 

Next, enter the following in the Category details section of the check:
 

  1. On the first line, select the liability account for the loan from the Category dropdown. Then enter the payment amount.
  2. On the second line, select the expense account for the interest from the Category dropdown. Then enter the interest amount.
  3. On additional lines, add any additional fees. Select the appropriate accounts from the Category dropdown.
  4. When you're done, select Save and close.

 

Moreover, learn how to you can run basic reports so you'll be able to acquire the information you need: Run Reports In QuickBooks Online.

 

Please touch base with us here if you need further assistance when recording a loan. We'd be glad to help.

E
eastend1Author
March 17, 2023

That doesn’t answer the question. We didn’t take a loan out. We paid off a loan associated with something that was traded in to us. 

Rainflurry
Rainflurry
March 17, 2023

@eastend1 

 

The $100K loan payoff can be added as another line item on the bill.  Create a liability account called 'Client Loan Payoff' (or something similar).  Then, add that line item to the bill as -$100K.  So, you will have a bill with $150K for the boat value, -$50K Client Trade Liability, and -$100K Client Loan Payoff, which nets to $0.  Then, when you pay off the loan, assign the newly-created 'Client Loan Payoff' liability account to the check/payment. 

    E
    eastend1Author
    March 18, 2023

    I think you are on the right track. However I still cannot get this to work. The negative offset for client trade liability (the amount the client will receive on trade) must match the purchase price we paid for their old boat. Following your logic the client trade liability will be reduced by the equity (gap between trade value and amount owed on trade). Any other ideas here? 

    Rainflurry
    RainflurryAnswer
    March 18, 2023

    @eastend1 

     

    The negative offset for client trade liability (the amount the client will receive on trade) must match the purchase price we paid for their old boat.  Following your logic the client trade liability will be reduced by the equity (gap between trade value and amount owed on trade). 

     

    Yes, that's correct.  Why would you book the entire liability to the client trade?  You only have a liability to your customer of $50K.  The remaining $100K is a liability to the lender.  From an accounting perspective, when you take in the trade, you debit the boat asset for $150K and credit the client trade liability for $50K and the lender liability for $100K.  That books $50K for that customer that can be applied against their new purchase and leaves the $100K balance as a liability that you need to close when you pay off the lender.   

      I
      InControl_1
      February 22, 2024

      I have a very similar situation. Curious if you are willing to share how you invoiced the sale with trade in and loan payoff amount to the customer? Did you just tack on the rollover loan amount to the sale price of the new unit? 

       

      Thank you!

      E
      eastend1Author
      February 23, 2024

      I recorded the invoice with trade in normally (see my original post above). Use negative value for trade in which is linked to corresponding liability account. 

      The money going out of the bank to bank (to payoff loan) I made an asset (Trade-in Loan Payoffs). Thought process is that since I paid the loan off the client owes me if they want the boat back.

      When the new boat arrives and we invoice the client I record on invoice their trade in against the new boat purchase as I do for all transactions. The client effectively owes me now for the old boat and new boat. In my case client took out new loan and funding arrived to our bank account. Created a bank deposit that zeroed out the Trade in Loan Payoffs account and the difference applied to their invoice balance to match what arrived in the bank.

      Hopefully this helps - it’s confusing but the guy above that answered the question helped. Don’t over think it. 

      Terms & ConditionsAccessibility statement