I have just had a conversation with Sage and wanted to know if anyone can shed any light on the process of importing information from Excel into bespoke software such as Sage.
I have a template from Sage which has the headings required for import. A client has a workbook with 12 tabs, each tab holds a monthly invoices where the net, and VAT totals are, by way of example, in cells F30 and F31 on each page.
My understanding is that with the clients workbook open, I will have to go into the Sage Excel template and under the 'Net Amount' heading select the formula '=F30' of the clients workbook page and under the heading Tax Amount select '=F31' as I have taken MTD to mean once a human has inputted the information into Excel, another human cannot simply type those numbers into anything else and has to bring them in using formulae.
Sage says, I am to manually type the figures into the Sage template from the invoices raised in the clients workbook, in order to import the excel information into Sage. Maybe I am taking things too far, but is Sage not asking me to manually re-type something in their sheet, that has already been typed into Excel by a human, which I have understood to mean that I can't under MTD.
Any clarification would be much appreciated.
Replies (18)
Please login or register to join the discussion.
For the time being (under the soft landing period) you could copy and paste the necessary info between the sheets, but after that you must (to comply with MTD rules) use a link (formula or otherwise).
What Sage have told you is nonsense.
It depends which are the digital records. Just because some records are digital does not mean that they are the MTD required digital records.
A simple way to look at things is that once something has been typed into the records it has to be transferred electronically. However, the situation is more complex.
You need to have a set of digital records and those records need to link through to the submission. The digital records need a certain level of detail. However, you can type into those digital records.
For example if you keep manual books you can type into the digital records to create them at any time before submitting the vat return (as long as it is submitted on time). Similarly you can actually retype lists of data, but you cannot take a total from one list and put the total in another system (from 1st April 2020).
I am not quite sure from the original question what is going on, but the Sage helpline might be right they might also be wrong.
If you are only inputting into Sage to comply with MTD then I don’t see the point. If the records are already digital and have totals then why not just use bridging software since you would then be able to continue after April 2020.
As Matrix says.
It sounds as if there is no summary sheet on your client's workbook. It would not be difficult to construct a summary page which pickes up the relevant 3 months for a return. This would then give a static source for the bridging software (or indeed the Sage template).
If you are putting the individual invoices, purchases and expenses into Sage then it doesn't matter how it gets there, the Sage records will comply with MTD.
You can retype the figures into a new spreadsheet, use copy and paste, formulas or enter the figures directly. The digital link is only required if you are using subtotals, so long as the level of detail required by MTD is present in Sage there's no need for any further digital link past that point.
You haven't understood what you read then.
There needs to be a digital link from the VAT return to the underlying accounting records. The underlying accounting records are those that record everything at a transaction level.
Therefore if the Sage records record everything at a transaction level, it doesn't matter how the figures got in to Sage.
If it makes you feel better you could print the spreadsheet out and then you're entering figures from paper records rather than digital ones but that would make me sad because I'm a fan of trees.
The digital link has to go all the way from the return to digital records, which are recorded digitally at a transaction level with the detail required by the legislation.
That's it, that's all that's mandated. Your problem, I think, is that you are looking at it from the other end and seeking to apply a digital link from the first time it goes on a computer all the way to the return. That is not required and isn't in the legislation.
Look at it the other way round, starting with the return and linking back to the underlying records. As soon as you get to the point that those records are of sufficient detail to comply, you can stop digitally linking. Whatever other copies of those records exist beyond that point are irrelevant.
That is the way the legislation is applied, and that is why there's no problem typing (or copy/pasting or importing) all the entries from a spreadsheet into Sage. How it goes between those two is irrelevant so long as Sage holds the level of detail required to comply, because at that point the requirement for digital links stops.
Unless HMRC are going to be actively sat behind you when you do it, I would suggest you get the data in in the most efficient manner.
I cant comment on antiques like SAGE, but in most modern packages imports of data are quite simple so long as you get the header rows matched up. You will however usually need to do it tab by tab, or copy all the tabs into a single sheet as the importing system will want to see a table of data in a flat file.
We import our sales invoices into Sage on a daily basis using an excel csv file from another system without any problems. I have all ready submitted my first vat return through Sage 50. Are you now saying that i am not compliant even though the return was done through Sage
If you are importing your invoices I would have thought you were fully compliant (in the sense that you have the digital links required from 1st April 2020).
If you are importing the invoices individually the requirement for digital records is probably satisfied by your Sage system in isolation.
How about getting them posted directly from Excel to Xero or QuickBooks Online? 1 click posting in Excel, digital link and saves time :) importing should be a thing of the past!
But yeah, i'd stay away from copying or re-keying, just another thing to remember to stop doing if not..