The Book-keepers Forum (BKF)

Post Info TOPIC: How to post Insurance Payments as installments with interest in Sage One


Newbie

Status: Offline
Posts: 2
Date:
How to post Insurance Payments as installments with interest in Sage One
Permalink Closed


Hi,

I'm new to the forum and bookkeeping in general! I only do my own books for my ltd company, so I'm not sure if I'm in the right forum?

 

The company is new and I have signed up to sage one accounting and payroll. My question relates to my insurance on the Trucks I operate (I'm a haulage company). The insurance is renewed annually and paid in installments through a finance company. The insurance attracts interest from the finance company and is paid over 10 months following an initial deposit to the insurance broker. I need to post the relevant entries into sage one, which journals do i need to set up?

 

To make things simple if I assume the insurance costs £10k per annum and I pay £1000 deposit with £9000 paid over 10 months to the finance company, total interest charged £500 so monthly payments are £905. Total cost will then be £10500.

 

If anyone can handhold me through the process I would be most appreciative, it will save me waiting until tomorrow to speak to my accountant.

 

Many thanks,

Steve Angliss



__________________


Senior Member

Status: Offline
Posts: 319
Date:
Permalink Closed

I would post the £10,000 invoice under the prepayment account for insurance then move £833.33 per month to the insurance expense account through a journal. I'd post the £500 to Finance Charges prepayment and again move £41.66 per month to the Finance Charge expense account.

Each of your actual payments can then be paid to the supplier account.

It depends whether the accountant will do all the accruals and prepayments at the end of year though so it's best to ask them first.

__________________

Matthew



Newbie

Status: Offline
Posts: 2
Date:
Permalink Closed

Many Thanks Matthew, I have since my post spoken to my accountant, who suggests that I keep it simple and post the payments to the insurance expense account and let him handle the journal entries. I'll go with that at the moment, although I must admit I like to have a better handle on my accounts from a personal point of view, so I'll probably ask him to give me some additional guidance when I next meet with him.

Anyway, thanks once again, I appreciate you taking the time to help me.

Steve

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Steve
To keep it simple - set up the insurance company as a supplier - key the invoice for the insurance to that account and insurance nominal (ie cost) code - not sure what it is set up as in sage online as I only use professional version - something close to 710x. Key the difference between the insurance and what the finance company charging as a 'dummy invoice' to that same supplier, but using the 'charge for credit' nominal - set up a new one if required - again should be lurking around the 79xx area.

When your Direct debit payment goes through each month just allocate it to that supplier - you can match to the original invoice and then the dummy and the supplier account will be cleared within the 10 month period. That way the full cost for the insurance will be expensed as he suggests.

Then all the Accountant will need to do are the adjustment journals for prepayments - he may just do a figure to cover the year end given you are a newco. If you want monthly or quarterly management accounts I would get him to do it for you then either monthly or quarterly - or show you how.

HTH

__________________

 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.

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