Partner Zone

Capital Purchases and Finance in AccountRight

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner
Ultimate Partner

4,553Posts

1,787Kudos

723Solutions

HOW TO RECORD CAPITAL PURCHASES AND FINANCE IN ACCOUNTRIGHT

 

There are many finance options available to purchase capital equipment. Commonly used in Australia are:

 

  • chattel mortgages: ownership of the item transfers to the business when the lending company pays the supplier of the goods.
  • hire purchase: ownership of the goods remain with the lending company until the agreement is paid out.
  • lease agreements: ownership stays with the leasing body and the goods are never owned by the business.
  • personal loans: these loans are usually from those close to the entity (e.g. directors, family or benevolent friends) and can be treated in the same manner as a chattel mortgage.

This article will focus on chattel mortgages as it is the most commonly used within the SME community. It will look at:

 

  • purchase of capital equipment with a long depreciation period (e.g. warehouse racking or workshop machinery)
  • repayments
  • handling purchases of motor vehicles.

PURCHASE OF ITEMS

 

Prior to recording the purchase transaction in AccountRight, you need to:

 

1. Assemble all the necessary paperwork – these may include:

  • details of the purchase including any relevant serial numbers
  • details of any deposits paid
  • details of the disbursement from the loan document

You should also determine:

 

  • The total cost of the loan
  • The amount of interest payable
  • Establishment fees

2. Discuss with your accountant as to how they would like the items recorded in the Balance Sheet. They may be happy with it being recorded under one of the generic accounts, or they may ask that it be set up as a new account on the Balance Sheet.

 

  • Every capital account must have an account immediately below it to show the depreciation accumulated to date. For example:

1-2901               Machinery At Cost                             CAP

1-2905               Machinery Accum. Depreciation       N-T

Or

1-2910               CNC Bridgeport Mill                            CAP

1-2950               CNC Mill Accum. Depreciation           N-T

 

  • The loan must be established on the chart of accounts with an account called ‘Unexpired Interest’ (see below). This is always set up as a Liability Account (Long Term) and is normally done as a Credit Card type account, so that money can be spent from and received into this account.

2-2100               ABC Loan for CNC Mill                     N-T

2-2105               Unexpired Interest on ABC Loan      N-T

 

  • In AccountRight, you do not receive money from the loan company – the loan is always populated by spending money from it.

Entering the transactions in AccountRight

 

In the example below, the equipment bill is listed as $89,590.20 with an interest of $12,863.05, totalling $102,453.25. The loan is to be paid back over 48 payments – 47 payments of $2137.57 and one payment of $1987.46.

 

  1. Create a card for the finance company. In our example, we’ll call it ‘ABC Loan’ .
  2. Create a purchase transaction for the equipment ($89,590.20), bearing in mind the following:
  • Enter in detailed information (e.g. description of the item, particularly serial numbers, and information on warranty)
  • The account should be the 1-xxxx determined earlier
  • If you have multiple locations, it should also define where the item is to be located

Purchase.png

 

3.Pay the bill, selecting the ‘Pay from Account’ as the 2-xxxx loan account set up earlier and entering in the amount of the loan ($89,590.20).

 

Pay Bills.png

 

Upon recording this example transaction, both the 1-xxxx account and the 2-xxxx account now have a value of $89,590.20.

 

4. Create a Spend Money transaction with the 2-xxxx loan account as the Pay from Account, and the Acct No. as the 2-xxxx Unexpired Interest account. In our example, the unexpired interest amount is $12,863.05.

 

Spend Money.png

 

In our example, the accounts now look like this:

 

Accounts list.png

 

That is the last time you’ll need to touch the 1-xxxx accounts until the accountant finalises the accounts and gives you a depreciation figure.

 

A word of warning – unless you are familiar with the depreciation schedule that the accountant is using you should not attempt to determine the depreciation yourself. The depreciation is normally journaled in as part of the alignment journal and the other side of it is Depreciation on the P & L.

 

