The Book-keepers Forum (BKF)

Post Info TOPIC: Recording CIS on Sage


Veteran Member

Status: Offline
Posts: 56
Date:
Recording CIS on Sage


Hi can anyone tell me please how to record the following in Sage.

Subcontractor issues the following invoice 

Net 750

Vat 150

Gross 900

Contractor then pays him 750 and pays 150 to HMRC for CIS.  

I am sure this is simple and I am over complicating it but I have put the full invoice on his supplier account, did a supplier payment for 750 from bank when the contractor paid him but now there is the 150 on his account that I need to get from bank coded to cis 

Thank you in advance



__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:

CN to cis n/c

__________________

 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



Veteran Member

Status: Offline
Posts: 56
Date:

Thank you but do I also then do a bank payment for the 150 coded to same cis code?



__________________


Master Book-keeper

Status: Offline
Posts: 3904
Date:

"did a supplier payment for 750 from bank"

Shouldn't that be a customer payment to the bank?

 

 



__________________

John 

 

 

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



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Pickle wrote:

Thank you but do I also then do a bank payment for the 150 coded to same cis code?


 Why are you doing a bank payment?

 

Who is the bank payment to?

 

Plus John's Q  (I just ignored that!)

 



__________________

 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



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Who is the debtor and who is the creditor? Which is your customer?



__________________

 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



Veteran Member

Status: Offline
Posts: 56
Date:

Isn't a subcontractor providing his services to a contractor a supplier? When the 150 cis payment comes out of the bank it gets coded to the cis code.

__________________


Veteran Member

Status: Offline
Posts: 56
Date:

The builder is the contractor and the subcontractor is the company supplying the scaffolding



-- Edited by Pickle on Friday 10th of January 2020 11:45:57 AM

__________________


Master Book-keeper

Status: Offline
Posts: 3904
Date:

I assumed the subby, but if it's the contractor it makes more sense.

Assuming that's the case it only requires one action as Joanne says.  Credit note to the supplier account with the CIS nominal code. Puts £150 to the CIS nominal and clears the supplier account.  The £150  in the CIS nominal is cleared when paid to HMRC.

Back up sage first then test it.



__________________

John 

 

 

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



Master Book-keeper

Status: Offline
Posts: 8646
Date:

We were trying to clarify whether you were dealing with the debtor or the creditor, hence my question....

Who is the debtor and who is the creditor? Which is your customer?

Your query stated your problem was with a balance on account - which account, the creditors (Im guessing)?

Did you pay £150 to someone for the CIS? Surely not at the same time and if you just code that to CIS, what balance is then on the CIS account? Given you havent put anything in their for the provision?


__________________

 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



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Forget the backup!



Pickle - just try the process in practice mode. Set up your supplier, key an invoice, key the payment , key the CN as I stated several posts ago, then key the bank payment to HMRC and see what happens

__________________

 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



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Pickle wrote:

The builder is the contractor and the subcontractor is the company supplying the scaffolding



-- Edited by Pickle on Friday 10th of January 2020 11:45:57 AM


 That still doesnt answer my question - WHICH is YOUR customer that you are processing on sage for?

 

 

YOu dont need to know - Ive assumed it was a supplier ie a CREDITOR. So have answered as required. I think. Although losing the plot now altogether.



__________________

 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



Veteran Member

Status: Offline
Posts: 56
Date:

Thank you and sorry for muddling you up so much. The client is the contractor. I have cn the supplier/subcontractor for 150 coded to cis and then done a bank payment also coded to cis once builder paid it over to HMRC. Everything is now clear.  Thank you both for your help



-- Edited by Pickle on Friday 10th of January 2020 12:03:22 PM



-- Edited by Pickle on Friday 10th of January 2020 12:04:34 PM

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:

Yey!

So then the supplier accounts and the CIS accounts will be nil. But CIS shows as owing until its paid - so all is well with the world.

Shall we blame John for muddling it? winkbiggrinbiggrin



__________________

 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



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Youre welcome - dont be a stranger on here though!!! We have a few giggle posts even if you dont feel you can help others (which Im sure you can!)



