1. Contracting
    1. General
      1. Brexit
    2. Business / Contracts
      1. Coronavirus Assistance
    3. Accounting / Legal
      1. Umbrella Companies
      2. HMRC Scheme Enquiries
      3. The Future of Contracting
      4. IR35 Reform
    4. Technical
    5. Welcome / FAQs
  2. Social
    1. Light Relief
    2. Social / Events
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Recent content by Lowery

  1. L

    Excel Group & Merge Question

    Ended up working it out.... By the if I was snr management I would have deligated it to some poor sap!
  2. L

    Excel Group & Merge Question

    Man I wish I could attach an excel sheet as an example....it would clearly show what I am trying to do. The way the labels are printed they need to be in this format...no way around it. Yep. And that's ok because all the cells I am merging are of the same value. That's the formatting I need...
  3. L

    Excel Group & Merge Question

    Umm sorry I think I need to clarify a bit further. Say you start with the below table...starting with 1 = A1, a = B1 etc... The table will be sorted by column A. 1 a 1 b 1 c 2 d 2 e 3 f 3 g 3 h The solution will search column A. 1. Select cells A1-A3. 2. Merge and Centre. 3. Select cells...
  4. L

    Excel Group & Merge Question

    Exactly right .... I see what you mean on not logical. After the merge has happened I want to align the text (in your example 0, 1 and 2) in the centre of the merged cell. That should be easy. Tried a pivot table and also exporting to Excel from Access but still couldn't get there.
  5. L

    Excel Group & Merge Question

    yep it was hard to explain..... I need to select all the "1" in column a....merge....select all the "2" ....merge.... and so on for 30000 rows....
  6. L

    Excel Group & Merge Question

    I am by no means an Excel pro so maybe someone out there can help me. I want to transform the table below from (a and b are columns)... ab 13 14 15 26 27 28 to this by selecting each section and merging...the "-" are blank cells by the way. ab -3 14 -5 -6 27 -8 Now I know I can...
  7. L

    Writing an "Opt-In" letter

    If your company and director has not opted out then you are automatically opted in...doesn't matter what the contract says. Once you have started the contract you cannot opt out.
  8. L

    Opt in / Opt out?

    Opting in or out has no impact on your IR35 status. It your contract terms and what you actually do on the job that puts you inside IR35 or not. As you can tell (with the comment above) this topic has been covered to death on this forum and a quick search will lead you to quite a few threads...
  9. L

    VAT Registration

    Stick to your guns and go with your Ltd Co. You are perfectly within your rights to operate a Ltd Co and don't let the agent tell you otherwise (remaining professional of course).
  10. L

    VAT Registration

    The VAT registration does NOT have to be in place before the contract starts. You can invoice for the owing VAT when your ltd co gets registered. With regards to the references. Have you opted in or out of the agency regulations? Legally that agency has to confirm references if you opted in to...
  11. L

    Separating Personnel and Business Assets

    Just had a chat to the PCG Legal Helpline on this issue and they said....(basically it's what boredsenseless posted). If it is the ltd co providing the service (i.e. it is the ltd co name on the contact not your name)? You are the employee of that ltd co provides the service. If the client...
  12. L

    Going Limited from Umbrella...?

    Brief description here. Also google "VAT Flat Rate Scheme" which will deliver more than a few explanations. http://www.hmrc.gov.uk/manuals/bimmanual/bim31585.htm Talk to your accountant to see if it fits with you....
  13. L

    Separating Personnel and Business Assets

    Interesting...I would have assumed that there would have been some method/structure of seperating business assets and personal assets. If from what your saying is true Tim I wonder how many contractors out there actually realise (or have even thought about) that if they are sued they could lose...
  14. L

    Progressive Payroll

    I almost got mixed up with this group....seems I've dodged a bullet.
  15. L

    Separating Personnel and Business Assets

    If you commit Professional Negligence then is this where PI insurance kicks in? But of course this has limits on the amount insured. How do you make sure your personal assets stay out of it....in NZ it is common for family homes etc... to be in a trust.
See more

Partners

Contractor Mortgages
Contractor Mortgages
PI Insurance
PI Insurance
Closing your company
Closing your company
Contractor accounting
Contractor Accounting

Advertisers

Contractor services

CUK News All news

Tag cloud

accountant agw boomed! contract contract advice expenses global warming guinea pigs hmrc ir35 limited company monday links mumsnet online tax the official doom training trigger warning umbrella wgas
  1. Contracting
    1. General
      1. Brexit
    2. Business / Contracts
      1. Coronavirus Assistance
    3. Accounting / Legal
      1. Umbrella Companies
      2. HMRC Scheme Enquiries
      3. The Future of Contracting
      4. IR35 Reform
    4. Technical
    5. Welcome / FAQs
  2. Social
    1. Light Relief
    2. Social / Events
Back
Top