The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> New Van as Hire Purchase in Sage
Post Info TOPIC: New Van as Hire Purchase in Sage
Marios


Member

Status: Offline
Posts: 19
Date:
New Van as Hire Purchase in Sage
Permalink  

Hello everyone,

So my company have just purchased a new van as a hire purchase. After some good looking into I've come to the following:

STEPS TO POST NEW VAN

1.    Create new N/C 0052 called HP Interest suspense account. 

2.       To post Vans Value excl. VAT

Cr £xxx to 2310 (default Hire Purchase N/C)

Dr £xxx to 0050 (default motor vehicle)

3.       To post fuel and Protection fee (included in the original invoice excl. VAT)

Cr £xxx to 2310

Dr £xxx to 7304? (Misc motor expenses) 

4.       To post VAT amount to be claimed from purchase (van + fuel and protection fuel)

Cr £xxx to 2310

Dr£xxx to 2201(Purchase VAT control account) 

5.       To post the HP interest payable

Cr £xxx to 2310

Dr £xxx to 0052 

6.       To post the deposit and front payment

Cr £xxx to Bank

Dr £xxx to 2310

7.       To post every monthly instalment from there on

Cr £xxx to Bank (full payment)

Dr £xxx to 2310

Cr £xxx to 0052 (the interest part)

 

Dr £xxx to 7904(Default HP interest expense N/C)

I am not sure I need the suspense account and if I do am I correctly creating a N/C  for it or is it meant to be already in sage?



__________________
abacus12345


Guru

Status: Offline
Posts: 1363
Date:
Permalink  

If you were a builder, would you teach me step by step how to build a brick shed? I so want one, and I'd really appreciate the input. Would you be so kind to give me your time? I know if I try to do it myself I'd make one hell of a mess.

__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink  

Hi Marios,

sorry, I don't use Sage (and to be honest not a great fan of nominal codes) but sure that someone will be along imminently who is an expert with that software.

My appologies that I didn't pick this thread up earlier,

kindest regards,

Shaun.







__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink  

abacus12345 wrote:

If you were a builder, would you teach me step by step how to build a brick shed? I so want one, and I'd really appreciate the input. Would you be so kind to give me your time? I know if I try to do it myself I'd make one hell of a mess.

Johnny,

play nice or its sitting on the naughty chair for you.

Marios is not a business person looking for freebies he's a trainee accountant (ACCA) looking for some help at the nuts and bolts level.

As with many of us here his issues are not with concepts but rather with getting the software that has been enforced upon him to do what ne needs it to.  

As its a Sage question I'm not the best person to answer this one which is why I haven't but I wouldn't say things likely to put an accountancy student off using this site.

No biggy just a gentle reminder to read peoples earlier posts before jumping on them.

kind regards,

Shaun.

 



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
abacus12345


Guru

Status: Offline
Posts: 1363
Date:
Permalink  

I apologise.

Sorry.

__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 
Cheshire


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink  

Hi Marios
Can I just say - nooooo, dont do it. Not got time to answer now, but no please dont do it that way. I will try to get to this tomorrow night, although I have a boozy sesh so you might get a very drunk answer. Or a sober one by Thursday!

So instead....

hey Johnny - a challenge, should you choose to accept (or whatever the saying is!).....how about you give this one a shot, with your new found silky Sage skills? wink

 

Oh Marios - just to check. Is its Mario or Marios?  wasnt sure is the 'S' was for a surname.   Anyway I digress - what VAT scheme in the company you are working for on?  Also - do you have a full invoice/schedule showing interest split out for the full term for the item on HP? Is it definately HP (sorry have to ask as often discover that people get these things mixed up). 



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position
Leger


Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink  

Shamus wrote:
Marios is not a business person looking for freebies he's a trainee accountant (ACCA) looking for some help at the nuts and bolts level.

 Hi Shaun

Could we not include this sort of info as a part of the sign up requirements?  I know there are only 8 posts but you would have to go back to the first post to know Marios is a trainee accountant.

If you had a tick box or drop down button that indicated folks experience /level of expertise (make sure there is one that says business owner though lol) I'm sure it would help us all



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.
Marios


Member

Status: Offline
Posts: 19
Date:
Permalink  

Good afternoon all (you too Johnny),

Thanks for the replies. I now understand why you asked me if the business was mine. No just honestly seeking a good answer to my question. 

