When is a digital link broken for MTD?

Accounting software cannot import CSV file without addition of a column to include a VAT "code"

Didn't find your answer?

A couple of my clients use a spreadsheet package to record their sales invoices which are a mixture of standard rated and outside the scope for VAT purposes. They forward me the spreadsheet which lays out the information in the format VAT (%), Amount, VAT, Total. In order to import the CSV file into my accounts software the CSV file needs to have a column allocating a code - "S" or "X" - to the supplies shown at either 20% or 0%. Does anyone know if the addition of this column prior to importing into the accounts software will "break" the digital link?

Replies (5)

Please login or register to join the discussion.

avatar
By SXGuy
14th Aug 2020 14:21

Possibly, possibly not. Would anyone query it? No. Would I just add it? Yes.

Thanks (1)
avatar
By paulwakefield1
14th Aug 2020 14:51

If you are using Excel, using Power Query would have the twin benefit of automatically adding the column without having to think about it or use formulae and also would definitely not break MTD. Although I have to agree with SXGuy as well.

Thanks (1)
avatar
By frankfx
16th Aug 2020 22:41

You could tidy their spreadsheet.

Return to them for approval.

They in turn send back to you, now in fit state to import without modification into MTD software.

Big Brother is watching.

Thanks (0)
avatar
By johnhemming
17th Aug 2020 07:23

The question, of course, is one as to where your records are actually stored. If the CSV file is individual invoices being incorporated into the accounting software then the accounting records are in the accounting software and it does not matter how you create those records.

The problem for digital links is when you are bringing forward totals.

Thanks (0)
avatar
By s_deards
20th Aug 2020 12:27

I have a similar query on this topic.
We have a client we raise excel invoices for because they have a lot of calculation and detail within them that cannot be included on the softwares (QB) invoice templates. We enter each invoice individually to our software. I was planning to import each invoice but from the post above do I understand that as we are inputting one invoice at a time this is ok to continue to manually enter the invoices?
The invoice sent to the client is the detailed excel one.

Thanks (0)