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.
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.
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.
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.
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.