REPAYMENT OF LOAN

 

Making your first Payment

 

As the establishment fee is normally added to the first payment, the first payment may be slightly higher than the remaining payments.

 

  1. Create a Spend Money transaction, selecting your bank account as the ‘Pay from Account’
  2. The payment should show the repayment amount for the loan, including the establishment fee (if applicable). In our example, this would look like the following:

2-2100               ABC Loan                        $2137.57          N-T

6- xxxx               Bank Charges                $432.95             FRE

 

Spend Money 2.png

 

Note:

 

If you have a complete schedule from the finance company, it can be entered as:

 

2-2100               ABC Loan                $500.00             N-T

2-2105               Unexpired Interest    $1508.08          N-T

6- xxxx               Bank Charges          $432.95            FRE

 

This method means that you have to make changes every month reflecting the principal/interest. You may be more comfortable leaving this adjustment to the accountant come EOFY, as it does not affect your day-to-day reporting.

 

Making the second (and the next 46) payments

 

  • These can be made following either of the above examples, minus the bank charges.
  • It is better to wait until the money has come out of the bank and either picked up by bank feeds or shown on a statement to create the Spend Money transactions.
  • If the finance company imposes fees for late payment, these should be allocated to a Bank Charges account. Penalty Interest should be allocated to an Interest Expense account – normally a 9-xxxx.

Making the final payment

 

  • Confirm with the loan company the amount of the final payment - it should be the net amount on the loan minus the unexpired interest.
  • After the final payment is made, any amount on the loan account should equal the Unexpired Interest, but in opposite direction. Payment from the Loan to Unexpired Interest should zero both lines.

 

HANDLING MOTORISED VEHICLES

 

All motorised vehicles have a relatively short depreciation period compared to plant and equipment so are separated on the accounts list. There are also different ways of writing down the value of a motor vehicle, so seek the advice of your accountant.

 

In recording any vehicle purchase, remember to record the Vehicle Identification Number (VIN) as it may be required for audit purposes. Other items that should form part of your record are the make, model, colour and registration number.

 

Trucks, off-road vehicles, tractors, fork lifts, trailers and vehicles that are not passenger vehicles can be treated in the same manner as the equipment entries we used in the example above.

 

This is also true of motor vehicles with a purchase price less than the Luxury Car Tax threshold. However, consideration should be given to the balloon, which seems to be an increasingly common means of writing loans for motor vehicles.

 

The Balloon

 

The balloon refers to the amount remaining after the number of payments specified in the contract has been paid. This amount needs to be paid back to the finance company to finalise the loan agreement. It is generally less than the written down value of the vehicle at the completion of the loan. Commonly, the balloon is rolled into a new loan figure as the vehicle is changed for a later model. Any loan document must specify the amount of the balloon at the completion of the loan.

 

Below are the accounts required for a loan with a balloon:

 

1-xxx0                              M-V at Cost

 

1-xxx5                              M-V Accum Dep

 

2- xxx0                             XYZ Loan M-V

 

2- xxx5                             XYZ Loan Unexp. Int.

 

2-xx10                              XYZ Loan – Balloon

 

As with equipment loans, the loan is set up as a Credit Card type account.

 

Using either Spend Money or Purchase and Pay Bill transactions, the vehicle is paid for from the loan account.

 

Using Spend Money, the balloon is paid to the 2-xx10 account.

 

The balance of the figure is then paid, using a Spend Money transaction, from the Loan Account to the Unexpired Interest Account.

 

Deposits Paid

 

Most car traders require a deposit to be paid by the owner/director. This becomes the first payment to the motor vehicle cost. On some occasions, this is included in the payment from the loan company and the deposit refunded by the car trader. The deposit should show as coming from and returning to the Director’s Loan account.

 

Trade In

 

A trade in is seen as a sale from your business to the car trader and must be acknowledged as such. It is normally recorded as an Other Income type account (8-xxxx Sale of Assets) with funds flowing to and from the Undeposited Funds account or another clearing account.