__________________

 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



Veteran Member

Status: Offline
Posts: 56
Date:

smile haha poor John! Don't worry I will probably be back when the reverse vat charge comes in to play in October blankstare 

Hope you have a good weekend both of you



__________________


Master Book-keeper

Status: Offline
Posts: 3904
Date:

Cheshire wrote:

Yey!

So then the supplier accounts and the CIS accounts will be nil. But CIS shows as owing until its paid - so all is well with the world.

Shall we blame John for muddling it? winkbiggrinbiggrin


 Yes, absolutely biggrin

I'm that used to doing subbies I automatically assumed that's what it was.



__________________

John 

 

 

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



Master Book-keeper

Status: Offline
Posts: 8646
Date:

I know you know that Im only joking John, of course!!!!!



__________________

 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



Master Book-keeper

Status: Offline
Posts: 3904
Date:

I know you well enough by now Joanne biggrin



__________________

John 

 

 

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



Veteran Member

Status: Offline
Posts: 61
Date:

Hopefully this won't confuse things, but I tend to set up a dummy CIS bank account for these things, especially when there's cash accounting for vat involved.

So in this instance you would pay the subcontractor £750 from the real bank account and £150 from the CIS bank. It works the same the other way around, if you were issuing the invoice, your customer would pay you £750 into the real bank account, then you would receive £150 from the CIS bank account. At the month end, I transfer the balance on the CIS bank to the Paye nominal so the payment to HMRC will net off the Paye nominal.

As I said, hopefully this won't confuse things!

__________________

All thoughts are my own and should not be used as professional advice.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Rachel19 wrote:

Hopefully this won't confuse things, but I tend to set up a dummy CIS bank account for these things, especially when there's cash accounting for vat involved.

So in this instance you would pay the subcontractor £750 from the real bank account and £150 from the CIS bank. It works the same the other way around, if you were issuing the invoice, your customer would pay you £750 into the real bank account, then you would receive £150 from the CIS bank account. At the month end, I transfer the balance on the CIS bank to the Paye nominal so the payment to HMRC will net off the Paye nominal.

As I said, hopefully this won't confuse things!


Hi Rachel

Horses for courses, lots of workarounds in sage, like this.  I use the sort of dummy account you mention, albeit mostly Director's stuff that carries VAT (saves on the adjustments to the VAT return in these MTD days, when faffing with journals, non VAT I just journal). 

The one I suggested should be keyed T9 (I missed the coding) - then will not impact on either kind of VAT, incl cash accounting.  I would also enter it at the point of the original invoice because then it shows the CIS liability straight away.

Yours of course has the added reconciliation (of the dummy bank), but it does the trick and thats what its about. Anyone trying it - just do it in Practice mode, or as John states, back up (backup up again and test your backup) then you can restore if it doesnt work.

 



__________________

 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



Veteran Member

Status: Offline
Posts: 67
Date:

Hi, When I post payments on a CIS supplier Sage automatically creates the credit note for the tax amount.

__________________
Riel


Senior Member

Status: Offline
Posts: 359
Date:

Riel wrote:

Hi, When I post payments on a CIS supplier Sage automatically creates the credit note for the tax amount.


 What type and version of sage?



__________________

Caron



Veteran Member

Status: Offline
Posts: 67
Date:

Sage 50 V 26 although you do need a CIS module, then it also send the monthly return



__________________
Riel


Senior Member

Status: Offline
Posts: 359
Date:

Riel wrote:

Sage 50 V 26 although you do need a CIS module, then it also send the monthly return


Thought as much.

 



__________________

Caron



Expert

Status: Offline
Posts: 1991
Date:

You beat me to it Riel, we have the CIS module at one of my clients on Sage, it is brilliant and well worth the extra money! It matches everything when you pay the contractor, it automatically dumps the credit into the CIS account, and the creates a CIS return at the end of the month, and produces certs for the subbies.

I used to do it the manual way and then have a spread sheet but it took too long to do!

__________________

Amanda

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