Skip to main content
September 26, 2019
Solved

How to add car loan with down payment (expense) and record it as fixed asset?

  • September 26, 2019
  • 3 replies
  • 0 views

how to add car loan with down payment (expense) and record it as fixed asset? example: car cost 5000, down payment 1000, loan amount: 4000, monthly instalment: 400 (inclusive of interest) and fixed asset depreciation at year end.

Best answer by Rustler

@ nazeef

in the chart of accounts create:
fixed asset car
sub fixed asset account car accumulated depreciation
loan liability account car

and if you do not have depreciation on any other assets, create an expense account called depreciation expense

open the register for the loan account you created and make a new entry as an increase in the amount of 4,000 and use the fixed asset car account in the account block

write a check on the bank you paid the down payment from and use the fixed asset car as the expense for the check, enter the amount 1,000

You make payments to the loan using the loan account as the expense for the payment, when you get next months statement in, it will show the amount of the previous payment that was interest, do a journal entry back dated

debit interest expense for the amount shown on the statement
credit loan liability account

annually you calculate and post accumulated depreciation using a journal entry
debit depreciation expense
credit car accumulated depreciation

3 replies

Rustler
RustlerAnswer
September 26, 2019

@ nazeef

in the chart of accounts create:
fixed asset car
sub fixed asset account car accumulated depreciation
loan liability account car

and if you do not have depreciation on any other assets, create an expense account called depreciation expense

open the register for the loan account you created and make a new entry as an increase in the amount of 4,000 and use the fixed asset car account in the account block

write a check on the bank you paid the down payment from and use the fixed asset car as the expense for the check, enter the amount 1,000

You make payments to the loan using the loan account as the expense for the payment, when you get next months statement in, it will show the amount of the previous payment that was interest, do a journal entry back dated

debit interest expense for the amount shown on the statement
credit loan liability account

annually you calculate and post accumulated depreciation using a journal entry
debit depreciation expense
credit car accumulated depreciation

January 15, 2020

no matter what I do, the down payment on a vehicle doesnt shpw up on my p&l?

September 26, 2019

purchasing the car is  one transaction resulting in having an asset worth 5,000.  (It is not an expense, but an investment & shows up on balance sheet not P&L)

having a loan is one transaction resulting in having a liability of 4,000.  Loan Balance also shows up on P&L.

when you make a loan payment, you need to show the principle paid to the liability account so the Balance Sheet improves

& the amount of interest paid should be posted as an expense which will show up on the P&L. 

At year end you can make a depreciation entry (our accountant gives us a list of adjusting journal entries for depreciation) I'm doubt if India's rules are identical to USA rules.  Our depreciation shows in P&L as expense & also in  Balance Sheet as a reduction in worth of car.

December 6, 2020

please explain how loan balance shows up on the P&L

December 6, 2020

The confusion ends here, @LNB.

 

Allow me to fill you in on everything you need to know about how loan balance is reported in QuickBooks.

 

A Profit and Loss report will not show a loan balance, most likely, payments of non-expense items from cash flow like liability reductions any more than borrowing the money in the first place would show as income. Since a loan balance is considered as a liability receipt, it'll appear on the Balance Sheet or Statement of Cash Flow reports.

 

To learn more about the Balance Sheet report, feel free to read this article: What is a Balance Sheet report?

 

Please visit our Community forums again for all of your QuickBooks needs. I'm always here to help. Have a wonderful day!

September 26, 2019

Dr.   fixed asset   5000

Cr-   Shareholder / cash / bank  1000

Cr- Finance company 4000


at the time of paying to finance company

Dr- Finance Company 400

Cr-  Shareholder / cash / bank

qbteachmt
September 26, 2019
Don't rely on Debits-Credits. When you pay something from banking, that is a Check or Expense entry and typically Split into two lines: Principal (the loan) and Interest expense.