Joanne, it's my first name and its Mariossmile 

Right so we are operating under standard VAT scheme. It is a Hire Purchase as I have a hire purchase contract - and feel free to ask anything.

Yes in the invoice the HP interest is stated in full for the whole term separately before stating the monthly instalment. ..



-- Edited by Marios on Tuesday 26th of July 2016 02:59:33 PM

__________________
Marios


Member

Status: Offline
Posts: 19
Date:
Permalink  

To be precise I have a VAT invoice of the selling value plus a fuel and protection fee.

Then the breakdown after deposits is shown in the Hire Purchase agreement and that includes the total interest charge for the whole term (60 months and then monthly)

plus an acceptance fee payable with first rental.

I apologise if I am too descriptive...

__________________
Cheshire


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink  

Oh Johnny - you didnt take me up on your challenge. BTW - did you get that one the other week? Or still on the hunt?

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position
Cheshire


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink  

Leger wrote:
Shamus wrote:
Marios is not a business person looking for freebies he's a trainee accountant (ACCA) looking for some help at the nuts and bolts level.

 Hi Shaun

Could we not include this sort of info as a part of the sign up requirements?  I know there are only 8 posts but you would have to go back to the first post to know Marios is a trainee accountant.

If you had a tick box or drop down button that indicated folks experience /level of expertise (make sure there is one that says business owner though lol) I'm sure it would help us all

 I always have a look back to see, if I cant quite recall, although some of the names stick.  I always have a look to see if they have said thank you - its three none thank and in my banning book, lol.   Its a good idea John, especially if you have a little box that pops up that just say 'tight wad' against the business owner ones, lol.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position
Cheshire


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink  

Hello Marios
Thanks for the name confirmation - didnt want to be upsetting anyone by getting it wrong. Sorry for the delay, another bombed week!

The thing with your use of 0052 for the HP suspense is that 0052 is in the fixed assets range.

There are a couple of ways round this in sage, as usual. Well three.

Just journals, each time for all of the entries.

Set up the HP facility as a loan 'Bank account'

or set up the 'HP' as a supplier. Think the latter seems to be favoured from what Ive seen, so will go with that one for now. As ever, backup, and again, check it and trail it before keying anything else (or try it in your practice data - simples!)

So:-

Set up the HP provider as a supplier, using nominal code 0050 (vehicles), T1 defaults.

Key your HP agreement to this - TOTAL, including all your bits, re fuel and licence etc, but when you key it you will have to override the nominal and tax codes for some, eg
- vehicle cost stripped out - key as is (that claims the VAT back)
- fuel - to motor expenses T0
- protection thingy - to new code in the eg 73xx region T2

Key the invoice as say three lines as above, but all with the same reference - will show in each of nominal codes separately, but as one invoice on the supplier account.

Then key a credit note to the HP provider 'supplier' account but code this to 2310 (HP creditor).

Link the invoice and credit note in the HP provider 'supplier' account so they dont show as o/s in any creditor reports.

The credit note will have created the balance on the HP nominal 2310!

THEN
Pay the deposit via the Bank - key this as a Bank payment, direct to the HP nominal 2310 - you will see this leaves the balance where it should be for the HP.

Monthly payments
Key as Bank payments - splitting the total to interest (HP interest nominal in P&L) and principal - to HP creditor 2310. (again key them with the same reference and only one entry comes up on the Bank which aids Bank rec.

HTH
(I do have this strange feeling Ive missed something, so test it out and hopefully I havent!)



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position
Marios


Member

Status: Offline
Posts: 19
Date:
Permalink  

Good Morning!!

Thank you Joanne, hope you enjoyed your drinks!!

Right, van posted, job done. I tested the whole thing on practice mode and it worked just fine so I went on and posted.

So, once more thank you!!

P.S On a philosophical note, could the whole thing be done just by posting journals?

The reason I'm asking is that when you post an invoice with T1 the VAT goes automatically to the purchase tax account (2201);

So if we journal the VAT part directly to 2201 will that have an impact during VAT return, not having been posted through an invoice?



__________________
Cheshire


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink  

You can - that was one of my options.

Tell you what - set a challenge for you - give it a try via practice data and see if it the VAT shows and it comes up in the right places on the VAT return.

As I said - you can also set it up as a Bank account.

There is always more than one way in sage

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> New Van as Hire Purchase in Sage
Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About