The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> Professional Book-keepers in Practice -> Excel spreadsheet - CIS subcontractors with VAT invoices
Post Info TOPIC: Excel spreadsheet - CIS subcontractors with VAT invoices
rachel_mclean


Guru

Status: Offline
Posts: 625
Date:
Excel spreadsheet - CIS subcontractors with VAT invoices
Permalink  

Hi, just wondering if anybody has any ideas on this.

Does anybody use spreadsheets for bookkeeping with payments to vat registered CIS subcontractors on them?

It always leaves my spreadsheet looking a bit messy as if the VAT is out, it's been bothering me for a while so I'm wondering if anyone has any ideas.

So the headings (to do with subcontractors and VAT) on my spreadsheet are:

 

          

Total

VAT

Net

Out of Scope

Standard Purchase

Zero Rated Purchases

Materials

CIS Subcontractors

Subcontractors

CIS

  

 

 

 

 

    

1728.00

360.00

1800.00

 

1800.00

 

 

1800.00

 

-360.00

  

 

 

 

 

    
  

 

 

 

 

    

1728.00

360.00

1800.00

0.00

1800.00

0.00

0.00

1800.00

0.00

-360.00

2160.00

totals check

 

1800.00

  

1440.00

   

360.00

vat check

        

 

 

When a vat registered subcontractor is paid my totals (for vat) at the tally at the bottom net x 20% are always out because of the CIS deducted in the net column.

Total - total amount paid from the bank 

VAT - the vat

Net - the net after the CIS deduction (so the net total at the bottom of the spreadsheet will equal the CIS subcontractor less the CIS tax)

 

Here's one

invoice total £2,160 (net 1,800 vat 360) cis deducted 360

 

It just looks so messy! I'm not quite sure how to deal with it. I'm sure I came up with something and sorted this out once but I can't find where I did it. I need to add a balance sheet and profit and loss page on to this spreadsheet too (not done that before confuse) so it would be great if I could sort it out. I don't think I can make the b/s balance without sorting this out either.

 

Thanks in advance for any ideas

 

Rachel biggrin

 

 



__________________

Rachel
Cheshire


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink  

Hi Rachel
Without meaning to sound rude, I noticed that the last couple of posts you did recently had responses from both Doug and John but these were not acknowledged in any way after the event. (A appreciate you TIA'd them at the start, but it always useful after the responses - so that they dont ignore future posts, which is happening increasingly on here, Im afraid). Just thought I should give you the heads up!

Also might be worth attaching your actual spreadsheet.



__________________

 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
rachel_mclean


Guru

Status: Offline
Posts: 625
Date:
Permalink  

Hi Joanne

I thought that was something I always did, replying! so I went back and checked on my last few posts....I haven't!

Not rude at all, I think I have been by not replying no I go back and check within the day of the post and if there's nothing there I get waylaid I think and forget to check back again and then when I do remember to go back I think it's too late and at which point if I comment again I make an old post go right back to the top again.

Sorry for not responding to your response to my previous post and thanks for responding to it

 



__________________

Rachel
Leger


Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink  

Hi Rachel

I don't understand the first column, where does the £1728 come from?   First column should read £1800 + VAT Total £2160, which agrees with your totals check.

 

As Joanne said, could you post a spreadsheet up with just that one transaction in, so we can see the formula, thanks.

 



__________________

John 

 

 

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


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink  

rachel_mclean wrote:

Hi Joanne

I thought that was something I always did, replying! so I went back and checked on my last few posts....I haven't!

Not rude at all, I think I have been by not replying no I go back and check within the day of the post and if there's nothing there I get waylaid I think and forget to check back again and then when I do remember to go back I think it's too late and at which point if I comment again I make an old post go right back to the top again.

Sorry for not responding to your response to my previous post and thanks for responding to it

 

Hi Rachel

Must admit - did think it wasnt like you!  

To avoid missing responses you can subscribe to the post so you will get an email from BKN. (Or just read on all posts dailywink)  But also - dont worry about old posts popping back up to the top of the list - we get LOADS of those.  Some of the worst are spammers digging up ancient ones but we also get to have a laugh at some of the things we had forgotten about where a post has descended into daft banter!

Hope you are keeping well - we dont see much of you these days.



__________________

 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) -> Professional Book-keepers in Practice -> Excel spreadsheet - CIS subcontractors with VAT invoices
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