The Book-keepers Forum (BKF)

Post Info TOPIC: Help with Posting a new HP Agreement


Veteran Member

Status: Offline
Posts: 35
Date:
Help with Posting a new HP Agreement
Permalink Closed


Afternoon All,

This particular client is on Cash VAT Accounting.

Client has just entered into a new HP agreement with leasing company in regards to a new company Van.

From the paperwork the Van is costing £16,065.83 (Vat £3,213.17) making a total of £19,279.00

Installments are over 36 months @ £489.35 per month

The client has paid a deposit of £3,702.52, which is £3,213.17 (The VAT) and also 1 x months instalment of £489.35.

My problem is can anyone help me with how I post all this in sage and then where i post the monthly installments each month going forward.

Many thanks in advance.

 



__________________


Expert

Status: Offline
Posts: 1501
Date:
Permalink Closed

Easiest thing to do is break down the various stages.

 

First need to record the asset

Dr P&M £16065.83

Dr VAT  £3213.17

Cr HP                      £19279.00

 

Then need to record the payment on deposit

Dr HP   £3702.52

Cr Bank                       £3702.52

As the deposit covers the HP means that you can reclaim the VAT when you pay deposit.  The balance is an amount of £489.35 which is the monthly payment that you are making but will assume the 36 months starts the month after you make the deposit payment.

This leaves a balance of £15576.48 (£19279.00 - £3702.52) in the HP account which is being repaid at £489.35 for 36 months.  Therefore you are paying back £17616.60 (36 x £489.35) which means you are paying £15576.48 HP capital and £2042.12 interest.

Spreading the capital of £15576.48 and £2042.12 interest over 36 months gives £432.68 capital (£15576.48/36) with the balance each month being interest £56.67 (£489.35 - £432.68).

This means each month out of the £489.35 payment £432.68 will go against the HP capital and £56.67 to HP interest in the P&L so by the end of the 36 months the HP balance will be cleared and the HP interest will have been fully expensed to the P&L.

Monthly journal is

Dr HP balance £432.68

Dr HP interest  £56.67

Cr Bank                            £489.35

Regards

MarkS



__________________

Mark Stewart CA

http://stewartaccounting.co.uk/

Providing accounting, bookkeeping, payroll and tax services to small and medium sized businesses across Central Scotland and beyond.



Veteran Member

Status: Offline
Posts: 35
Date:
Permalink Closed

Hi Mark,

Many thanks for the above, I'm now attempting to put this into Sage and got stuck at the first hurdle.......

When posting the first journal, what T-Codes should I use in sage??

i.e. the P&M, VAT & HP, should they all be T9 or should the VAT be as T1 (Help...Very confused!!!)

Thanks again for the great response.

Regards

__________________


Expert

Status: Offline
Posts: 1501
Date:
Permalink Closed

First journal should be T1 otherwise it wont pick up on your VAT report.

After this all the journals should be T9 as the VAT transaction is really covered by the first journal.

Regards

MarkS



__________________

Mark Stewart CA

http://stewartaccounting.co.uk/

Providing accounting, bookkeeping, payroll and tax services to small and medium sized businesses across Central Scotland and beyond.

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

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