If you are trading in a vehicle that is above the Luxury Car Tax Threshold (see below), there are rules that need to be followed and are outside the scope of these notes.

 

Luxury Car Tax Threshold

 

The government has determined that the vehicles over a certain value cannot be written off as a business expense.

For the 2016 financial year, the Luxury Car Threshold is $63,184, or $75,375 for a fuel efficient vehicle.

 

There are some exceptions to the application of the threshold. Most notable are utilities, emergency vehicles, vehicles specifically modified for use by disabled drivers/passengers, and vehicles purchased by registered charities. Any LCT 4-door utility should be discussed with your accountant and/or the ATO.

 

Anything outside the LCT threshold cannot be claimed and the CAP figure should be 1/11th of the LCT limit.

 

This means that if there is a loan supporting this purchase, the first $63,184 can be paid from the loan towards the vehicle as CAP. The unexpired interest and any balloon considerations should also be paid from the loan account. The remainder of the loan should be paid to the Director’s Loan account and this account used to pay the remainder of the vehicle, coded N-T.

 

I understand this is a very vast and complex topic. I have opted to concentrate on Chattel Mortgage, being the most common form of financing. And included a brief description of the difference between the various forms of finance.

 

Should you need any further information on anything covered in this article, or would just like to chat about finance, please comment below. I’d be happy to discuss.

 

Happy reading!!

 

Ron Boulton

BAS Group
1300 BAS GRP (1300 227 477)
ron@basgroup.com.au

39 Comments
Liam_M
3,488 Posts
Former Staff

Thanks for your very detailed article @ronatbas!

 

Capital purchases are often asked about, chattel mortgages in particular. This will be a fantastic reference material for anyone wanting to know how to record these purchases and deal with the financing. I'll certainly be directing people to this information in future.

CloudMindAcc
Ultimate Partner
1,949 Posts
Ultimate Partner

Thanks ronatbas great information and examples will also be referring to this blog to my clients as well.

DuncanS
Ultimate Partner
1,889 Posts
Ultimate Partner

Ron,

 

Very detailed article.

 

A few observations -

 

  The Card for the Finance Coy should include the monthly amount.

 

  I would set up 2 Cards  ABC Loan 47 by $2137.57

                                        ABC Loan final Oct 19 $1987.46

 

The Luxury Car Threshold (ie when Luxury Car Tax is charged) and the Luxury Car Limit for depreciation and Input Tax Credits are 2 different figures.

My understanding is that the Luxury Car Limit for depreciation and Input Tax Credits for FY16 is $57,466.

The maximum amount of Input Tax Credits that can be claimed is $57,466 / 11 = $5224.

If there is personal use, I reduce the $5224 by the personal use %.

 

If a car costs more than $57,466, I create a separate ledger called MV (over $57466).

This is important in working out a potential profit on sale given that depreciation at 15/30% means a car is often written down faster than its resale price.

 

Accounting for cars is indeed complex - as you say all business owners should consult their accountant for advice. Cloud Accounting should assist in getting regular advice from an accountant.

 

Duncan Smith

Business Advice + Tax

 

 

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

@DuncanS

 

Hi Duncan

 

I don't know how many times I thought I must remember to put the amount after the Loan name and then sent it off without doing so. I really like your system of also adding the number of payments and your further input re LCT - Suja had given me a 'deadline' and I was already pushing the boundary on that so I didn't complete the LCT. I also like your treatment of  LCT vehicles on the COA.

Regards

Ron

Suja_P
5,976 Posts
Former Staff

Thank you, Duncan (@DuncanS) for your input on Ron's blog.

 

This is exactly what we hope to achieve on these blogs. We hope for Ron's post and the discussions between experts like the two of you to benefit everyone visiting this space.

 

Thank you again Ron for providing such a detailed article for our community members.

 

Cheers,

Suja

