Just thought I would check how to stay legal post the soft landing period for a client who has old sage, non MTD compliant.
Can extract reports from software in either csv or excel (or indeed both).
What info will need to be dragged kicking and screaming from non compliant accounting software (any, not restricted to sage per se) and dumped into any kind of bridging software to retain compliance? How should this info be extracted from accounts software and dropped into bridging?
Only reason Im checking is I thought I knew, but got into a major debate about it on Thursday and started to doubt myself on a Saturday morning. Plus thought it would be a good time for reminders gvien some of the software companies are ramping up their arguments to gain sales once again.
(Although I am pretty sure now that I will not be here come April 2020)
__________________
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
It's just the 9 boxes Joanne. Presumably if sage can produce a page with the 9 boxes on that should be compliant.
I found Taxfiler a doddle when I used it this time round, as it picks up the box numbers from the import. (VT+ pre MTD in my case) I'm guessing it would be the same with Sage.
In John's software all you need to do is rename the boxes to his formulae before importing which should then be picked up once imported.
That's my understanding anyway, what was it that put doubts in your mind?
__________________
John
Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.
The point about MTD (Digital Records) is that there needs to be an electronic audit trail. You don't have to transfer all of the records just the 9 boxes. For ITSA the same principles apply, but there are many more boxes on the SA forms and also a bit more summary is needed. (in the sense that some of the submitted figures are divided up in more detail).
Hence as long as you don't retype the totals and just taken them from the Sage CSV files all is good.
I started to doubt myself after having a dicsussion with an Accountant. But then also shortly followed by a dicussion with Sage. I did say to Sage 'please start perpetuating this rubbish' but I started to worry in case I had missed something.
The none boxes are dumped to excel straight from Sage into bridging or sent via VT excel add in. What I have noticed is that the VAT number needs to be manually added, even though the VAT number is showing in the software. That imo is potentially more dangerous than the old system. Lets face it box four was always a check method, being an auto calc, but adding the VAT number can result in human error (number blindness and all that!)
Thanks both for the re-assurance!
__________________
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
FWIW, if you're going via a spreadsheet, you could use a formula to validate the (UK) VAT number. I've just quickly dropped this one in LibreOffice Calc and it works:
That total plus Digits 8 and 9 as a two digit number must be divisible wholly by 97* - that's what the IF and MOD check; MOD returns the "remainder" when the first number (that sum and the final two digits as a two digit number) is divided by 97. If the result is 0, it's a valid VAT number, but if it's non-zero (if there's a remainder) it isn't.
John's 'double check' probably does the same thing programmatically.
* I think the correct description is to add up the first seven digits as multiplied above, then keep deducting 97 until you get a negative number, and that number is the last two digits - but to make it work as a formula... see above.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Thanks Vince - I will have a play with this. Used VT add in for this one and realised after I had done the first batch that the info is only retained properly if you add to it as a workbook, so was just thinking that I should add the VAT number to the workbook and then I can pull it forward to the VAt returns via a simple formula (has to be simple for my brain!)
John - a very sensible thing to have. Can see there could bo some carnage with other software.
__________________
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
What I have noticed is that the VAT number needs to be manually added, even though the VAT number is showing in the software. That imo is potentially more dangerous than the old system. Lets face it box four was always a check method, being an auto calc, but adding the VAT number can result in human error (number blindness and all that!)
Hi Joanne
Can you copy the VAT no from sage? (eg ctrl+c).
__________________
John
Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.
John - a very sensible thing to have. Can see there could bo some carnage with other software.
Apart from agents I have some clients who run more than one legal entity that is vat registered. There is, therefore, a danger that people can submit the wrong return on the right vat number or the right return on the wrong vat number. Hence I require that people keep the vat number in the data as it goes through the system. That means the system won't allow the wrong vat return to be submitted. So far no-one has submitted a return on the wrong number through my system so that works quite nicely.
ITSA differs from VAT in that you can resubmit an amendment for some information until it is finally frozen (they use the word crystallised).
