NJT Tax Return Manager

(Bridging software for online filing of the MTD compliant Tax Returns to Her Majesty's Revenue and Customs)


The following section describes the detailed technical requirements for importing a VAT Return from a a CSV file using the NJT standard format.

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 is 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 single-line CSV file compliant with the following specification.

Example (MyVATReturn.csv):
Definition:

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 Taxpayer or Trading Name (always enclosed in speech marks)
Item 6: contains the 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).
Note: For zero values, Boxes 1 to 5 should be set to 0.00 and Boxes 6 to 9 should be set to 0.



The following section describes the detailed technical requirements for importing an Income Tax 'Quarterly Update' from a CSV file using the NJT standard format. Each Business Type has two possible layouts, depending upon the Total Turnover. Consolidated Expenses may be submitted where the Turnover is less than £90,000 pounds. Otherwise, Full Expenses must be submitted.

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 is provided to allow preprared 'Quarterly Updates' to be imported via a Comma Separated Variable (CSV) file. The pre-requisite being that 3rd party Accounting systems are able to generate a single-line CSV file compliant with the following specification.

Common Item Definitions:

Item 1 - API_ID (Constant "NJT_MTD_IT") (always enclosed in speech marks)
Item 2 - API_Version (Example 1.0) (Currently set to 1.0)
Item 3 - Vendor_ID (Constant "StdCSV") (always enclosed in speech marks)
Item 4 - Date Stamp (Example 01/01/2018 14:35)
Item 5 - Trading Name (Example "NJT") (always enclosed in speech marks)
Item 6 - NINO (Example "AR592832B") (always enclosed in speech marks)
Item 7 - Period Start (Example 01/04/2026)
Item 8 - Period End (Example 30/06/2026)

Note: The remaining items will vary depending on the chosen business type and expenses breakdown. Unused numeric items should be set to 0.00

Example 1 (Self Employment with Consolidated Expenses.csv) Code: [SEC]:

Item 9 - NJT Code - Constant "SEC" (always enclosed in speech marks)
Item 10 - Income 01 - Turnover
Item 11 - Income 02 - Other income
Item 12 - Income 03 - Tax taken off trading income
Item 13 - Expenses 01 - Consolidated expenses

Example 2 (Self Employment with Full Expenses.csv) Code: [SEF]:

Item 9 - NJT Code - Constant "SEF" (always enclosed in speech marks)
Item 10 - Income 01 - Turnover
Item 11 - Income 02 - Other income
Item 12 - Income 03 - Tax taken off trading income
Item 13 - Expenses 01 - Cost of goods bought
Item 14 - Expenses 02 - CIS payments to contractors
Item 15 - Expenses 03 - Wages & staff costs
Item 16 - Expenses 04 - Car/Van rental expenses
Item 17 - Expenses 05 - Premises running costs
Item 18 - Expenses 06 - Maintenance costs
Item 19 - Expenses 07 - Administration costs
Item 20 - Expenses 08 - Business entertaining costs
Item 21 - Expenses 09 - Advertising costs
Item 22 - Expenses 10 - Interest on bank & other loans
Item 23 - Expenses 11 - Financial charges
Item 24 - Expenses 12 - Irrecoverable debts
Item 25 - Expenses 13 - Professional fees
Item 26 - Expenses 14 - Depreciation
Item 27 - Expenses 15 - Other expenses

Example 3 (UK Property Business with Consolidated Expenses.csv) Code: [UPC]:

Item 9 - NJT Code - Constant "UKF" (always enclosed in speech marks)
Item 10 - Income 01 - Rent income
Item 11 - Income 02 - Tax deducted from rent income
Item 12 - Income 03 - 'Rent a room' income
Item 13 - Income 04 - Premiums of lease grant
Item 14 - Income 05 - Reverse premiums
Item 15 - Income 06 - Other property income
Item 16 - Expenses 01 - Residential financial costs
Item 17 - Expenses 02 - Residential financial costs C/F
Item 18 - Expenses 03 - 'Rent a room' relief claimed
Item 19 - Expenses 04 - Consolidated expenses

Example 4 (UK Property Business with Full Expenses.csv) Code: [UPF]:

Item 9 - NJT Code - Constant "UKF" (always enclosed in speech marks)
Item 10 - Income 01 - Rent income
Item 11 - Income 02 - Tax deducted from rent income
Item 12 - Income 03 - 'Rent a room' income
Item 13 - Income 04 - Premiums of lease grant
Item 14 - Income 05 - Reverse premiums
Item 15 - Income 06 - Other property income
Item 16 - Expenses 01 - Premises running costs
Item 17 - Expenses 02 - Repairs and maintenance costs
Item 18 - Expenses 03 - Financial costs
Item 19 - Expenses 04 - Professional fees
Item 20 - Expenses 05 - Services costs
Item 21 - Expenses 06 - Travel costs
Item 22 - Expenses 07 - Other costs
Item 23 - Expenses 08 - Residential financial costs
Item 24 - Expenses 09 - Residential financial costs C/F
Item 25 - Expenses 10 - 'Rent a room' relief claimed