Geoff_
Ultimate Partner
1,721 Posts
Ultimate Partner

Hi Duncan

 

Great article thankyou

 

Many thanks

 

Geoff

Busselton Bookkeeping Service

Timtam
2 Posts
Cover User

Hi

 

I am new and have been asked by the accountant to enter a general journal entry for the purchase and sale of a mv.

The client purchased the mv in 2000 privately no gst.

He sold it in 2012 for 2000 no gst.

 

I have set up an at cost MV account 1 - 2211.

 

Also what date should it be recorded as i am doing paperwork from 2011 onwards.

 

All help appreciated.

 

Cheers Tam

 

 

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

@Timtam

 

 

Sorry I missed this as it was not on the main boards.

A $2000 vehicle that is obviously more than 12 years old would be well and truly depreciated to zero so the first entry you should make is to your Depreciation on M/V which should sit immediately below 1-2211. Dr Depreciation (6-xxxx) Cr Dep on MV (1-xxxx). This could all be recorded as 30/6/11.

 

If your client is registered for GST then the sale would include GST and the account should be (8 -xxxx) Other Income.

Sam987
2 Posts
Cover User

Hi all

 

I have looked at a number of posts already regarding entering a car purchase and just can't get my head around it.

 

I am trying to record a purchase of a car totalling $41147

$500 was already paid from personal funds (say owner contribution) as deposit.

A further $3500 was paid from the business account.

 

Is it a simple matter of opening a MV asset account and doing a general journal where i Debit it $41147?

But then I am lost on the other side of the transaction. I've attached my entry - which i think looks ok for the purchase side of things

 

Do i credit Loan account for the difference ($37147)? ANd then how do i record the 2 deposits?

Apologies Its a dumb question, but hoping someone can help me.

 

Thanks in advance.

I have 3 cars to enter, so hopefully once I have it sorted on one, I can do the others.

 

Its a Chattel Mortgage, so I am claiming the GST upfront.

 

Thanks again

Capture.PNG
Suja_P
5,976 Posts
Former Staff

Welcome to the MYOB Community Forum, @Sam987. I hope you find this to be a useful resource for all MYOB related queries.

 

Thank you for your post. I have moved it to this article by Ron (@ronatbas), as you may find the information in this article to be of help to you. Furthermore Ron may also be able to assist you with your specific transaction.

 

Kind regards,

Suja Pillai
Social Support Manager
MYOB Australia Pty Ltd

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

@Sam987

 

Notionally you will have the following accounts already set up

1 xxxx Motor Vehicles at Cost

1 xxx5 Depreciation on MV

2 xxxx Directors loan account as Credit Card type account

You will need the following

2 xxxx Finance Co loan -set up as Credit Card type

2 xxx5 Unexpired Interest on Finance Co Loan

 

The bill should be set up with the account being1 xxxx MV at cost and code CAP to pick up the GST.

The smaller payments can be made from bank and director's loan account and the major payment from the 2 xxxx Finance Co Loan. These payments are detailed in the original blog.

Sally_k
Experienced User
36 Posts
Experienced User

Hi @ronatabs

your article is amazing and save my life :-) I am doing hire purchase for construction company My boss bought CNC machine  on hire purchase and your example help me very well . I want to know when you enter the purchase and use the tax code  N-T but in above lines it was CAP

1-2910               CNC Bridgeport Mill                            CAP

1-2950               CNC Mill Accum. Depreciation           N-T

 

kindly explain me which code should I use for Purchase ?

 

Another question is I  just create the depreciation account as you suggest but I don't know how their accountant do the deprecation . Is it alright if I didn't touch the depreciation and at the end accountant handle as he want to do it. Because I am doing their backlog and as well as working for current financial year but I have not any idea about depreciation.

 

Also if you can explain me how 2-2105  Unexpired Interest on ABC Loan    account will reconcile at the end?

 

Warm Regards

 

Sally 

 

 

Sally_k
Experienced User
36 Posts
Experienced User

