The following sections describe the detailed technical requirements for importing from an Excel workbook or a CSV file using the NJT standard formats.
One of the main principles of Making Tax Digital is that any transfer of data must be undertaken digitally. To facilitate businesses that use Excel based Accounting systems, a function will be provided to allow preprared VAT returns to be imported via an Excel workbook that contains a worksheet conforming to a 'Standard Format' as defined by NJT. The pre-requisite being that businesses are able populate the worksheet as per the following example.
Assuming you already use an Excel workbook to calculate your VAT Return. This may include applying manual adjustments etc. This workbook may already contain multiple worksheets that hold your adjustments details. It is assumed that you already have formula based cells that contain your 'Nine Box' totals for the VAT Return.
You may wish to create an Excel template or an empty workbook containing all the layouts and formulas. Alternatively, after you have completed and saved the current VAT Return workbook, you may choose to 'Save As' the workbook, giving it a different name in preparation for your next VAT Return. The objective being that you only create the formulas once.
One of the main principles of Making Tax Digital is that any transfer of data must be undertaken digitally. To facilitate 3rd party Accounting systems using this software, a function will be provided to allow preprared VAT returns to be imported via a Comma Separated Variable (CSV) file. The pre-requisite being that 3rd party Accounting systems are able to generate a CSV file compliant with the following specification.
Item 1: always set to "NJT_MTD_VAT" (always enclosed in speech marks)
Item 2: contains the CSV file version number, currently 1.0
Item 3: contains the Import_ID, always set to "StdCSV" (always enclosed in speech marks)
Item 4: contains the Date and Time stamp. I.e. when the CSV file was generated. Format: DD/MM/YYYY HH:MM:SS
Item 5: contains the Client's Company Name (always enclosed in speech marks)
Item 6: contains the Client's VAT Registration Number
Item 7: contains the Period Start Date. Format: DD/MM/YYYY
Item 8: contains the Period End Date. Format: DD/MM/YYYY
Items 9 to 17: contains values for Boxes 1 to 9. (Box 1 to 5 values should be formatted to 2 decimal places, Box 6 to 9 values should be formatted to 0 decimal places and all Box display formatting should be removed E.G. commas and currency symbols).