• Xero CIS – correcting a submitted return (it is possible)

    If you make a mistake deducting CIS tax from a subcontractor, submitting the return to HMRC, and then having to work out how to correct it, this post is for you! (and me, ’cause that’s what just happened and the Xero documentation and initial support response is wrong).

    Quick version:

    • Void the incorrect invoice (which in turn means first unreconciling any payments made).
    • Create a new correct invoice
    • Allocate the payments
    • Resubmit the return

    Long version:

    CIS is the Construction Industry Scheme. It’s a tax that is deducted from subcontractors and paid directly to the government. We have it because the building industry had a high number of small contractors that would be paid and then vanish or go out of business never paying the income tax. By making the larger contractors deduct a percentage at source (typically 20%, so less than income is likely to be) it protects the public revenue.

    So far, so good.

    Every month we submit a return to HMRC saying who’s tax we have collected and HMRC take the money from our bank via direct debit.

    The dates are based on ‘cash accounting’ which means the tax is ‘taken’ on the day we pay them. It ignores their invoice date, so if they bill on 30th Jan and we pay on the 10th Feb the tax is reported as February.

    This is different to VAT, where the tax applies on the date the invoice is raised (the tax point).

    If we make a mistake, eg: I deducted CIS from a roofing contractor when I shouldn’t have because it was a gutter cleaning job which is outside of the scope of CIS taxes, then I must promptly correct my submission.

    I cannot submit a negative number on my next return (the HMRC system doesn’t work that way). Instead I must resubmit a corrected return. There is no penalty for a resubmission.

    Typically to correct accounts we would make a ‘credit note’ to reverse the transaction and the create a new invoice. However Credit notes aren’t applied to past CIS returns. Xero does some strange amortisation in the background too (I once had an issue when materials and labour were switched and the correction to me hours to figure out because what Xero showed on my screen was not the same as what it did behind the scenes when creating the report).

    Xero’s first answer is that I could not make the correction in Xero and would need to find another way of reporting the change but HMRC said they require all commercial software to be able to resubmit returns. HMRC were very helpful on the phone and the advisor suggested I could use them manual web page submission system and that would replace our Xero submitted one…. but I figured if HMRC required the software to do it, it could and I just needed to figure out how.

    I thought around the problem and asked Xero what would happen if I voided the original invoice? I assumed that meant it would no longer appear to be included in the past CIS submission, which would change the numbers and I could resubmit the correction. I was worried because of my past experience of Xero hiding things but they confirmed it would indeed allow me to resubmit a corrected return.

    For me, I’d paid when I shouldn’t have so I just reallocated payment to the new non-CIS invoice I created.

    Remember that CIS is ‘cash accounting’ so if you are allocating or part paying some CIS in a corrected return you need to be careful to ensure you are paying on the correct date (the past, as it were). Putting todays date in as today is the day you are correcting something will probably not give the answer you expect.

    I hope this helps someone!


  • Quickly convert a Xero batch payment CSV to a format that works on Metro Bank

    Ah Xero. Every day you disappoint. Not quite enough for me to find a replacement for your poor accounting software (I figure they all have issues but at least I have work arounds for most of your flaws) but one day, I will put enough effort into moving.

    Today though, I’m going to share a fix for Xero’s bulk/batch payment file export being in the wrong format.

    Where we start

    If you have a number of people/suppliers to pay you can create a ‘batch’ payment.

    Details here: https://central.xero.com/s/article/Pay-multiple-bills-UK

    This generates a file of payment instructions you can upload to your bank. However the payment file is in the wrong format.

    The help page says the format is correct for Santander but it is not.

    I filed a bug report a long time ago and go the now typical Xero response to a bug: ‘Please suggest fixing this as a new product idea’.

    I maintain that as a piece of software it would be easy for Xero to solve this if they cared. Fixing those files was as simple as adding the total and number of lines to the bottom of the text file and I’ve been doing that by hand. It was just about fast enough to not automate a fix.

    However, we’re now moving to Metro Bank and Xero won’t output the correct file format. The fix includes splitting the sort code and account number into two fields rather than the 1 field Xero exports which is not something that would be quick to do by hand, as well as putting them in a different order.

    I did ask Xero about fixing the CSV export and their answer is their software can’t format CSVs (🤦‍♂️but they do it for Santander and HSBC, albeit badly) and that I need to reformat their output to make it useful.

    The solution (that’s free and you can use too)

    I wrote a web page that takes the Xero CSV file and reformats it into the banks requirements.

    It does this using instructions in Javascript which your browser understands natively. That means it does NOT need to send your file to my server to process and return All the code runs on your own computer.

    You can find the page at https://sroot.eu/xero-csv-converter/ and although you can convert your CSV there you’ll read in the notes that I suggest you save the page to your computer, check the code, and use it from there to know that no one (including me) has tampered with your payment file.


  • Clothing for your first marathon

    I’ve been training for my first marathon and vlogging my progress on YouTube and Instagram. Early on I was told to start running in my marathon kit as soon as possible. I’m sharing below what I chose, why, and how much it cost. Perhaps it will help other new marathon runners choose.

    I do not promise these are the best choices, or that these are right for you!

    Links are to the manufacturers websites but you’ll likely find plenty of other retails of their products

    There’s a video version of this here [note to self, add it when published :-)]

    The BLUF (Bottom Line, Up Front)

    All of my marathon equipment has cost a total of £589.

    That includes several items I have multiples of so that I can avoid washing them every day. So much for running being a cheap activity.

    Trainers – Brooks Ghost 16

      £135 from my local running shop.

      I went there for an hour and tried on 5 different pairs. Strangely I didn’t settle on the most expensive. I had decided that even £200 would be worth it if it makes my first run more comfortable so didn’t ask the price until I’d chosen my favourite.

      Socks – Balega Blister Resist

      £16/pair, £64 for the 4 pairs that I bought.

      Before I lost my mind and decided to run a marathon I’d been running 5Km 2 or 3 times a week. Buying trail running trainers when I happened to be passing the running shop meant I didn’t have decent socks so I bought a new pair there, and their recommendation was Balega. That pair has been fine so I decided to buy a few more specifically for the marathon. I’ve no idea if they actually resist blisters or it’s good marketing. I did get a few small and minor blisters the first few weeks of having the trainers but none since. For context that’s probably 300km of training runs so I’m guessing they work for me.

      Shorts – Montane Men’s Jetstream 5″ Trail running short tights

      £44 each, £132 for 3 pairs.

      I love these shorts! I started running in tights over winter and realised I much prefer the figure hugging fabric. Not because I have an amazing figure (watch the videos, you’ll see what I mean), I find the tights more comfortable to run in. Also, if you watch my vlog “Run 36, number 2” you’ll discover a bonus feature they don’t advertise…

      Decathlon breathable Kiprun Run 500 dry+

      £11 each, £33 for 3 t-shirts.

      Despite throwing money at other clothing, I found these cheap T-Shirts from Decathlon that do just what I need. My wife doesn’t like the print pattern but I think they were end of line on offer.

      Hydration Vest – Montane Gecko VP 5L+

      £100 including 2 x soft water flasks

      Technically, I bought this twice. I misread the web site for sizing and ordered large which would be right for some of their other things, but the hydration vest sizes at the bottom I needed medium. Too large, and they bounce as you’ll notice in my early videos. I’m only counting the cost once for this. Also they RRP seems to be around £120 but there are always discounts and offers on Montane so £100 is the realistic price. The alternatives I considered were also around £100 from Salomon (I tried one in the running shop but I can’t remember it’s name, I was going to get that one until I saw the £100 price from Montane and decided to save myself a trip into the city).

      FRACTEL L-TANGLE Legionnaire cap

      £45

      I spent ages researching caps. I wanted one with cloth to cover my neck as there’s a good chance my marathon will be on a sunny day. It’s proved useful on my training runs too. Picking a cap was hard because I wanted to put my Run Rootie logo on it with iron on vinyl. The one I chose had a fabric patch that I unpicked to give me the space for my logo. It’s very lightweight and wicks away sweat ever so quickly. It’s always wet from sweat when I return from a run.

      Shokz OpenMove Blue refurbished

      £80

      Technically I had these before I signed up for the marathon. One of my suppliers reps is a keen marathon runner and recommend bone conduction headphones when I first started running. I went cheap by ordering the refurbished pair when my originals died and I couldn’t wait for the warranty replacements (I sold those when they arrived). In hindsight I should have got the version with USB-C charging rather than magnetic connecting cable. It’s a minor annoyance to remember to take that cable with me when travelling.

      The bottom line

      £589

      All of the equipment I’ve chosen to run my first marathon has cost me £589 which to me is a sensible investment in my comfort on my marathon challenge.


    Search this site


    Free apps

    • birthday.sroot.eu – Your birthday or other celebration date based on [years on other planets] / [how many seconds/days] / [how far you’ve travelled around the sun]
    • stampulator.sroot.eu – Calculates the combination and how many 1st, 2nd, large 1st and large 2nd class Royal Mail stamps you need on large envelopes and packets

    Recent posts


    Archives


    Categories