Hi @ronatbas

 

One more question  . My boss hand over few more hire purchase documents and he bought two machines in 5 June 2014 and another 10 Oct 2014 . As I am doing back log and my boss wants me  to enter the transaction from July 2015 . I am thinking to calculate the pending amount on 1 July 2015 and start entering the transactions by following above method. Kindly advise me is it the right method to do it ?

 

Warm Regards

 

Sally

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

@Sally_k

 

I don't think any accountant expects the bookkeeper to adjust depreciation. They should have their schedules using one or other of the accepted depreciation methods and it is not up to you to second guess their preferred method. What I would be doing is scan all of the Capital equipment invoices and sending them to the accountant so that when they eventually get the file they can determine the depreciation they are able to claim. They should also advise you on the timing of the entry dates for the machines mentioned in your second note. It is all going to depend on when they last reported.

 

Going back to the purchase query - you will the 1-2910               CNC Bridgeport Mill                            CAP.

On your chart there may not be specific Item and all of the mills may be gathered up under 1 xxxx Machinery at Cost.

MYOB will puts a message about using this account ... press OK

Telperien
Contributing Cover User
9 Posts
Contributing Cover User

Hello Ronatbas,

 

Thanks so much for your assistance with my recent query, I have worked my way through most of the steps (very slowly...).

 

I have a couple of (probably rather dumb) questions still outstanding:

 

1. The car we have purchased has a balloon; I have set up the loan account, the unexpired interest account, and the balloon account. In your directions, you have said to pay for the car from the loan account, which I have done. You also then say to "Using Spend Money, the balloon is paid to the 2-xx10 account." I assume this is at the end , when the balloon is the final payment paid ?  

 

2. We put down a deposit of $3000, which was subsequently refunded to us by the dealership. I am not clear about how to record this in and out ?

 

Thank you again for your help !  And best wishes for the New Year!

 

 

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

@Telperien

 

You should move the money from the loan account to the balloon account as at the date of the loan so that loan account is representative of the amount still payable on the loan.It will not be exactly the amount payable as your accountant should do the adjustment to the interest when he finalises the accounts at year end.

 

The deposit paid, then refunded should be paid back to account that it came from. Either your trading account/Credit card or personal funds. Personal funds are generally represented on the chart of accounts as Directors Loan or Directors current account.

 

Ron

Telperien
Contributing Cover User
9 Posts
Contributing Cover User

Thanks , Ron. Much appreciated. I think I am on top of it now (temporarily,at least!)

 

Telperien

CarlyHutchings
Contributing Cover User
7 Posts
Contributing Cover User

Hi, I have followed the instructions for the purchase of a motor vehicle.  When I put through the monthly repayment, including a payment of interest, the amount of interest increases.  I would expect that this should decrease as the loan is paid off.  Can you please help with this.

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

The monthly payment should be bank to loan for the total payable. To pick up interest payment you need to do another spend money Loan Account to Unexpired Interest. This can be done periodically and is often left to end of year.

 

Ron B

DuncanS
Ultimate Partner
1,889 Posts
Ultimate Partner

@CarlyHutchings @ronatbas

 

Carly,

 

In the Liability to the Finance Company, I put the monthly amount.

It is then easy to see that the repayment is made to the correct account.

I would set up a recurring Spend Money or a Bank Rule for the monthly repayment to the Finance Company.

 

You can obtain from the Finance Company, a Interest Amortisation Schedule.

This will show the interest charged each month.

I prefer to enter a monthly journal entry for the interest (setup a recurring journal entry).

I also prefer to do monthly journals for depreciation using the simplified method available to SBE ie 15% and 30%.

Many Tax Accountants prefer to do annual entries for Interest and Depreciation - once again this is not my preference.

 

Let us know how you go.

 

Duncan

Julie_A_C
Partner
3,362 Posts
Partner

Hi @ronatbas, @DuncanS, @CarlyHutchings

 

