Q1. Can the Absolute Excel MTD VAT Filer be used to file
monthly VAT returns?
Yes – monthly, quarterly, annual are all supported.
Q2. Can the Absolute Excel MTD VAT Filer be used for partially
Yes – as long as the source file contains the correct figures for submission of boxes 1
Q3. Can the Absolute Excel MTD VAT Filer be used to file group
Yes – as long as the source file contains the correct figures for submission of boxes 1
Q4. Does the Absolute Excel MTD VAT Filer work on Apple or
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.
Q5. Does the Absolute Excel MTD VAT Filer work with Excel
No – only with Excel 2010 or later.
Q6. Do macros have to be enabled to run the VAT Filer?
Yes they do – Please see the user guide.
Q7. Can you provide VAT Filer as an Excel add-in?
No – there are too many potential environmental issues in creating an Excel add-in.
Q8. Can I type directly onto the Absolute Excel VAT Filer?
No - any changes need to be made in the source file and then linked through to the VAT filer as per the video.
Q9. Is the Absolute Excel VAT Filer GDPR compliant?
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
Q10. Do you provide support for the Absolute Excel VAT
Yes – users should email email@example.com if they have any support queries and your query will be responded to via email.
Q11. Do you provide telephone support for the Absolute Excel VAT
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.
Q12. When will I receive my user name and password from Absolute
Accounting Software that will enable me to file to HMRC?
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 firstname.lastname@example.org. If you have not received the email we would recommend
checking any spam or junk folders that you may have.
Q13. What date format must the settings on my machine be set
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.
Q14. Does the Absolute Excel VAT Filer MAC compatible version
come with the import sheet?
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.
Q15. Can I contact HMRC if I have any queries with my VAT account or the process of registering for MTD?
Q16. As an agent do I need to reregister for MTD?
Q17. As an Individual business or organisation do I need to reregister for MTD?
Q18. Can I rename the tabs within the Absolute Excel VAT Filer?
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.
Q19. When i click the "Link Cells" option it doesn’t allow me to select the source spreadsheet and so I cannot choose the cell to link to.
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.
Q20. When I use the "Link Cells" option it does not allow me to select the cell in my source spreadsheet or copies through data that is different from what shows in my source spreadsheet.
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.
Q21. When does the 12 month period activate?
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.
Q22. Is there a demo version available of the Absolute Excel MTD VAT Filer?
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.
Q23. How long do the HMRC take to sign you up as the agent and/or the
client up for Making Tax digital?
HMRC have confirmed that the process can take approximately 72 hours.
Q24. How do I gain access to the Absolute Excel VAT Filer Client Portal?
Q25. How do I gain access to the Knowledgebase?
The knowledgebase can be accessed directly from your Client Portal.
Q26. Can I continue to use the Absolute Excel VAT Filer software after the soft landing period has finished in April?
Q27. Can I use the VAT Filer spreadsheet for another company with a different VAT number, and if so how do I do this?
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.
Q28. How can I renew my licences for the Excel VAT Filer software?
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.
Q29.Can I continue to use the VAT Filer spreadsheet after the soft landing period has finished in April 2021?
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.