ACCOUNTING & TAX SOFTWARE SOLUTIONS 

FAQs

Yes – monthly, quarterly, annual are all supported.

Yes – as long as the source file contains the correct figures for submission of boxes 1 to 9.

Yes – as long as the source file contains the correct figures for submission of boxes 1 to 9.

The VAT Filer will run on an Apple MAC provided it is running Mojave 10.14.3 or later and Excel for MAC 2016 16.26 or later. The software will not run with Apple Numbers and does not run on Android devices.

No – only with Excel 2010 or later.

Yes they do – Please see the user guide.

No – there are too many potential environmental issues in creating an Excel add-in.

No - any changes need to be made in the source file and then linked through to the VAT filer as per the video.

Yes – any data held on our bridging website is held in accordance with our data policy and in accordance with GDPR compliance regulations. Full technical specifications can be found HERE

Yes – users should email support@absolutetax.co.uk if they have any support queries and your query will be responded to via email.

No, all support is dealt with via email– unless you have in the last year spent a minimum of £500 on any software supplied by Absolute Accounting Software Ltd.

The Excel VAT Filer username and password will be emailed to you within a few minutes of the order completing. The email will come from noreply@absoluteexcelfiler.co.uk. If you have not received the email we would recommend checking any spam or junk folders that you may have.

They must be set to English United Kingdom - this is usually altered by going into Regional settings and ensuring that it is set to English United Kingdom.

The MAC compatible version of the VAT Filer does not support the import sheet option shown in the video demonstration. You can only use the Link Cells option to link the 13 cells individually to your source workbook.

HMRC have put together a number of support services for MTD. Full details can be found on their website www.gov.uk/government/organisations/hm-revenue-customs/contact/online-services-helpdesk.

As an agent you need to reregister for a new Agent Services Account. Full details on how to do this is available on the HMRC website www.gov.uk/guidance/get-an-hmrc-agent-services-account.

As an individual business or organisation you will need to reregister for MTD. Full details on how to do this is available on the HMRC website www.gov.uk/guidance/making-tax-digital-for-vat.

You will not be able to rename the tabs within the software as these are used to create the links between the input and VAT return tabs. If you rename the tabs it will prevent the software from linking correctly to both your source spreadsheet and the HMRC when submitting.

Due to a restriction within Excel 2010 it doesn’t allow macros to run correctly therefore not recognising open multiple spreadsheets as individual items and so when selecting "Link Cells" and then the source spreadsheet it doesn’t recognise this as a separate Excel file. you can either open a blank spreadsheet and choose file / open to open the source spreadsheet before running the link option, or alternatively when you click "Link Cells" select "View" in the menu bar within the Excel file and then "Switch Windows" and you can then select the source spreadsheet from the drop-down menu. This is likely to affect users running Excel 2010 on a Windows machine and Excel for Mac 2011.

This will either be that your source spreadsheet is in protected mode in Excel or that you have merged cells set in certain cells of the spreadsheet. To unprotect the spreadsheet you either need to click "Enable Editing" in the menu bar at the top when you open the spreadsheet or choose file / enable editing.

The 12 month licence activates when you file your first successful submission to HMRC, rather than the day the product is purchased. This means you can buy the Excel VAT Filer in advance to test the linking to your source spreadsheet.

We do not have a demo version that we can send to you, as it is an Excel template and HMRC do not allow for test submissions of the VAT returns. For this reason we have put together a video demonstration that can be found on the homepage of this website.

HMRC have confirmed that the process can take approximately 72 hours.

You will need to go to www.absoluteexcelvatfiler.co.uk and then sign in with your username and password.

The knowledgebase can be accessed directly from your Client Portal.

HMRC have announced from 8th April 2021 they will no longer accept VAT submissions using XML software but instead require them to be sent using Making Tax Digital compatible software of which Absolute Excel VAT Filer is one and if you are already using it then there is no need to do anything. If you are an agent and not already using MTD Software and wish to do so you will first need to register for an Agent Services account via the following link https://www.gov.uk/guidance/making-tax-digital-for-vat-as-an-agent-step-by-step this is different to your usual Government Gateway account. If you are filing your own VAT return then you will need to follow the link to sign up with HMRC https://www.gov.uk/vat-record-keeping/sign-up-for-making-tax-digital-for-vat.

The licences for the VAT Filer are sold in batches of 10 allowing you to file for up to 10 unique VAT numbers. The licence runs for 13 months from when you first successfully file your first VAT number. To use the software for a further company, you can either download a fresh copy of the VAT Filer spreadsheet to have a separate copy per company or you can use the same copy to list all companies and submissions. If you want to continue using the one spreadsheet, you would open the Absolute Excel VAT Filer and click the data link tab in the bottom left hand corner. You can then click into the next blank row and this will move the link cells (and link import sheet if you are running the Windows version) buttons down to that row. You would then link to the source file for the next company in the same way. The VAT Filer username and password entered into cells C29 and C30 will remain the same for all submissions, so if you do download a fresh copy of the spreadsheet for each company you will just need to enter the details into those two cells.

To renew your licences you need to log into your Excel VAT Filer portal. This is done by going to www.absoluteexcelvatfiler.co.u and clicking Sign In in the top right hand corner. If this is your first time accessing the hub you will need to click forgotten password/reset password to create a password. The username will be the email address entered into cell C29 on your VAT Filer spreadsheet. Once logged into your account if you click orders/order new licence you can pay online. The licences will be automatically added to your account and an invoice emailed across to you. The VAT Filer username and password in cells C29 and C30 will remain the same.

From April 2021 the extended soft landing period for MTD for VAT will finish. This means that from April a full digital journey is required for your transactions so you cannot rekey any figures or copy and paste. HMRC have confirmed that bridging packages, such as the Absolute Excel VAT Filer, can continue to be used from April 2021 along with Excel spreadsheets. The Absolute Excel VAT Filer does not allow you to copy and paste, so is already compliant with the rule changes and so can continue to be used to file VAT returns under Making Tax Digital after the soft landing period has finished. HMRC have confirmed that if you log your transactions in spreadsheets that you continue to do so, using the Excel formula options to auto total transactions and calculate VAT. If you use bookkeeping packages you will need the function of exporting the data from the bookkeeping package into Excel, meaning the transactions are logged within the bookkeeping software and then exported without any rekeying of data. In either instance you can then use the Link Cells (or link import sheet option if you are running the Windows version of the Excel VAT Filer spreadsheet) to link across to your source document to pick up the data required for the VAT return. The cells that need to be linked are the business name, VAT number, start and end date of the VAT period and the totals of the nine boxes on the VAT return. If one of the nine boxes is not applicable to you, you do not need to link that cell and the VAT Filer software will populate the cell with a zero when you click Finish. HMRC do not require the backing schedules to be filed, just the totals of the boxes, but would require the transactional data to be sent to them on any VAT inspection and this will then show how the digital journey was made to the VAT Filer and then the submission.

MTD Myths