The loan payment in total will be a spend money on the bank with allocation to the loan account.

 

Depending on the size of the small business and the depth that you want to go to in the P & L will decide whether you really need to record depreciation and interest charges on a monthly basis or you want to record them annually.

 

Depreciation for SBE is 15% flat in the year you purchase the capital item and then 30% each year after that, and you also need to take into account the SBE advantages presently in effect of being able to write off immediately items costing $20,000 or less (ex GST).

 

 

It is sometimes better to look at your P & L nett profit without accounting for interest and depreciation and thinking you may have a $20,000 tax bill coming up, and then factoring in these extra expenses later and then having less tax to pay. 

 

If you do want/need to factor them in monthly, depreciation can be set as an auto record, as the monthly amount wont change. 

 

Interest though will change each month, and reduce and will need to be obtained from the amortisation schedule if added to to the loan at the commencment.

 

 

forms
3 Posts
Cover User

Hi

 

I need some advice on this. Client purcahsed a vehcile on chattel mortgage via Volkswagon finance. The agreement is for two years and teh monthly repayment is say $1500 . The agreement has a guaranteed future value at the end of 24 months.

 

The client has paid for the 24 months and at the end of teh 24 months Volkswagon Finance has taken the vehicle back at the guarantted future value whic is also teh reamining balance owing.

 

How do I recoard this vehcile disposal in myob.

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

@forms

 

There are a couple of issues here that make me think that you really need to talk to the client's accountant.

A chattel mortgage implies that the vehicle was bought by the client. Was the agreement a separate document? 

It will depend on the book value of the vehicle at the time of sale. The accountant will need cost of vehicle, amount of loan, amount repaid to date and date of sale.

They will then work out the depreciated value of the vehicle and if there has been a profit or loss on the sale of the vehicle.

To save me writing a lot of details of processes about if this, if that, once you have the information please come back through the main part of the forum if you need further assistance.

 

Roweboat17
Contributing Cover User
6 Posts
Contributing Cover User

I am trying to comprehend this but in relation to MYOB Essentials. I have looked up Essential Chattel Mortgage but it only gives me details to record a Hire Purchase and this looked different to the advice posted here. It didnt use an unexpired Interest Account.

The details of the purchase are:

Amount financed: $81,000

Cost: $89,100

Minus deposit: $8,100

No balloon payment

Instalments made yearly (for 5 years) $18,983.07

Total Interest: $13,915.35

 

The establishment fee applies at settlement and is not financed: $401.80

 

I am trying to relate the advice above to Essentials so can anyone provide assistance or point me in the correct direction.

 

Thanks

Jo

Fishcounter
Experienced Cover User
23 Posts
Experienced Cover User

error sorry

 

aryam
Contributing User
9 Posts
Contributing User

Hi There

 

I am currently studying bookkeeping and I had a exam and the question was Luxry car purchase with chattel mortage and trade in so it is a bit connfusing however what I did I created an account under bank (trade-in clearing) and allocated the N-T tax code. My question is when I do enrty to myob how to split luxry car and trade in basically how to do myob entry ? it is very complicated I am really stuck any help would be great. 

Thanks in advance

Kind Regards

CarmenA1
1 Post
User

@ronatbas 

you had mention,

Making the final payment

 

  • Confirm with the loan company the amount of the final payment - it should be the net amount on the loan minus the unexpired interest.
  • After the final payment is made, any amount on the loan account should equal the Unexpired Interest, but in opposite direction. Payment from the Loan to Unexpired Interest should zero both lines.

but, my account shows zero from the loan account and negative from the unexpired interest account.

Example:

Credit 2-2100 ABC loan for CNC Mill                                                         $102,453.25

Credit 2-2105 Unexpired Interest on ABC loan                                     -$12,863.05

 

After all the repayment (47 payments of $2137.57 and one payment of $1987.46. total $102.453.25)

Debit 2-2100 ABC loan for CNC Mill                                                          $2,137.57

