If you don't want to upload a spreadsheet, you can upload your return data in CSV (Comma Separated Value) of QCSV (Quoted Comma Separated Value) format (We'll use CSV throught this document but it is generally interchangeable with QCSV).
CSV files can be useful if your spreadsheet is not recognised by mtdvatbridge.uk. We have not been able to test the system with every version of every spreadsheet software out there. If your spreadsheet software has an 'Export' or 'Save As' function then it will more than likely be able to save the return data as a CSV file which can then be uploaded to mtdvatbridge.uk. As with text files and normal spreadsheets, CSV files need to be laid out in a particular way to work.
CSV files can only contain one spreadsheet page and can't contain references to other cells. The format of the data we require is the same as for a normal spreadsheet - the return data must include the vat100 box name in a cell and its adjacent cell must include the value to be returned.
A sample CSV (invalid) file is shown below :-
MTDVAT.uk Interface,
,
,
Key,Cell Reference
vatDueSales,5540.55
vatDueAcquisitions,3.75
totalVatDue,5544.3
vatReclaimedCurrPeriod,552.08
netVatDue,"4,992.22"
totalValueSalesExVAT,9366
totalValuePurchasesExVAT,1039
totalValueGoodsSuppliedExVAT,0
totalAcquisitionsExVAT,2511
Note the above file example won't actually be recognised as a valid return. It's a test data file and is deliberately wrong and has incorrectly formatted numbers. The only relevant fields are the box names. It does serve a useful purpose. The corrected file is shown below :
MTDVAT.uk Interface,
,
,
Key,Cell Reference
vatDueSales,5540.55
vatDueAcquisitions,3.75
totalVatDue,5544.3
vatReclaimedCurrPeriod,552.08
netVatDue,4992.22
totalValueSalesExVAT,9366
totalValuePurchasesExVAT,1039
totalValueGoodsSuppliedExVAT,0
totalAcquisitionsExVAT,2511
The name fields (e.g. vatDueSales above) are not case sensitive so vatDueSales, vatDUESALES, vatduesales are all the same. You can also use the box names e.g. box1, box2...box9 that correspond with the VAT100 form.
The amount should be formatted to follow the vat100 form specification so use whole pounds totalValueGoodsSuppliedExVAT (box 8) for example. Don't use commas or spaces to break the numbers up into thousands and do not use currency characters (e.g. £). If your exported CSV file does have currency symbols or non numeric characters, change the cell format so it is purely numeric with the correct number of decimal places then re-export the data.