Product Description

The 'NJT Tax Return Manager' bridging software is an application developed in Microsoft Access, that provides a quick and secure online filing of, MTD compliant, Tax Returns to Her Majesty's Revenue and Customs (HMRC). The Software provides a combined solution covering both VAT and Income Tax submissions.

HMRC defines 'Bridging software' as a product that provides an MTD compliant digital link between your accounting / bookkeeping software and the HMRC MTD system.

The software comprises of a ‘Front End’ application (Software) and a separate ‘Back End’ database. Due to this versatile design, the software is applicable for individuals, businesses & Agencies of all sizes. The software is fully ‘Multi’ User, which means many users can access the database simultaneously. The ‘Front End’ software is installed on each User’s computer and the database can be stored locally or on a central computer (File Server).

For information, Microsoft provides a free 'Runtime' version of Access, which can be installed by customers that do not have at least Office 2016 with Access included.

Please Note: The software caters for Income Tax ‘Quarterly Update’ submissions from Tax Year 2026-27 onwards for Sole Traders & UK Property Landlords with a qualifying Income exceeding £50,000. From April 2027, it is intended that the software will be enhanced to include ‘Year-End’ functionality.

Process Summary (Income Tax 'Quarterly Update' Submissions)

1. How to purchase the 'NJT Tax Return Manager' software (This includes how to install and configure the software).
   [Click here] for a 'Step by Step' guide (Individuals or Businesses).
   [Click here] for a 'Step by Step' guide (Agents that submit on behalf of Clients).
   
   
2. Decide on the location of the 'BackEnd' Database.
   If you are the only user of the software, then no further action is required as the 'NJT Tax Manager Database.accdb' is already located within the default sub folder '\(Database)'.
   
   However, if you want to share a single database with multiple users within the local network, after installing on the 1st computer, move a copy the 'NJT Tax Manager Database.accdb' from the default folder into a folder on a network drive. For example, 'Z:\MTD\(DataBase)\NJT Tax Manager Database.accdb' ensuring each user has full access rights to this folder.
   Note: For multiuser access, you need to install the 'Front End' software on the 'C: Drive' of each users computer.
   Finally, within the 'Front End' software for each user, link to the central database via the 'Administration Routines', 'Software and Database Configuration' and 'Link Database' buttons.
   
   
3. Income Tax Obligations
   For each taxpayer, for each Tax Year, HMRC generates 'Obligations', which have to be completed by a defined 'Due Date'. The NJT software currently supports the 4 'Quarterly Update' obligations. The overall Tax Return obligation will become relevant from April 2027, when new releases of the NJT software will include the 'Year-End' functionalty.
   
   You can choose between 2 Date Ranges as follows (These ranges are known as 'Quarterly Period Types'):
   'Standard' (Example for Q2 is 06 Apr 2026 to 05 Oct 2026). 'Calendar' (Example for Q2 is 01 Apr 2026 to 30 Sep 2026).
   Note: Quarterly Updates are cumulative, therefore the Start Date is always either 01 Apr or 06 Apr. Meaning Q4 will include all transactions for the whole Tax Year. You can change this prior to submitting your first 'Quarterly Update' of the Tax Year via the 'View/Change Business Details' button.
   
   Unlike the VAT obligations, all 4 of the 'Quarterly Update' obligations are retrived as soon as the Taxpayer record is accessed.
   To submit a 'Quarterly Update', firstly,you highlight the desired Quarter, then click on the 'Manage Obligation' button (a new window is then displayed). This is where you import the financial values and submit the 'Quarterly Update' to HMRC.
   Note: when the window is first opened, the software will attempt to retrieve and display the previous submission (where applicable).
   
   
4. Decide on your preferred method to import 'Income Tax Quarterly Update' financial details.
   As this is bridging software, you will need to populate the financial values within your desired bookkeeping software (or Excel) and then import these details ready for submission to HMRC.
   Note: Exports from other accounting systems will be considered on an individual basis. If you have any examples please email them to NJT followed by a telephone call to discuss.
   Note: You can submit 'Consolidated Expenses' where your annual turnover is less than £90,000.
   
   • Importing from Microsoft Excel
     NJT provides you with 4 templates to choose from. These can be downloaded and copied into your existing Excel 'Bookkeeping' workbook.
     [1] Self Employment - Consolidated Expenses
     [2] Self Employment - Full Expenses
     [3] UK Property Rental Business - Consolidated Expenses
     [4] UK Property Rental Business - Full Expenses
     [Click here] for more information on Importing from Excel.
     
     
   • Importing from Sage (CSV or Excel P&L exported report)
     A Sage 'P&L Report' and 'P&L Transactional Report' can be exported from your Sage software in either 'CSV' or 'Excel' format. The formats available are dependant upon your Sage version. Often older versions only allow CSV exports.
     After you have imported the financial details, the NJT software will display a 'Mapping' table, allowing you to match the Sage Nominal Accounts to the Fixed HMRC Income and Expense categories. Note: The NJT software will then save these mappings for future imports.
     
     
   • Importing from VT Transaction+ (Direct Access) The NJT software can access a VT 'Company File' directly, so you simply select the VT file when prompted to do so.
     After you have imported the financial details, the NJT software will display a 'Mapping' table, allowing you to match the VT Analysis Accounts to the Fixed HMRC Income and Expense categories. Note: The NJT software will then save these mappings for future imports.
     
     
5. Submit Income Tax 'Quarterly Update' to HMRC After you have successfully imported the financial details, click on the 'Submit to HMRC' button. After the 'Quarterly Update' has been submitted, the software will automaticaly request a new 'Tax Calculation'.
   Note: The NJT software will display only the current 'Total Liability' amount. The breakdown/details of the calculation can be viewed via your 'Business/Personal Tax Account'.