Credit 1-XXXX Bank account                                                                         $2137.57

 

This bring the 2-2100 to zero, but 2-2105 still -$12,863.05, how can I bring 2-2105 to zero?

 

Thanks

 

georgieh
Experienced Cover User
46 Posts
Experienced Cover User

Hi everyone, 

 

I've found this to be a great reference, but I'm missing a step. The same issue was mentioned above but I can't see a clear answer/instructions.

 

I have set up Unexpired Interest for the entire interest amount, and have the amortisation schedule. 

 

I have been put the monthly interest amounts against the unexpired interest, but as someone mentioned earlier, this increases the liability. 

 

What entry do I need to reflect the interest expense, as well as bring down that liability as each month goes by? (A screenshot would be great - I'm self-taught!)

 

Thanks, 

 

Georgie

SylviaTS
1 Post
User

I am looking forward to seeing the response to @georgieh  as I have the same query. Thank you

PhilipK3288_
1 Post
Cover User

Hi @ronatbas 

 

Thank you for the detailed guide.

I also have the same question as  @georgieh and  @CarmenA1

 

We have the complete amortization schedule.

 

After apply repayment of loan through Spend money to principle 2-2100 and interest 2-2105, we find the principle balance is reducing but the balance for unexpired Interest (negative amount) is growing. 

 

We worried by continue the steps, the principle amount will redue to "0", however the unexpired interest will be duble when meet maturity.

 

We are wondering if we missed some steps?

 

Looking forward for your reply, thank you.

 

Sara

AshMyob
5 Posts
User

Hello @ronatbas 

 

Would I  claim GST 1-11th to the Luxury Car Tax limit on purchase with tax code as CAP? 

Will GST registration on cash or accrual affect this? 

 

How would i treate GST on every instalment payment? 

 

Thank you all

Ash 

LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User

Hi

 

If you have the  amortization schedule you can reduce the unexpired interest.

 

When you record the repayment it should be recorded this way

eg repayment $2500 interest component $250

DR 2-XXXXLoan account  2500 N-T

CR 2-XXXX unexpired interest            250 N-T

DR 6-XXXX interest expense account  250 FRE

 

 

 

LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User

Hi Ash

 

Yes you do claim 1/11th of the cap for luxury car tax and you use CAP.

 

Whether you use accrual or cash the GST is claimed at this stage because you are claiming it all up front.

 

So the instalments are then coded against the loan and unexpired interest and the interest expense as per below:

 

If you have the  amortization schedule you can reduce the unexpired interest.

 

When you record the repayment it should be recorded this way

eg repayment $2500 interest component $250

DR 2-XXXXLoan account  2500 N-T

CR 2-XXXX unexpired interest            250 N-T

DR 6-XXXX interest expense account  250 FRE

 

If you dont have the amortisation schedule a journal can be done at the end of the year by your accountant

 

Hope that helps

 

Lisa

 

 

Hope that helps

 

Lisa

ronatbas
Ultimate Partner
4,553 Posts
Ultimate Partner

Hi Ash

 

Hi Ash

 

You need to be very clear on the finance you are using. A personal loan or similar does not have GST, a hire purchase arrangement does have GST, which I believe is now claimable at the start of the agreement. With hire purchase the vehicle remains the property of the financier and does not appear on the company accounts until such time that the HP is paid out.

These days HP is rarely used and loan is the most likely arrangement. In this case the car vendors bill is written as

1-xxxx Motor Vehicle at Cost                       $64741                 CAP

1-xxxx Motor Vehicle at Cost                       Remainder          NT

 

The loan needs to be setup as Credit Card type and is populated by using Pay Bills to pay the bill.

It is unaffected by the GST registration of the company.

 

I recently answered a similar query and you might find the notes below useful

 

Changes to Chart of Accounts

1-xx00 (Motor Vehicle) at Cost

1-xx05 depreciation on (motor vehicle)

 

2- xx00 ABC loan (setup as Credit Card type)

2- xx05 ABC loan interest (setup as Credit Card type)

2 -0007 ABC loan balloon (setup as Credit Card type)

 

8- xxxx Sale of Asset(MV)

 

I assume that you already have a Cash drawer and a Directors loan Account

 

Use Receive Money to Cash Drawer for Sale of old Vehicle 15000 Account 8-xxxx Tax CAP

 

Setup purchase Invoice for entire cost of Vehicle inc. registration, dealer fees and charges.

Line 1 should read

Vehicle details inc.  Reg #, VIN. Account 1-xx00 MV at Cost            $64741  Tax CAP

Line 2

Vehicle                                                                                                                 Difference  Tax N-T

 

 

https://www.ato.gov.au/Business/GST/In-detail/Your-industry/Motor-vehicle-and-transport/GST-and-moto...

Generally, if you purchase a car and the price is more than the car limit, the maximum amount of GST credit you can claim is one-eleventh of that limit. For 2022–23, the maximum GST credit you can claim is $5,885 (that is, 1/11 × $64,741). This limit also applies to cars which are fuel efficient.

 

Pay invoice in three steps

From Directors loan or Bank        $500

From Cash drawer                           $15000

From Loan Account                         Balance

 

We then need to set up the loan account.

Spend money from Loan Account to Interest on Loan $17K

Assuming that there is no GST on the Loan charges spend money from Loan Account to Bank charges $1301 FRE. If there is identifiable GST charge to Merchant Fees

Calculate the loan amount over $48K and use Spend Money to 2-0007 Balloon.

Monthly payments should be made Bank to Loan and the accountant can do an end of year adjustment to move some of the payment to Interest payable.

 

AshMyob
5 Posts
User

Thank you @ronatbas.

 

Very helpful.

Ash 

AshMyob
5 Posts
User

Hello @LRBooks61 

 

If i am doing a spend money lets say from cheque a/c $1,000 per month 

 

Spend money - 

Liability ac A/C code 2 - 1000

Unexpired interest A/C code 2 = (150)

Interest A/C - a/c code 6 = 150 

 

Is that correct?

Thank you again Smiley Happy

Ash 

LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User

Hi Ash 

 

yes that is perfect 

 

Lisa

huong2411
1 Post
User

Hello all,

 

I have read thru most of the thread but I can't determine which entries to setup my new car purchased in August 2022 in MYOB.

 

Here's the details of the car purchase:

Toyota Hiace 2022 GDH300R Van 5dr, LWB SA 6sp 2.8DT $40,854.64
Commercial Heavy Duty Roof Racks - 3 bar set $772.34
Technician Step (Step only) $882.30
Customer Fee $590.91
Total Price (Before GST) $43,100.19
GST Payable $4,310.02
CTP (See CTP Policy for GST) $746.79
Plate Issue $115.00
Registration $824.00
Stamp Duty $1,404.00
Total Sales $50,500.00
Total GST $4,310.02

 

The car is under finance with Wespac with the contract as below:

 

Loan amount: $50,950

Total interest charges payable: $9311.60

Repayment amount: 1004.36

Number of repayments: 60

Payment period: Monthly

 

Establishment fee: $450

 

Could someone help me create associated accounts in chart of account so that I can create correct entries in General Journal in MYOB and I could claim GST (GST Payable $4,310.02) on my new car for last quarter BAS and on going repayment recorded by matching in the monthly direct debit bank feed transaction.

 

Much appreciated your detailed response

 

Thanks,

Harry

David65
Experienced User
25 Posts
Experienced User

Hi - We purchased a vehicle for $43,900 - Finance adds $10485.03 in interest over 60 months with a balloon of $13,169.83.  Repayment is $686.92 pm.

 

Total Loan is $54,385.03

 

I have recorded purchase of vehicle and payment made by loan account however where do I record the $10485.03 in order to balance the GJ entry?

 

Thanks