Account Keeping Plus – Administration, Bookkeeping, Compliance News & Tips MYOB Reckon Quickbooks Xero Software TrainingSmall Business

Making Business Books and Accounting Come Alive! MYOB Reckon Xero

Quickbooks – How to go about setting Chattel Mortgage up and accounting for the monthly payments in Quickbooks.

3 Comments


In Quickbooks you can set up and enter transactions for the purchase of a new car financed by Chattel Mortgage and handle all the things like trade in, stamp duty etc.
Here are the transaction details sent by a client:
New Car Ex GST $30767
GST $3076
Rego $639.00
3rd Party Ins $449.77
Stamp Duty $1017
Therefore Car Total INC GST $36000
I made an initial $500 deposit to Car Dealer
I received 3500 Trade-in
I paid an additional Limp sum of $7000 to the car dealer
I then financed $25000 via chattel mortgage
with the repayments of $520pm for 60months.

Chattel Mortgages and the like are always a little complicated. As its a chattel mortgage you should be able to claim GST upfront even if you are on cash reporting. I’ve done an example below –

1. Bring to account asset and liability:
DR MV – Asset $30,767 GST code $3,076
DR MV – Asset $1,017 GST Free
CR Chattel Mortgage Liability $34,860

2. Bring to account expense associated with purchase;
DR – Rego Expense $639 (GST Free)
DR – Insurance $449.77 (I would have thought this had GST on it)
CR – Chattel Mortgage Liability $1,088.77
Your explanation doesn’t quite make up the $36,000 that you are referring to but only 35,948.77

3. Apply initial deposit of $500
DR – Chattel Mortgage Liability $500 (No GST should be NRT code)
CR – Cash at Bank $500

4. Apply Trade In
I’ve assumed your old car was also in Quickbooks and therefore the trade in would actually be proceeds on sale of the old vehicle.
– DR Chattel Mortgage Liability $3,500
– CR Sale of Assets $3,500 (check this may have GST included)

5. Additional Lump Sum
– DR Chattel Mortgage $7,000 (no GST)
– CR Cash at Bank $7,000 (no GST)
This leaves you with a liability of $24,948.77.

6. Monthly Repayments
The difference between your total monthly repayments and the liability is the interest you are charged. I would suggest you talk to your accountant to work out a schedule on how you should apply the interest. If your handy with excel you might be able to do it yourself.
– DR Chattel Mortgage (Principle Repaid)
– DR Interest Paid
– CR Cash at Bank

Advertisements

Author: accountkeepingplus

Administration, bookkeeping and compliance for small business, Training, trouble-shooting, or we can do the books and payroll for you! Self Managed Superannuation Fund Service Provider, free support MYOB Certified Consultant, Reckon/QuickBooks Professional Partner.

3 thoughts on “Quickbooks – How to go about setting Chattel Mortgage up and accounting for the monthly payments in Quickbooks.

  1. Hi, I do believe this is an excellent site.
    I stumbledupon it I’m going to revisit once again since I book-marked it.
    Money and freedom is the greatest way to change, may you be rich and continue to help other people.

    Like

  2. I tend not to write many responses, but I did a few searching and wound up here Quickbooks – How to go about setting Chattel Mortgage up and accounting for the monthly payments in Quickbooks.| AccountKeepingPlus – Administration, Bookkeeping, Compliance News & Tips.
    And I actually do have 2 questions for you if you don’t mind. 😛 And, if you are posting at additional social sites, I’d like to keep up with everything fresh you have to post.
    Could you make a list of all of all your communal sites like your Facebook page, twitter feed, or linkedin profile?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s